public JsonResult ExtendLab(ViewModelExtendLab labProp) { IjepaiEntities db = new IjepaiEntities(); Lab lab = db.Labs.Find(labProp.Lab_ID_For_Extend); lab.End_Time = labProp.End_Time; db.SaveChanges(); return Json(new { Status = 0, Message = "Lab extended successfully." }); }
public JsonResult EditLab(ViewModelEditLab labProp) { IjepaiEntities db = new IjepaiEntities(); Lab lab = db.Labs.Find(labProp.Lab_ID_For_Edit); lab.Name = labProp.Name.Trim(); lab.Start_Time = labProp.Start_Time; lab.End_Time = labProp.End_Time; lab.LabConfiguration.Networked = labProp.VMNetwork.Trim(); lab.LabConfiguration.OS = labProp.OS.Trim(); lab.LabConfiguration.VM_Type = labProp.VM_Type.Trim(); lab.LabConfiguration.VM_Count = labProp.VM_Count; db.Entry(lab).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return Json(new { Status = 0, Message = "Lab updated succesfully." }); }
public JsonResult DeleteLab(int Lab_ID_For_Deletion) { IjepaiEntities db = new IjepaiEntities(); db.Billings.Where(bill => bill.Lab_Id == Lab_ID_For_Deletion).ToList().ForEach(b => db.Billings.Remove(b)); db.LabParticipants.Where(p => p.Lab_Id == Lab_ID_For_Deletion).ToList().ForEach(p => db.LabParticipants.Remove(p)); Lab lab = db.Labs.Find(Lab_ID_For_Deletion); db.LabSoftwares.Where(s => s.Config_Id == lab.Config_ID).ToList().ForEach(s => db.LabSoftwares.Remove(s)); db.LabConfigurations.Where(c => c.ID == lab.Config_ID).ToList().ForEach(c => db.LabConfigurations.Remove(c)); db.Labs.Remove(lab); db.SaveChanges(); return Json(new { Status = 0, Message = "Lab deleted successfully." }); }
public ActionResult NewLab(ViewModelNewLab newLab) { Lab lab = new Lab(); lab.Start_Time = newLab.Start_Time; lab.End_Time = newLab.End_Time; lab.Name = newLab.Name; lab.Time_Zone = "Asia/Calcutta"; lab.User_ID = 1; LabConfiguration labConfig = new LabConfiguration(); labConfig.OS = newLab.OS; labConfig.RAM = newLab.Ram; labConfig.VM_Count = newLab.VM_Count; labConfig.Hard_Disk = newLab.Hard_Disk; IjepaiEntities db = new IjepaiEntities(); db.LabConfigurations.Add(labConfig); lab.Config_ID = labConfig.ID; db.Labs.Add(lab); db.SaveChanges(); return View("~/Views/MyLabs/LabDetail.cshtml", newLab); }
public ActionResult Index(ViewModelNewLab newLab) { Lab lab = new Lab(); lab.Start_Time = newLab.Start_Time; lab.End_Time = newLab.End_Time; lab.Name = newLab.Name.Trim(); lab.Time_Zone = "Asia/Calcutta"; lab.Status = "Scheduled"; lab.User_ID = 5; LabConfiguration labConfig = new LabConfiguration(); labConfig.OS = newLab.OS.Trim(); labConfig.VM_Count = newLab.VM_Count; labConfig.Hard_Disk = newLab.Hard_Disk.Trim(); labConfig.VM_Type = newLab.VM_Type.Trim(); labConfig.Networked = newLab.VMNetwork.Trim(); IjepaiEntities db = new IjepaiEntities(); db.LabConfigurations.Add(labConfig); try { db.SaveChanges(); lab.Config_ID = labConfig.ID; db.Labs.Add(lab); db.SaveChanges(); StoreParticipants(newLab.Participants, lab.ID); } catch (Exception ex) { string message = ex.ToString(); } return View("~/Views/MyLabs/Index.cshtml"); }
public int StoreParticipants(ICollection<Participant> Participants, int Participants_Of_Lab) { IjepaiEntities db = new IjepaiEntities(); db.LabParticipants.Where(p => p.Lab_Id == Participants_Of_Lab).ToList().ForEach(p => db.LabParticipants.Remove(p)); if (Participants != null) { foreach (Participant participant in Participants) { if (participant.Username != null) { LabParticipant labParticipant = new LabParticipant(); labParticipant.Email_Address = participant.Username.Trim(); if(participant.First_Name != null) labParticipant.First_Name = participant.First_Name.Trim(); if(participant.Last_Name != null) labParticipant.Last_Name = participant.Last_Name.Trim(); labParticipant.Role = participant.Role.Trim(); labParticipant.Lab_Id = Participants_Of_Lab; db.LabParticipants.Add(labParticipant); db.SaveChanges(); } } } return 0; }