public ICollection <LookupModel> GetLookups(string type, string description, string category, int?status = null) { using (var conn = new SQLContext().Database.Connection) { using (var reader = conn.QueryMultiple("dbo.s_get_lookups", new { type = type, description = description, category = category, status = status }, commandType: System.Data.CommandType.StoredProcedure)) { var result = reader.Read <LookupModel>().ToList(); return(result); } } }
public ICollection <LookupModel> GetLookupsSetting(string category) { using (var conn = new SQLContext().Database.Connection) { using (var reader = conn.QueryMultiple("dbo.s_get_lookups_setting", new { category = category }, commandType: System.Data.CommandType.StoredProcedure)) { var result = reader.Read <LookupModel>().ToList(); return(result); } } }
public ICollection <UserModel> GetUsers(string userEmail, string userFullName, int?status) { using (var conn = new SQLContext().Database.Connection) { using (var reader = conn.QueryMultiple("dbo.s_get_users", new { userEmail = userEmail, userFullName = userFullName, status = status }, commandType: System.Data.CommandType.StoredProcedure)) { var result = reader.Read <UserModel>().ToList(); return(result); } } }
public ICollection <Select2Model> GetLookupsCategory(int?status) { using (var conn = new SQLContext().Database.Connection) { using (var reader = conn.QueryMultiple("dbo.s_get_lookup_category", new { status = status }, commandType: CommandType.StoredProcedure)) { var result = reader.Read <Select2Model>().ToList(); return(result); } } }