public ActionResult editlab(labVM labvm)
{
bll.updateLab(labvm);
List <labVM> labs = bll.getAllLabs();
ViewBag.labs = labs;
return(RedirectToAction("getlabs", "lab", new { area = "AdminArea" }));
}
public ActionResult editlab(int id)
{
labVM labtoedit = bll.getLabById(id);
List <servicesVM> servicevm = bll.getAllservices();
SelectList li = new SelectList(servicevm, "service_id", "service_name", labtoedit.lab_id);
ViewBag.li = li;
return(PartialView(labtoedit));
}
// update data
public void updateLab(labVM labvm)
{
lab labtoupdate = db.labs.Where(a => a.lab_id == labvm.lab_id).FirstOrDefault();
labtoupdate.lab_name = labvm.lab_name;
labtoupdate.lab_number = labvm.lab_number;
labtoupdate.description = labvm.description;
labtoupdate.floor_number = labvm.floor_number;
labtoupdate.service_id = labvm.service_id;
db.SaveChanges();
}
//adding a lab
public void AddLab(labVM labVM)
{
lab labToAdd = new lab();
labToAdd.lab_name = labVM.lab_name;
labToAdd.lab_number = labVM.lab_number;
labToAdd.description = labVM.description;
labToAdd.floor_number = labVM.floor_number;
labToAdd.service_id = labVM.service_id;
db.labs.Add(labToAdd);
db.SaveChanges();
}
// get lab by id
public labVM getLabById(int id)
{
lab mylab = db.labs.Where(a => a.lab_id == id).FirstOrDefault();
labVM labvm = new labVM();
if (mylab != null)
{
labvm.lab_id = mylab.lab_id;
labvm.lab_name = mylab.lab_name;
labvm.description = mylab.description;
labvm.floor_number = mylab.floor_number;
labvm.service_id = mylab.service_id;
labvm.lab_number = mylab.lab_number;
return(labvm);
}
else
{
return(null);
}
}
public List <labVM> getAllLabs()
{
List <labVM> mylabs = new List <labVM>();
var lab = db.labs.ToList();
foreach (var item in lab)
{
labVM lbobj = new labVM();
lbobj.lab_id = item.lab_id;
lbobj.lab_name = item.lab_name;
lbobj.lab_number = item.lab_number;
lbobj.description = item.description;
lbobj.floor_number = item.floor_number;
lbobj.service_id = item.service_id;
mylabs.Add(lbobj);
}
return(mylabs);
}
public ActionResult Addlab(labVM labvm)
{
bll.AddLab(labvm);
return(RedirectToAction("getlabs", "lab", new { area = "AdminArea" }));
}
