o365consumer.cs

using System;
using System.Collections.Generic;
using Sage.DriveManagement.Interfaces;
using sage.ew.usuario;
using Sage.O365Management.Classes;
using System.Web.Script.Serialization;
using System.Data;
using Sage.O365Management.Classes.OData;
using sage.ew.db;
using sage.ew.functions.Clases;

namespace sage.ew.o365
{
    public abstract class o365consumer
    {
        #region User calendar Data

        
        internal static string _Sage50User
        {
            get { return _cSage50User; }
            set 
            { 
                //if user is diferent from stored, Logout() required
                if (!String.IsNullOrWhiteSpace(_cSage50User) && _cSage50User != value && _O365ManagementUser != null)
                {
                    _O365ManagementUser.Logout();
                    _O365ManagementUser.RefreshToken = "";
                }
                _cSage50User = value; 
            }
        }
        private static string _cSage50User = "";

        public static string _ClientId
        {
            get
            {
                return Usuario._This._ClientId;
            }
            set
            {
                Usuario._This._ClientId = value;
            }
        }

        public static string _ServiceResourceIds
        {
            get
            {
                return Usuario._This._ServiceResourceIds;
            }
            set
            {
                Usuario._This._ServiceResourceIds = value;
            }
        }
        
        public static string _RefreshToken
        {
            get 
            { 
                return Usuario._This._RefreshToken;
            }
            set
            { 
                Usuario._This._RefreshToken = value;
            }
        }

        #endregion User calendar Data

        #region Shared calendar Data

        protected static internal bool _lRegisterMode = false;

        private static SharedCalendarData _oSharedCalendarData = new SharedCalendarData();

        internal static SharedCalendarData OSharedCalendarData
        {
            get 
            {   if(_oSharedCalendarData == null)
                    _oSharedCalendarData = new SharedCalendarData();
                return _oSharedCalendarData; 
            }
            set { _oSharedCalendarData = value; }
        }

        internal static string _SharedServiceResourceIds
        {
            get { return OSharedCalendarData._RRIdsO365; }
            set { OSharedCalendarData._RRIdsO365 = value; }
        }

        internal static string _SharedRefreshToken
        {
            get { return OSharedCalendarData._TokenO365; }
            set { OSharedCalendarData._TokenO365 = value; }
        }

        internal static string _SharedEmail
        {
            get { return OSharedCalendarData._EmailO365; }
            set 
            {
                //ReadOnly except for register operations
                if (_lRegisterMode) OSharedCalendarData._EmailO365 = value;
            }
        }

        internal static string _SharedCalendarId
        {
            get { return OSharedCalendarData._IdCalO365; }
            set 
            {
                //ReadOnly except for register operations
                if (_lRegisterMode) OSharedCalendarData._IdCalO365 = value;
            }
        }

        internal static bool _SharedCalendarActive
        {
            get { return OSharedCalendarData._ShareCalendar; }
            set { OSharedCalendarData._ShareCalendar = value; }
        }

        public bool _IsSharingCalendar
        {
            get 
            {
                //Is sharing when the option is true and email is SET
                return (OSharedCalendarData._ShareCalendar && !String.IsNullOrWhiteSpace(OSharedCalendarData._EmailO365));
            }
        }

        #endregion Shared calendar Data

        protected static string _UserCalendars
        {
            get
            {
                return Usuario._This._UserCalendars;
            }
            set
            {
                Usuario._This._UserCalendars = value;
            }
        }

        protected static string _CurrentUserCode
        {
            get
            {
                return Usuario._This._Codigo.TrimEnd();
            }
        }


        public string _ErrorMessage
        {
            get { return _cErrorMessage; }
            set { _cErrorMessage = value; }
        }
        private string _cErrorMessage = "";

        #region Eventos

        public delegate void _Authentication_Failed(object sender, EventArgs e);

        public event _Authentication_Failed _OnAuthenticationFailed;

        private void _Throw_Authentication_Failed_Event()
        {
            //local copy for threadsafe
            var handler = _OnAuthenticationFailed;
            //if suscriptors
            if (handler != null)
                handler(this, null);
        }

        #endregion Eventos

        #region O365Management

        private static bool RenewToken()
        {
            _IsLogged = _O365ManagementUser.Login();
            if (_IsLogged)
            {
                //Get the account info of the login
                AccountInfo loAccount = (AccountInfo)_O365ManagementUser.GetAccountInfo();
                if (loAccount != null) _OperatingAs = loAccount.Id;


                _ClientId = _O365ManagementUser.ClientId;
                _RefreshToken = _O365ManagementUser.RefreshToken;
                _ServiceResourceIds = new JavaScriptSerializer().Serialize(O365Management.ServiceResourceIds); //_O365Management.ClientId;
                Usuario._This._Save(); //Forced save to BBDD
            }
            else
            {
                //login skiped / failed
            }
            return _IsLogged;
        }

        private void Clear_User_Data()
        {
            _ClientId = "";
            _RefreshToken = "";
            _ServiceResourceIds = "";
            _UserCalendars = "";
            Usuario._This._Save(); //Forced save to BBDD
        }

        private static string _OperatingAs { get; set; }

        private static bool _IsLogged = false;

        protected void _ValidateCalendarId(ref string tcCalendarId)
        {
            //If we where operating against shared calendar the Id must be forced to the correct one (from BBDD)
            if (_lUseSharedCalendar) tcCalendarId = _SharedCalendarId;
        }

        private static bool RenewTokenSage50()
        {
            _IsLogged = _O365ManagementSage50.Login();
            if (_IsLogged)
            {
                //Get the account info of the login
                AccountInfo loAccount = (AccountInfo)_O365ManagementSage50.GetAccountInfo();
                if (loAccount != null) _OperatingAs = loAccount.Id;

                if (String.IsNullOrWhiteSpace(_SharedEmail) || loAccount.Id.Trim() == _SharedEmail.Trim()) //Cuenta coincidente o no establecida la directriz
                {
                    _SharedRefreshToken = _O365ManagementSage50.RefreshToken;
                    _SharedServiceResourceIds = new JavaScriptSerializer().Serialize(O365ManagementSage50.ServiceResourceIds);
                }
                else
                {
                    string lcErrorMessage = "Para esta operación se requiere la cuenta: " + Environment.NewLine + _SharedEmail.Trim();
                        
                    functions.FUNCTIONS._MessageBox(lcErrorMessage, "Error operación o365",
                        System.Windows.Forms.MessageBoxButtons.OK,
                        System.Windows.Forms.MessageBoxIcon.Error,
                        System.Windows.Forms.MessageBoxDefaultButton.Button1);

                     //Cuenta no concordante
                     _O365ManagementSage50.Logout();
                }

            }
            return _IsLogged;
        }

        public virtual bool _UseSharedCalendar
        {
            get { return _lUseSharedCalendar; }
            set { _lUseSharedCalendar = value; }
        }
        private static bool _lUseSharedCalendar = false;

        public static IManagement O365Management
        {
            get 
            {
                if (_lUseSharedCalendar || _lRegisterMode) 
                    return o365consumer.O365ManagementSage50; 
                else 
                    return o365consumer.O365ManagementUser; 
            }
        }

        protected static IManagement O365ManagementUser
        {
            get
            {
                //To check user changed
                _Sage50User = Usuario._This._Codigo.TrimEnd();

                if (_O365ManagementUser == null || String.IsNullOrEmpty(_O365ManagementUser.RefreshToken) || String.IsNullOrEmpty(_O365ManagementUser.ClientId))
                {
                    _O365ManagementUser = new O365Management();

                    if (!String.IsNullOrWhiteSpace(_RefreshToken) && !String.IsNullOrWhiteSpace(_ServiceResourceIds))
                    {
                        _O365ManagementUser.RefreshToken = _RefreshToken;

                        _O365ManagementUser.ServiceResourceIds = new JavaScriptSerializer().Deserialize<O365Service[]>(_ServiceResourceIds);

                        _O365ManagementUser.ClientId = _ClientId;
                    }
                    else
                    {
                        RenewToken();
                    }
                }
                return _O365ManagementUser;
            }
        }
        private static IManagement _O365ManagementUser;

        public static void _Resetear_Credenciales(Usuario toUsuario)
        {
            _Reset_User_Credentials(toUsuario);
        }

        protected static void _Reset_User_Credentials(Usuario toUser)
        {

            //Si es el mismo usuario de la conexion => Fuerzo logout
            if (!String.IsNullOrWhiteSpace(_Sage50User) && _O365ManagementUser != null && _Sage50User == toUser._Codigo)
            {
                //El usuario actual concuerda con el de las credenciales
                //Estos campos apuntan al usuario _This
                _ClientId = "";
                _RefreshToken = "";
                _ServiceResourceIds = "";
                _UserCalendars = "";
                _O365ManagementUser = null;
            }
            else 
                _Sage50User = toUser._Codigo; //Si el usuario almacenado no concuerda hace un logout

            //Creo un manager no vinculado a nada
            IManagement oManager = new O365Management();
            //Logout forzado por si reaprovecha conexión preexistente (static 2 usos seguidos)
            oManager.Logout();

            //Solicito login
            _IsLogged = oManager.Login();
            if (_IsLogged) //Si me lo da lo guardo
            {
                toUser._ClientId = oManager.ClientId;
                toUser._RefreshToken = oManager.RefreshToken;
                toUser._ServiceResourceIds = new JavaScriptSerializer().Serialize(oManager.ServiceResourceIds); //_O365Management.ClientId;
            }
            else //No hace el login
            {
                //Vaciar los datos
                toUser._ClientId = "";
                toUser._RefreshToken = "";
                toUser._ServiceResourceIds = "";
            }

            //Con o sin login salvo los datos
            toUser._UserCalendars = ""; //Sin calendarios prefijados
            toUser._Save(); //Forced save to BBDD
        }

        protected static IManagement O365ManagementSage50
        {
            get
            {
                if (_O365ManagementSage50 == null || String.IsNullOrEmpty(_O365ManagementSage50.RefreshToken) || String.IsNullOrEmpty(_O365ManagementSage50.ClientId))
                {
                    _O365ManagementSage50 = new O365Management();

                    if (!String.IsNullOrWhiteSpace(_SharedRefreshToken) && !String.IsNullOrWhiteSpace(_SharedServiceResourceIds))
                    {
                        _O365ManagementSage50.RefreshToken = _SharedRefreshToken;
                        _O365ManagementSage50.ServiceResourceIds = new JavaScriptSerializer().Deserialize<O365Service[]>(_SharedServiceResourceIds);
                    }
                    else
                    {
                        RenewTokenSage50();
                    }
                }
                return _O365ManagementSage50;
            }
        }
        private static IManagement _O365ManagementSage50;
       

        #endregion


        #region Constructors

        public o365consumer() 
        { 
        
        }

        #endregion Constructors

        #region Public methods

        public virtual string _ShowUsers()
        {
            //String to store selected users email
            string lcUsuariosSeleccionados = "";

            //Configure the user browser form
            sage.ew.botones.btBrowser lbtBrowser = new botones.btBrowser();
            lbtBrowser._Seleccion_Multiple = true; //Multiselection enabled
            lbtBrowser._Tabla = "USUARIOS";
            lbtBrowser._DataBase = "COMUNES";
            lbtBrowser._Codigo = "NOMBRE";
            lbtBrowser._Clave = "NOMBRE";
            lbtBrowser._Campo_Predet = "NOMBRE";
            lbtBrowser._Titulos_Campos = "Nombre, Email";
            lbtBrowser._Campos = "NOMBRE, MAIL";
            lbtBrowser._Condicion = "MAIL<>'' ";
            lbtBrowser.PerformClick();

            //Proccess the result selecction
            if (lbtBrowser._Codigo_List != null && lbtBrowser._Codigo_List.Count > 0)
            {
                //_Codigo_List is a KeyValuePair
                foreach (KeyValuePair<string,object> lkvpISelectedItem in lbtBrowser._Codigo_List)
                {
                    //The value is (all) the browser row
                    DataRow loRow = lkvpISelectedItem.Value as DataRow;
                    if (loRow != null)
                    {
                        try
                        {
                            string lcUsuario = Convert.ToString(loRow["mail"]).Trim();
                            if (!String.IsNullOrWhiteSpace(lcUsuario) && !lcUsuario.EndsWith(";")) lcUsuario += ";";
                            lcUsuariosSeleccionados += lcUsuario;
                        }
                        catch (Exception loEx)
                        {
                            _RaiseException(loEx);
                        }
                    }
                }
            }
            return lcUsuariosSeleccionados;
        }

        public void _RaiseException(Exception toException)
        {
            if (_IsLogged)
            {
                string lcErrorMessage = "";

                //PE-97256
                if (O365Management.MessageError != null && O365Management.MessageError.Contains("The user or administrator has not consented to use the application"))
                {
                    lcErrorMessage = "Se ha poducido una incidencia en la validación de la cuenta de correo al acceder al calendario en Microsoft 365. " +
                        "Deberá revisar los siguientes apartados de configuración:" + Environment.NewLine +
                        "- No se trata de una cuenta de Microsoft 365" + Environment.NewLine +
                        "- No existen los permisos necesarios en la aplicación" + Environment.NewLine +
                        "- Se han denegado los permisos en la aplicación";
                    //At this moment we know that it were invalid to operate credencials stored in the DDBB. We call a clean function 
                    Clear_User_Data();
                }
                else
                {
                    lcErrorMessage = "Se ha producido un error cuando se ha intentado realizar la comunicación con Microsoft 365" +
                        Environment.NewLine + "El mensaje por parte de Microsoft 365 es: " + Environment.NewLine + toException.Message +
                        Environment.NewLine + Environment.NewLine +
                        "Revisa la configuración de la cuenta en Microsoft 365";  //PE-97418

                    //Detectado en instalación propia un error que resulta bloqueante:
                    //Teniendo unas credenciales válidas pero con un refreshtoken expirado (90 días) Login devuelve true pero no recarga el token y falla
                    //Cuando detectamos este caso concreto purgamos las credenciales para forzar un login completo
                    if(toException.Message.Contains("refresh token has expired due to inactivity"))
                    {
                        Clear_User_Data();
                    }
                }

                functions.FUNCTIONS._MessageBox(lcErrorMessage, "Error operación o365",
                    System.Windows.Forms.MessageBoxButtons.OK,
                    System.Windows.Forms.MessageBoxIcon.Error,
                    System.Windows.Forms.MessageBoxDefaultButton.Button1);
                _ErrorMessage = toException.Message;
                db.DB.Registrar_Error(toException);
            }
            else
            {
                string lcErrorMessage = "No ha sido posible obtener el código de autenticación.";
                functions.FUNCTIONS._MessageBox(lcErrorMessage, "Error operación o365",
                    System.Windows.Forms.MessageBoxButtons.OK,
                    System.Windows.Forms.MessageBoxIcon.Error,
                    System.Windows.Forms.MessageBoxDefaultButton.Button1);
                _ErrorMessage = toException.Message;
                db.DB.Registrar_Error(toException);

                //PE-97171
                _Throw_Authentication_Failed_Event();
            }
        }

        #endregion Public methods

        internal void _ResetOManagers()
        {
            if(_O365ManagementSage50 != null) _O365ManagementSage50.Logout();
            _O365ManagementSage50 = null;
            _O365ManagementSage50 = new O365Management();
            if (_O365ManagementUser != null) _O365ManagementUser.Logout();
            _O365ManagementUser = null;
            _O365ManagementUser = new O365Management();
            OSharedCalendarData = null;
        }

        internal void _ResetUserStoredCalendars()
        {
            bool llOk = false;
            string lcSql = "UPDATE " + DB.SQLDatabase("COMUNES","USUARIOS") + " SET USERCALENDARS = ''"; //For all of the users
            llOk = DB.SQLExec(lcSql);

            //Referencia estática al USUARIO._This
            _UserCalendars = "";
        }
    }

    internal class SharedCalendarData
    {
        #region Encryption

        private Criptografia _oCifrado = new Criptografia();
        private string _cClaveCifrado = "#Nice to see you";

        #endregion Encryption

        #region Public properties

        public bool _ShareCalendar
        {
            get { return _lShareCalendar; }
            set 
            { 
                _lShareCalendar = value;
                _SetDataField("CMPCALO365", value.ToString());
            }
        }
        private bool _lShareCalendar;

        public string _EmailO365
        {
            get { return _cEmailO365; }
            set { _cEmailO365 = value; }
        }
        private string _cEmailO365;

        public string _IdCalO365
        {
            get { return _cIdCalO365; }
            set { _cIdCalO365 = value; }
        }
        private string _cIdCalO365;

        public string _TokenO365
        {
            get { return _cTokenO365; }
            set { _cTokenO365 = value; }
        }
        private string _cTokenO365;

        public string _RRIdsO365
        {
            get { return _cRRIdsO365; }
            set { _cRRIdsO365 = value; }
        }
        private string _cRRIdsO365;

        #endregion Public properties

        #region Constructors

        public SharedCalendarData()
        {
            _Load();
        }

        #endregion Constructors

        #region Public methods

        public bool _Load()
        {
            string lcSql = "SELECT CMPCALO365, EMAILO365, IDCALO365, TOKENO365, RRIDSO365 FROM" + DB.SQLDatabase("COMUNES", "CODCOM");
            bool llOk = false;
            DataTable ldtResultado = new DataTable();

            llOk = DB.SQLExec(lcSql, ref ldtResultado);
            if (llOk && ldtResultado.Rows.Count > 0)
            {
                _lShareCalendar = Convert.ToBoolean(ldtResultado.Rows[0]["CMPCALO365"]);
                _cEmailO365 = _oCifrado.DesencriptaSimetricaAES(Convert.ToString(ldtResultado.Rows[0]["EMAILO365"]).TrimEnd(), _cClaveCifrado);
                _cIdCalO365 = _oCifrado.DesencriptaSimetricaAES(Convert.ToString(ldtResultado.Rows[0]["IDCALO365"]).TrimEnd(), _cClaveCifrado);
                _cTokenO365 = _oCifrado.DesencriptaSimetricaAES(Convert.ToString(ldtResultado.Rows[0]["TOKENO365"]).TrimEnd(), _cClaveCifrado);
                _cRRIdsO365 = _oCifrado.DesencriptaSimetricaAES(Convert.ToString(ldtResultado.Rows[0]["RRIDSO365"]).TrimEnd(), _cClaveCifrado);
            }
            return llOk;
        }

        public bool _Save()
        {
            string lcSql = "UPDATE " + DB.SQLDatabase("COMUNES", "CODCOM") + " SET " +
                           " CMPCALO365 = " + DB.SQLString(_lShareCalendar) + ", " + 
                           " EMAILO365 = " + DB.SQLString(_oCifrado.EncriptaSimetricaAES(_cEmailO365, _cClaveCifrado)) + ", " +
                           " IDCALO365 = " + DB.SQLString(_oCifrado.EncriptaSimetricaAES(_cIdCalO365, _cClaveCifrado)) + ", " +
                           " TOKENO365 = " + DB.SQLString(_oCifrado.EncriptaSimetricaAES(_cTokenO365, _cClaveCifrado)) + ", " +
                           " RRIDSO365 = " + DB.SQLString(_oCifrado.EncriptaSimetricaAES(_cRRIdsO365, _cClaveCifrado));

            return DB.SQLExec(lcSql);
        }

        public void _Update(AccountInfo toAccount, string tcRefreshToken, string tcResoucesServiceIds)
        {
            //Exit if not the correct account 
            if (toAccount.Id != _cEmailO365) return;

            _cTokenO365 = tcRefreshToken;
            _cRRIdsO365 = tcResoucesServiceIds;
        }

        #endregion Public methods

        #region Private methods

        private bool _GetDataField(string tcDataFieldName, out string tcDataValue)
        {
            string lcSql = "SELECT [" + tcDataFieldName.TrimEnd() + "] FROM" + DB.SQLDatabase("COMUNES", "CODCOM");
            bool llOk = false;
            string lcDataValue = "";
            DataTable ldtResultado = new DataTable();

            llOk = DB.SQLExec(lcSql, ref ldtResultado);
            if (llOk && ldtResultado.Rows.Count > 0)
            {

                lcDataValue = _oCifrado.DesencriptaSimetricaAES(Convert.ToString(ldtResultado.Rows[0][tcDataFieldName]).TrimEnd(), _cClaveCifrado);
            }

            tcDataValue = lcDataValue;
            return llOk;
        }

        private bool _SetDataField(string tcDataFieldName, string tcDataValue)
        {
            if (tcDataFieldName == "CMPCALO365") //bool not encripted
            {
                string lcSql = "UPDATE " + DB.SQLDatabase("COMUNES", "CODCOM") + " SET [" + tcDataFieldName + "] = " +
                           DB.SQLString(tcDataValue);

                return DB.SQLExec(lcSql);
            }
            else
            {
                string lcSql = "UPDATE " + DB.SQLDatabase("COMUNES", "CODCOM") + " SET [" + tcDataFieldName + "] = " +
                                           DB.SQLString(_oCifrado.EncriptaSimetricaAES(tcDataValue, _cClaveCifrado));

                return DB.SQLExec(lcSql);
            }
        }

        #endregion Private methods
    }
}