public async Task <ICollection <Gbl_Cat_Agreement_Status> > ListCollection(Gbl_Cat_Agreement_Status model)
{
using (var connection = new SqlConnection(ConnectionString))
{
var result = connection.Query <
Common.Gbl_Cat_Agreement_Status>
("PA_CON_GBL_CAT_AGREEMENT_STATUS_GET",
param: new
{
//P_SEARCH_KEY = model.Search_Key
// P_PK_GLB_CAT_CATALOG = model.Pk_Glb_Cat_Catalog,
// P_CREATION_DATE = model.Creation_Date,
// P_CREATION_USER = model.Creation_User,
// P_MODIFICATION_DATE = model.Modification_Date,
// P_MODIFICATION_USER = model.Modification_User,
// P_FK_GLB_CAT_CATALOG = model.Fk_Glb_Cat_Catalog,
P_FK_GLB_CAT_TYPE_CATALOG = model.Fk_Glb_Cat_Type_Catalog
// P_VALUE = model.Value,
// P_DESCRIPTION = model.Description,
// P_EDITABLE = model.Editable,
// P_ACTIVE = model.Active,
// P_SEARCH_KEY_TYPE_CATALOG = model.Search_Key_Type_Catalog
},
commandType: CommandType.StoredProcedure);
return(await Task.FromResult <ICollection <Common.Gbl_Cat_Agreement_Status> >(result.ToList()));
}
}
public async Task <IEnumerable <Gbl_Cat_Agreement_Status> > List(Gbl_Cat_Agreement_Status model)
{
using (var connection = new SqlConnection(ConnectionString))
{
var result = connection.Query <
Common.Gbl_Cat_Agreement_Status>
("PA_CON_GBL_CAT_AGREEMENT_STATUS_GET",
param: new
{
P_FK_GLB_CAT_TYPE_CATALOG = model.Fk_Glb_Cat_Type_Catalog,
},
commandType: CommandType.StoredProcedure);
return(await Task.FromResult <IEnumerable <Gbl_Cat_Agreement_Status> >(result.ToList()));
}
}
