public static User CheckUser(string _userName, string _password)
{
try
{
NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString);
var dbUsers = from u in newAppsCnn.Sec_Users where u.UserLogin == _userName && u.Password == _password select u;
if (dbUsers.Count() > 0)
{
Sec_Users dbUser = dbUsers.First();
User user = new User();
user.FromDbUser(dbUser);
user.LoadUserMenu(dbUser);
return user;
}
else
return null;
}
catch (Exception ex)
{
throw ex;
}
}
