public ActionResult ManageServer() { DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); DSRCManagementSystem.Models.ManageServer ObjAC = new DSRCManagementSystem.Models.ManageServer(); List <DSRCManagementSystem.Models.ManageServer> AsgnList = new List <DSRCManagementSystem.Models.ManageServer>(); AsgnList = (from a in db.ManageServers where a.ISDelete == false && a.Raid == true join l in db.locations on a.LocationId equals l.locationid join o in db.Master_ServerOs on a.OperatingSystem equals o.ServerOsName // join c in db.Cpus on a.Processor equals c.CpuName select new DSRCManagementSystem.Models.ManageServer() { RackNo = a.RackNo, MachineName = a.MachineName, Location = l.LocationName, ServerMake = a.ServerMake, Model = a.Model, Processor = a.Processor, Memory = a.Memory, HardDisks = a.HardDisks, Raid = a.Raid, Configurationdetails = a.Configurationdetails, OperatingSystem = o.ServerOsName, ServerEdition = a.ServerEdition, NameofProjectsHosted = a.NameofProjectsHosted, ID = a.ManageServers_Id }).ToList(); return(View(AsgnList.ToList())); }
public ActionResult EditServer(DSRCManagementSystem.Models.ManageServer modelObj, List <int> ProjectList, List <int> AssignedTo) { DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); var userId = (int)Session["UserId"]; ViewBag.Raid = new SelectList(new[] { new { Text = "No", Value = 0 }, new { Text = "Yes", Value = 1 } }, "Value", "Text", 0); var LocationList = db.locations.ToList(); ViewBag.LocationIDList = new SelectList(LocationList, "locationid", "LocationName"); var OsList = db.Master_ServerOs.ToList(); ViewBag.OsIdList = new SelectList(OsList, "ServerOsId", "ServerOsName"); ViewBag.Reporting = new SelectList(GetReportingPersons(userId), "UserId", "Name"); //project(); //if (!ModelState.IsValid) //{ string temp = ""; //for (int i = 0; i < j; i++) // { // temp += ProjectList[i] + ";"; // } if (ProjectList != null) { foreach (int i in ProjectList) { temp += i + ";"; } } string temp1 = ""; if (AssignedTo != null) { foreach (var i in AssignedTo) { temp1 += i + ";"; } } using (DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1()) { var obj_server = objdb.ManageServers.Where(o => o.ManageServers_Id == modelObj.ID).Select(o => o).FirstOrDefault(); obj_server.LocationId = modelObj.LocationId; obj_server.RackNo = modelObj.RackNo; obj_server.AssetId = modelObj.AssetId; obj_server.MachineName = modelObj.MachineName; obj_server.ServerMake = modelObj.ServerMake; obj_server.Model = modelObj.Model; obj_server.Processor = modelObj.Processor; obj_server.Memory = modelObj.Memory; obj_server.HardDisks = modelObj.HardDisks; obj_server.Raid = Convert.ToInt32(modelObj.Raid) == 0 ? true : false; obj_server.Configurationdetails = modelObj.Configurationdetails; obj_server.OperatingSystem = modelObj.ServerOsName; obj_server.ServerEdition = modelObj.ServerEdition; obj_server.NameofProjectsHosted = temp; obj_server.Assignedto = temp1; obj_server.OtherProjects = modelObj.OtherProjects; objdb.SaveChanges(); List <int> selectedProjects = new List <int>(); if (obj_server.NameofProjectsHosted != null) { string[] tokens = obj_server.NameofProjectsHosted.Split(new string[] { ";" }, StringSplitOptions.None); foreach (var i in tokens) { int val; int.TryParse(i, out val); selectedProjects.Add(val); } } ViewBag.ProjectIDList = new MultiSelectList(ProjectList, "ProjectID", "ProjectName", selectedProjects); } return(Json("Success", JsonRequestBehavior.AllowGet)); //} //else //{ // return View(); //} }
public ActionResult AddNew(DSRCManagementSystem.Models.ManageServer modelObj, List <int> ProjectList, List <int> AssignedTo, int Raid) { DSRCManagementSystem.Models.ManageServer obj_Assign = new DSRCManagementSystem.Models.ManageServer(); DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); var OsList = db.Master_ServerOs.ToList(); var LocationList = db.locations.ToList(); // var cpulist = db.Cpus.ToList(); // var ProjectList = db.Projects.ToList(); // int j = ProjectList.Count(); string temp = ""; //for (int i = 0; i < j; i++) // { // temp += ProjectList[i] + ";"; // } foreach (int i in ProjectList) { temp += i; } string temp1 = ""; foreach (var i in AssignedTo) { temp1 += i; } ViewBag.Raid = new SelectList(new[] { new { Text = "No", Value = 0 }, new { Text = "Yes", Value = 1 } }, "Value", "Text", 0); ViewBag.LocationList = new SelectList(new[] { new location() { locationid = 0, LocationName = "---Select---" } }.Union(LocationList), "locationid", "LocationName", 0); ViewBag.OsList = new SelectList(new[] { new Master_ServerOs() { ServerOsId = 0, ServerOsName = "---Select---" } }.Union(OsList), "ServerOsId", "ServerOsName", 0); // ViewBag.cpulist = new SelectList(new[] { new Cpu() { CpuIdNew = 0, CpuName = "---Select---" } }.Union(cpulist), "CpuIdNew", "CpuName", 0); DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1(); var already = objdb.ManageServers.Where(o => o.MachineName == modelObj.MachineName).Select(o => o).FirstOrDefault(); var already1 = objdb.ManageServers.Where(o => o.OtherProjects == modelObj.OtherProjects).Select(o => o).FirstOrDefault(); if (already != null) { return(Json(new { Result = "AlreadyExist", URL = @Url.Action("AlertPopUp", "Popup") }, JsonRequestBehavior.AllowGet)); } else if (already1 != null) { return(Json(new { Result = "Already", URL = @Url.Action("AlertPopUp", "Popup") }, JsonRequestBehavior.AllowGet)); } else { var Asgnobj = db.ManageServers.CreateObject(); Asgnobj.LocationId = modelObj.LocationId; Asgnobj.MachineName = modelObj.MachineName.Trim(); Asgnobj.ServerMake = modelObj.ServerMake.Trim(); Asgnobj.Model = modelObj.Model; Asgnobj.Processor = modelObj.Processor.Trim(); Asgnobj.Memory = modelObj.Memory; Asgnobj.HardDisks = modelObj.HardDisks; Asgnobj.Raid = Raid == 0 ? false : true; Asgnobj.Configurationdetails = modelObj.Configurationdetails.Trim(); Asgnobj.OperatingSystem = modelObj.ServerOsName; Asgnobj.ServerEdition = modelObj.ServerEdition.Trim(); //Asgnobj.NameofProjectsHosted = modelObj.NameofProjectsHosted; Asgnobj.NameofProjectsHosted = temp; Asgnobj.Assignedto = temp1; //Asgnobj.AssignedtoUserId = Convert.ToInt32(temp1.Trim(new Char[] { ' ', '*', '.', ';' })); Asgnobj.ISDelete = false; Asgnobj.AssetId = modelObj.AssetId.Trim(); Asgnobj.RackNo = modelObj.RackNo; Asgnobj.OtherProjects = modelObj.OtherProjects; db.ManageServers.AddObject(Asgnobj); db.SaveChanges(); return(Json("Success", JsonRequestBehavior.AllowGet)); } }