private bool IsValid(string username, string password) { bool IsValid = false; using (HRIMSdbEntities db = new HRIMSdbEntities()) { var user = db.tblLogins.Where(x => x.varLoginName == username).FirstOrDefault(); if (user != null) { if (user.varPassword == password) { IsValid = true; } } } return(IsValid); }