public static LoginResultModel ValidateUserLogin(LoginModel userlogin)
{
var loginResult = new LoginResultModel();
try
{
var UserName = new SqlParameter {
ParameterName = "UserName", Value = userlogin.UserName
};
var Password = new SqlParameter {
ParameterName = "Password", SqlDbType = SqlDbType.NVarChar, Value = Encrypt(userlogin.Password)
};
using (var dbContext = new CompanyDBEntities())
{
var results = dbContext
.MultipleResults("[dbo].[PROC_ValidateUserLoginReport]")
.With <LoginResultModel>()
.With <CompanyModel>()
.Execute(UserName, Password);
if (results != null && results.Count > 0)
{
loginResult = ((List <LoginResultModel>)results[0]).SingleOrDefault();
if (loginResult != null)
{
if (loginResult.ResponseCode.Equals("00"))
{
loginResult.LstCompany = ((List <CompanyModel>)results[1]).ToList();
if (loginResult.LstCompany.Count > 0)
{
loginResult.DBName = loginResult.LstCompany.FirstOrDefault().DBName;
loginResult.CompanyName = loginResult.LstCompany.FirstOrDefault().CompanyName;
}
}
}
}
}
}
catch (Exception ex)
{
Common.LogError("Login", "ValidateUserLogin", "ValidateUserLogin", ex.Message.ToString(), ex.InnerException.Message.ToString(), "", "");
}
return(loginResult);
}