public void UpdateSheets(NacSheet ns, MatSheet ms, DefSheet ds, UserSheet us)
{
using (Models.notariadbContext db = new Models.notariadbContext())
{
ns.DataSource = QueryController.getNacSheetData();
FormStylist.HideColumns(ns, "BloodtypeId", "BirthHour", "NotaryId",
"WitnessId", "AttachId", "AttachDescription",
"Fileroute", "Attach", "Bloodtype", "Dad", "Mom",
"Notary", "Place", "Relateduser", "Witness");
ms.DataSource = QueryController.getMatSheetData();
FormStylist.HideColumns(ms, "NotaryId", "WitnessId", "AttachId", "AttachDescription",
"Fileroute", "Attach", "Notary", "Place",
"Relateduser1", "Relateduser2", "Witness");
ds.DataSource = QueryController.getDefSheetData();
FormStylist.HideColumns(ds, "MedicId", "WitnessId", "NotaryId", "AttachDescription", "Fileroute",
"Medic", "Notary", "Place", "Relateduser", "Witness");
us.DataSource = QueryController.getUserSheetData();
FormStylist.HideColumns(us, "Doctype", "Notarios", "DefuncionesRelateduser", "DefuncionesWitness",
"MatrimoniosRelateduser1", "MatrimoniosRelateduser2", "MatrimoniosWitness", "NacimientosDad",
"NacimientosMom", "NacimientosRelateduser", "NacimientosWitness");
}
}
public ActionResult DeleteConfirmed(int id)
{
UserSheet usersheet = db.UserSheets.Find(id);
db.UserSheets.Remove(usersheet);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "SheetID,PCBoardBrand,PCBoardModel,PCBoardSerial,PCBoardRemark,ProcessorBrand,ProcessorModel,ProcessorSerial,ProcessorRemark,MemoryBrand,MemoryModel,MemorySerial,MemoryRemark,VideoCardBrand,VideoCardModel,VideoCardSerial,VideoCardRemark,LANCardBrand,LANCardModel,LANCardSerial,LANCardRemark,MouseBrand,MouseModel,MouseSerial,MouseRemark,MonitorBrand,MonitorModel,MonitorSerial,MonitorRemark,Monitor2Brand,Monitor2Model,Monitor2Serial,Monitor2Remark,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,Zip7Ver,Zip7Remark,AcrobatVer,AcrobatRemark,AutoCADVer,AutoCADRemark,CureGraphVer,CureGraphRemark,CutePDFVer,CutePDFRemark,HealthBookVer,HealthBookRemark,HRMSystemVer,HRMSystemRemark,IllustratorVer,IllustratorRemark,JP1Ver,JP1Remark,LexitronDictVer,LexitronDictRemark,MiniTabVer,MiniTabRemark,MSOfficeVer,MSOfficeRemark,PhotoShopVer,PhotoShopRemark,SAPVer,SAPRemark,SaveToPDFVer,SaveToPDFRemark,SeedWincsVer,SeedWincsRemark,SolidEdgeVer,SolidEdgeRemark,TrendMicroVer,TrendMicroRemark,WindowsVer,WindowsRemark,ZimbraVer,ZimbraRemark,OtherProgram,OtherProgramVer,OtherProgramRemark,OtherProgram1,OtherProgram1Ver,OtherProgram1Remark,OtherProgram2,OtherProgram2Ver,OtherProgram2Remark,UserID,UserName,PlantID,DepartmentID,LocationID,PhaseID,Plant,Department,Location,Phase,FixAccess,CreateBy,UpdateBy,DateCreate,DateUpdate,DeviceName")] UserSheet usersheet)
{
if (ModelState.IsValid)
{
db.Entry(usersheet).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(usersheet));
}
public ActionResult ExportPdf(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
UserSheet usersheet = db.UserSheets.Find(id);
if (usersheet == null)
{
return(HttpNotFound());
}
return(View(usersheet));
}
// GET: /UserSheet/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
UserSheet usersheet = db.UserSheets.Find(id);
if (usersheet == null)
{
return(HttpNotFound());
}
ViewBag.ID = id;
return(View(usersheet));
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
UserSheet usersheet = db.UserSheets.Find(id);
usersheet.UpdateBy = System.Web.HttpContext.Current.User.Identity.Name;
usersheet.DateUpdate = DateTime.Now;
if (usersheet == null)
{
return(HttpNotFound());
}
return(View(usersheet));
}
public ActionResult CreateSheet([Bind(Include = "SheetID,PCBoardBrand,PCBoardModel,PCBoardSerial,PCBoardRemark,ProcessorBrand,ProcessorModel,ProcessorSerial,ProcessorRemark,MemoryBrand,MemoryModel,MemorySerial,MemoryRemark,VideoCardBrand,VideoCardModel,VideoCardSerial,VideoCardRemark,LANCardBrand,LANCardModel,LANCardSerial,LANCardRemark,MouseBrand,MouseModel,MouseSerial,MouseRemark,MonitorBrand,MonitorModel,MonitorSerial,MonitorRemark,Monitor2Brand,Monitor2Model,Monitor2Serial,Monitor2Remark,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,Zip7Ver,Zip7Remark,AcrobatVer,AcrobatRemark,AutoCADVer,AutoCADRemark,CureGraphVer,CureGraphRemark,CutePDFVer,CutePDFRemark,HealthBookVer,HealthBookRemark,HRMSystemVer,HRMSystemRemark,IllustratorVer,IllustratorRemark,JP1Ver,JP1Remark,LexitronDictVer,LexitronDictRemark,MiniTabVer,MiniTabRemark,MSOfficeVer,MSOfficeRemark,PhotoShopVer,PhotoShopRemark,SAPVer,SAPRemark,SaveToPDFVer,SaveToPDFRemark,SeedWincsVer,SeedWincsRemark,SolidEdgeVer,SolidEdgeRemark,TrendMicroVer,TrendMicroRemark,WindowsVer,WindowsRemark,ZimbraVer,ZimbraRemark,OtherProgram,OtherProgramVer,OtherProgramRemark,OtherProgram1,OtherProgram1Ver,OtherProgram1Remark,OtherProgram2,OtherProgram2Ver,OtherProgram2Remark,UserID,UserName,PlantID,DepartmentID,LocationID,PhaseID,Plant,Department,Location,Phase,FixAccess,CreateBy,UpdateBy,DateCreate,DateUpdate,DeviceName")] UserSheet usersheet)
{
if (ModelState.IsValid)
{
usersheet.PlantID = db.Users.Where(m => m.Plant.PlantName == usersheet.Plant).Select(m => m.PlantID).DefaultIfEmpty().First();
usersheet.DepartmentID = db.Users.Where(m => m.Department.DepartmentName == usersheet.Department).Select(m => m.DepartmentID).DefaultIfEmpty().First();
usersheet.LocationID = db.Users.Where(m => m.Location.LocationName == usersheet.Location).Select(m => m.LocationID).DefaultIfEmpty().First();
usersheet.PhaseID = db.Users.Where(m => m.PhaseName == usersheet.Phase).Select(m => m.PhaseID).DefaultIfEmpty().First();
usersheet.UserID = db.Users.Where(m => m.FullName == usersheet.UserName).Select(m => m.UserID).DefaultIfEmpty().First();
usersheet.DeviceName = usersheet.DeviceName;
db.UserSheets.Add(usersheet);
db.SaveChanges();
return(RedirectToAction("CreateUserSheet", "User", new { id = usersheet.PlantID, did = usersheet.DepartmentID }));
}
ViewBag.DepartmentID = new SelectList(db.Departments.OrderBy(d => d.DepartmentName), "DepartmentID", "DepartmentName", usersheet.DepartmentID);
ViewBag.LocationID = new SelectList(db.Locations.OrderBy(d => d.LocationName), "LocationID", "LocationName", usersheet.LocationID);
ViewBag.PhaseID = new SelectList(db.Phases.OrderBy(d => d.PhaseName), "PhaseID", "PhaseName", usersheet.PhaseID);
ViewBag.PlantID = new SelectList(db.Plants.OrderBy(d => d.PlantName), "PlantID", "PlantName", usersheet.PlantID);
return(View(usersheet));
}
public ActionResult CreateSheet(int?id)
{
#region SetDevice
UserSheet usersheet = new UserSheet();
var totalmonitor = db.Devices.Where(d => d.UserID == id && d.DeviceType.DeviceTypeID == 43 && d.Status.StatusID == 1).Count();
var totalhdd = db.Devices.Where(d => d.UserID == id && d.DeviceType.DeviceTypeID == 13 && d.Status.StatusID == 1).Count();
usersheet.PCBoardBrand = db.Devices.Where(d => d.UserID == id && (d.DeviceTypeID == 49 || d.DeviceTypeID == 54 || d.DeviceTypeID == 66) && d.StatusID == 1).Select(d => d.Brand.BrandName).DefaultIfEmpty("").First();
usersheet.PCBoardSerial = db.Devices.Where(d => d.UserID == id && (d.DeviceTypeID == 49 || d.DeviceTypeID == 54 || d.DeviceTypeID == 66) && d.StatusID == 1).Select(d => d.SerialNumber).DefaultIfEmpty("").First();
usersheet.PCBoardModel = db.Devices.Where(d => d.UserID == id && (d.DeviceTypeID == 49 || d.DeviceTypeID == 54 || d.DeviceTypeID == 66) && d.StatusID == 1).Select(d => d.Model.ModelName).DefaultIfEmpty("").First();
//if(usersheet.PCBoardBrand.Equals(null))
//{
// usersheet.PCBoardBrand = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 54 && d.StatusID == 1).Select(d => d.Brand.BrandName).DefaultIfEmpty("").First();
// usersheet.PCBoardSerial = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 54 && d.StatusID == 1).Select(d => d.SerialNumber).DefaultIfEmpty("").First();
// usersheet.PCBoardModel = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 54 && d.StatusID == 1).Select(d => d.Model.ModelName).DefaultIfEmpty("").First();
//}
usersheet.MemoryBrand = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 59 && d.StatusID == 1).Select(d => d.Brand.BrandName).DefaultIfEmpty("").First();
usersheet.MemorySerial = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 59 && d.StatusID == 1).Select(d => d.SerialNumber).DefaultIfEmpty("").First();
usersheet.MemoryModel = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 59 && d.StatusID == 1).Select(d => d.Model.ModelName).DefaultIfEmpty("").First();
usersheet.LANCardBrand = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 40 && d.StatusID == 1).Select(d => d.BrandName).DefaultIfEmpty("").First();
usersheet.LANCardModel = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 40 && d.StatusID == 1).Select(d => d.ModelName).DefaultIfEmpty("").First();
usersheet.LANCardSerial = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 40 && d.StatusID == 1).Select(d => d.SerialNumber).DefaultIfEmpty("").First();
usersheet.VideoCardBrand = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 65 && d.StatusID == 1).Select(d => d.BrandName).DefaultIfEmpty("").First();
usersheet.VideoCardModel = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 65 && d.StatusID == 1).Select(d => d.ModelName).DefaultIfEmpty("").First();
usersheet.VideoCardSerial = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 65 && d.StatusID == 1).Select(d => d.SerialNumber).DefaultIfEmpty("").First();
usersheet.MouseBrand = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 44 && d.StatusID == 1).Select(d => d.BrandName).DefaultIfEmpty("").First();
usersheet.MouseModel = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 44 && d.StatusID == 1).Select(d => d.ModelName).DefaultIfEmpty("").First();
usersheet.MouseSerial = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 44 && d.StatusID == 1).Select(d => d.SerialNumber).DefaultIfEmpty("").First();
usersheet.KeyboardBrand = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 18 && d.StatusID == 1).Select(d => d.BrandName).DefaultIfEmpty("").First();
usersheet.KeyboardModel = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 18 && d.StatusID == 1).Select(d => d.ModelName).DefaultIfEmpty("").First();
usersheet.KeyboardSerial = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 18 && d.StatusID == 1).Select(d => d.SerialNumber).DefaultIfEmpty("").First();
usersheet.DVDBrand = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 32 && d.StatusID == 1).Select(d => d.BrandName).DefaultIfEmpty("").First();
usersheet.DVDModel = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 32 && d.StatusID == 1).Select(d => d.ModelName).DefaultIfEmpty("").First();
usersheet.DVDSerial = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 32 && d.StatusID == 1).Select(d => d.SerialNumber).DefaultIfEmpty("").First();
usersheet.HDD1Brand = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 13 && d.StatusID == 1).Select(d => d.BrandName).DefaultIfEmpty("").First();
usersheet.HDD1Model = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 13 && d.StatusID == 1).Select(d => d.ModelName).DefaultIfEmpty("").First();
usersheet.HDD1Serial = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 13 && d.StatusID == 1).Select(d => d.SerialNumber).DefaultIfEmpty("").First();
if (totalhdd >= 2)
{
usersheet.HDD2Brand = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 13 && d.StatusID == 1).OrderBy(d => d.DeviceID).Skip(totalhdd - 1).Select(d => d.BrandName).DefaultIfEmpty().First();
usersheet.HDD2Model = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 13 && d.StatusID == 1).OrderBy(d => d.DeviceID).Skip(totalhdd - 1).Select(d => d.ModelName).DefaultIfEmpty().First();
usersheet.HDD2Serial = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 13 && d.StatusID == 1).OrderBy(d => d.DeviceID).Skip(totalhdd - 1).Select(d => d.SerialNumber).DefaultIfEmpty().First();
}
usersheet.PrinterBrand = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 56 && d.StatusID == 1).Select(d => d.BrandName).DefaultIfEmpty("").First();
usersheet.PrinterModel = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 56 && d.StatusID == 1).Select(d => d.ModelName).DefaultIfEmpty("").First();
usersheet.PrinterSerial = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 56 && d.StatusID == 1).Select(d => d.SerialNumber).DefaultIfEmpty("").First();
usersheet.MonitorBrand = db.Devices.OrderBy(d => d.DeviceID).Where(d => d.UserID == id && d.DeviceTypeID == 43 && d.StatusID == 1).Select(d => d.BrandName).DefaultIfEmpty("").First();
usersheet.MonitorModel = db.Devices.OrderBy(d => d.DeviceID).Where(d => d.UserID == id && d.DeviceTypeID == 43 && d.StatusID == 1).Select(d => d.ModelName).DefaultIfEmpty("").First();
usersheet.MonitorSerial = db.Devices.OrderBy(d => d.DeviceID).Where(d => d.UserID == id && d.DeviceTypeID == 43 && d.StatusID == 1).Select(d => d.SerialNumber).DefaultIfEmpty("").First();
if (totalmonitor >= 2)
{
usersheet.Monitor2Brand = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 43 && d.StatusID == 1).OrderBy(d => d.DeviceID).Skip(totalmonitor - 1).Select(d => d.BrandName).DefaultIfEmpty().First();
usersheet.Monitor2Model = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 43 && d.StatusID == 1).OrderBy(d => d.DeviceID).Skip(totalmonitor - 1).Select(d => d.ModelName).DefaultIfEmpty().First();
usersheet.Monitor2Serial = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 43 && d.StatusID == 1).OrderBy(d => d.DeviceID).Skip(totalmonitor - 1).Select(d => d.SerialNumber).DefaultIfEmpty().First();
}
usersheet.ScannerBrand = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 58 && d.StatusID == 1).Select(d => d.BrandName).DefaultIfEmpty("").First();
usersheet.ScannerModel = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 58 && d.StatusID == 1).Select(d => d.ModelName).DefaultIfEmpty("").First();
usersheet.ScannerSerial = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 58 && d.StatusID == 1).Select(d => d.SerialNumber).DefaultIfEmpty("").First();
usersheet.UPSBrand = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 64 && d.StatusID == 1).Select(d => d.BrandName).DefaultIfEmpty("").First();
usersheet.UPSModel = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 64 && d.StatusID == 1).Select(d => d.ModelName).DefaultIfEmpty("").First();
usersheet.UPSSerial = db.Devices.Where(d => d.UserID == id && d.DeviceTypeID == 64 && d.StatusID == 1).Select(d => d.SerialNumber).DefaultIfEmpty("").First();
usersheet.Plant = db.Users.Where(d => d.UserID == id).Select(d => d.Plant.PlantName).DefaultIfEmpty("").First();
usersheet.Department = db.Users.Where(d => d.UserID == id).Select(d => d.Department.DepartmentName).DefaultIfEmpty("").First();
usersheet.Location = db.Users.Where(d => d.UserID == id).Select(d => d.Location.LocationName).DefaultIfEmpty("").First();
usersheet.Phase = db.Users.Where(d => d.UserID == id).Select(d => d.PhaseName).DefaultIfEmpty("").First();
usersheet.UserName = db.Users.Where(d => d.UserID == id).Select(d => d.FullName).DefaultIfEmpty("").First();
usersheet.DeviceName = db.Users.Where(d => d.UserID == id).Select(d => d.DeviceName).DefaultIfEmpty("").First();
usersheet.Zip7Ver = db.UserSheets.Where(u => u.UserName == usersheet.UserName).Select(u => u.Zip7Ver).DefaultIfEmpty().First();
usersheet.AcrobatVer = db.UserSheets.Where(u => u.UserName == usersheet.UserName).Select(u => u.AcrobatVer).DefaultIfEmpty().First();
usersheet.AutoCADVer = db.UserSheets.Where(u => u.UserName == usersheet.UserName).Select(u => u.AutoCADVer).DefaultIfEmpty().First();
usersheet.CureGraphVer = db.UserSheets.Where(u => u.UserName == usersheet.UserName).Select(u => u.CureGraphVer).DefaultIfEmpty().First();
usersheet.CutePDFVer = db.UserSheets.Where(u => u.UserName == usersheet.UserName).Select(u => u.CutePDFVer).DefaultIfEmpty().First();
usersheet.HealthBookVer = db.UserSheets.Where(u => u.UserName == usersheet.UserName).Select(u => u.HealthBookVer).DefaultIfEmpty().First();
usersheet.HRMSystemVer = db.UserSheets.Where(u => u.UserName == usersheet.UserName).Select(u => u.HRMSystemVer).DefaultIfEmpty().First();
usersheet.IllustratorVer = db.UserSheets.Where(u => u.UserName == usersheet.UserName).Select(u => u.IllustratorVer).DefaultIfEmpty().First();
usersheet.JP1Ver = db.UserSheets.Where(u => u.UserName == usersheet.UserName).Select(u => u.JP1Ver).DefaultIfEmpty().First();
usersheet.LexitronDictVer = db.UserSheets.Where(u => u.UserName == usersheet.UserName).Select(u => u.LexitronDictVer).DefaultIfEmpty().First();
usersheet.MiniTabVer = db.UserSheets.Where(u => u.UserName == usersheet.UserName).Select(u => u.MiniTabVer).DefaultIfEmpty().First();
usersheet.MSOfficeVer = db.UserSheets.Where(u => u.UserName == usersheet.UserName).Select(u => u.MSOfficeVer).DefaultIfEmpty().First();
usersheet.PhotoShopVer = db.UserSheets.Where(u => u.UserName == usersheet.UserName).Select(u => u.PhotoShopVer).DefaultIfEmpty().First();
usersheet.SAPVer = db.UserSheets.Where(u => u.UserName == usersheet.UserName).Select(u => u.SAPVer).DefaultIfEmpty().First();
usersheet.SaveToPDFVer = db.UserSheets.Where(u => u.UserName == usersheet.UserName).Select(u => u.SaveToPDFVer).DefaultIfEmpty().First();
usersheet.SeedWincsVer = db.UserSheets.Where(u => u.UserName == usersheet.UserName).Select(u => u.SeedWincsVer).DefaultIfEmpty().First();
usersheet.SolidEdgeVer = db.UserSheets.Where(u => u.UserName == usersheet.UserName).Select(u => u.SolidEdgeVer).DefaultIfEmpty().First();
usersheet.TrendMicroVer = db.UserSheets.Where(u => u.UserName == usersheet.UserName).Select(u => u.TrendMicroVer).DefaultIfEmpty().First();
usersheet.WindowsVer = db.UserSheets.Where(u => u.UserName == usersheet.UserName).Select(u => u.WindowsVer).DefaultIfEmpty().First();
usersheet.ZimbraVer = db.UserSheets.Where(u => u.UserName == usersheet.UserName).Select(u => u.ZimbraVer).DefaultIfEmpty().First();
usersheet.CreateBy = System.Web.HttpContext.Current.User.Identity.Name;
usersheet.UpdateBy = System.Web.HttpContext.Current.User.Identity.Name;
usersheet.DateCreate = DateTime.Now;
usersheet.DateUpdate = DateTime.Now;
#endregion
ViewBag.DeviceID = id;
ViewBag.PlantID = db.Users.Where(d => d.UserID == id).Select(d => d.PlantID).DefaultIfEmpty().First();
ViewBag.DepartmentID = db.Users.Where(d => d.UserID == id).Select(d => d.DepartmentID).DefaultIfEmpty().First();
ViewBag.LocationID = db.Users.Where(d => d.UserID == id).Select(d => d.LocationID).DefaultIfEmpty().First();
return(View(usersheet));
}
