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