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();
}