public Users GetUsersDetailsByUserName(string userName)
{
Users users = null;
using (var entity = new TaxProjectDB.TaxProjectDB())
{
var dbUser = (from u in entity.Users
where u.USERNAME == userName
select new
{
u.USERNAME,
u.Password,
u.Salary
}).SingleOrDefault();
if (dbUser != null)
{
users = new Users();
users.EmailAddress = dbUser.USERNAME;
users.Password = dbUser.Password;
users.Salary = dbUser.Salary.Value;
}
}
return(users);
}
public bool IsValidUser(string userName, string password)
{
using (var entity = new TaxProjectDB.TaxProjectDB())
{
return(entity.Users.Any(a => a.USERNAME == userName && a.Password == password));
}
}