public ActionResult Create(FormCollection formCollection) { ViewData["Action"] = "Create"; var user = new USER(); try { if (ModelState.IsValid) { using (var dc = new db_ultramedicaDataContext(Helper.ConnectionString())) { user.NIK = formCollection["NIK"]; user.NAMA = formCollection["NAMA"]; user.POSISI = formCollection["POSISI"]; user.USERNAME = formCollection["USERNAME"]; if (!string.IsNullOrEmpty(formCollection["PASSWORD"])) user.PASSWORD = formCollection["PASSWORD"]; user.ROLES = formCollection["ROLES"]; dc.USERs.InsertOnSubmit(user); dc.SubmitChanges(); } // TODO: Add insert logic here return RedirectToAction("Index"); } return View(); } catch (Exception ex) { ViewData["ErrorMessage"] = ex.Message; return View(user); } }
public ActionResult Create(FormCollection form) { ViewData["Action"] = "Create"; try { if (ModelState.IsValid) { using (var dc = new db_ultramedicaDataContext(Helper.ConnectionString())) { var fo = new FO { LAB_ID = int.Parse(form["LAB_ID"] ?? "0"), EMPLOYEE_ID = form["EMPLOYEE_ID"], YEAR_CHECKUP = form["YEAR_CHECKUP"], DATE = new DateTime(int.Parse(form["DATE"].Substring(6, 4)), int.Parse(form["DATE"].Substring(3, 2)), int.Parse(form["DATE"].Substring(0, 2))), DISTRICT = form["DISTRICT"] }; dc.FOs.InsertOnSubmit(fo); dc.SubmitChanges(); } // TODO: Add insert logic here return RedirectToAction("Index"); } return View(); } catch (Exception ex) { ViewData["ErrorMessage"] = ex.Message; return View(new FO()); } }
public ActionResult Create(FormCollection form) { ViewData["Action"] = "Create"; SPIRO spiro = new SPIRO(); try { if (ModelState.IsValid) { USER user = (USER)Session["user"]; using (var dc = new db_ultramedicaDataContext(Helper.ConnectionString())) { spiro = new SPIRO() { EMPLOYEE_ID = form["EMPLOYEE_ID"], YEAR_CHECKUP = form["YEAR_CHECKUP"], SPIROMETRY_RESULT = form["SPIROMETRY_RESULT"], CHECKED_BY = user.NIK }; HttpPostedFileBase file = Request.Files["FileSPIRO"]; if (Request.ContentLength > Helper.MaxRequestLength() * 1024) { throw new Exception("Maximum request length exceeded. File allowed to be upload are " + (Helper.MaxRequestLength() / 1024).ToString() + " MB"); } if (file.ContentLength > 0) { string fileDir = string.Format("{0}\\{1}_{2}", ConfigurationManager.AppSettings["FileUpload"], form["EMPLOYEE_ID"].ToString(), form["YEAR_CHECKUP"]); string filePath = string.Format("{0}\\{1}", fileDir, Path.GetFileName(file.FileName)); if (!Directory.Exists(fileDir)) Directory.CreateDirectory(fileDir); file.SaveAs(filePath); spiro.SPIROMETRY_FILE_NAME = Path.GetFileName(file.FileName); } dc.SPIROs.InsertOnSubmit(spiro); dc.SubmitChanges(); } // TODO: Add insert logic here return RedirectToAction("Index"); } return View(); } catch (Exception ex) { ViewData["ErrorMessage"] = ex.Message; return View(spiro); } }
public ActionResult Create(EMPLOYEE employee) { ViewData["Action"] = "Create"; try { if (ModelState.IsValid) { using (var dc = new db_ultramedicaDataContext(Helper.ConnectionString())) { dc.EMPLOYEEs.InsertOnSubmit(employee); dc.SubmitChanges(); } // TODO: Add insert logic here return RedirectToAction("Index"); } return View(); } catch (Exception ex) { ViewData["ErrorMessage"] = ex.Message; return View(employee); } }
public ActionResult Create(FormCollection form) { ViewData["Action"] = "Create"; var user = (USER)Session["user"]; FISIK fisik = new FISIK(); try { if (ModelState.IsValid) { using (var dc = new db_ultramedicaDataContext(Helper.ConnectionString())) { fisik = new FISIK(); fisik.EMPLOYEE_ID = form["EMPLOYEE_ID"]; fisik.YEAR_CHECKUP = form["YEAR_CHECKUP"]; fisik.TEMPAT_KERJA = form["TEMPAT_KERJA"]; fisik.POSISI_KERJA = form["POSISI_KERJA"]; fisik.PAPARAN = form["PAPARAN"]; fisik.METODE_KERJA = form["METODE_KERJA"]; fisik.RIWAYAT_ASMA = form["RIWAYAT_ASMA"] == "true"; fisik.RIWAYAT_EPILEPSI = form["RIWAYAT_EPILEPSI"] == "true"; fisik.RIWAYAT_LEPRA = form["RIWAYAT_LEPRA"] == "true"; fisik.RIWAYAT_ANSIETAS = form["RIWAYAT_ANSIETAS"] == "true"; fisik.RIWAYAT_DEPRESI = form["RIWAYAT_DEPRESI"] == "true"; fisik.RIWAYAT_DM = form["RIWAYAT_DM"] == "true"; fisik.RIWAYAT_PROSTAT = form["RIWAYAT_PROSTAT"] == "true"; fisik.RIWAYAT_HEMOROID = form["RIWAYAT_HEMOROID"] == "true"; fisik.RIWAYAT_KELAMIN = form["RIWAYAT_KELAMIN"] == "true"; fisik.VAKSIN_HEPATITIS = form["VAKSIN_HEPATITIS"] == "true"; fisik.RIWAYAT_OPERASI = form["RIWAYAT_OPERASI"] == "true"; fisik.RIWAYAT_KECELAKAAN_KERJA = form["RIWAYAT_KECELAKAAN_KERJA"] == "true"; fisik.SUMMARY_RIWAYAT_PENYAKIT = form["SUMMARY_RIWAYAT_PENYAKIT"]; fisik.KEBIASAAN_ALKOHOL = form["KEBIASAAN_ALKOHOL"]; fisik.KEBIASAAN_OLAHRAGA = form["KEBIASAAN_OLAHRAGA"]; fisik.KEBIASAAN_MEROKOK = form["KEBIASAAN_MEROKOK"]; fisik.KEBIASAAN_NARKOBA = form["KEBIASAAN_NARKOBA"]; fisik.TINGGI_BADAN = string.IsNullOrEmpty(form["TINGGI_BADAN"]) ? 0 : Convert.ToInt32(form["TINGGI_BADAN"]); fisik.BERAT_BADAN = string.IsNullOrEmpty(form["BERAT_BADAN"]) ? 0 : Convert.ToInt32(form["BERAT_BADAN"]); fisik.BMI = string.IsNullOrEmpty(form["BMI"]) ? 0 : Convert.ToDecimal(form["BMI"] ?? "0"); fisik.LKR_DD = string.IsNullOrEmpty(form["LKR_DD"]) ? 0 : Convert.ToInt32(form["LKR_DD"] ?? "0"); fisik.LKR_PRT = string.IsNullOrEmpty(form["LKR_PRT"]) ? 0 : Convert.ToInt32(form["LKR_PRT"] ?? "0"); fisik.T_SISTOL = string.IsNullOrEmpty(form["T_SISTOL"]) ? 0 : Convert.ToInt32(form["T_SISTOL"] ?? "0"); fisik.T_DIASTOL = string.IsNullOrEmpty(form["T_DIASTOL"]) ? 0 : Convert.ToInt32(form["T_DIASTOL"] ?? "0"); fisik.NADI = string.IsNullOrEmpty(form["NADI"]) ? 0 : Convert.ToInt32(form["NADI"] ?? "0"); fisik.RESPIRASI = string.IsNullOrEmpty(form["RESPIRASI"]) ? 0 : Convert.ToInt32(form["RESPIRASI"] ?? "0"); fisik.VISUS_JAUH_TANPA_KACMATA = form["VISUS_JAUH_TANPA_KACMATA"]; fisik.VISUS_JAUH_DENGAN = form["VISUS_JAUH_DENGAN"]; fisik.VISUS_DEKAT_TANPA_KACAMATA = form["VISUS_DEKAT_TANPA_KACAMATA"]; fisik.VISUS_DEKAT_DENGAN_KACAMATA = form["VISUS_DEKAT_DENGAN_KACAMATA"]; fisik.BUTA_WARNA = form["BUTA_WARNA"] == "true"; fisik.ANAMNESA_KELUHAN_UTAMA = form["ANAMNESA_KELUHAN_UTAMA"]; fisik.ANAMNESA_KELUHAN_TAMBAHAN = form["ANAMNESA_KELUHAN_TAMBAHAN"]; fisik.MATA = form["MATA"]; fisik.TELINGA = form["TELINGA"]; fisik.HIDUNG = form["HIDUNG"]; fisik.MULUT = form["MULUT"]; fisik.FARING = form["FARING"]; fisik.TONSIL = form["TONSIL"]; fisik.THYROID = form["THYROID"]; fisik.LYMP_NODE = form["LYMP_NODE"]; fisik.DADA = form["DADA"]; fisik.PERUT = form["PERUT"]; fisik.HERNIA = form["HERNIA"]; fisik.ANUS = form["ANUS"]; fisik.PAYUDARA = form["PAYUDARA"]; fisik.VARICHES_HEMOROID = form["VARICHES_HEMOROID"]; fisik.KULIT_KUKU = form["KULIT_KUKU"]; fisik.PULMO_SIST_RESPIRASI = form["PULMO_SIST_RESPIRASI"]; fisik.COR_SIST_CV = form["COR_SIST_CV"]; fisik.HATI_LIEN_GIT = form["HATI_LIEN_GIT"]; fisik.SUG = form["SUG"]; fisik.SIST_REPROD = form["SIST_REPROD"]; fisik.EXTRIMITAS_ATAS = form["EXTRIMITAS_ATAS"]; fisik.EXTRIMITAS_BAWAH = form["EXTRIMITAS_BAWAH"]; fisik.OTOT_TULANG_LAIN = form["OTOT_TULANG_LAIN"]; fisik.BAU_MULUT = form["BAU_MULUT"] == "true"; fisik.KARIES = string.IsNullOrEmpty(form["KARIES"]) ? 0 : Convert.ToInt32(form["KARIES"] ?? "0"); fisik.TANGGAL = string.IsNullOrEmpty(form["TANGGAL"]) ? 0 : Convert.ToInt32(form["TANGGAL"] ?? "0"); fisik.SISA_AKAR = string.IsNullOrEmpty(form["SISA_AKAR"]) ? 0 : Convert.ToInt32(form["SISA_AKAR"] ?? "0"); fisik.REFLEX_PATOLOGIS = form["REFLEX_PATOLOGIS"] == "true"; fisik.PARESTESI = form["PARESTESI"] == "true"; fisik.PARESE = form["PARESE"] == "true"; fisik.LASSAGUESIGN = form["LASSAGUESIGN"] == "true"; fisik.PATRICK_SIGN = form["PATRICK_SIGN"] == "true"; fisik.CONTRA_PATRICK_SIGN = form["CONTRA_PATRICK_SIGN"] == "true"; fisik.SUMMARY_KESIMPULAN = form["SUMMARY_KESIMPULAN"]; fisik.CHECKED_BY = user.NIK; dc.FISIKs.InsertOnSubmit(fisik); dc.SubmitChanges(); } // TODO: Add insert logic here return RedirectToAction("Index"); } return View(); } catch (Exception ex) { ViewData["ErrorMessage"] = ex.Message; return View(fisik); } }
public ActionResult Delete(string employee_id, string year_checkup) { try { FISIK fisik; ViewData["ErrorMessage"] = ""; // TODO: Add insert logic here using (var dc = new db_ultramedicaDataContext(Helper.ConnectionString())) { fisik = dc.FISIKs.SingleOrDefault( o => o.EMPLOYEE_ID.Equals(employee_id) && o.YEAR_CHECKUP.Equals(year_checkup)); if (fisik != null) { dc.FISIKs.DeleteOnSubmit(fisik); dc.SubmitChanges(); } } } catch (Exception ex) { ViewData["ErrorMessage"] = ex.Message; } return RedirectToAction("Index"); }
public ActionResult Delete(string ID) { try { USER user; ViewData["ErrorMessage"] = ""; // TODO: Add insert logic here using (var dc = new db_ultramedicaDataContext(Helper.ConnectionString())) { user = dc.USERs.SingleOrDefault( o => o.NIK.Equals(ID)); if (user != null) { dc.USERs.DeleteOnSubmit(user); dc.SubmitChanges(); } } } catch (Exception ex) { ViewData["ErrorMessage"] = ex.Message; } return RedirectToAction("Index"); }
public ActionResult Edit(FormCollection formCollection) { ViewData["Action"] = "Edit"; var userdb = new USER(); using (var dc = new db_ultramedicaDataContext(Helper.ConnectionString())) { userdb = dc.USERs.SingleOrDefault(o => o.NIK.Equals(formCollection["NIK"])); try { if (userdb != null) { if (ModelState.IsValid) { userdb.NAMA = formCollection["NAMA"]; userdb.POSISI = formCollection["POSISI"]; userdb.USERNAME = formCollection["USERNAME"]; if (!string.IsNullOrEmpty(formCollection["PASSWORD"])) userdb.PASSWORD = formCollection["PASSWORD"]; userdb.ROLES = formCollection["ROLES"]; dc.SubmitChanges(); } } return RedirectToAction("Index"); } catch (Exception ex) { ViewData["ErrorMessage"] = ex.Message; return View(userdb); } } }
public ActionResult Edit(FormCollection form) { ViewData["Action"] = "Edit"; var EMPLOYEE_ID = form["EMPLOYEE_ID"]; var YEAR_CHECKUP = form["YEAR_CHECKUP"]; EKG ekg = new EKG(); using (var dc = new db_ultramedicaDataContext(Helper.ConnectionString())) { ekg = dc.EKGs.SingleOrDefault(o => o.EMPLOYEE_ID.Equals(EMPLOYEE_ID) && o.YEAR_CHECKUP == YEAR_CHECKUP); try { if (ekg != null) { if (ModelState.IsValid) { USER user = (USER)Session["user"]; HttpPostedFileBase file = Request.Files["FileEKG"]; if (Request.ContentLength > Helper.MaxRequestLength() * 1024) { throw new Exception("Maximum request length exceeded. File allowed to be upload are " + (Helper.MaxRequestLength() / 1024).ToString() + " MB"); } if (file.ContentLength > 0) { string fileDir = string.Format("{0}\\{1}_{2}", ConfigurationManager.AppSettings["FileUpload"], EMPLOYEE_ID.ToString(), YEAR_CHECKUP); string filePath = string.Format("{0}\\{1}", fileDir, Path.GetFileName(file.FileName)); if (!Directory.Exists(fileDir)) Directory.CreateDirectory(fileDir); file.SaveAs(filePath); ekg.EKG_FILE_NAME = Path.GetFileName(file.FileName); } ekg.EKG_RESULT = form["EKG_RESULT"]; ekg.CHECKED_BY = user.NIK; dc.SubmitChanges(); } } return RedirectToAction("Index"); } catch (Exception ex) { ViewData["ErrorMessage"] = ex.Message; return View(ekg); } } }
public ActionResult Create(FormCollection form) { ViewData["Action"] = "Create"; var user = (USER)Session["user"]; LAB lab = new LAB(); try { if (ModelState.IsValid) { using (var dc = new db_ultramedicaDataContext(Helper.ConnectionString())) { lab = new LAB(); lab.EMPLOYEE_ID = form["EMPLOYEE_ID"]; lab.YEAR_CHECKUP = form["YEAR_CHECKUP"]; lab.HB = string.IsNullOrEmpty(form["HB"]) ? 0 : Convert.ToDecimal(form["HB"]); lab.HCT = string.IsNullOrEmpty(form["HCT"]) ? 0 : Convert.ToInt32(form["HCT"]); lab.LEUKOSIT = string.IsNullOrEmpty(form["LEUKOSIT"]) ? 0 : Convert.ToInt32(form["LEUKOSIT"]); lab.TROMBOSIT = string.IsNullOrEmpty(form["TROMBOSIT"]) ? 0 : Convert.ToInt32(form["TROMBOSIT"]); lab.ERITROSIT = string.IsNullOrEmpty(form["ERITROSIT"]) ? 0 : Convert.ToDecimal(form["ERITROSIT"]); lab.LED = string.IsNullOrEmpty(form["LED"]) ? 0 : Convert.ToInt32(form["LED"]); lab.DIFLIM = string.IsNullOrEmpty(form["DIFLIM"]) ? 0 : Convert.ToInt32(form["DIFLIM"]); lab.DIFMON = string.IsNullOrEmpty(form["DIFMON"]) ? 0 : Convert.ToInt32(form["DIFMON"]); lab.DIFGRAN = string.IsNullOrEmpty(form["DIFGRAN"]) ? 0 : Convert.ToInt32(form["DIFGRAN"]); lab.HBSAG = form["HBSAG"] == "true"; lab.AHBS = string.IsNullOrEmpty(form["AHBS"]) ? 0 : Convert.ToInt32(form["AHBS"]); lab.VDRL = form["VDRL"] == "true"; lab.CHOLESTEROL = string.IsNullOrEmpty(form["CHOLESTEROL"]) ? 0 : Convert.ToInt32(form["CHOLESTEROL"]); lab.TRIGLISERIN = string.IsNullOrEmpty(form["TRIGLISERIN"]) ? 0 : Convert.ToInt32(form["TRIGLISERIN"]); lab.HDL = string.IsNullOrEmpty(form["HDL"]) ? 0 : Convert.ToInt32(form["HDL"]); lab.LDL = string.IsNullOrEmpty(form["LDL"]) ? 0 : Convert.ToInt32(form["LDL"]); lab.BUN = string.IsNullOrEmpty(form["BUN"]) ? 0 : Convert.ToInt32(form["BUN"]); lab.CREATINE = string.IsNullOrEmpty(form["CREATINE"]) ? 0 : Convert.ToInt32(form["CREATINE"]); lab.UA = string.IsNullOrEmpty(form["UA"]) ? 0 : Convert.ToInt32(form["UA"]); lab.BSN = string.IsNullOrEmpty(form["BSN"]) ? 0 : Convert.ToInt32(form["BSN"]); lab._2JPP = string.IsNullOrEmpty(form["_2JPP"]) ? 0 : Convert.ToInt32(form["_2JPP"]); lab.OT = string.IsNullOrEmpty(form["OT"]) ? 0 : Convert.ToInt32(form["OT"]); lab.PT = string.IsNullOrEmpty(form["PT"]) ? 0 : Convert.ToInt32(form["PT"]); lab.REDUKSI_PUASA = form["REDUKSI_PUASA"] == "true"; lab.REDUKSI_2JPP = form["REDUKSI_2JPP"] == "true"; lab.WARNA_URINE = form["WARNA_URINE"]; lab.BJ = string.IsNullOrEmpty(form["BJ"]) ? 0 : Convert.ToInt32(form["BJ"]); lab.PH = string.IsNullOrEmpty(form["PH"]) ? 0 : Convert.ToInt32(form["PH"]); lab.KETON = form["KETON"] == "true"; lab.BIL = form["BIL"] == "true"; lab.NITRIT = form["NITRIT"] == "true"; lab.EPITEL = string.IsNullOrEmpty(form["EPITEL"]) ? 0 : Convert.ToInt32(form["EPITEL"]); lab.URINE_ERITROSIT = string.IsNullOrEmpty(form["URINE_ERITROSIT"]) ? 0 : Convert.ToInt32(form["URINE_ERITROSIT"]); lab.URINE_LEKOSIT = string.IsNullOrEmpty(form["URINE_LEKOSIT"]) ? 0 : Convert.ToInt32(form["URINE_LEKOSIT"]); lab.BAKTERI = form["BAKTERI"] == "true"; lab.SIL = form["SIL"] == "true"; lab.KRISTAL = form["KRISTAL"] == "true"; lab.LAB_RESUME = form["LAB_RESUME"]; lab.CHECKED_BY = user.NIK; dc.LABs.InsertOnSubmit(lab); dc.SubmitChanges(); } // TODO: Add insert logic here return RedirectToAction("Index"); } return View(); } catch (Exception ex) { ViewData["ErrorMessage"] = ex.Message; return View(lab); } }
public ActionResult Delete(string ID) { try { EMPLOYEE employee; ViewData["ErrorMessage"] = ""; // TODO: Add insert logic here using (var dc = new db_ultramedicaDataContext(Helper.ConnectionString())) { employee = dc.EMPLOYEEs.SingleOrDefault( o => o.EMPLOYEE_ID.Equals(ID)); if (employee != null) { dc.EMPLOYEEs.DeleteOnSubmit(employee); dc.SubmitChanges(); } } } catch (Exception ex) { ViewData["ErrorMessage"] = ex.Message; } return RedirectToAction("Index"); }
public ActionResult Edit(EMPLOYEE employee) { ViewData["Action"] = "Edit"; try { using (var dc = new db_ultramedicaDataContext(Helper.ConnectionString())) { var employeedb = dc.EMPLOYEEs.SingleOrDefault(o => o.EMPLOYEE_ID.Equals(employee.EMPLOYEE_ID)); if (employeedb != null) { if (ModelState.IsValid) { employeedb.NAME = employee.NAME; employeedb.COMPANY_ID = employee.COMPANY_ID; employeedb.DISTRICT = employee.DISTRICT; employeedb.AGE = employee.AGE; employeedb.DEPARTMENT = employee.DEPARTMENT; employeedb.MESS_STATUS = employee.MESS_STATUS; employeedb.POSITION = employee.POSITION; employeedb.SEX = employee.SEX; employeedb.STATUS = employee.STATUS; dc.SubmitChanges(); } } } return RedirectToAction("Index"); } catch (Exception ex) { ViewData["ErrorMessage"] = ex.Message; return View(employee); } }
public ActionResult Delete(string EMPLOYEE_ID, string YEAR_CHECKUP) { try { FO fo; ViewData["ErrorMessage"] = ""; // TODO: Add insert logic here using (var dc = new db_ultramedicaDataContext(Helper.ConnectionString())) { fo = dc.FOs.SingleOrDefault(o => o.EMPLOYEE_ID.Equals(EMPLOYEE_ID) && o.YEAR_CHECKUP == YEAR_CHECKUP); if (fo != null) { dc.FOs.DeleteOnSubmit(fo); dc.SubmitChanges(); } } } catch (Exception ex) { ViewData["ErrorMessage"] = ex.Message; } return RedirectToAction("Index"); }
public ActionResult Edit(FormCollection form) { ViewData["Action"] = "Edit"; var EMPLOYEE_ID = form["EMPLOYEE_ID"]; var YEAR_CHECKUP = form["YEAR_CHECKUP"]; using (var dc = new db_ultramedicaDataContext(Helper.ConnectionString())) { var fo = dc.FOs.SingleOrDefault(o => o.EMPLOYEE_ID.Equals(EMPLOYEE_ID) && o.YEAR_CHECKUP == YEAR_CHECKUP); try { if (fo != null) { if (ModelState.IsValid) { fo.LAB_ID = Int32.Parse(form["LAB_ID"]); fo.EMPLOYEE_ID = form["EMPLOYEE_ID"]; fo.YEAR_CHECKUP = form["YEAR_CHECKUP"]; fo.DATE = new DateTime(int.Parse(form["DATE"].Substring(6, 4)), int.Parse(form["DATE"].Substring(3, 2)), int.Parse(form["DATE"].Substring(0, 2))); fo.DISTRICT = form["DISTRICT"]; dc.SubmitChanges(); } } return RedirectToAction("Index"); } catch (Exception ex) { ViewData["ErrorMessage"] = ex.Message; return View(fo); } } }