public ActionResult Add() { //object var obj = new Utilities_Datos_Generales(); //sites list Sites s = new Sites(); s.SitesList = new SelectList(s.GetAllSites(), "SiteID", "SiteName"); obj.Sites = s; return View(obj); }
public ActionResult Update(Utilities_Datos_Generales u) { String thisPageUrl = this.ControllerContext.HttpContext.Request.Url.AbsoluteUri; try { //getting sites with same name as new site name var sameName = from s in db.Utilities_Datos_Generales where s.NombreUtility.Equals(u.NombreUtility) select s; if (u != null) { if (sameName.Count() > 1) { TempData["previous"] = thisPageUrl; TempData["message"] = "The name you are trying to use is already taken."; return View("~/Views/Shared/Error.cshtml"); } else { u.LastUpdatedBy = LoggedUser(); u.SiteID = int.Parse(u.SelectedSite); u.LastUpdatedDate = DateTime.Now; db.Entry(u).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); TempData["previous"] = thisPageUrl; TempData["message"] = "The utility was updated."; return View("~/Views/Shared/Success.cshtml"); } } else { TempData["previous"] = thisPageUrl; TempData["message"] = "There was an error updating site. Try again or contact administrator."; return View("~/Views/Shared/Error.cshtml"); } } catch (Exception e) { TempData["previous"] = thisPageUrl; TempData["message"] = "There was an error updating site. Try again or contact administrator."; return View("~/Views/Shared/Error.cshtml"); } }
public ActionResult Add(Utilities_Datos_Generales u) { String thisPageUrl = this.ControllerContext.HttpContext.Request.Url.AbsoluteUri; TempData["previous"] = thisPageUrl; //getting site ID int SiteID = 0; if (!string.IsNullOrEmpty(u.SelectedSite)) { try { SiteID = int.Parse(u.SelectedSite); var site = db.Sites.Find(SiteID); if (site != null) { if (!string.IsNullOrEmpty(u.AceptaAnulacion)) { u.SiteID = SiteID; u.RegisteredBy = LoggedUser(); u.RegisteredDate = DateTime.Now; //saving database db.Utilities_Datos_Generales.Add(u); db.SaveChanges(); TempData["message"] = "The utilitie was added."; return View("~/Views/Shared/Success.cshtml"); } else { ModelState.AddModelError("AceptaAnulacion", "You must select an option."); //object var obj = new Utilities_Datos_Generales(); //sites list Sites s = new Sites(); s.SitesList = new SelectList(s.GetAllSites(), "SiteID", "SiteName"); obj.Sites = s; return View(obj); } } else { TempData["message"] = "The site you selected doesn't exist. Try again with another site."; return View("~/Views/Shared/Error.cshtml"); } } catch (Exception e) { TempData["message"] = "There was an error registering utility. Try again or contact administrator."; return View("~/Views/Shared/Error.cshtml"); } } else { ModelState.AddModelError("Site", "You must select a site."); //object var obj = new Utilities_Datos_Generales(); //sites list Sites s = new Sites(); s.SitesList = new SelectList(s.GetAllSites(), "SiteID", "SiteName"); obj.Sites = s; return View(obj); } }
public ActionResult Search(string SelectedSite) { String thisPageUrl = this.ControllerContext.HttpContext.Request.Url.AbsoluteUri; TempData["previous"] = thisPageUrl; Sites site = new Sites(); if (!string.IsNullOrEmpty(SelectedSite)) { int SiteID = int.Parse(SelectedSite); site = db.Sites.Find(SiteID); if (site != null) { //utilities var utilities = from b in db.Utilities_Datos_Generales where b.SiteID == SiteID select b; Utilities_Datos_Generales utility = new Utilities_Datos_Generales(); site.SitesList = new SelectList(site.GetAllSites(), "SiteID", "SiteName"); utility.Sites = site; utility.SiteUDG = utilities.ToList(); ViewBag.Error = false; return View(utility); } else { ViewBag.Message = "There are none utilities for the selected site."; return View(); } } ViewBag.Error = true; ModelState.AddModelError("Site", "You must select a site."); var obj = new Batch(); site = new Sites(); site.SitesList = new SelectList(site.GetAllSites(), "SiteID", "SiteName"); obj.Sites = site; return View(obj); }
//Search by Site public ActionResult Search() { var obj = new Utilities_Datos_Generales(); var s = new Sites(); s.SitesList = new SelectList(s.GetAllSites(), "SiteID", "SiteName"); obj.Sites = s; return View(obj); }
//List All Utilities public ActionResult AllUtilities() { Utilities_Datos_Generales u = new Utilities_Datos_Generales(); var us = u.GetAllUDG(); if (us.Count() > 0) { return View(us.ToList()); } else { ViewBag.Message = "There are not registered utilities."; return View(); } }