public async Task <int> UpdateDetail(UspReturnTradeDetail tradeDetailVModel, string userName) { var parameters = new[] { new SqlParameter("@tdTrade", tradeDetailVModel?.tdTrade), new SqlParameter("@BrokerFINNo", tradeDetailVModel?.BrokerFINNo), new SqlParameter("@mOtherFee", tradeDetailVModel?.mOtherFee), new SqlParameter("@ShawBrokerCode", tradeDetailVModel?.ShawBrokerCode), new SqlParameter("@FlagDeleted", tradeDetailVModel?.FlagDeleted), new SqlParameter("@UserCode", tradeDetailVModel?.UserCode), new SqlParameter("@TradeComments", tradeDetailVModel?.TradeComments), new SqlParameter("@DoNotAffirm", tradeDetailVModel?.DoNotAffirm), new SqlParameter("@lastchangedby", userName), new SqlParameter("@lastchangeddate", DateTime.Now), new SqlParameter("@ClearingBrokerFINNo", tradeDetailVModel?.ClearingBrokerFINNo), new SqlParameter("@tdxSecurityType", tradeDetailVModel?.tdxSecurityType), new SqlParameter("@SettlementLoc", tradeDetailVModel?.SettlementLoc), new SqlParameter("@StampDuty", tradeDetailVModel?.StampDuty), new SqlParameter("@ValueAddedTax", tradeDetailVModel?.ValueAddedTax), new SqlParameter("@ISITCIssueType", tradeDetailVModel?.ISITCIssueType), new SqlParameter("@timestamp", tradeDetailVModel?.timestamp), new SqlParameter("@user_name", userName) }; var repo = new GenericRepository <UspReturnTradeDetail>(_context); return(await repo.ExecueUpdateAsync("usp_updateTradeDetail", parameters)); }
public async void DeleteSort(string sortId) { var parameters = new[] { new SqlParameter("@QuickSortID", sortId) }; var repo = new GenericRepository <QuickfindMC>(_context); await repo.ExecueUpdateAsync("usp_deleteQuickSort", parameters); }