Пример #1
0
        public IHttpActionResult PutQUY_PHIEU_THU(string id, QUY_PHIEU_THU qUY_PHIEU_THU)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != qUY_PHIEU_THU.SO_CHUNG_TU)
            {
                return(BadRequest());
            }

            db.Entry(qUY_PHIEU_THU).State = EntityState.Modified;

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!QUY_PHIEU_THUExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(StatusCode(HttpStatusCode.NoContent));
        }
Пример #2
0
        public IHttpActionResult GetQUY_PHIEU_THU(string id)
        {
            QUY_PHIEU_THU qUY_PHIEU_THU = db.QUY_PHIEU_THU.Find(id);

            if (qUY_PHIEU_THU == null)
            {
                return(NotFound());
            }

            return(Ok(qUY_PHIEU_THU));
        }
Пример #3
0
        public IHttpActionResult DeleteQUY_PHIEU_THU(string id)
        {
            QUY_PHIEU_THU qUY_PHIEU_THU = db.QUY_PHIEU_THU.Find(id);

            if (qUY_PHIEU_THU == null)
            {
                return(NotFound());
            }

            db.QUY_PHIEU_THU.Remove(qUY_PHIEU_THU);
            db.SaveChanges();

            return(Ok(qUY_PHIEU_THU));
        }
Пример #4
0
        public IHttpActionResult PostQUY_PHIEUTHU(QuyPhieuThu quy_phieuthu)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }


            //Lưu thông tin nhập kho
            QUY_PHIEU_THU qpt = new QUY_PHIEU_THU();

            qpt.NGAY_CHUNG_TU       = GeneralFunction.ConvertToTime(quy_phieuthu.NGAY_CHUNG_TU);
            qpt.NGAY_HACH_TOAN      = GeneralFunction.ConvertToTime(quy_phieuthu.NGAY_HACH_TOAN);
            qpt.SO_CHUNG_TU         = AutoMA_DU_KIEN();
            qpt.MA_DOI_TUONG        = quy_phieuthu.MA_DOI_TUONG;
            qpt.LY_DO_NOP           = quy_phieuthu.LY_DO_NOP;
            qpt.DIEN_GIAI_LY_DO_NOP = quy_phieuthu.DIEN_GIAI_LY_DO_NOP;
            qpt.NGUOI_NOP           = quy_phieuthu.NGUOI_NOP;
            qpt.NHAN_VIEN_THU       = quy_phieuthu.NHAN_VIEN_THU;
            qpt.NGUOI_LAP_BIEU      = quy_phieuthu.NGUOI_LAP_BIEU;
            qpt.TRUC_THUOC          = "HOPLONG";
            db.QUY_PHIEU_THU.Add(qpt);

            //Lưu thông tin tham chiếu
            if (quy_phieuthu.ThamChieu.Count > 0)
            {
                foreach (ThamChieu item in quy_phieuthu.ThamChieu)
                {
                    XL_THAM_CHIEU_CHUNG_TU newItem = new XL_THAM_CHIEU_CHUNG_TU();
                    newItem.SO_CHUNG_TU_GOC        = qpt.SO_CHUNG_TU;
                    newItem.SO_CHUNG_TU_THAM_CHIEU = item.SO_CHUNG_TU;
                    db.XL_THAM_CHIEU_CHUNG_TU.Add(newItem);
                }
            }
            //Lưu chi tiết
            decimal tongtien = 0;

            //TONKHO_HOPLONG HHTon = new TONKHO_HOPLONG();
            //HH_NHOM_VTHH NhomHang = new HH_NHOM_VTHH();
            if (quy_phieuthu.ChiTietQPT != null && quy_phieuthu.ChiTietQPT.Count > 0)
            {
                foreach (ChiTietQuyPhieuThu item in quy_phieuthu.ChiTietQPT)
                {
                    QUY_CT_PHIEU_THU newItem = new QUY_CT_PHIEU_THU();
                    newItem.SO_CHUNG_TU  = qpt.SO_CHUNG_TU;
                    newItem.DIEN_GIAI    = item.DIEN_GIAI;
                    newItem.LOAI_TIEN    = item.LOAI_TIEN;
                    newItem.TK_CO        = item.TK_CO;
                    newItem.TK_NO        = item.TK_NO;
                    newItem.SO_TIEN      = Convert.ToDecimal(item.SO_TIEN);
                    newItem.TY_GIA       = Convert.ToInt32(item.TY_GIA);
                    newItem.QUY_DOI      = newItem.SO_TIEN * newItem.TY_GIA;
                    tongtien            += newItem.QUY_DOI;
                    newItem.DOI_TUONG    = qpt.MA_DOI_TUONG;
                    newItem.TK_NGAN_HANG = item.TK_NGAN_HANG;
                    db.QUY_CT_PHIEU_THU.Add(newItem);
                }
            }
            //Lưu nhật ký chung

            if (quy_phieuthu.ChiTietQPT != null && quy_phieuthu.ChiTietQPT.Count > 0)
            {
                foreach (ChiTietQuyPhieuThu item in quy_phieuthu.ChiTietQPT)
                {
                    KT_SO_NHAT_KY_CHUNG newitem = new KT_SO_NHAT_KY_CHUNG();
                    newitem.SO_CHUNG_TU         = qpt.SO_CHUNG_TU;
                    newitem.NGAY_CHUNG_TU       = qpt.NGAY_CHUNG_TU;
                    newitem.NGAY_HACH_TOAN      = qpt.NGAY_HACH_TOAN;
                    newitem.DOI_TUONG           = qpt.MA_DOI_TUONG;
                    newitem.TRUC_THUOC          = "HOPLONG";
                    newitem.DIEN_GIAI_CHUNG     = qpt.DIEN_GIAI_LY_DO_NOP;
                    newitem.DIEN_GIAI_CHI_TIET  = item.DIEN_GIAI;
                    newitem.TAI_KHOAN_HACH_TOAN = item.TK_NO;
                    newitem.TAI_KHOAN_DOI_UNG   = item.TK_CO;
                    newitem.PHAT_SINH_NO        = tongtien;
                    newitem.PHAT_SINH_CO        = 0;
                    db.KT_SO_NHAT_KY_CHUNG.Add(newitem);
                    KT_SO_NHAT_KY_CHUNG newitem1 = new KT_SO_NHAT_KY_CHUNG();
                    newitem1.SO_CHUNG_TU         = qpt.SO_CHUNG_TU;
                    newitem1.NGAY_CHUNG_TU       = qpt.NGAY_CHUNG_TU;
                    newitem1.NGAY_HACH_TOAN      = qpt.NGAY_HACH_TOAN;
                    newitem1.DOI_TUONG           = qpt.MA_DOI_TUONG;
                    newitem1.TRUC_THUOC          = "HOPLONG";
                    newitem1.DIEN_GIAI_CHUNG     = qpt.DIEN_GIAI_LY_DO_NOP;
                    newitem1.DIEN_GIAI_CHI_TIET  = item.DIEN_GIAI;
                    newitem1.TAI_KHOAN_HACH_TOAN = item.TK_CO;
                    newitem1.TAI_KHOAN_DOI_UNG   = item.TK_NO;
                    newitem1.PHAT_SINH_NO        = 0;
                    newitem1.PHAT_SINH_CO        = tongtien;
                    db.KT_SO_NHAT_KY_CHUNG.Add(newitem1);
                    db.SaveChanges();
                }
            }

            qpt.TONG_TIEN = tongtien;



            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateException)
            {
                if (QUY_PHIEU_THUExists(quy_phieuthu.SO_CHUNG_TU))
                {
                    return(Conflict());
                }
                else
                {
                    throw;
                }
            }


            return(Ok(qpt.SO_CHUNG_TU));
        }