public async Task <IEnumerable <Do_Cat_Label> > List(Do_Cat_Label model)
{
using (var connection = new SqlConnection(ConnectionString))
{
var result = connection.Query <
Common.Do_Cat_Label,
Common.Do_Cat_Form,
Common.Do_Cat_Language,
Common.Do_Cat_Organization,
Common.Do_Cat_Label>
("PA_CON_CAT_LABEL",
map: (a, b, c, d) =>
{
a.GblCatForm = (Common.Do_Cat_Form)b;
a.GblCatLanguage = (Common.Do_Cat_Language)c;
a.GblOrganization = (Common.Do_Cat_Organization)d;
return(a);
},
splitOn: "PK_GLB_CAT_LABEL, PK_GLB_CAT_FORM, PK_GLB_CAT_LANGUAGE, PK_GLB_MTR_ORGANIZATION",
param: new
{
CODE = model.GblCatForm.Code,
PK_GLB_MTR_ORGANIZATION = model.GblOrganization.Pk_Glb_Mtr_Organization,
LABEL = model.Label,
ISO = model.GblCatLanguage.Iso,
P_ROWS_PAGE = model.Rows_Pag,
P_PAGE_NUMBER = model.Page_Number
},
commandTimeout: 0,
commandType: CommandType.StoredProcedure);
return(await Task.FromResult <IEnumerable <Do_Cat_Label> >(result.ToList()));
}
}
public Task Delete(Do_Cat_Label entity)
{
throw new NotImplementedException();
}
