public ActionResult Save(lab com) { bool status = false; if (ModelState.IsValid) { using (TCMSDBEntities dc = new TCMSDBEntities()) { if (com.LabNo > 0) { // Edit var v = dc.labs.Where(a => a.LabNo == com.LabNo).FirstOrDefault(); if (v != null) { v.LabNo = com.LabNo; v.floor = com.floor; } else { //Save dc.labs.Add(com); } } dc.SaveChanges(); status = true; } } return(new JsonResult { Data = new { status = status, message = "Saved Successfully" } }); }
public ActionResult Save(repair com) { bool status = false; if (ModelState.IsValid) { using (TCMSDBEntities dc = new TCMSDBEntities()) { if (com.MachineNO > 0) { // Edit var v = dc.repairs.Where(a => a.repair_id == com.repair_id).FirstOrDefault(); if (v != null) { v.MachineNO = com.MachineNO; v.cost = com.cost; v.description = com.description; v.repair_date = com.repair_date; } else { //Save dc.repairs.Add(com); } dc.SaveChanges(); status = true; } } } return(new JsonResult { Data = new { status = status, message = "Saved Successfully" } }); //return Json(new { status = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet); }
public ActionResult Save(int id) { using (TCMSDBEntities dc = new TCMSDBEntities()) { var v = dc.repairs.Where(a => a.repair_id == id).FirstOrDefault(); return(View(v)); } }
public ActionResult GetRepairDetails() { using (TCMSDBEntities tm = new TCMSDBEntities()) { var machines = tm.repairs.OrderBy(a => a.repair_id).ToList(); return(Json(new { data = machines }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Save(int id) { using (TCMSDBEntities dc = new TCMSDBEntities()) { var v = dc.computers.Where(a => a.MachineNO == id).FirstOrDefault(); return(View(v)); } }
public ActionResult GetMachineDetails() { using (TCMSDBEntities tm = new TCMSDBEntities()) { var machines = tm.computers.OrderBy(a => a.MachineNO).ToList(); return(Json(new { data = machines }, JsonRequestBehavior.AllowGet)); } }
public ActionResult GetLabDetails() { using (TCMSDBEntities tm = new TCMSDBEntities()) { var labs = tm.labs.OrderBy(a => a.LabNo).ToList(); return(Json(new { data = labs }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Save(computer com) { bool status = false; if (ModelState.IsValid) { using (TCMSDBEntities dc = new TCMSDBEntities()) { if (com.MachineNO > 0) { // Edit var v = dc.computers.Where(a => a.MachineNO == com.MachineNO).FirstOrDefault(); if (v != null) { v.MachineNO = com.MachineNO; v.Processor_Type = com.Processor_Type; v.HDD_Capacity = com.HDD_Capacity; v.RAM_Capacity = com.RAM_Capacity; v.PowerSupply_ID = com.PowerSupply_ID; v.Motherboard_ID = com.Motherboard_ID; v.LabNo = com.LabNo; } else { //Save dc.computers.Add(com); } } try { dc.SaveChanges(); status = true; } catch (Exception) { status = true; return(new JsonResult { Data = new { status = status, message = "Something Wrong!" } }); throw; } } } return(new JsonResult { Data = new { status = status, message = "Saved Successfully" } }); //return Json(new { status = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet); }
public ActionResult Delete(int id) { using (TCMSDBEntities dc = new TCMSDBEntities()) { computer aa = new computer(); var v = dc.repairs.Where(a => a.repair_id == id).FirstOrDefault(); if (v != null) { return(View(v)); } else { return(HttpNotFound()); } } }
public ActionResult Delete(int id) { using (TCMSDBEntities dc = new TCMSDBEntities()) { lab aa = new lab(); var v = dc.labs.Where(a => a.LabNo == id).FirstOrDefault(); if (v != null) { return(View(v)); } else { return(HttpNotFound()); } } }
public ActionResult DeleteMachine(int id) { bool status = false; using (TCMSDBEntities dc = new TCMSDBEntities()) { var v = dc.repairs.Where(a => a.repair_id == id).FirstOrDefault(); if (v != null) { dc.repairs.Remove(v); dc.SaveChanges(); status = true; } } return(new JsonResult { Data = new { status = status, message = "Repair Details Deleted Successfully" } }); }