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" }
});
}
