public IHttpActionResult Get(int id) { DTO_PRO_DonXinXetDuyet tbl_PRO_DonXinXetDuyet = BS_PRO_DonXinXetDuyet.get_PRO_DonXinXetDuyet(db, id); if (tbl_PRO_DonXinXetDuyet == null) { return(NotFound()); } return(Ok(tbl_PRO_DonXinXetDuyet)); }
public static bool put_PRO_DonXinXetDuyet(AppEntities db, int ID, DTO_PRO_DonXinXetDuyet item, string Username) { bool result = false; var dbitem = db.tbl_PRO_DonXinXetDuyet.Find(ID); if (dbitem != null) { dbitem.IDDeTai = item.IDDeTai; dbitem.HoTenChuNhiem = item.HoTenChuNhiem; dbitem.DonVi = item.DonVi; dbitem.DiaChi = item.DiaChi; dbitem.DienThoai = item.DienThoai; dbitem.TenDeTai = item.TenDeTai; dbitem.TenDonViChuTri = item.TenDonViChuTri; dbitem.DiaChiDonVi = item.DiaChiDonVi; dbitem.DienThoaiDonVi = item.DienThoaiDonVi; dbitem.DiaDiemNghienCuu = item.DiaDiemNghienCuu; dbitem.ThoiGianNghienCuu = item.ThoiGianNghienCuu; dbitem.TuNgay = item.TuNgay; dbitem.DenNgay = item.DenNgay; dbitem.ThuyetMinhDeCuong = item.ThuyetMinhDeCuong; dbitem.LLKHChuNhiem = item.LLKHChuNhiem; dbitem.LLKHNCV = item.LLKHNCV; dbitem.GiayToKhac = item.GiayToKhac; dbitem.GhiChuGiayToKha = item.GhiChuGiayToKha; dbitem.HTML = item.HTML; dbitem.IsDisabled = item.IsDisabled; dbitem.IsDeleted = item.IsDeleted; dbitem.NgayKy_Ngay = item.NgayKy_Ngay; dbitem.NgayKy_Thang = item.NgayKy_Thang; dbitem.NgayKy_Nam = item.NgayKy_Nam; dbitem.NgayKy_ChuKy = item.NgayKy_ChuKy; dbitem.FormConfig = item.FormConfig; dbitem.NgayKy_ChuKyThuTruong = item.NgayKy_ChuKyThuTruong; dbitem.ModifiedBy = Username; dbitem.ModifiedDate = DateTime.Now; try { db.SaveChanges(); BS_CUS_Version.update_CUS_Version(db, null, "DTO_PRO_DonXinXetDuyet", DateTime.Now, Username); result = true; } catch (DbEntityValidationException e) { errorLog.logMessage("put_PRO_DonXinXetDuyet", e); result = false; } } return(result); }
public IHttpActionResult Post(DTO_PRO_DonXinXetDuyet tbl_PRO_DonXinXetDuyet) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } DTO_PRO_DonXinXetDuyet result = BS_PRO_DonXinXetDuyet.save_PRO_DonXinXetDuyet(db, tbl_PRO_DonXinXetDuyet, Username); if (result != null) { return(CreatedAtRoute("get_PRO_DonXinXetDuyet", new { id = result.ID }, result)); } return(Conflict()); }
public IHttpActionResult GetCustom(int idDeTai, bool?isInput = false) { DTO_PRO_DonXinXetDuyet tbl_PRO_DonXinXetDuyet = BS_PRO_DonXinXetDuyet.get_PRO_DonXinXetDuyetByDeTai(db, idDeTai); string html = ""; string htmlPrint = ""; using (System.IO.StreamReader r = new System.IO.StreamReader(System.Web.Hosting.HostingEnvironment.MapPath("~/Content/FormTemplate/DonXinXetDuyet.html"))) { htmlPrint = r.ReadToEnd(); } using (System.IO.StreamReader r = new System.IO.StreamReader(System.Web.Hosting.HostingEnvironment.MapPath("~/Content/FormTemplate/DonXinXetDuyet_Input.html"))) { html = r.ReadToEnd(); } tbl_PRO_DonXinXetDuyet.HTML = html; tbl_PRO_DonXinXetDuyet.HTMLPrint = htmlPrint; return(Ok(tbl_PRO_DonXinXetDuyet)); }
public IHttpActionResult Put(int id, DTO_PRO_DonXinXetDuyet tbl_PRO_DonXinXetDuyet) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tbl_PRO_DonXinXetDuyet.ID) { return(BadRequest()); } var result = BS_PRO_DonXinXetDuyet.save_PRO_DonXinXetDuyet(db, tbl_PRO_DonXinXetDuyet, Username); if (result != null) { return(StatusCode(HttpStatusCode.NoContent)); } else { return(NotFound()); } }
public static DTO_PRO_DonXinXetDuyet save_PRO_DonXinXetDuyet(AppEntities db, DTO_PRO_DonXinXetDuyet item, string Username) { var dbitem = db.tbl_PRO_DonXinXetDuyet.FirstOrDefault(c => c.IDDeTai == item.IDDeTai && c.IsDeleted == false); if (dbitem == null) { dbitem = new tbl_PRO_DonXinXetDuyet(); dbitem.CreatedBy = Username; dbitem.CreatedDate = DateTime.Now; dbitem.TenDeTai = item.TenDeTai; dbitem.HoTenChuNhiem = item.HoTenChuNhiem; dbitem.DiaChi = item.DiaChi; dbitem.DienThoai = item.DienThoai; db.tbl_PRO_DonXinXetDuyet.Add(dbitem); } dbitem.IDDeTai = item.IDDeTai; dbitem.DonVi = item.DonVi; dbitem.TenDonViChuTri = item.TenDonViChuTri; dbitem.DiaChiDonVi = item.DiaChiDonVi; dbitem.DienThoaiDonVi = item.DienThoaiDonVi; dbitem.DiaDiemNghienCuu = item.DiaDiemNghienCuu; dbitem.ThoiGianNghienCuu = item.ThoiGianNghienCuu; dbitem.TuNgay = item.TuNgay; dbitem.DenNgay = item.DenNgay; dbitem.ThuyetMinhDeCuong = item.ThuyetMinhDeCuong; dbitem.LLKHChuNhiem = item.LLKHChuNhiem; dbitem.LLKHNCV = item.LLKHNCV; dbitem.GiayToKhac = item.GiayToKhac; dbitem.GhiChuGiayToKha = item.GhiChuGiayToKha; dbitem.HTML = item.HTML; dbitem.IsDisabled = item.IsDisabled; dbitem.IsDeleted = item.IsDeleted; dbitem.NgayKy_Ngay = item.NgayKy_Ngay; dbitem.NgayKy_Thang = item.NgayKy_Thang; dbitem.NgayKy_Nam = item.NgayKy_Nam; dbitem.NgayKy_ChuKy = item.NgayKy_ChuKy; dbitem.FormConfig = item.FormConfig; dbitem.NgayKy_ChuKyThuTruong = item.NgayKy_ChuKyThuTruong; dbitem.CreatedBy = Username; dbitem.CreatedDate = DateTime.Now; dbitem.ModifiedBy = Username; dbitem.ModifiedDate = DateTime.Now; try { db.SaveChanges(); BS_CUS_Version.update_CUS_Version(db, null, "DTO_PRO_DonXinXetDuyet", DateTime.Now, Username); item.ID = dbitem.ID; item.CreatedBy = dbitem.CreatedBy; item.CreatedDate = dbitem.CreatedDate; item.ModifiedBy = dbitem.ModifiedBy; item.ModifiedDate = dbitem.ModifiedDate; } catch (DbEntityValidationException e) { errorLog.logMessage("save_PRO_DonXinXetDuyet", e); item = null; } return(item); }
public static DTO_PRO_DonXinXetDuyet get_PRO_DonXinXetDuyetByDeTai(AppEntities db, int deTaiId) { var query = db.tbl_PRO_DonXinXetDuyet.Where(d => d.IDDeTai == deTaiId && d.IsDeleted == false).Select(s => new DTO_PRO_DonXinXetDuyet { ID = s.ID, IDDeTai = s.IDDeTai, HoTenChuNhiem = s.HoTenChuNhiem, DonVi = s.DonVi, DiaChi = s.DiaChi, DienThoai = s.DienThoai, TenDeTai = s.TenDeTai, TenDonViChuTri = s.TenDonViChuTri, DiaChiDonVi = s.DiaChiDonVi, DienThoaiDonVi = s.DienThoaiDonVi, DiaDiemNghienCuu = s.DiaDiemNghienCuu, ThoiGianNghienCuu = s.ThoiGianNghienCuu, TuNgay = s.TuNgay, DenNgay = s.DenNgay, ThuyetMinhDeCuong = s.ThuyetMinhDeCuong, LLKHChuNhiem = s.LLKHChuNhiem, LLKHNCV = s.LLKHNCV, GiayToKhac = s.GiayToKhac, GhiChuGiayToKha = s.GhiChuGiayToKha, HTML = s.HTML, FormConfig = s.FormConfig, NgayKy_ChuKy = s.NgayKy_ChuKy, NgayKy_Nam = s.NgayKy_Nam, NgayKy_Ngay = s.NgayKy_Ngay, NgayKy_Thang = s.NgayKy_Thang, IsDisabled = s.tbl_PRO_DeTai.IsDisabledHDDD ?? false, IsDeleted = s.IsDeleted, CreatedDate = s.CreatedDate, CreatedBy = s.CreatedBy, ModifiedDate = s.ModifiedDate, ModifiedBy = s.ModifiedBy, NgayKy_ChuKyThuTruong = s.NgayKy_ChuKyThuTruong }).FirstOrDefault(); if (query == null) { query = new DTO_PRO_DonXinXetDuyet { IDDeTai = deTaiId }; var detai = db.tbl_PRO_DeTai.FirstOrDefault(c => c.ID == deTaiId); if (detai != null) { query.TenDeTai = detai.TenTiengViet; var chunhiem = db.tbl_CUS_HRM_STAFF_NhanSu.FirstOrDefault(c => c.ID == detai.IDChuNhiem); if (chunhiem != null) { query.HoTenChuNhiem = chunhiem.Name; query.DiaChi = chunhiem.DiaChi; query.DienThoai = chunhiem.SoDienThoai; } } } return(query); }