public ActionResult ManageHardware() { Asset1(); ManageHardwareModel rec = new ManageHardwareModel(); rec.HardwareListCollection = (from a in db.Assets where a.InUse == true && a.ISDelete == false join b in db.locations on a.LocationID equals b.locationid into Bord1 from tab2 in Bord1.DefaultIfEmpty() join c in db.AssetTypes on a.AssetTypeId equals c.AssetTypeId join d in db.computermanagements on a.ComputerName equals d.managementid into Bord from tab1 in Bord.DefaultIfEmpty() select new HardwareList() { ID = a.AssetID, Hardware = c.AssetName, Component = a.Name_Model_No, Model = a.ModelNo, AssignedTo = a.ComputerName == 0 ? "Not Assigned" : tab1.ComputerName, Floor = a.LocationID == 0 ? "Not Allocated" : tab2.LocationName, Quantity = a.Quantity, Ip = a.ConnectedTo, InUse = a.InUse }).ToList(); return(View(rec)); }
public ActionResult ManageHardware(ManageHardwareModel HW, FormCollection form) { Asset1(); bool status = form["NotInUse"].Contains("true"); int DropHardware = Convert.ToInt32(HW.ID); if (DropHardware == 0) { if (status == true) { HW.HardwareListCollection = (from a in db.Assets where a.InUse == false && a.ISDelete == false join b in db.locations on a.LocationID equals b.locationid into Bord1 from tab2 in Bord1.DefaultIfEmpty() join c in db.AssetTypes on a.AssetTypeId equals c.AssetTypeId join d in db.computermanagements on a.ComputerName equals d.managementid into Bord from tab1 in Bord.DefaultIfEmpty() select new HardwareList() { ID = a.AssetID, Hardware = c.AssetName, Component = a.Name_Model_No, Model = a.ModelNo, AssignedTo = a.ComputerName == 0 ? "Not Assigned" : tab1.ComputerName, Floor = a.LocationID == 0 ? "Not Allocated" : tab2.LocationName, Quantity = a.Quantity, Ip = a.ConnectedTo, InUse = a.InUse }).ToList(); } else { HW.HardwareListCollection = (from a in db.Assets where a.InUse == true && a.ISDelete == false join b in db.locations on a.LocationID equals b.locationid into Bord1 from tab2 in Bord1.DefaultIfEmpty() join c in db.AssetTypes on a.AssetTypeId equals c.AssetTypeId join d in db.computermanagements on a.ComputerName equals d.managementid into Bord from tab1 in Bord.DefaultIfEmpty() select new HardwareList() { ID = a.AssetID, Hardware = c.AssetName, Component = a.Name_Model_No, Model = a.ModelNo, AssignedTo = a.ComputerName == 0 ? "Not Assigned" : tab1.ComputerName, Floor = a.LocationID == 0 ? "Not Allocated" : tab2.LocationName, Quantity = a.Quantity, Ip = a.ConnectedTo, InUse = a.InUse }).ToList(); } } else { if (status == true) { HW.HardwareListCollection = (from a in db.Assets where a.InUse == false join b in db.locations on a.LocationID equals b.locationid into Bord1 from tab2 in Bord1.DefaultIfEmpty() join c in db.AssetTypes on a.AssetTypeId equals c.AssetTypeId join d in db.computermanagements on a.ComputerName equals d.managementid into Bord from tab1 in Bord.DefaultIfEmpty() where (a.ISDelete == false && a.AssetTypeId == DropHardware) select new HardwareList() { ID = a.AssetID, Hardware = c.AssetName, Component = a.Name_Model_No, Model = a.ModelNo, AssignedTo = a.ComputerName == 0 ? "Not Assigned" : tab1.ComputerName, Floor = a.LocationID == 0 ? "Not Allocated" : tab2.LocationName, Quantity = a.Quantity, Ip = a.ConnectedTo, InUse = a.InUse }).ToList(); } else { HW.HardwareListCollection = (from a in db.Assets where a.InUse == true join b in db.locations on a.LocationID equals b.locationid into Bord1 from tab2 in Bord1.DefaultIfEmpty() join c in db.AssetTypes on a.AssetTypeId equals c.AssetTypeId join d in db.computermanagements on a.ComputerName equals d.managementid into Bord from tab1 in Bord.DefaultIfEmpty() where (a.ISDelete == false && a.AssetTypeId == DropHardware) select new HardwareList() { ID = a.AssetID, Hardware = c.AssetName, Component = a.Name_Model_No, Model = a.ModelNo, AssignedTo = a.ComputerName == 0 ? "Not Assigned" : tab1.ComputerName, Floor = a.LocationID == 0 ? "Not Allocated" : tab2.LocationName, Quantity = a.Quantity, Ip = a.ConnectedTo, InUse = a.InUse }).ToList(); } } return(View(HW)); }