Esempio n. 1
0
        public static async Task <LogonDetailsStruct> DoLogon(string User, string Password, string Server, string PackageName)
        {
            LogonDetailsStruct result            = new LogonDetailsStruct();
            string             _connectionString = string.Format("Server={0};Initial Catalog={1};User Id={2};Password={3};MultipleActiveResultSets=True;Connection Lifetime=3;Max Pool Size=3", Server, "SISTEMAS", "SA", "5380");

            using (SqlConnection gDatos = new SqlConnection(_connectionString))
            {
                try
                {
                    await gDatos.OpenAsync();
                }
                catch (Exception ex)
                {
                    throw ex;//control errores TBD
                }
                using (var sp = new SqlCommand("pLogonUser", gDatos)
                {
                    CommandType = CommandType.StoredProcedure
                })
                {
                    SqlCommandBuilder.DeriveParameters(sp);
                    sp.Parameters["@msg"].Value         = "";
                    sp.Parameters["@User"].Value        = User;
                    sp.Parameters["@Password"].Value    = Password;
                    sp.Parameters["@Origin"].Value      = PackageName;
                    sp.Parameters["@Version"].Value     = "";
                    sp.Parameters["@PackageName"].Value = "";
                    sp.Parameters["@FullName"].Value    = "";
                    try
                    {
                        await sp.ExecuteNonQueryAsync();
                    }
                    catch (Exception ex)
                    {
                        throw ex;
                    }
                    if (sp.Parameters["@msg"].Value.ToString() != "OK")
                    {
                        throw new Exception(sp.Parameters["@msg"].Value.ToString());
                    }
                    result.Version          = sp.Parameters["@Version"].Value.ToString();
                    result.User             = sp.Parameters["@User"].Value.ToString();
                    result.FullName         = sp.Parameters["@FullName"].Value.ToString();
                    result.Password         = sp.Parameters["@Password"].Value.ToString();
                    result.ConnectionServer = Server;
                    return(result);
                }
            }
        }
Esempio n. 2
0
 public static async Task <LogonDetailsStruct> DoLogon(LogonDetailsStruct LogonDetails, string PackageName)
 {
     return(await DoLogon(LogonDetails.User, LogonDetails.Password, LogonDetails.ConnectionServer, PackageName));
 }