public LoginStatus AllowedToLogin(LoginViewModel vm)
{
using (var con = conFac.GetConnection())
{
using (var cmd = QueryConst.GetLoginCommand(con, vm.EmpId))
{
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (!dr.HasRows)
{
return(LoginStatus.NotFound);
}
dr.Read();
vm.FirstName = dr.GetFieldValue <string>(0).Trim();
bool isActive = dr.GetFieldValue <bool>(1);
string jobCode = dr.GetFieldValue <string>(2).Trim();
if (isActive && ApplicationVariable.JobCodeAllowedToLogin().Any(c => string.Equals(c, jobCode, StringComparison.InvariantCultureIgnoreCase)))
{
return(LoginStatus.Successful);
}
else
{
return(LoginStatus.NotAllowed);
}
}
}
}
