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