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