public Task <int> Create(SaleTxn saleTxn)
{
var dbPara = new DynamicParameters();
var articleId = Task.FromResult(_dapperManager.Get <int>(
$"INSERT INTO [SaleTxn](SaleTxnStatus, SaleTxnQty, SaleTxnSubTotal, SaleReceivedQty, SaleTxnProductID, SaleTxnOrderID ,DELETED, UpdatedDateTime, UpdatedBy) OUTPUT Inserted.ID VALUES('{saleTxn.SaleTxnStatus}','{saleTxn.SaleTxnQty}','{saleTxn.SaleSubTotal}', '{saleTxn.SaleReceivedQty}','{saleTxn.SaleProduct.ID}','{saleTxn.SaleTxnOrderID}' ,'{false}', CONVERT(datetime,'{saleTxn.UpdatedDateTime}',103), '{saleTxn.UpdatedBy}')",
null,
commandType: CommandType.Text));
return(articleId);
}
public Task <int> Update(SaleTxn saleTxn)
{
var dbPara = new DynamicParameters();
dbPara.Add("ID", saleTxn.ID, DbType.Int32);
dbPara.Add("SaleTxnStatus", saleTxn.SaleTxnStatus, DbType.Int32);
dbPara.Add("SaleTxnProductID", saleTxn.SaleTxnProductID, DbType.Int32);
dbPara.Add("SaleTxnQty", saleTxn.SaleTxnQty, DbType.Double);
dbPara.Add("SaleTxnSubTotal", saleTxn.SaleSubTotal, DbType.Double);
dbPara.Add("SaleReceivedQty", saleTxn.SaleReceivedQty, DbType.Double);
dbPara.Add("DELETED", false, DbType.Boolean);
dbPara.Add("UpdatedDateTime", System.DateTime.Now, DbType.DateTime);
dbPara.Add("UpdatedBy", "abc", DbType.String);
var updateArticle = Task.FromResult(_dapperManager.Update <int>("[dbo].[SP_Update_SaleTxn]",
dbPara,
commandType: CommandType.StoredProcedure));
return(updateArticle);
}
