public ActionResult DeleteConfirmed(int id)
{
PMSheet pmsheet = db.PMSheets.Find(id);
db.PMSheets.Remove(pmsheet);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "SheetID,PCBoardBrand,PCBoardModel,PCBoardSerial,PCBoardRemark,CreateBy,UpdateBy,DateCreate,DateUpdate,FixAccess,ProcessorBrand,ProcessorModel,ProcessorSerial,ProcessorRemark,PlantID,DepartmentID,LocationID,PhaseID,MachineID,PlantName,DepartmentName,LocationName,PhaseName,MachineName,MemoryBrand,MemoryModel,MemorySerial,MemoryRemark,VideoCardBrand,VideoCardModel,VideoCardSerial,VideoCardRemark,LANCardBrand,LANCardSerial,LANCardModel,LANCardRemark,MouseBrand,MouseModel,MouseSerial,MouseRemark,MonitorBrand,MonitorModel,MonitorSerial,MonitorRemark,KeyboardBrand,KeyboardModel,KeyboardSerial,KeyboardRemark,ScannerBrand,ScannerModel,ScannerSerial,ScannerRemark,DVDBrand,DVDModel,DVDSerial,DVDRemark,HDD1Brand,HDD1Model,HDD1Serial,HDD1Remark,HDD2Brand,HDD2Model,HDD2Serial,HDD2Remark,PrinterBrand,PrinterModel,PrinterSerial,PrinterRemark,UPSBrand,UPSModel,UPSSerial,UPSRemark,PCICardBrand,PCICardModel,PCICardSerial,PCIRemark,BluetoothBrand,BluetoothModel,BluetoothSerial,BluetoothRemark,HUBBrand,HUBModel,HUBSerial,HUBRemark,OtherHardwareName1,OtherHardwareBrand,OtherHardwareModel,OtherHardwareSerial,OtherHardwareRemark,OtherHardwareName2,OtherHardware1Brand,OtherHardware1Model,OtherHardware1Serial,OtherHardware1Remark,OtherHardwareName3,OtherHardware2Brand,OtherHardware2Model,OtherHardware2Serial,OtherHardware2Remark,FixAccess,CreateBy,UpdateBy,DateCreate,DateUpdate,PlantID,DepartmentID,LocationID,PhaseID,MachineID,PlantName,DepartmentName,LocationName,PhaseName,MachineName,Zip7Version,Zip7Remark,AcrobatVersion,AcrobatRemark,CureGraphVersion,CureGraphRemark,JP1Version,JP1Remark,MSOfficeVersion,MSOfficeRemark,OracleVersion,OracleRemark,RaidVersion,RaidRemark,SeedWincsVersion,SeedWincsRemark,SharedCPCVersion,SharedCPCRemark,SharedDPanelPCVersion,SharedDPanelPCRemark,TightVNCVersion,TightVNCRemark,TrendMicroVersion,TrendMicroRemark,WindowsVersion,WindowsRemark,OtherSoftware,OtherSoftwareRemark")] PMSheet pmsheet)
{
if (ModelState.IsValid)
{
db.Entry(pmsheet).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(pmsheet));
}
// GET: /MachineSheet/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PMSheet pmsheet = db.PMSheets.Find(id);
if (pmsheet == null)
{
return(HttpNotFound());
}
return(View(pmsheet));
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PMSheet pmsheet = db.PMSheets.Find(id);
var updateName = System.Web.HttpContext.Current.User.Identity.Name;
pmsheet.UpdateBy = db.Users.Where(u => u.EmployeeID == updateName).Select(u => u.FullName).DefaultIfEmpty().First();
pmsheet.DateUpdate = DateTime.Now;
if (pmsheet == null)
{
return(HttpNotFound());
}
return(View(pmsheet));
}
public ActionResult CreateSheet([Bind(Include = "SheetID,PCBoardBrand,PCBoardModel,PCBoardSerial,PCBoardRemark,CreateBy,UpdateBy,DateCreate,DateUpdate,FixAccess,ProcessorBrand,ProcessorModel,ProcessorSerial,ProcessorRemark,PlantID,DepartmentID,LocationID,PhaseID,MachineID,PlantName,DepartmentName,LocationName,PhaseName,MachineName,MemoryBrand,MemoryModel,MemorySerial,MemoryRemark,VideoCardBrand,VideoCardModel,VideoCardSerial,VideoCardRemark,LANCardBrand,LANCardSerial,LANCardModel,LANCardRemark,MouseBrand,MouseModel,MouseSerial,MouseRemark,MonitorBrand,MonitorModel,MonitorSerial,MonitorRemark,KeyboardBrand,KeyboardModel,KeyboardSerial,KeyboardRemark,ScannerBrand,ScannerModel,ScannerSerial,ScannerRemark,DVDBrand,DVDModel,DVDSerial,DVDRemark,HDD1Brand,HDD1Model,HDD1Serial,HDD1Remark,HDD2Brand,HDD2Model,HDD2Serial,HDD2Remark,PrinterBrand,PrinterModel,PrinterSerial,PrinterRemark,UPSBrand,UPSModel,UPSSerial,UPSRemark,PCICardBrand,PCICardModel,PCICardSerial,PCIRemark,BluetoothBrand,BluetoothModel,BluetoothSerial,BluetoothRemark,HUBBrand,HUBModel,HUBSerial,HUBRemark,OtherHardwareName1,OtherHardwareBrand,OtherHardwareModel,OtherHardwareSerial,OtherHardwareRemark,OtherHardwareName2,OtherHardware1Brand,OtherHardware1Model,OtherHardware1Serial,OtherHardware1Remark,OtherHardwareName3,OtherHardware2Brand,OtherHardware2Model,OtherHardware2Serial,OtherHardware2Remark,FixAccess,CreateBy,UpdateBy,DateCreate,DateUpdate,PlantID,DepartmentID,LocationID,PhaseID,MachineID,PlantName,DepartmentName,LocationName,PhaseName,MachineName,Zip7Version,Zip7Remark,AcrobatVersion,AcrobatRemark,CureGraphVersion,CureGraphRemark,JP1Version,JP1Remark,MSOfficeVersion,MSOfficeRemark,OracleVersion,OracleRemark,RaidVersion,RaidRemark,SeedWincsVersion,SeedWincsRemark,SharedCPCVersion,SharedCPCRemark,SharedDPanelPCVersion,SharedDPanelPCRemark,TightVNCVersion,TightVNCRemark,TrendMicroVersion,TrendMicroRemark,WindowsVersion,WindowsRemark,OtherSoftware,OtherSoftwareRemark")] PMSheet pmsheet)
{
if (ModelState.IsValid)
{
pmsheet.PlantID = db.Machines.Where(m => m.Plant.PlantName == pmsheet.PlantName).Select(m => m.PlantID).DefaultIfEmpty().First();
pmsheet.DepartmentID = db.Machines.Where(m => m.Department.DepartmentName == pmsheet.DepartmentName).Select(m => m.DepartmentID).DefaultIfEmpty().First();
pmsheet.LocationID = db.Machines.Where(m => m.Location.LocationName == pmsheet.LocationName).Select(m => m.LocationID).DefaultIfEmpty().First();
pmsheet.PhaseID = db.Machines.Where(m => m.Phase.PhaseName == pmsheet.PhaseName).Select(m => m.PhaseID).DefaultIfEmpty().First();
pmsheet.MachineID = db.Machines.Where(m => m.MachineName == pmsheet.MachineName).Select(m => m.MachineID).DefaultIfEmpty().First();
db.PMSheets.Add(pmsheet);
db.SaveChanges();
return(RedirectToAction("Index", "MachineSheet"));
}
ViewBag.DepartmentID = new SelectList(db.Departments.OrderBy(d => d.DepartmentName), "DepartmentID", "DepartmentName", pmsheet.DepartmentID);
ViewBag.LocationID = new SelectList(db.Locations.OrderBy(d => d.LocationName), "LocationID", "LocationName", pmsheet.LocationID);
ViewBag.PhaseID = new SelectList(db.Phases.OrderBy(d => d.PhaseName), "PhaseID", "PhaseName", pmsheet.PhaseID);
ViewBag.PlantID = new SelectList(db.Plants.OrderBy(d => d.PlantName), "PlantID", "PlantName", pmsheet.PlantID);
return(View(pmsheet));
}
public ActionResult CreateSheet(int?id)
{
#region SetDevice
PMSheet pmsheet = new PMSheet();
var totalhdd = db.Devices.Where(d => d.MachineID == id && d.DeviceType.DeviceTypeID == 13 && d.Status.StatusID == 1).Count();
var createName = System.Web.HttpContext.Current.User.Identity.Name;
var updateName = System.Web.HttpContext.Current.User.Identity.Name;
pmsheet.PCBoardBrand = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 50 && d.StatusID == 1).Select(d => d.Brand.BrandName).DefaultIfEmpty().First();
pmsheet.PCBoardSerial = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 50 && d.StatusID == 1).Select(d => d.SerialNumber).DefaultIfEmpty().First();
pmsheet.PCBoardModel = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 50 && d.StatusID == 1).Select(d => d.Model.ModelName).DefaultIfEmpty().First();
if (pmsheet.PCBoardBrand == null)
{
pmsheet.PCBoardBrand = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 54 && d.StatusID == 1).Select(d => d.Brand.BrandName).DefaultIfEmpty().First();
pmsheet.PCBoardSerial = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 54 && d.StatusID == 1).Select(d => d.SerialNumber).DefaultIfEmpty().First();
pmsheet.PCBoardModel = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 54 && d.StatusID == 1).Select(d => d.Model.ModelName).DefaultIfEmpty().First();
}
pmsheet.MemoryBrand = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 59 && d.StatusID == 1).Select(d => d.Brand.BrandName).DefaultIfEmpty("").First();
pmsheet.MemorySerial = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 59 && d.StatusID == 1).Select(d => d.SerialNumber).DefaultIfEmpty("").First();
pmsheet.MemoryModel = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 59 && d.StatusID == 1).Select(d => d.Model.ModelName).DefaultIfEmpty("").First();
pmsheet.LANCardBrand = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 40 && d.StatusID == 1).Select(d => d.BrandName).DefaultIfEmpty("").First();
pmsheet.LANCardModel = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 40 && d.StatusID == 1).Select(d => d.ModelName).DefaultIfEmpty("").First();
pmsheet.LANCardSerial = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 40 && d.StatusID == 1).Select(d => d.SerialNumber).DefaultIfEmpty("").First();
pmsheet.VideoCardBrand = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 65 && d.StatusID == 1).Select(d => d.BrandName).DefaultIfEmpty("").First();
pmsheet.VideoCardModel = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 65 && d.StatusID == 1).Select(d => d.ModelName).DefaultIfEmpty("").First();
pmsheet.VideoCardSerial = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 65 && d.StatusID == 1).Select(d => d.SerialNumber).DefaultIfEmpty("").First();
pmsheet.MouseBrand = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 44 && d.StatusID == 1).Select(d => d.BrandName).DefaultIfEmpty("").First();
pmsheet.MouseModel = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 44 && d.StatusID == 1).Select(d => d.ModelName).DefaultIfEmpty("").First();
pmsheet.MouseSerial = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 44 && d.StatusID == 1).Select(d => d.SerialNumber).DefaultIfEmpty("").First();
pmsheet.KeyboardBrand = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 18 && d.StatusID == 1).Select(d => d.BrandName).DefaultIfEmpty("").First();
pmsheet.KeyboardModel = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 18 && d.StatusID == 1).Select(d => d.ModelName).DefaultIfEmpty("").First();
pmsheet.KeyboardSerial = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 18 && d.StatusID == 1).Select(d => d.SerialNumber).DefaultIfEmpty("").First();
pmsheet.DVDBrand = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 32 && d.StatusID == 1).Select(d => d.BrandName).DefaultIfEmpty("").First();
pmsheet.DVDModel = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 32 && d.StatusID == 1).Select(d => d.ModelName).DefaultIfEmpty("").First();
pmsheet.DVDSerial = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 32 && d.StatusID == 1).Select(d => d.SerialNumber).DefaultIfEmpty("").First();
pmsheet.HDD1Brand = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 13 && d.StatusID == 1).Select(d => d.BrandName).DefaultIfEmpty("").First();
pmsheet.HDD1Model = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 13 && d.StatusID == 1).Select(d => d.ModelName).DefaultIfEmpty("").First();
pmsheet.HDD1Serial = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 13 && d.StatusID == 1).Select(d => d.SerialNumber).DefaultIfEmpty("").First();
if (totalhdd >= 2)
{
pmsheet.HDD2Brand = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 13 && d.StatusID == 1).OrderBy(d => d.DeviceID).Skip(totalhdd - 1).Select(d => d.BrandName).DefaultIfEmpty().First();
pmsheet.HDD2Model = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 13 && d.StatusID == 1).OrderBy(d => d.DeviceID).Skip(totalhdd - 1).Select(d => d.ModelName).DefaultIfEmpty().First();
pmsheet.HDD2Serial = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 13 && d.StatusID == 1).OrderBy(d => d.DeviceID).Skip(totalhdd - 1).Select(d => d.SerialNumber).DefaultIfEmpty().First();
}
pmsheet.PrinterBrand = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 56 && d.StatusID == 1).Select(d => d.BrandName).DefaultIfEmpty("").First();
pmsheet.PrinterModel = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 56 && d.StatusID == 1).Select(d => d.ModelName).DefaultIfEmpty("").First();
pmsheet.PrinterSerial = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 56 && d.StatusID == 1).Select(d => d.SerialNumber).DefaultIfEmpty("").First();
pmsheet.MonitorBrand = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 43 && d.StatusID == 1).Select(d => d.BrandName).DefaultIfEmpty("").First();
pmsheet.MonitorModel = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 43 && d.StatusID == 1).Select(d => d.ModelName).DefaultIfEmpty("").First();
pmsheet.MonitorSerial = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 43 && d.StatusID == 1).Select(d => d.SerialNumber).DefaultIfEmpty("").First();
pmsheet.ScannerBrand = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 58 && d.StatusID == 1).Select(d => d.BrandName).DefaultIfEmpty("").First();
pmsheet.ScannerModel = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 58 && d.StatusID == 1).Select(d => d.ModelName).DefaultIfEmpty("").First();
pmsheet.ScannerSerial = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 58 && d.StatusID == 1).Select(d => d.SerialNumber).DefaultIfEmpty("").First();
pmsheet.UPSBrand = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 64 && d.StatusID == 1).Select(d => d.BrandName).DefaultIfEmpty("").First();
pmsheet.UPSModel = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 64 && d.StatusID == 1).Select(d => d.ModelName).DefaultIfEmpty("").First();
pmsheet.UPSSerial = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 64 && d.StatusID == 1).Select(d => d.SerialNumber).DefaultIfEmpty("").First();
pmsheet.BluetoothBrand = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 7 && d.StatusID == 1).Select(d => d.BrandName).DefaultIfEmpty("").First();
pmsheet.BluetoothModel = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 7 && d.StatusID == 1).Select(d => d.ModelName).DefaultIfEmpty("").First();
pmsheet.BluetoothSerial = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 7 && d.StatusID == 1).Select(d => d.SerialNumber).DefaultIfEmpty("").First();
pmsheet.HUBBrand = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 15 && d.StatusID == 1).Select(d => d.BrandName).DefaultIfEmpty("").First();
pmsheet.HUBModel = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 15 && d.StatusID == 1).Select(d => d.ModelName).DefaultIfEmpty("").First();
pmsheet.HUBSerial = db.Devices.Where(d => d.MachineID == id && d.DeviceTypeID == 15 && d.StatusID == 1).Select(d => d.SerialNumber).DefaultIfEmpty("").First();
pmsheet.PlantName = db.Machines.Where(d => d.MachineID == id).Select(d => d.Plant.PlantName).DefaultIfEmpty("").First();
pmsheet.DepartmentName = db.Machines.Where(d => d.MachineID == id).Select(d => d.Department.DepartmentName).DefaultIfEmpty("").First();
pmsheet.LocationName = db.Machines.Where(d => d.MachineID == id).Select(d => d.Location.LocationName).DefaultIfEmpty("").First();
pmsheet.PhaseName = db.Machines.Where(d => d.MachineID == id).Select(d => d.Phase.PhaseName).DefaultIfEmpty("").First();
pmsheet.MachineName = db.Machines.Where(d => d.MachineID == id).Select(d => d.MachineName).DefaultIfEmpty("").First();
pmsheet.CreateBy = db.Users.Where(u => u.EmployeeID == createName).Select(u => u.FullName).DefaultIfEmpty().First();
pmsheet.UpdateBy = db.Users.Where(u => u.EmployeeID == updateName).Select(u => u.FullName).DefaultIfEmpty().First();
pmsheet.DateCreate = DateTime.Now;
pmsheet.DateUpdate = DateTime.Now;
#endregion
ViewBag.DeviceID = id;
ViewBag.PlantID = db.Machines.Where(d => d.MachineID == id).Select(d => d.PlantID).DefaultIfEmpty().First();
ViewBag.DepartmentID = db.Machines.Where(d => d.MachineID == id).Select(d => d.DepartmentID).DefaultIfEmpty().First();
ViewBag.LocationID = db.Machines.Where(d => d.MachineID == id).Select(d => d.LocationID).DefaultIfEmpty().First();
return(View(pmsheet));
}
