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)); }