public ActionResult Add() { SubstationView substationView = new SubstationView(); substationView.BindDDLs(substationView, db); return(View(substationView)); }
public ActionResult Index() { ISubstationsRepository substationsRepository = new SubstationsRepository(db); IRegionalOfficesRepository regionalOfficesRepository = new RegionalOfficesRepository(db); int page = !String.IsNullOrWhiteSpace(Request.QueryString["page"]) ? Convert.ToInt32(Request.QueryString["page"]) : 1; int pageSize = !String.IsNullOrWhiteSpace(Request.QueryString["pageSize"]) ? Convert.ToInt32(Request.QueryString["pageSize"]) : Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["ResultsPerPage"]); string sortOrder = !String.IsNullOrWhiteSpace(Request.QueryString["sortOrder"]) ? Request.QueryString["sortOrder"] : "DESC"; string sortColumn = !String.IsNullOrWhiteSpace(Request.QueryString["sortColumn"]) ? Request.QueryString["sortColumn"] : "SubstationPK"; string ordering = sortColumn + " " + sortOrder; ordering = ordering.Trim(); IQueryable <SubstationView> substations = SubstationView.GetSubstationView(substationsRepository.GetValid(), regionalOfficesRepository.GetValid()) .OrderBy(ordering); if (!String.IsNullOrWhiteSpace(Request.QueryString["searchString"])) { string searchString = Request.QueryString["searchString"].ToString(); substations = substations.Where(c => c.Name.Contains(searchString)); } substations = substations.Page(page, pageSize); if (!String.IsNullOrWhiteSpace(Request.QueryString["searchString"])) { string searchString = Request.QueryString["searchString"].ToString(); ViewData["numberOfRecords"] = substationsRepository.GetValid().Where(c => c.Name.Contains(searchString)).Count(); } else { ViewData["numberOfRecords"] = substationsRepository.GetValid().Count(); } int numberOfPages = ((int)ViewData["numberOfRecords"] + pageSize - 1) / pageSize; if (page > numberOfPages) { string url = LinkHelper.getQueryStringArray(new string[] { "page" }); return(Redirect("Substation?" + url + "page=" + numberOfPages)); } else { return(View("Index", substations.ToList())); } }
public ActionResult Edit(int?substationPK) { if (substationPK != null) { ISubstationsRepository substationsRepository = new SubstationsRepository(db); Substation substation = substationsRepository.GetSubstationByPK((int)substationPK); SubstationView substationView = new SubstationView(); substationView.ConvertFrom(substation, substationView); substationView.BindDDLs(substationView, db); return(View(substationView)); } else { return(RedirectToAction("Index", "Substation")); } }
public ActionResult Edit(SubstationView substationView) { if (ModelState.IsValid) { ISubstationsRepository substationsRepository = new SubstationsRepository(db); Substation substation = substationsRepository.GetSubstationByPK((int)substationView.SubstationPK); substationView.ConvertTo(substationView, substation); substationsRepository.SaveChanges(); TempData["message"] = LayoutHelper.GetMessage("UPDATE", substation.SubstationPK); return(RedirectToAction("Index", "Substation")); } else { substationView.BindDDLs(substationView, db); return(View(substationView)); } }