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(string EMPLOYEE_ID, string YEAR_CHECKUP)
{
if (Session["user"] != null)
{
InitializeSession();
ViewData["Action"] = "Create";
ViewData["ErrorMessage"] = "";
var Objreturn = new SPIRO();
Objreturn.YEAR_CHECKUP = YEAR_CHECKUP;
Objreturn.EMPLOYEE_ID = EMPLOYEE_ID;
return View(Objreturn);
}
return RedirectToAction("LogOut", "Account");
}
private void detach_SPIROs(SPIRO entity)
{
this.SendPropertyChanging();
entity.FO = null;
}
private void attach_SPIROs(SPIRO entity)
{
this.SendPropertyChanging();
entity.FO = this;
}
partial void DeleteSPIRO(SPIRO instance);
partial void UpdateSPIRO(SPIRO instance);
partial void InsertSPIRO(SPIRO instance);
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");
}
