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 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 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 static USER SetSession(HttpCookie cookie)
{
string username = FormsAuthentication.Decrypt(cookie.Value).Name;
string roles = string.Empty;
using (var data = new db_ultramedicaDataContext(Helper.ConnectionString()))
{
var user = data.USERs.SingleOrDefault(u => u.USERNAME == username);
if (user != null) return user;
}
return null;
}
public List<string> MasterRoles()
{
var objreturn = new List<string>();
using(var data = new db_ultramedicaDataContext(Helper.ConnectionString()))
{
var roles = from f in data.ROLEs select f;
if(roles.Any())
{
foreach (var role in roles)
{
objreturn.Add(role.ROLE_NAME);
}
}
}
return objreturn;
}
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);
}
}
protected void FormsAuthentication_OnAuthenticate(Object sender, FormsAuthenticationEventArgs e)
{
if (FormsAuthentication.CookiesSupported == true)
{
if (Request.Cookies[FormsAuthentication.FormsCookieName] != null)
{
try
{
//let us take out the username now
var httpCookie = Request.Cookies[FormsAuthentication.FormsCookieName];
if (httpCookie != null)
{
string username =
FormsAuthentication.Decrypt(httpCookie.Value).Name;
string roles = string.Empty;
using (var data = new db_ultramedicaDataContext(Helper.ConnectionString()))
{
var user = data.USERs.SingleOrDefault(u => u.USERNAME == username);
if (user != null) roles = user.ROLES;
}
//let us extract the roles from our own custom cookie
//Let us set the Pricipal with our user specific details
e.User = new System.Security.Principal.GenericPrincipal(
new System.Security.Principal.GenericIdentity(username, "Forms"), roles.Split(','));
}
}
catch (Exception)
{
//somehting went wrong
}
}
}
}
public ActionResult Edit(string EMPLOYEE_ID, string YEAR_CHECKUP)
{
if (Session["user"] != null)
{
InitializeSession();
ViewData["Action"] = "Edit";
SPIRO spiro = new SPIRO();
try
{
ViewData["ErrorMessage"] = "";
// TODO: Add insert logic here
using (var dc = new db_ultramedicaDataContext(Helper.ConnectionString()))
{
spiro = dc.SPIROs.SingleOrDefault(o => o.EMPLOYEE_ID.Equals(EMPLOYEE_ID) && o.YEAR_CHECKUP == YEAR_CHECKUP);
}
return View(spiro);
}
catch (Exception ex)
{
ViewData["ErrorMessage"] = ex.Message;
return View(spiro);
}
}
return RedirectToAction("LogOut", "Account");
}
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 Edit(string employeeId)
{
if (Session["user"] != null)
{
InitializeSession();
ViewData["Action"] = "Edit";
EMPLOYEE employee = new EMPLOYEE();
try
{
ViewData["ErrorMessage"] = "";
// TODO: Add insert logic here
using (var dc = new db_ultramedicaDataContext(Helper.ConnectionString()))
{
employee = dc.EMPLOYEEs.SingleOrDefault(o => o.EMPLOYEE_ID.Equals(employeeId));
}
return View(employee);
}
catch (Exception ex)
{
ViewData["ErrorMessage"] = ex.Message;
return View(employee);
}
}
return RedirectToAction("LogOut", "Account");
}
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 Index()
{
InitializeSession();
var listUser = new List<USER>();
if (Session["user"] != null)
{
ViewData["ErrorMessage"] = "";
var user = (USER)Session["user"];
var roles = user.ROLES.Split(',');
if (!roles.Any(m => m.Equals("Admin")))
{
listUser.Add(user);
}
else
{
using (var dc = new db_ultramedicaDataContext(Helper.ConnectionString()))
{
listUser = dc.USERs.ToList();
}
}
return View(listUser);
}
return RedirectToAction("LogOut", "Account");
}
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 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);
}
}
}
public ActionResult Index(int? year)
{
InitializeSession();
if (Session["user"] != null)
{
ViewData["ErrorMessage"] = "";
if (year == null)
{
year = DateTime.Now.Year;
}
List<FISIK_INDEX> listfisik = new List<FISIK_INDEX>();
using (var dc = new db_ultramedicaDataContext(Helper.ConnectionString()))
{
var q = (from fo in dc.GetFisikIndex()
select new FISIK_INDEX() { EMPLOYEE_ID = fo.EMPLOYEE_ID, FISIK_ID = fo.FISIK_ID ?? 0, LabId = fo.LAB_ID, YEAR_CHECKUP = fo.YEAR_CHECKUP }).ToList();
if (q.Any())
listfisik.AddRange(q);
}
return View(listfisik);
}
return RedirectToAction("LogOut");
}
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 LogOn(USER model, string returnUrl)
{
if (ModelState.IsValid)
{
using (var data = new db_ultramedicaDataContext(Helper.ConnectionString()))
{
bool isFound = false;
foreach (USER employee in data.USERs)
{
if (employee.USERNAME == model.USERNAME && employee.PASSWORD == model.PASSWORD)
{
isFound = true;
FormsAuthentication.SetAuthCookie(model.USERNAME, false);
{
Session["user"] = employee;
Session["roles"] = employee.ROLES;
return RedirectToAction("Index", "Employee");
}
}
}
if (!isFound)
{
ModelState.AddModelError("", "The user name or password provided is incorrect.");
}
}
}
// If we got this far, something failed, redisplay form
return View(model);
}
public ActionResult Index()
{
if (Session["user"] != null)
{
InitializeSession();
ViewData["ErrorMessage"] = "";
List<EMPLOYEE> listEmployee;
using (var dc = new db_ultramedicaDataContext(Helper.ConnectionString()))
{
listEmployee = dc.EMPLOYEEs.ToList();
}
return View(listEmployee);
}
return RedirectToAction("LogOut", "Account");
}
private List<SelectListItem> GetSelectListItems(string key)
{
var objReturn = new List<SelectListItem>();
using (var db = new db_ultramedicaDataContext(Helper.ConnectionString()))
{
var listItems = db.MASTER_SELECTs.Where(m => m.KEY_SELECT.Equals(key));
if(listItems.Any())
{
objReturn.AddRange(listItems.Select(masterSelect => new SelectListItem() {Text = masterSelect.TEXT, Value = masterSelect.VALUE}));
}
}
return objReturn;
}
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 Edit(string employee_id, string year_checkup)
{
if (Session["user"] != null)
{
InitializeSession();
ViewData["Action"] = "Edit";
ViewData["ErrorMessage"] = "";
FISIK fisik = new FISIK();
try
{
// 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));
}
return View(fisik);
}
catch (Exception ex)
{
ViewData["ErrorMessage"] = ex.Message;
return View(fisik);
}
}
return RedirectToAction("LogOut", "Account");
}
public ActionResult Edit(string userNik)
{
if (Session["user"] != null)
{
InitializeSession();
ViewData["Action"] = "Edit";
USER user = new USER();
try
{
ViewData["ErrorMessage"] = "";
// TODO: Add insert logic here
using (var dc = new db_ultramedicaDataContext(Helper.ConnectionString()))
{
user = dc.USERs.SingleOrDefault(o => o.NIK.Equals(userNik));
}
return View(user);
}
catch (Exception ex)
{
ViewData["ErrorMessage"] = ex.Message;
return View(user);
}
}
return RedirectToAction("LogOut", "Account");
}
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 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);
}
}
}
