public UserLogin LoginUser(string email, string password, string companyId) { UserLogin loggedUser = null; if (!_commonService.IsCompanyActive(companyId)) { throw new Exception(String.Format("Selected [{0}] institute has not valid licence.", companyId)); } using (var db = ObjectFactory.CreateDbContext(_commonService.GetCompanyDbFilePath(companyId))) { loggedUser = db.GetQueryData <UserLogin>(SQL.UserLoginCheck, new { Email = email, Password = password }).FirstOrDefault(); } return(loggedUser); }
public List <Company> GetAllCompanies(string query) { var data = new List <Company>(); using (var db = ObjectFactory.CreateDbContext(commonService.GetCompanyDbFilePath(this.company))) { data = db.GetQueryData <Company>(SQL.SelectAllCompanyLike, new { Term = "%" + query + "%" }).ToList(); } return(data); }