public IHttpActionResult Post(DTO_PRO_ThuyetMinhDeTai tbl_PRO_ThuyetMinhDeTai)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            tbl_PRO_ThuyetMinhDeTai.A8_JSON_CoQuanPhoiHopThucHien          = Newtonsoft.Json.JsonConvert.SerializeObject(tbl_PRO_ThuyetMinhDeTai.ListCoQuanPhoiHop);
            tbl_PRO_ThuyetMinhDeTai.A9_JSON_NhanLucNghienCuu_ChuNhiemDeTai = Newtonsoft.Json.JsonConvert.SerializeObject(tbl_PRO_ThuyetMinhDeTai.ChuNhiemDeTai);
            tbl_PRO_ThuyetMinhDeTai.A9_JSON_NhanLucNghienCuu      = Newtonsoft.Json.JsonConvert.SerializeObject(tbl_PRO_ThuyetMinhDeTai.ListNhanLucNghienCuu);
            tbl_PRO_ThuyetMinhDeTai.B2_JSON_GioiThieuChuyenGia    = Newtonsoft.Json.JsonConvert.SerializeObject(tbl_PRO_ThuyetMinhDeTai.ListGioiThieuChuyenGia);
            tbl_PRO_ThuyetMinhDeTai.B326_JSON_CacBienSoCanThuThap = Newtonsoft.Json.JsonConvert.SerializeObject(tbl_PRO_ThuyetMinhDeTai.ListBienSo);
            tbl_PRO_ThuyetMinhDeTai.B313_JSON_KeHoachThucHien     = Newtonsoft.Json.JsonConvert.SerializeObject(tbl_PRO_ThuyetMinhDeTai.ListKeHoachThucHien);
            tbl_PRO_ThuyetMinhDeTai.B52_JSON_TongHopKinhPhi       = Newtonsoft.Json.JsonConvert.SerializeObject(tbl_PRO_ThuyetMinhDeTai.ListKinhPhiTongHop);
            tbl_PRO_ThuyetMinhDeTai.PhuLuc_JSON_NguyenVatLieu     = Newtonsoft.Json.JsonConvert.SerializeObject(tbl_PRO_ThuyetMinhDeTai.ListKinhPhiNguyenVatLieu);
            tbl_PRO_ThuyetMinhDeTai.PhuLuc_JSON_KhoanCongLaoDong  = Newtonsoft.Json.JsonConvert.SerializeObject(tbl_PRO_ThuyetMinhDeTai.ListKinhPhiCongLaoDong);
            tbl_PRO_ThuyetMinhDeTai.PhuLuc_JSON_ThietBi           = Newtonsoft.Json.JsonConvert.SerializeObject(tbl_PRO_ThuyetMinhDeTai.ListKinhPhiThietBi);
            tbl_PRO_ThuyetMinhDeTai.PhuLuc_JSON_ChiKhac           = Newtonsoft.Json.JsonConvert.SerializeObject(tbl_PRO_ThuyetMinhDeTai.ListKinhPhiKhac);

            DTO_PRO_ThuyetMinhDeTai result = BS_PRO_ThuyetMinhDeTai.post_PRO_ThuyetMinhDeTai(db, tbl_PRO_ThuyetMinhDeTai, Username);

            if (result != null)
            {
                BS_HelperReference.PRO_ThuyetMinhDeTai_Update(db, tbl_PRO_ThuyetMinhDeTai.IDDeTai);
                return(CreatedAtRoute("get_PRO_ThuyetMinhDeTai", new { id = result.ID }, result));
            }
            return(Conflict());
        }
        public IHttpActionResult Get(int id)
        {
            DTO_PRO_ThuyetMinhDeTai tbl_PRO_ThuyetMinhDeTai = BS_PRO_ThuyetMinhDeTai.get_PRO_ThuyetMinhDeTai(db, id);

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

            return(Ok(tbl_PRO_ThuyetMinhDeTai));
        }
        public IHttpActionResult Put(int id, DTO_PRO_ThuyetMinhDeTai tbl_PRO_ThuyetMinhDeTai)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != tbl_PRO_ThuyetMinhDeTai.ID)
            {
                return(BadRequest());
            }

            tbl_PRO_ThuyetMinhDeTai.A8_JSON_CoQuanPhoiHopThucHien          = Newtonsoft.Json.JsonConvert.SerializeObject(tbl_PRO_ThuyetMinhDeTai.ListCoQuanPhoiHop);
            tbl_PRO_ThuyetMinhDeTai.A9_JSON_NhanLucNghienCuu_ChuNhiemDeTai = Newtonsoft.Json.JsonConvert.SerializeObject(tbl_PRO_ThuyetMinhDeTai.ChuNhiemDeTai);
            tbl_PRO_ThuyetMinhDeTai.A9_JSON_NhanLucNghienCuu      = Newtonsoft.Json.JsonConvert.SerializeObject(tbl_PRO_ThuyetMinhDeTai.ListNhanLucNghienCuu);
            tbl_PRO_ThuyetMinhDeTai.B2_JSON_GioiThieuChuyenGia    = Newtonsoft.Json.JsonConvert.SerializeObject(tbl_PRO_ThuyetMinhDeTai.ListGioiThieuChuyenGia);
            tbl_PRO_ThuyetMinhDeTai.B326_JSON_CacBienSoCanThuThap = Newtonsoft.Json.JsonConvert.SerializeObject(tbl_PRO_ThuyetMinhDeTai.ListBienSo);
            tbl_PRO_ThuyetMinhDeTai.B313_JSON_KeHoachThucHien     = Newtonsoft.Json.JsonConvert.SerializeObject(tbl_PRO_ThuyetMinhDeTai.ListKeHoachThucHien);
            tbl_PRO_ThuyetMinhDeTai.B52_JSON_TongHopKinhPhi       = Newtonsoft.Json.JsonConvert.SerializeObject(tbl_PRO_ThuyetMinhDeTai.ListKinhPhiTongHop);
            tbl_PRO_ThuyetMinhDeTai.PhuLuc_JSON_NguyenVatLieu     = Newtonsoft.Json.JsonConvert.SerializeObject(tbl_PRO_ThuyetMinhDeTai.ListKinhPhiNguyenVatLieu);
            tbl_PRO_ThuyetMinhDeTai.PhuLuc_JSON_KhoanCongLaoDong  = Newtonsoft.Json.JsonConvert.SerializeObject(tbl_PRO_ThuyetMinhDeTai.ListKinhPhiCongLaoDong);
            tbl_PRO_ThuyetMinhDeTai.PhuLuc_JSON_ThietBi           = Newtonsoft.Json.JsonConvert.SerializeObject(tbl_PRO_ThuyetMinhDeTai.ListKinhPhiThietBi);
            tbl_PRO_ThuyetMinhDeTai.PhuLuc_JSON_ChiKhac           = Newtonsoft.Json.JsonConvert.SerializeObject(tbl_PRO_ThuyetMinhDeTai.ListKinhPhiKhac);

            bool result = BS_PRO_ThuyetMinhDeTai.put_PRO_ThuyetMinhDeTai(db, id, tbl_PRO_ThuyetMinhDeTai, Username);

            if (result)
            {
                BS_HelperReference.PRO_ThuyetMinhDeTai_Update(db, tbl_PRO_ThuyetMinhDeTai.IDDeTai);
                return(StatusCode(HttpStatusCode.NoContent));
            }
            else
            {
                return(NotFound());
            }
        }
        public static DTO_PRO_ThuyetMinhDeTai get_PRO_ThuyetMinhDeTaiByDeTai(AppEntities db, int deTaiId)
        {
            var query = db.tbl_PRO_ThuyetMinhDeTai.Where(d => d.IDDeTai == deTaiId && d.IsDeleted == false).Select(s => new DTO_PRO_ThuyetMinhDeTai
            {
                ID                                     = s.ID,
                IDDeTai                                = s.IDDeTai,
                A0_MaSoDeTai                           = s.A0_MaSoDeTai,
                A0_NgayNhanHoSo                        = s.A0_NgayNhanHoSo,
                A1_TenTiengViet                        = s.A1_TenTiengViet,
                A1_TenTiengAnh                         = s.A1_TenTiengAnh,
                A2_QuanLy                              = s.A2_QuanLy,
                A2_SinhHocVaCongNghe                   = s.A2_SinhHocVaCongNghe,
                A2_KhoaHocSucKhoe                      = s.A2_KhoaHocSucKhoe,
                A2_Khac                                = s.A2_Khac,
                A2_KhacMoTa                            = s.A2_KhacMoTa,
                A3_NghienCuuCoBan                      = s.A3_NghienCuuCoBan,
                A3_NghienCuuUngDung                    = s.A3_NghienCuuUngDung,
                A3_NghienCuuTrienKhai                  = s.A3_NghienCuuTrienKhai,
                A4_ThoiGianThucHien                    = s.A4_ThoiGianThucHien,
                A5_TongKinhPhi                         = s.A5_TongKinhPhi,
                A6_HoTen                               = s.A6_HoTen,
                A6_NgaySinh                            = s.A6_NgaySinh,
                A6_GioiTinh                            = s.A6_GioiTinh,
                A6_CMND                                = s.A6_CMND,
                A6_NgayCap                             = s.A6_NgayCap,
                A6_NoiCap                              = s.A6_NoiCap,
                A6_MST                                 = s.A6_MST,
                A6_STK                                 = s.A6_STK,
                A6_NganHang                            = s.A6_NganHang,
                A6_DiaChiCoQuan                        = s.A6_DiaChiCoQuan,
                A6_DienThoai                           = s.A6_DienThoai,
                A6_Email                               = s.A6_Email,
                A6_TomTatHoatDong                      = s.A6_TomTatHoatDong,
                A7_TenCoQuan                           = s.A7_TenCoQuan,
                A7_HoTenThuTruong                      = s.A7_HoTenThuTruong,
                A7_DienThoai                           = s.A7_DienThoai,
                A7_DiaChi                              = s.A7_DiaChi,
                A8_CoQuanPhoiHopThucHien               = s.A8_CoQuanPhoiHopThucHien,
                A8_JSON_CoQuanPhoiHopThucHien          = s.A8_JSON_CoQuanPhoiHopThucHien,
                A9_JSON_NhanLucNghienCuu               = s.A9_JSON_NhanLucNghienCuu,
                B1_GioiThieu                           = s.B1_GioiThieu,
                B2_TaiLieuThamKhao                     = s.B2_TaiLieuThamKhao,
                B2_JSON_GioiThieuChuyenGia             = s.B2_JSON_GioiThieuChuyenGia,
                B311_MucTieuNghienCuu                  = s.B311_MucTieuNghienCuu,
                B312_ChiTieuDanhGia                    = s.B312_ChiTieuDanhGia,
                B313_DiaChi                            = s.B313_DiaChi,
                B313_JSON_KeHoachThucHien              = s.B313_JSON_KeHoachThucHien,
                B321_ThietKeNghienCuu                  = s.B321_ThietKeNghienCuu,
                B322_DanSoNghienCuu                    = s.B322_DanSoNghienCuu,
                B3221_TieuChuanNhanLoai                = s.B3221_TieuChuanNhanLoai,
                B3221_TieuChuanNhan                    = s.B3221_TieuChuanNhan,
                B3221_TieuChuanLoai                    = s.B3221_TieuChuanLoai,
                B3222_CoMau                            = s.B3222_CoMau,
                B323_PhuongPhapTienHanh                = s.B323_PhuongPhapTienHanh,
                B324_PhuongPhapDanhGia                 = s.B324_PhuongPhapDanhGia,
                B3241_YeuToDanhGiaKetQua               = s.B3241_YeuToDanhGiaKetQua,
                B3242_CacBienChungDieuTri              = s.B3242_CacBienChungDieuTri,
                B3243_CacBienChungVeSanKhoa            = s.B3243_CacBienChungVeSanKhoa,
                B325_PhuongPhapPhanTich                = s.B325_PhuongPhapPhanTich,
                B326_JSON_CacBienSoCanThuThap          = s.B326_JSON_CacBienSoCanThuThap,
                B327_BangKetQuaDuKien                  = s.B327_BangKetQuaDuKien,
                B328_VanDeYDuc                         = s.B328_VanDeYDuc,
                B329_TinhKhaThi                        = s.B329_TinhKhaThi,
                B33_PhuongAnPhoiHop                    = s.B33_PhuongAnPhoiHop,
                B33_PhuongAnPhoiHopPTN                 = s.B33_PhuongAnPhoiHopPTN,
                B33_PhuongAnPhoiHopDonVi               = s.B33_PhuongAnPhoiHopDonVi,
                B33_PhuongAnPhoiHopCGCN                = s.B33_PhuongAnPhoiHopCGCN,
                B4_KetQuaNghienCuu                     = s.B4_KetQuaNghienCuu,
                B41_AnPhamKhoaHoc                      = s.B41_AnPhamKhoaHoc,
                B42_DangKySoHuuTriTue                  = s.B42_DangKySoHuuTriTue,
                B43_KetQuaDaoTao                       = s.B43_KetQuaDaoTao,
                B5_KhaNangUngDung                      = s.B5_KhaNangUngDung,
                B51_KhaNangUngDungLinhVucDaoTao        = s.B51_KhaNangUngDungLinhVucDaoTao,
                B52_TongHopKinhPhi                     = s.B52_TongHopKinhPhi,
                B52_ChuNhiemDeTai_Nam                  = s.B52_ChuNhiemDeTai_Nam,
                B52_ChuNhiemDeTai_Ngay                 = s.B52_ChuNhiemDeTai_Ngay,
                B52_ChuNhiemDeTai_Thang                = s.B52_ChuNhiemDeTai_Thang,
                B52_CoQuanChuTri_Nam                   = s.B52_CoQuanChuTri_Nam,
                B52_CoQuanChuTri_Ngay                  = s.B52_CoQuanChuTri_Ngay,
                B52_CoQuanChuTri_Thang                 = s.B52_CoQuanChuTri_Thang,
                B52_JSON_TongHopKinhPhi                = s.B52_JSON_TongHopKinhPhi,
                PhuLuc_JSON_KhoanCongLaoDong           = s.PhuLuc_JSON_KhoanCongLaoDong,
                PhuLuc_JSON_NguyenVatLieu              = s.PhuLuc_JSON_NguyenVatLieu,
                HTML                                   = s.HTML,
                FormConfig                             = s.FormConfig,
                IsDisabled                             = s.tbl_PRO_DeTai.IsDisabledHDDD ?? false,
                IsDeleted                              = s.IsDeleted,
                CreatedDate                            = s.CreatedDate,
                CreatedBy                              = s.CreatedBy,
                ModifiedDate                           = s.ModifiedDate,
                ModifiedBy                             = s.ModifiedBy,
                PhuLuc_JSON_ThietBi                    = s.PhuLuc_JSON_ThietBi,
                PhuLuc_JSON_ChiKhac                    = s.PhuLuc_JSON_ChiKhac,
                A9_JSON_NhanLucNghienCuu_ChuNhiemDeTai = s.A9_JSON_NhanLucNghienCuu_ChuNhiemDeTai,
                B52_CoQuanChuTri_NgayKy_Ngay           = s.B52_CoQuanChuTri_NgayKy_Ngay,
                B52_CoQuanChuTri_NgayKy_Thang          = s.B52_CoQuanChuTri_NgayKy_Thang,
                B52_CoQuanChuTri_NgayKy_Nam            = s.B52_CoQuanChuTri_NgayKy_Nam,
                B52_CoQuanChuTri_NgayKy_ChuKy          = s.B52_CoQuanChuTri_NgayKy_ChuKy,
                B52_CNDT_NgayKy_Ngay                   = s.B52_CNDT_NgayKy_Ngay,
                B52_CNDT_NgayKy_Thang                  = s.B52_CNDT_NgayKy_Thang,
                B52_CNDT_NgayKy_Nam                    = s.B52_CNDT_NgayKy_Nam,
                B52_CNDT_NgayKy_ChuKy                  = s.B52_CNDT_NgayKy_ChuKy,
            }).FirstOrDefault();

            if (query == null)
            {
                query = new DTO_PRO_ThuyetMinhDeTai
                {
                    IDDeTai = deTaiId
                };

                query.ChuNhiemDeTai = new DTO_PRO_ThuyetMinhDeTai_NhanLucNghienCuu();

                var detai = db.tbl_PRO_DeTai.FirstOrDefault(c => c.ID == deTaiId);
                if (detai != null)
                {
                    query.A1_TenTiengViet = detai.TenTiengViet;
                    query.A1_TenTiengAnh  = detai.TenTiengAnh;
                    query.IsDisabled      = detai.IsDisabledHDDD ?? false;
                    var chunhiem = db.tbl_PRO_LLKH.FirstOrDefault(c => c.IDDetai == deTaiId && c.IDNhanSu == detai.IDChuNhiem && c.IsDeleted == false);
                    if (chunhiem != null)
                    {
                        query.A6_HoTen        = (!string.IsNullOrEmpty(chunhiem.HocHam) ? chunhiem.HocHam + ", " : "") + (!string.IsNullOrEmpty(chunhiem.HocViThacSy) ? chunhiem.HocViThacSy + ", " : "") + (!string.IsNullOrEmpty(chunhiem.HocViTienSy) ? chunhiem.HocViTienSy + ", " : "") + chunhiem.HoTen;
                        query.A6_NgaySinh     = chunhiem.NgaySinh;
                        query.A6_GioiTinh     = chunhiem.GioiTinh;
                        query.A6_CMND         = chunhiem.CMND;
                        query.A6_NgayCap      = chunhiem.CMND_NgayCap;
                        query.A6_NoiCap       = chunhiem.CMND_NoiCap;
                        query.A6_MST          = chunhiem.TaiKhoan_MST;
                        query.A6_STK          = chunhiem.TaiKhoan_STK;
                        query.A6_NganHang     = chunhiem.TaiKhoan_NganHang;
                        query.A6_DiaChiCoQuan = chunhiem.DiaChi_CoQuan;
                        query.A6_DienThoai    = chunhiem.DienThoai_CaNhan;
                        query.A6_Email        = chunhiem.Email_CaNhan;

                        query.ChuNhiemDeTai.HoTen = query.A6_HoTen;
                        query.ChuNhiemDeTai.DonVi = chunhiem.TruongVien;
                    }

                    var dxdg = db.tbl_PRO_DonXinDanhGiaDaoDuc.FirstOrDefault(c => c.IDDeTai == deTaiId && c.IsDeleted == false);
                    if (dxdg != null)
                    {
                        query.A4_ThoiGianThucHien = "Địa điểm: " + (!string.IsNullOrEmpty(dxdg.DiaDiemNghienCuu) ? dxdg.DiaDiemNghienCuu.Replace("<br>", "<div>") : "") + "<div>" + "Thời gian: " + dxdg.ThoiGianNghienCuu + " tháng. Từ " + dxdg.TuNgay + " đến tháng " + dxdg.DenNgay + "</div>";
                        query.A7_TenCoQuan        = dxdg.TenDonViChuTri;
                        query.A7_DiaChi           = dxdg.DiaChiDonVi;
                        query.A7_DienThoai        = dxdg.DienThoaiDonVi;
                    }
                }
            }

            return(query);
        }
        public IHttpActionResult GetCustom(int idDeTai, bool?isInput = false)
        {
            DTO_PRO_ThuyetMinhDeTai tbl_PRO_ThuyetMinhDeTai = BS_PRO_ThuyetMinhDeTai.get_PRO_ThuyetMinhDeTaiByDeTai(db, idDeTai);

            string html      = "";
            string htmlPrint = "";

            using (System.IO.StreamReader r = new System.IO.StreamReader(System.Web.Hosting.HostingEnvironment.MapPath("~/Content/FormTemplate/ThuyetMinhDeTai.html")))
            {
                htmlPrint = r.ReadToEnd();
            }

            using (System.IO.StreamReader r = new System.IO.StreamReader(System.Web.Hosting.HostingEnvironment.MapPath("~/Content/FormTemplate/ThuyetMinhDeTai_Input.html")))
            {
                html = r.ReadToEnd();
            }

            if (tbl_PRO_ThuyetMinhDeTai == null || tbl_PRO_ThuyetMinhDeTai.ID == 0)
            {
                var tbl_PRO_ThuyetMinhDeTaiNew = new DTO_PRO_ThuyetMinhDeTai
                {
                    IDDeTai                = idDeTai,
                    HTML                   = html,
                    HTMLPrint              = htmlPrint,
                    A1_TenTiengViet        = tbl_PRO_ThuyetMinhDeTai.A1_TenTiengViet,
                    A1_TenTiengAnh         = tbl_PRO_ThuyetMinhDeTai.A1_TenTiengAnh,
                    A6_HoTen               = tbl_PRO_ThuyetMinhDeTai.A6_HoTen,
                    A6_NgaySinh            = tbl_PRO_ThuyetMinhDeTai.A6_NgaySinh,
                    A6_GioiTinh            = tbl_PRO_ThuyetMinhDeTai.A6_GioiTinh,
                    A6_CMND                = tbl_PRO_ThuyetMinhDeTai.A6_CMND,
                    A6_NgayCap             = tbl_PRO_ThuyetMinhDeTai.A6_NgayCap,
                    A6_NoiCap              = tbl_PRO_ThuyetMinhDeTai.A6_NoiCap,
                    A6_MST                 = tbl_PRO_ThuyetMinhDeTai.A6_MST,
                    A6_STK                 = tbl_PRO_ThuyetMinhDeTai.A6_STK,
                    A6_NganHang            = tbl_PRO_ThuyetMinhDeTai.A6_NganHang,
                    A6_DiaChiCoQuan        = tbl_PRO_ThuyetMinhDeTai.A6_DiaChiCoQuan,
                    A6_DienThoai           = tbl_PRO_ThuyetMinhDeTai.A6_DienThoai,
                    A6_Email               = tbl_PRO_ThuyetMinhDeTai.A6_Email,
                    A4_ThoiGianThucHien    = tbl_PRO_ThuyetMinhDeTai.A4_ThoiGianThucHien,
                    A7_TenCoQuan           = tbl_PRO_ThuyetMinhDeTai.A7_TenCoQuan,
                    A7_DiaChi              = tbl_PRO_ThuyetMinhDeTai.A7_DiaChi,
                    A7_DienThoai           = tbl_PRO_ThuyetMinhDeTai.A7_DienThoai,
                    ChuNhiemDeTai          = tbl_PRO_ThuyetMinhDeTai.ChuNhiemDeTai,
                    IsDisabled             = tbl_PRO_ThuyetMinhDeTai.IsDisabled,
                    ListNhanLucNghienCuu   = new List <DTO_PRO_ThuyetMinhDeTai_NhanLucNghienCuu>(),
                    ListGioiThieuChuyenGia = new List <DTO_PRO_ThuyetMinhDeTai_GioiThieuChuyenGia>(),
                    ListBienSo             = new List <DTO_PRO_ThuyetMinhDeTai_CacBienSoCanThuThap>()
                    {
                        new DTO_PRO_ThuyetMinhDeTai_CacBienSoCanThuThap()
                        {
                            LoaiBienSo = (int)DTO_PRO_ThuyetMinhDeTai_CacBienSoCanThuThap.BienSo.BSNen
                        },
                        new DTO_PRO_ThuyetMinhDeTai_CacBienSoCanThuThap()
                        {
                            LoaiBienSo = (int)DTO_PRO_ThuyetMinhDeTai_CacBienSoCanThuThap.BienSo.BSDocLap
                        },
                        new DTO_PRO_ThuyetMinhDeTai_CacBienSoCanThuThap()
                        {
                            LoaiBienSo = (int)DTO_PRO_ThuyetMinhDeTai_CacBienSoCanThuThap.BienSo.BSPhuThuoc
                        },
                    },
                    ListKeHoachThucHien = new List <DTO_PRO_ThuyetMinhDeTai_KeHoachThucHien>()
                    {
                        new DTO_PRO_ThuyetMinhDeTai_KeHoachThucHien(DTO_PRO_ThuyetMinhDeTai_KeHoachThucHien.VietDeCuong),
                        new DTO_PRO_ThuyetMinhDeTai_KeHoachThucHien(DTO_PRO_ThuyetMinhDeTai_KeHoachThucHien.ThongQuaHDKH),
                        new DTO_PRO_ThuyetMinhDeTai_KeHoachThucHien(DTO_PRO_ThuyetMinhDeTai_KeHoachThucHien.ThuThapSoLieu),
                        new DTO_PRO_ThuyetMinhDeTai_KeHoachThucHien(DTO_PRO_ThuyetMinhDeTai_KeHoachThucHien.PhanTichSoLieuGiuaKy),
                        new DTO_PRO_ThuyetMinhDeTai_KeHoachThucHien(DTO_PRO_ThuyetMinhDeTai_KeHoachThucHien.PhanTichSoLieuCuoiCung),
                        new DTO_PRO_ThuyetMinhDeTai_KeHoachThucHien(DTO_PRO_ThuyetMinhDeTai_KeHoachThucHien.VietBaiDangBaoTrongNuoc),
                        new DTO_PRO_ThuyetMinhDeTai_KeHoachThucHien(DTO_PRO_ThuyetMinhDeTai_KeHoachThucHien.NghiemThuDeTai),
                        new DTO_PRO_ThuyetMinhDeTai_KeHoachThucHien(DTO_PRO_ThuyetMinhDeTai_KeHoachThucHien.VietBaiDangBaoQuocTe)
                    },
                    ListKinhPhiTongHop = new List <DTO_PRO_ThuyetMinhDeTai_TongHopKinhPhi>()
                    {
                        new DTO_PRO_ThuyetMinhDeTai_TongHopKinhPhi(DTO_PRO_ThuyetMinhDeTai_TongHopKinhPhi.NoiDungKinhPhi.Khoan1TraCongLaoDong),
                        new DTO_PRO_ThuyetMinhDeTai_TongHopKinhPhi(DTO_PRO_ThuyetMinhDeTai_TongHopKinhPhi.NoiDungKinhPhi.Khoan2NguyenLieu),
                        new DTO_PRO_ThuyetMinhDeTai_TongHopKinhPhi(DTO_PRO_ThuyetMinhDeTai_TongHopKinhPhi.NoiDungKinhPhi.Khoan3ThietBi),
                        new DTO_PRO_ThuyetMinhDeTai_TongHopKinhPhi(DTO_PRO_ThuyetMinhDeTai_TongHopKinhPhi.NoiDungKinhPhi.Khoan4Khac),
                        new DTO_PRO_ThuyetMinhDeTai_TongHopKinhPhi(DTO_PRO_ThuyetMinhDeTai_TongHopKinhPhi.NoiDungKinhPhi.Cong),
                    },
                    ListKinhPhiCongLaoDong = new List <DTO_PRO_ThuyetMinhDeTai_KinhPhi>()
                    {
                        new DTO_PRO_ThuyetMinhDeTai_KinhPhi(DTO_PRO_ThuyetMinhDeTai_KinhPhi.NoiDungKinhPhi.Khoan1VietDeCuong),
                        new DTO_PRO_ThuyetMinhDeTai_KinhPhi(DTO_PRO_ThuyetMinhDeTai_KinhPhi.NoiDungKinhPhi.Khoan2ThuThapDL),
                        new DTO_PRO_ThuyetMinhDeTai_KinhPhi(DTO_PRO_ThuyetMinhDeTai_KinhPhi.NoiDungKinhPhi.Khoan3XLVaPTSoLieu),
                        new DTO_PRO_ThuyetMinhDeTai_KinhPhi(DTO_PRO_ThuyetMinhDeTai_KinhPhi.NoiDungKinhPhi.Khoan4DieuPhoiNghienCuu),
                        new DTO_PRO_ThuyetMinhDeTai_KinhPhi(DTO_PRO_ThuyetMinhDeTai_KinhPhi.NoiDungKinhPhi.Khoan5VietBaiDangBao),
                        new DTO_PRO_ThuyetMinhDeTai_KinhPhi(DTO_PRO_ThuyetMinhDeTai_KinhPhi.NoiDungKinhPhi.Cong),
                    },
                    ListKinhPhiNguyenVatLieu = new List <DTO_PRO_ThuyetMinhDeTai_KinhPhi>()
                    {
                        new DTO_PRO_ThuyetMinhDeTai_KinhPhi(DTO_PRO_ThuyetMinhDeTai_KinhPhi.NoiDungKinhPhi.Khoan1NguyenVatLieu),
                        new DTO_PRO_ThuyetMinhDeTai_KinhPhi(DTO_PRO_ThuyetMinhDeTai_KinhPhi.NoiDungKinhPhi.Khoan2DungCuPhuTungReTien),
                        new DTO_PRO_ThuyetMinhDeTai_KinhPhi(DTO_PRO_ThuyetMinhDeTai_KinhPhi.NoiDungKinhPhi.Khoan3NangLuong),
                        new DTO_PRO_ThuyetMinhDeTai_KinhPhi(DTO_PRO_ThuyetMinhDeTai_KinhPhi.NoiDungKinhPhi.Khoan4SachTaiLieu),
                        new DTO_PRO_ThuyetMinhDeTai_KinhPhi(DTO_PRO_ThuyetMinhDeTai_KinhPhi.NoiDungKinhPhi.Cong),
                    },
                    ListKinhPhiThietBi = new List <DTO_PRO_ThuyetMinhDeTai_KinhPhi>()
                    {
                        new DTO_PRO_ThuyetMinhDeTai_KinhPhi(DTO_PRO_ThuyetMinhDeTai_KinhPhi.NoiDungKinhPhi.Khoan1MuaThietBi),
                        new DTO_PRO_ThuyetMinhDeTai_KinhPhi(DTO_PRO_ThuyetMinhDeTai_KinhPhi.NoiDungKinhPhi.Khoan2ThueThietBi),
                        new DTO_PRO_ThuyetMinhDeTai_KinhPhi(DTO_PRO_ThuyetMinhDeTai_KinhPhi.NoiDungKinhPhi.Khoan3VanChuyenLapDat),
                        new DTO_PRO_ThuyetMinhDeTai_KinhPhi(DTO_PRO_ThuyetMinhDeTai_KinhPhi.NoiDungKinhPhi.Cong),
                    },
                    ListKinhPhiKhac = new List <DTO_PRO_ThuyetMinhDeTai_KinhPhi>()
                    {
                        new DTO_PRO_ThuyetMinhDeTai_KinhPhi(DTO_PRO_ThuyetMinhDeTai_KinhPhi.NoiDungKinhPhi.Khoan1HopTacTrongNuoc),
                        new DTO_PRO_ThuyetMinhDeTai_KinhPhi(DTO_PRO_ThuyetMinhDeTai_KinhPhi.NoiDungKinhPhi.Khoan2HDDD),
                        new DTO_PRO_ThuyetMinhDeTai_KinhPhi(DTO_PRO_ThuyetMinhDeTai_KinhPhi.NoiDungKinhPhi.Khoan3HDKH),
                        new DTO_PRO_ThuyetMinhDeTai_KinhPhi(DTO_PRO_ThuyetMinhDeTai_KinhPhi.NoiDungKinhPhi.Khoan4DuPhong),
                        new DTO_PRO_ThuyetMinhDeTai_KinhPhi(DTO_PRO_ThuyetMinhDeTai_KinhPhi.NoiDungKinhPhi.Cong),
                    },
                    ListCoQuanPhoiHop = new List <DTO_PRO_ThuyetMinhDeTai_DonVi>()
                    {
                        new DTO_PRO_ThuyetMinhDeTai_DonVi()
                    }
                };

                return(Ok(tbl_PRO_ThuyetMinhDeTaiNew));
            }
            else
            {
                tbl_PRO_ThuyetMinhDeTai.HTML      = html;
                tbl_PRO_ThuyetMinhDeTai.HTMLPrint = htmlPrint;
                if (!string.IsNullOrWhiteSpace(tbl_PRO_ThuyetMinhDeTai.A8_JSON_CoQuanPhoiHopThucHien))
                {
                    tbl_PRO_ThuyetMinhDeTai.ListCoQuanPhoiHop = JsonConvert.DeserializeObject <List <DTO_PRO_ThuyetMinhDeTai_DonVi> >(tbl_PRO_ThuyetMinhDeTai.A8_JSON_CoQuanPhoiHopThucHien);
                }
                if (!string.IsNullOrWhiteSpace(tbl_PRO_ThuyetMinhDeTai.A9_JSON_NhanLucNghienCuu_ChuNhiemDeTai))
                {
                    tbl_PRO_ThuyetMinhDeTai.ChuNhiemDeTai = JsonConvert.DeserializeObject <DTO_PRO_ThuyetMinhDeTai_NhanLucNghienCuu>(tbl_PRO_ThuyetMinhDeTai.A9_JSON_NhanLucNghienCuu_ChuNhiemDeTai);
                }
                if (!string.IsNullOrWhiteSpace(tbl_PRO_ThuyetMinhDeTai.A9_JSON_NhanLucNghienCuu))
                {
                    tbl_PRO_ThuyetMinhDeTai.ListNhanLucNghienCuu = JsonConvert.DeserializeObject <List <DTO_PRO_ThuyetMinhDeTai_NhanLucNghienCuu> >(tbl_PRO_ThuyetMinhDeTai.A9_JSON_NhanLucNghienCuu);
                }
                if (!string.IsNullOrWhiteSpace(tbl_PRO_ThuyetMinhDeTai.B2_JSON_GioiThieuChuyenGia))
                {
                    tbl_PRO_ThuyetMinhDeTai.ListGioiThieuChuyenGia = JsonConvert.DeserializeObject <List <DTO_PRO_ThuyetMinhDeTai_GioiThieuChuyenGia> >(tbl_PRO_ThuyetMinhDeTai.B2_JSON_GioiThieuChuyenGia);
                }
                if (!string.IsNullOrWhiteSpace(tbl_PRO_ThuyetMinhDeTai.B326_JSON_CacBienSoCanThuThap))
                {
                    tbl_PRO_ThuyetMinhDeTai.ListBienSo = JsonConvert.DeserializeObject <List <DTO_PRO_ThuyetMinhDeTai_CacBienSoCanThuThap> >(tbl_PRO_ThuyetMinhDeTai.B326_JSON_CacBienSoCanThuThap);
                }
                if (!string.IsNullOrWhiteSpace(tbl_PRO_ThuyetMinhDeTai.B313_JSON_KeHoachThucHien))
                {
                    tbl_PRO_ThuyetMinhDeTai.ListKeHoachThucHien = JsonConvert.DeserializeObject <List <DTO_PRO_ThuyetMinhDeTai_KeHoachThucHien> >(tbl_PRO_ThuyetMinhDeTai.B313_JSON_KeHoachThucHien);
                }
                if (!string.IsNullOrWhiteSpace(tbl_PRO_ThuyetMinhDeTai.B52_JSON_TongHopKinhPhi))
                {
                    tbl_PRO_ThuyetMinhDeTai.ListKinhPhiTongHop = JsonConvert.DeserializeObject <List <DTO_PRO_ThuyetMinhDeTai_TongHopKinhPhi> >(tbl_PRO_ThuyetMinhDeTai.B52_JSON_TongHopKinhPhi);
                }
                if (!string.IsNullOrWhiteSpace(tbl_PRO_ThuyetMinhDeTai.PhuLuc_JSON_KhoanCongLaoDong))
                {
                    tbl_PRO_ThuyetMinhDeTai.ListKinhPhiCongLaoDong = JsonConvert.DeserializeObject <List <DTO_PRO_ThuyetMinhDeTai_KinhPhi> >(tbl_PRO_ThuyetMinhDeTai.PhuLuc_JSON_KhoanCongLaoDong);
                }
                if (!string.IsNullOrWhiteSpace(tbl_PRO_ThuyetMinhDeTai.PhuLuc_JSON_NguyenVatLieu))
                {
                    tbl_PRO_ThuyetMinhDeTai.ListKinhPhiNguyenVatLieu = JsonConvert.DeserializeObject <List <DTO_PRO_ThuyetMinhDeTai_KinhPhi> >(tbl_PRO_ThuyetMinhDeTai.PhuLuc_JSON_NguyenVatLieu);
                }
                if (!string.IsNullOrWhiteSpace(tbl_PRO_ThuyetMinhDeTai.PhuLuc_JSON_ThietBi))
                {
                    tbl_PRO_ThuyetMinhDeTai.ListKinhPhiThietBi = JsonConvert.DeserializeObject <List <DTO_PRO_ThuyetMinhDeTai_KinhPhi> >(tbl_PRO_ThuyetMinhDeTai.PhuLuc_JSON_ThietBi);
                }
                if (!string.IsNullOrWhiteSpace(tbl_PRO_ThuyetMinhDeTai.PhuLuc_JSON_ChiKhac))
                {
                    tbl_PRO_ThuyetMinhDeTai.ListKinhPhiKhac = JsonConvert.DeserializeObject <List <DTO_PRO_ThuyetMinhDeTai_KinhPhi> >(tbl_PRO_ThuyetMinhDeTai.PhuLuc_JSON_ChiKhac);
                }

                if (tbl_PRO_ThuyetMinhDeTai.ListKinhPhiCongLaoDong != null && tbl_PRO_ThuyetMinhDeTai.ListKinhPhiCongLaoDong.Count == 5)
                {
                    tbl_PRO_ThuyetMinhDeTai.ListKinhPhiCongLaoDong.Insert(3, new DTO_PRO_ThuyetMinhDeTai_KinhPhi(DTO_PRO_ThuyetMinhDeTai_KinhPhi.NoiDungKinhPhi.Khoan4SachTaiLieu));
                }
            }

            return(Ok(tbl_PRO_ThuyetMinhDeTai));
        }
 public IHttpActionResult UploadFileThuyetMinh(DTO_PRO_ThuyetMinhDeTai item)
 {
     BS_PRO_ThuyetMinhDeTai.uploadFileThuyetMinh(db, item.IDDeTai, item.FileThuyetMinh, Username);
     return(Ok());
 }