public async Task <ActionResult <dtInvVoucher> > PostdtInvVoucher(dtInvVoucher dtInvVoucher)
{
_context.dtInvVoucher.Add(dtInvVoucher);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetdtInvVoucher", new { id = dtInvVoucher.ID }, dtInvVoucher));
}
public Task <dtInvVoucher> CreateVoucher(dtInvVoucher InvVoucher)
{
var dbPara = new DynamicParameters();
dbPara.Add("VNo", InvVoucher.VNo, DbType.String);
dbPara.Add("EffectiveDate", InvVoucher.EffectiveDate, DbType.String);
dbPara.Add("VDate", InvVoucher.VDate, DbType.String);
dbPara.Add("DueDate", InvVoucher.DueDate, DbType.String);
dbPara.Add("CreatedDate", InvVoucher.CreatedDate, DbType.String);
dbPara.Add("ModifiedDate", InvVoucher.ModifiedDate, DbType.String);
dbPara.Add("StaffName", InvVoucher.StaffName, DbType.String);
dbPara.Add("VType", InvVoucher.VType, DbType.String);
dbPara.Add("BranchID", InvVoucher.BranchID, DbType.String);
dbPara.Add("VATAmt", InvVoucher.VATAmt, DbType.String);
dbPara.Add("VATPaid", InvVoucher.VATPaid, DbType.String);
dbPara.Add("VRound", InvVoucher.VRound, DbType.String);
dbPara.Add("SubTotal", InvVoucher.SubTotal, DbType.String);
dbPara.Add("IsCanceled", InvVoucher.IsCanceled, DbType.String);
dbPara.Add("CreatedUserID", InvVoucher.CreatedUserID, DbType.String);
dbPara.Add("ModifiedUserID", InvVoucher.ModifiedUserID, DbType.String);
dbPara.Add("ExchangeRate", InvVoucher.ExchangeRate, DbType.String);
dbPara.Add("Currency", InvVoucher.Currency, DbType.String);
var VId = Task.FromResult(_dapperManager.Insert <dtInvVoucher>("[VoucherSP]",
dbPara,
commandType: CommandType.StoredProcedure));
return(VId);
}
public async Task <IActionResult> PutdtInvVoucher(long id, dtInvVoucher dtInvVoucher)
{
if (id != dtInvVoucher.ID)
{
return(BadRequest());
}
_context.Entry(dtInvVoucher).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!dtInvVoucherExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
