public async Task <IEnumerable <Ac_Mtr_Agreement_Detail> > ListInventory(Ac_Mtr_Agreement_Detail model)
{
using (var connection = new SqlConnection(ConnectionString))
{
var result = connection.Query <
Common.Ac_Mtr_Agreement_Detail>
("PA_PRO_AGREEMENT_SYNC_INVENTORY",
param: new
{
@P_AGREEMENT_ID = model.Pk_Ac_Trade_Agreement
},
commandType: CommandType.StoredProcedure);
return(await Task.FromResult <IEnumerable <Ac_Mtr_Agreement_Detail> >(result.ToList()));
}
}
public async Task <IEnumerable <Ac_Mtr_Agreement_Detail> > List(Ac_Mtr_Agreement_Detail model)
{
using (var connection = new SqlConnection(ConnectionString))
{
var result = connection.Query <
Common.Ac_Mtr_Agreement_Detail>
("PA_CON_AC_MTR_AGREEMENT_GET",
param: new
{
P_PK_AC_TRADE_AGREEMENT = model.Pk_Ac_Trade_Agreement,
// P_PK_GLB_PRODUCTS = model.Pk_Glb_Products
},
commandType: CommandType.StoredProcedure);
return(await Task.FromResult <IEnumerable <Ac_Mtr_Agreement_Detail> >(result.ToList()));
}
}
public async Task <IEnumerable <Ac_Mtr_Agreement_Detail> > DeleteScalar(Ac_Mtr_Agreement_Detail model)
{
using (var connection = new SqlConnection(ConnectionString))
{
var result = connection.Query <
Common.Ac_Mtr_Agreement_Detail>
("PA_CON_AC_MTR_AGREEMENT_DELETE",
param: new
{
P_PK_CAT_AGREEMENT_DETAILS = model.Pk_Cat_Agreement_Details,
P_PK_AC_TRADE_AGREEMENT = model.Pk_Ac_Trade_Agreement,
P_PK_GLB_PRODUCTS = model.Pk_Glb_Products,
P_CREATION_USER = model.Creation_User,
P_MODIFICATION_DATE = model.Modification_Date,
P_MODIFICATION_USER = model.Modification_User
},
commandType: CommandType.StoredProcedure);
return(await Task.FromResult <IEnumerable <Ac_Mtr_Agreement_Detail> >(result.ToList()));
}
}
