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 Task <IActionResult> UpdateDetail(UspReturnTradeDetail tradeDetailVModel)
{
var rep = new Repository.Repository(_context);
return(await rep.UpdateDetail(tradeDetailVModel, User.Identity.Name) > 0
? (ActionResult)
Content("<script language='javascript' type='text/javascript'>alert('Updated'); window.location='" + Request.Headers["referer"] + "'</script>")
: Content("<script language='javascript' type='text/javascript'>alert('Not updated!');</script>"));
}
