public IHttpActionResult Get(int id) { DTO_PRO_SAE tbl_PRO_SAE = BS_PRO_SAE.get_PRO_SAE(db, id); if (tbl_PRO_SAE == null) { return(NotFound()); } return(Ok(tbl_PRO_SAE)); }
public IHttpActionResult Post(DTO_PRO_SAE tbl_PRO_SAE) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } DTO_PRO_SAE result = BS_PRO_SAE.post_PRO_SAE(db, tbl_PRO_SAE, Username); if (result != null) { return(CreatedAtRoute("get_PRO_SAE", new { id = result.ID }, result)); } return(Conflict()); }
public IHttpActionResult Save(DTO_PRO_SAE tbl_PRO_SAE) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } DTO_PRO_SAE result = BS_PRO_SAE.save_PRO_SAE(db, tbl_PRO_SAE, Username); if (result != null) { return(Ok(result)); } return(BadRequest()); }
public IHttpActionResult GetCustom(int idDeTai, int idBenhNhan, int?id = -1, bool?isInput = false) { DTO_PRO_SAE tbl_PRO_SAE = BS_PRO_SAE.get_PRO_SAECustom(db, idDeTai, idBenhNhan, id); string html = ""; string htmlPrint = ""; using (System.IO.StreamReader r = new System.IO.StreamReader(System.Web.Hosting.HostingEnvironment.MapPath("~/Content/FormTemplate/SAE.html"))) { htmlPrint = r.ReadToEnd(); } using (System.IO.StreamReader r = new System.IO.StreamReader(System.Web.Hosting.HostingEnvironment.MapPath("~/Content/FormTemplate/SAE_Input.html"))) { html = r.ReadToEnd(); } tbl_PRO_SAE.HTML = html; tbl_PRO_SAE.HTMLPrint = htmlPrint; return(Ok(tbl_PRO_SAE)); }
public IHttpActionResult Put(int id, DTO_PRO_SAE tbl_PRO_SAE) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tbl_PRO_SAE.ID) { return(BadRequest()); } bool result = BS_PRO_SAE.put_PRO_SAE(db, id, tbl_PRO_SAE, Username); if (result) { return(StatusCode(HttpStatusCode.NoContent)); } else { return(NotFound()); } }
public static DTO_PRO_SAE save_PRO_SAE(AppEntities db, DTO_PRO_SAE item, string Username) { var dbitem = db.tbl_PRO_SAE.Find(item.ID); if (dbitem == null) { dbitem = new tbl_PRO_SAE(); dbitem.CreatedBy = Username; dbitem.CreatedDate = DateTime.Now; db.tbl_PRO_SAE.Add(dbitem); } dbitem.IDDeTai = item.IDDeTai; dbitem.IDBenhNhan = item.IDBenhNhan; dbitem.MaSo = item.MaSo; dbitem.BaoCaoLanDau = item.BaoCaoLanDau; dbitem.BaoCaoBoSung = item.BaoCaoBoSung; dbitem.TuVong = item.TuVong; dbitem.DeDoaTinhMang = item.DeDoaTinhMang; dbitem.NhapVien = item.NhapVien; dbitem.TanTat = item.TanTat; dbitem.DiTatBamSinh = item.DiTatBamSinh; dbitem.YeuCanCanThiepYKhoa = item.YeuCanCanThiepYKhoa; dbitem.TenNghienCuu = item.TenNghienCuu; dbitem.ThietKeNghienCuu_NhanMo = item.ThietKeNghienCuu_NhanMo; dbitem.ThietKeNghienCuu_MuDon = item.ThietKeNghienCuu_MuDon; dbitem.ThietKeNghienCuu_MuDoi = item.ThietKeNghienCuu_MuDoi; dbitem.MoMu_Co = item.MoMu_Co; dbitem.MoMu_Khong = item.MoMu_Khong; dbitem.MoMu_KhongCoThongTin = item.MoMu_KhongCoThongTin; dbitem.NhaTaiTro = item.NhaTaiTro; dbitem.HoTenNCV = item.HoTenNCV; dbitem.DiemNghienCuu = item.DiemNghienCuu; dbitem.ThoiDiemNhanThongTin = item.ThoiDiemNhanThongTin; dbitem.ThoiDiemXuatHien = item.ThoiDiemXuatHien; dbitem.ThoiDiemKetThuc = item.ThoiDiemKetThuc; dbitem.DangTiepDien = item.DangTiepDien; dbitem.TenSAE = item.TenSAE; dbitem.TenNguoiThuThuoc = item.TenNguoiThuThuoc; dbitem.MaSoNguoiThuThuoc = item.MaSoNguoiThuThuoc; dbitem.MoTaDienBien = item.MoTaDienBien; dbitem.KetQua_HoiPhucKhongDiChung = item.KetQua_HoiPhucKhongDiChung; dbitem.KetQua_HoiPhucCoDiChung = item.KetQua_HoiPhucCoDiChung; dbitem.KetQua_DangHoiPhuc = item.KetQua_DangHoiPhuc; dbitem.KetQua_ChuaHoiPhuc = item.KetQua_ChuaHoiPhuc; dbitem.KetQua_TuVong = item.KetQua_TuVong; dbitem.KetQua_TuVong_Ngay = item.KetQua_TuVong_Ngay; dbitem.KetQua_KhongCoThongTin = item.KetQua_KhongCoThongTin; dbitem.NguoiThamGia_NgaySinh = item.NguoiThamGia_NgaySinh; dbitem.NguoiThamGia_Tuoi = item.NguoiThamGia_Tuoi; dbitem.NguoiThamGia_GioiTinh_Nam = item.NguoiThamGia_GioiTinh_Nam; dbitem.NguoiThamGia_GioiTinh_Nu = item.NguoiThamGia_GioiTinh_Nu; dbitem.NguoiThamGia_GioiTinh_Nu_DangMangThai = item.NguoiThamGia_GioiTinh_Nu_DangMangThai; dbitem.NguoiThamGia_GioiTinh_Nu_TuanMangThai = item.NguoiThamGia_GioiTinh_Nu_TuanMangThai; dbitem.NguoiThamGia_CanNang = item.NguoiThamGia_CanNang; dbitem.NguoiThamGia_TienSuYKhoa = item.NguoiThamGia_TienSuYKhoa; dbitem.LyDoDanhGia = item.LyDoDanhGia; dbitem.LyDoDanhGia_SoLuong = item.LyDoDanhGia_SoLuong; dbitem.LyDoDanhGia_SoLuongNghienCuuKhac = item.LyDoDanhGia_SoLuongNghienCuuKhac; dbitem.YKienHDDD_NguoiThamGia_TiepTucThamGia = item.YKienHDDD_NguoiThamGia_TiepTucThamGia; dbitem.YKienHDDD_NguoiThamGia_TamNgungThamGia = item.YKienHDDD_NguoiThamGia_TamNgungThamGia; dbitem.YKienHDDD_NguoiThamGia_RutKhoiNghienCuu = item.YKienHDDD_NguoiThamGia_RutKhoiNghienCuu; dbitem.YKienHDDD_DeXuatNghienCuu_TiepTucTrienKhai = item.YKienHDDD_DeXuatNghienCuu_TiepTucTrienKhai; dbitem.YKienHDDD_DeXuatNghienCuu_TamNgungTrienKhai = item.YKienHDDD_DeXuatNghienCuu_TamNgungTrienKhai; dbitem.YKienHDDD_DeXuatNghienCuu_NgungTrienKhai = item.YKienHDDD_DeXuatNghienCuu_NgungTrienKhai; dbitem.YKienHDDD_DeXuatKhac = item.YKienHDDD_DeXuatKhac; dbitem.NguoiBaoCao_ChuKy = item.NguoiBaoCao_ChuKy; dbitem.NguoiBaoCao_NgayKy = item.NguoiBaoCao_NgayKy; dbitem.NguoiBaoCao_HoTen = item.NguoiBaoCao_HoTen; dbitem.NguoiBaoCao_ChucVu = item.NguoiBaoCao_ChucVu; dbitem.NguoiBaoCao_DienThoai = item.NguoiBaoCao_DienThoai; dbitem.NguoiBaoCao_Email = item.NguoiBaoCao_Email; if (item.ListThuocThuLamSan != null) { dbitem.JSON_ThuocThuLamSang = JsonConvert.SerializeObject(item.ListThuocThuLamSan); } else { dbitem.JSON_ThuocThuLamSang = string.Empty; } if (item.ListCanThiepThuocThuLamSan != null) { dbitem.JSON_CanThiepThuocThuLamSang = JsonConvert.SerializeObject(item.ListCanThiepThuocThuLamSan); } else { dbitem.JSON_CanThiepThuocThuLamSang = string.Empty; } if (item.ListThuocSuDungDongThoi != null) { dbitem.JSON_ThuocSuDungDongThoi = JsonConvert.SerializeObject(item.ListThuocSuDungDongThoi); } else { dbitem.JSON_ThuocSuDungDongThoi = string.Empty; } if (item.ListDanhGiaNCV != null) { dbitem.JSON_DanhGiaNCV = JsonConvert.SerializeObject(item.ListDanhGiaNCV); } else { dbitem.JSON_DanhGiaNCV = string.Empty; } dbitem.FormConfig = item.FormConfig; dbitem.HTML = item.HTML; dbitem.IsDisabled = item.IsDisabled; dbitem.IsDeleted = item.IsDeleted; dbitem.ModifiedBy = Username; dbitem.ModifiedDate = DateTime.Now; try { db.SaveChanges(); BS_CUS_Version.update_CUS_Version(db, null, "DTO_PRO_SAE", DateTime.Now, Username); item.ID = dbitem.ID; item.CreatedBy = dbitem.CreatedBy; item.CreatedDate = dbitem.CreatedDate; item.ModifiedBy = dbitem.ModifiedBy; item.ModifiedDate = dbitem.ModifiedDate; return(item); } catch (DbEntityValidationException e) { errorLog.logMessage("save_PRO_SAE", e); return(null); } }
public static DTO_PRO_SAE get_PRO_SAECustom(AppEntities db, int idDeTai, int idBenhNhan, int?id = -1) { DTO_PRO_SAE query = null; if (id > 0) { query = db.tbl_PRO_SAE.Where(d => d.ID == id).Select(s => new DTO_PRO_SAE { ID = s.ID, IDDeTai = s.IDDeTai, IDBenhNhan = s.IDBenhNhan, MaSo = s.MaSo, BaoCaoLanDau = s.BaoCaoLanDau, BaoCaoBoSung = s.BaoCaoBoSung, TuVong = s.TuVong, DeDoaTinhMang = s.DeDoaTinhMang, NhapVien = s.NhapVien, TanTat = s.TanTat, DiTatBamSinh = s.DiTatBamSinh, YeuCanCanThiepYKhoa = s.YeuCanCanThiepYKhoa, TenNghienCuu = s.TenNghienCuu, ThietKeNghienCuu_NhanMo = s.ThietKeNghienCuu_NhanMo, ThietKeNghienCuu_MuDon = s.ThietKeNghienCuu_MuDon, ThietKeNghienCuu_MuDoi = s.ThietKeNghienCuu_MuDoi, MoMu_Co = s.MoMu_Co, MoMu_Khong = s.MoMu_Khong, MoMu_KhongCoThongTin = s.MoMu_KhongCoThongTin, NhaTaiTro = s.NhaTaiTro, HoTenNCV = s.HoTenNCV, DiemNghienCuu = s.DiemNghienCuu, ThoiDiemNhanThongTin = s.ThoiDiemNhanThongTin, ThoiDiemXuatHien = s.ThoiDiemXuatHien, ThoiDiemKetThuc = s.ThoiDiemKetThuc, DangTiepDien = s.DangTiepDien, TenSAE = s.TenSAE, TenNguoiThuThuoc = s.TenNguoiThuThuoc, MaSoNguoiThuThuoc = s.MaSoNguoiThuThuoc, MoTaDienBien = s.MoTaDienBien, KetQua_HoiPhucKhongDiChung = s.KetQua_HoiPhucKhongDiChung, KetQua_HoiPhucCoDiChung = s.KetQua_HoiPhucCoDiChung, KetQua_DangHoiPhuc = s.KetQua_DangHoiPhuc, KetQua_ChuaHoiPhuc = s.KetQua_ChuaHoiPhuc, KetQua_TuVong = s.KetQua_TuVong, KetQua_TuVong_Ngay = s.KetQua_TuVong_Ngay, KetQua_KhongCoThongTin = s.KetQua_KhongCoThongTin, NguoiThamGia_NgaySinh = s.NguoiThamGia_NgaySinh, NguoiThamGia_Tuoi = s.NguoiThamGia_Tuoi, NguoiThamGia_GioiTinh_Nam = s.NguoiThamGia_GioiTinh_Nam, NguoiThamGia_GioiTinh_Nu = s.NguoiThamGia_GioiTinh_Nu, NguoiThamGia_GioiTinh_Nu_DangMangThai = s.NguoiThamGia_GioiTinh_Nu_DangMangThai, NguoiThamGia_GioiTinh_Nu_TuanMangThai = s.NguoiThamGia_GioiTinh_Nu_TuanMangThai, NguoiThamGia_CanNang = s.NguoiThamGia_CanNang, NguoiThamGia_TienSuYKhoa = s.NguoiThamGia_TienSuYKhoa, JSON_ThuocThuLamSang = s.JSON_ThuocThuLamSang, JSON_CanThiepThuocThuLamSang = s.JSON_CanThiepThuocThuLamSang, JSON_ThuocSuDungDongThoi = s.JSON_ThuocSuDungDongThoi, JSON_DanhGiaNCV = s.JSON_DanhGiaNCV, LyDoDanhGia = s.LyDoDanhGia, LyDoDanhGia_SoLuong = s.LyDoDanhGia_SoLuong, LyDoDanhGia_SoLuongNghienCuuKhac = s.LyDoDanhGia_SoLuongNghienCuuKhac, YKienHDDD_NguoiThamGia_TiepTucThamGia = s.YKienHDDD_NguoiThamGia_TiepTucThamGia, YKienHDDD_NguoiThamGia_TamNgungThamGia = s.YKienHDDD_NguoiThamGia_TamNgungThamGia, YKienHDDD_NguoiThamGia_RutKhoiNghienCuu = s.YKienHDDD_NguoiThamGia_RutKhoiNghienCuu, YKienHDDD_DeXuatNghienCuu_TiepTucTrienKhai = s.YKienHDDD_DeXuatNghienCuu_TiepTucTrienKhai, YKienHDDD_DeXuatNghienCuu_TamNgungTrienKhai = s.YKienHDDD_DeXuatNghienCuu_TamNgungTrienKhai, YKienHDDD_DeXuatNghienCuu_NgungTrienKhai = s.YKienHDDD_DeXuatNghienCuu_NgungTrienKhai, YKienHDDD_DeXuatKhac = s.YKienHDDD_DeXuatKhac, NguoiBaoCao_ChuKy = s.NguoiBaoCao_ChuKy, NguoiBaoCao_NgayKy = s.NguoiBaoCao_NgayKy, NguoiBaoCao_HoTen = s.NguoiBaoCao_HoTen, NguoiBaoCao_ChucVu = s.NguoiBaoCao_ChucVu, NguoiBaoCao_DienThoai = s.NguoiBaoCao_DienThoai, NguoiBaoCao_Email = s.NguoiBaoCao_Email, HTML = s.HTML, FormConfig = s.FormConfig, IsDisabled = s.IsDisabled, IsDeleted = s.IsDeleted, CreatedDate = s.CreatedDate, CreatedBy = s.CreatedBy, ModifiedDate = s.ModifiedDate, ModifiedBy = s.ModifiedBy, MaSoBenhNhan = s.tbl_CUS_HRM_BenhNhan.MaBenhNhan, }).FirstOrDefault(); //Edit if (!string.IsNullOrWhiteSpace(query.JSON_CanThiepThuocThuLamSang)) { query.ListCanThiepThuocThuLamSan = JsonConvert.DeserializeObject <List <DTO_PRO_SAE_CanThiepThuocThuLamSan> >(query.JSON_CanThiepThuocThuLamSang); } if (!string.IsNullOrWhiteSpace(query.JSON_DanhGiaNCV)) { query.ListDanhGiaNCV = JsonConvert.DeserializeObject <List <DTO_PRO_SAE_DanhGiaNCV> >(query.JSON_DanhGiaNCV); } if (!string.IsNullOrWhiteSpace(query.JSON_ThuocSuDungDongThoi)) { query.ListThuocSuDungDongThoi = JsonConvert.DeserializeObject <List <DTO_PRO_SAE_ThuocSuDungDongThoi> >(query.JSON_ThuocSuDungDongThoi); } if (!string.IsNullOrWhiteSpace(query.JSON_ThuocThuLamSang)) { query.ListThuocThuLamSan = JsonConvert.DeserializeObject <List <DTO_PRO_SAE_ThuocThuLamSan> >(query.JSON_ThuocThuLamSang); } } else { //New query = new DTO_PRO_SAE { IDDeTai = idDeTai, IDBenhNhan = idBenhNhan }; query.ListCanThiepThuocThuLamSan = new List <DTO_PRO_SAE_CanThiepThuocThuLamSan>() { new DTO_PRO_SAE_CanThiepThuocThuLamSan() }; query.ListDanhGiaNCV = new List <DTO_PRO_SAE_DanhGiaNCV>() { new DTO_PRO_SAE_DanhGiaNCV() }; query.ListThuocSuDungDongThoi = new List <DTO_PRO_SAE_ThuocSuDungDongThoi>() { new DTO_PRO_SAE_ThuocSuDungDongThoi() }; query.ListThuocThuLamSan = new List <DTO_PRO_SAE_ThuocThuLamSan>() { new DTO_PRO_SAE_ThuocThuLamSan() }; } return(query); }