public tbl_user validateUser(string username, string password, string role) { syncdbEntities db = new syncdbEntities(); return db.tbl_user.Where(u => u.USERNAME.Equals(username) && u.PASSWORD.Equals(password) && u.ROLE.Equals(role) && u.STATUS == 0).SingleOrDefault(); }
public List<tbl_organization> getOrganizationList() { syncdbEntities db = new syncdbEntities(); return db.tbl_organization.Where(o => o.STATUS == 0).OrderBy(o => o.ORGANIZATION_NAME).ToList(); }