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