public ActionResult SoilPollutionCategoriesUpdate(SoilPollutionCategoriesView sp) { GEAContext db = null; ViewBag.EGHLayout = "GEA.SoilPollutionCategories"; ActionResult view = View("Index"); string menuitem = this.HttpContext.Request.Params["menuitem"] ?? "Empty"; try { db = new GEAContext(); view = View("SoilPollutionCategories", db); if (menuitem.Equals("SoilPollutionCategories.Update.Update")) { EGH01DB.Types.CadastreType cadastre_type = new EGH01DB.Types.CadastreType(); if (EGH01DB.Types.CadastreType.GetByCode(db, sp.list_cadastre, out cadastre_type)) { int code = sp.code; String name = sp.name; string strmin = this.HttpContext.Request.Params["min"] ?? "Empty"; string strmax = this.HttpContext.Request.Params["max"] ?? "Empty"; float min = 0.0f; float max = 0.0f; if (!Helper.FloatTryParse(strmin, out min)) { min = 0.0f; } if (!Helper.FloatTryParse(strmax, out max)) { max = 0.0f; } EGH01DB.Types.SoilPollutionCategories soil_pollution = new EGH01DB.Types.SoilPollutionCategories(code, name, min, max, cadastre_type); if (EGH01DB.Types.SoilPollutionCategories.Update(db, soil_pollution)) { view = View("SoilPollutionCategories", db); } } } else if (menuitem.Equals("SoilPollutionCategories.Update.Cancel")) { view = View("SoilPollutionCategories", db); } } catch (RGEContext.Exception e) { ViewBag.msg = e.message; } catch (Exception e) { ViewBag.msg = e.Message; } return(view); }
public ActionResult SoilPollutionCategoriesCreate(SoilPollutionCategoriesView sp) { GEAContext db = null; ViewBag.EGHLayout = "GEA.SoilPollutionCategories"; ActionResult view = View("Index"); string menuitem = this.HttpContext.Request.Params["menuitem"] ?? "Empty"; try { db = new GEAContext(this); if (!SoilPollutionCategoriesView.Handler(db, this.HttpContext.Request.Params)) { } view = View("SoilPollutionCategories", db); if (menuitem.Equals("SoilPollutionCategories.Create.Create")) { int code = -1; if (EGH01DB.Types.SoilPollutionCategories.GetNextCode(db, out code)) { EGH01DB.Types.CadastreType cadastre_type = new EGH01DB.Types.CadastreType(); if (EGH01DB.Types.CadastreType.GetByCode(db, sp.list_cadastre, out cadastre_type)) { float min; string strmin = this.HttpContext.Request.Params["min"] ?? "Empty"; if (!Helper.FloatTryParse(strmin, out min)) { min = 0.0f; } float max; string strmax = this.HttpContext.Request.Params["max"] ?? "Empty"; if (!Helper.FloatTryParse(strmax, out max)) { max = 0.0f; } String name = sp.name; if (min < max) { EGH01DB.Types.SoilPollutionCategories soil_pollution = new EGH01DB.Types.SoilPollutionCategories(code, name, min, max, cadastre_type); if (EGH01DB.Types.SoilPollutionCategories.Create(db, soil_pollution)) { view = View("SoilPollutionCategories", db); } } else { ViewBag.Error = "Проверьте введенные данные"; view = View("SoilPollutionCategoriesCreate", db); return(view); } } } } else if (menuitem.Equals("SoilPollutionCategories.Create.Cancel")) { view = View("SoilPollutionCategories", db); } } catch (RGEContext.Exception e) { ViewBag.msg = e.message; } catch (Exception e) { ViewBag.msg = e.Message; } return(view); }
public ActionResult SoilPollutionCategories() { GEAContext db = null; ViewBag.EGHLayout = "GEA.SoilPollutionCategories"; ActionResult view = View("Index"); string menuitem = this.HttpContext.Request.Params["menuitem"] ?? "Empty"; try { db = new GEAContext(); SoilPollutionCategoriesView viewcontext = db.GetViewContext("SoilPollutionCategoriesCreate") as SoilPollutionCategoriesView; ViewBag.msg = "Соединение с базой данных установлено"; view = View("SoilPollutionCategories", db); if (menuitem.Equals("SoilPollutionCategories.Create")) { view = View("SoilPollutionCategoriesCreate"); //viewcontext.min = null; //viewcontext.max = null; //viewcontext.name = ""; } else if (menuitem.Equals("SoilPollutionCategories.Delete")) { string type_code_item = this.HttpContext.Request.Params["id"]; if (type_code_item != null) { int c = 0; if (int.TryParse(type_code_item, out c)) { EGH01DB.Types.SoilPollutionCategories sp = new EGH01DB.Types.SoilPollutionCategories(); if (EGH01DB.Types.SoilPollutionCategories.GetByCode(db, c, out sp)) { view = View("SoilPollutionCategoriesDelete", sp); } } } } else if (menuitem.Equals("SoilPollutionCategories.Update")) { string type_code_item = this.HttpContext.Request.Params["id"]; if (type_code_item != null) { int c = 0; if (int.TryParse(type_code_item, out c)) { EGH01DB.Types.SoilPollutionCategories sp = new EGH01DB.Types.SoilPollutionCategories(); if (EGH01DB.Types.SoilPollutionCategories.GetByCode(db, c, out sp)) { view = View("SoilPollutionCategoriesUpdate", sp); } } } } else if (menuitem.Equals("SoilPollutionCategories.Excel")) { EGH01DB.Types.SoilPollutionCategoriesList splist = new EGH01DB.Types.SoilPollutionCategoriesList(db); XmlNode node = splist.toXmlNode(); XmlDocument doc = new XmlDocument(); XmlNode nnode = doc.ImportNode(node, true); doc.AppendChild(nnode); doc.Save(Server.MapPath("~/App_Data/SoilPollutionCategories.xml")); view = View("Index"); view = File(Server.MapPath("~/App_Data/SoilPollutionCategories.xml"), "text/plain", "Категории загрязнения грунтов.xml"); } } catch (RGEContext.Exception e) { ViewBag.msg = e.message; } catch (Exception e) { ViewBag.msg = e.Message; } return(view); }