Beispiel #1
0
        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;
        }
Beispiel #2
0
        // 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);
            }
        }
Beispiel #3
0
        // 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);
        }