public long CreateVoucher(long DRCoaID,long CRCoaID,decimal Amount,long VoucherTypeID,DateTime TranDate) { VoucherList DrVoucher = new VoucherList(); VoucherList CrVoucher = new VoucherList(); long? VoucherNo = db.VoucherLists.Where(v => v.CompanyID == loginUser.CompanyID).Select(v => v.VoucherNo).Max(); DrVoucher.COAID = DRCoaID; DrVoucher.Amount = Amount; DrVoucher.DrCr = true; DrVoucher.CompanyID = loginUser.CompanyID; DrVoucher.VoucherTypeID = VoucherTypeID; DrVoucher.TranDate = TranDate; DrVoucher.StatusID = 0; DrVoucher.VoucherNo = VoucherNo > 0 ? VoucherNo + 1 : 1; DrVoucher.InsertBy = loginUser.UserID; DrVoucher.InsertDate = DateTime.Now; db.VoucherLists.Add(DrVoucher); db.SaveChanges(); // CrVoucher = DrVoucher; CrVoucher.COAID = CRCoaID; CrVoucher.DrCr = false; CrVoucher.Amount = Amount; CrVoucher.CompanyID = loginUser.CompanyID; CrVoucher.VoucherTypeID = VoucherTypeID; CrVoucher.TranDate = TranDate; CrVoucher.StatusID = 0; CrVoucher.VoucherNo = VoucherNo > 0 ? VoucherNo + 1 : 1; CrVoucher.InsertBy = loginUser.UserID; CrVoucher.InsertDate = DateTime.Now; db.VoucherLists.Add(CrVoucher); db.SaveChanges(); return (long)CrVoucher.VoucherNo; }
// POST api/VoucherList public HttpResponseMessage PostVoucherList(VoucherList voucherlist) { if (ModelState.IsValid) { voucherlist.InsertBy = loginUser.UserID; db.VoucherLists.Add(voucherlist); db.SaveChanges(); HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, voucherlist); response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = voucherlist.VoucherID })); return response; } else { return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState); } }
// PUT api/VoucherList/5 public HttpResponseMessage PutVoucherList(long id, VoucherList voucherlist) { if (!ModelState.IsValid) { return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState); } if (id != voucherlist.VoucherID) { return Request.CreateResponse(HttpStatusCode.BadRequest); } voucherlist.UpdateBy = loginUser.UserID; db.Entry(voucherlist).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException ex) { return Request.CreateErrorResponse(HttpStatusCode.NotFound, ex); } return Request.CreateResponse(HttpStatusCode.OK); }