public ActionResult WaterPollutionCategoriesUpdate(WaterPollutionCategoriesView sp)
{
GEAContext db = null;
ViewBag.EGHLayout = "GEA.WaterPollutionCategories";
ActionResult view = View("Index");
string menuitem = this.HttpContext.Request.Params["menuitem"] ?? "Empty";
try
{
db = new GEAContext();
view = View("WaterPollutionCategories", db);
if (menuitem.Equals("WaterPollutionCategories.Update.Update"))
{
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.CadastreType cadastre = new EGH01DB.Types.CadastreType();
EGH01DB.Types.CadastreType.GetByCode(db, sp.list_cadastre, out cadastre);
EGH01DB.Types.WaterPollutionCategories water_pollution = new EGH01DB.Types.WaterPollutionCategories(code, name, min, max, cadastre); //blinova
if (EGH01DB.Types.WaterPollutionCategories.Update(db, water_pollution))
{
view = View("WaterPollutionCategories", db);
}
}
else if (menuitem.Equals("WaterPollutionCategories.Update.Cancel"))
{
view = View("WaterPollutionCategories", db);
}
}
catch (RGEContext.Exception e)
{
ViewBag.msg = e.message;
}
catch (Exception e)
{
ViewBag.msg = e.Message;
}
return(view);
}
public ActionResult RehabilitationMethodsCreate(RehabilitationMethodsView rm)
{
ORTContext db = null;
ViewBag.EGHLayout = "ORT.RehabilitationMethods";
ActionResult view = View("Index");
string menuitem = this.HttpContext.Request.Params["menuitem"] ?? "Empty";
try
{
db = new ORTContext();
view = View("RehabilitationMethods", db);
if (menuitem.Equals("RehabilitationMethods.Create.Create"))
{
int type_code = 2;
if (EGH01DB.Types.RehabilitationMethod.GetNextCode(db, out type_code))
{
EGH01DB.Types.CadastreType list_cadastre = new EGH01DB.Types.CadastreType();
if (EGH01DB.Types.CadastreType.GetByCode(db, rm.list_cadastre, out list_cadastre))
{
EGH01DB.Types.RiskObjectType list_risk = new EGH01DB.Types.RiskObjectType();
if (EGH01DB.Types.RiskObjectType.GetByCode(db, rm.list_type, out list_risk))
{
EGH01DB.Types.PetrochemicalCategories list_petrochemical = new EGH01DB.Types.PetrochemicalCategories();
if (EGH01DB.Types.PetrochemicalCategories.GetByCode(db, rm.list_petrochemical, out list_petrochemical))
{
EGH01DB.Types.EmergencyClass list_emergency = new EGH01DB.Types.EmergencyClass();
if (EGH01DB.Types.EmergencyClass.GetByCode(db, rm.list_emergency, out list_emergency))
{
EGH01DB.Types.PenetrationDepth list_penetration = new EGH01DB.Types.PenetrationDepth();
if (EGH01DB.Types.PenetrationDepth.GetByCode(db, rm.list_penetration, out list_penetration))
{
EGH01DB.Types.SoilPollutionCategories list_soil = new EGH01DB.Types.SoilPollutionCategories();
if (EGH01DB.Types.SoilPollutionCategories.GetByCode(db, rm.list_soil, out list_soil))
{
bool waterachieved = rm.waterachieved;
EGH01DB.Types.WaterPollutionCategories list_water = new EGH01DB.Types.WaterPollutionCategories();
if (EGH01DB.Types.WaterPollutionCategories.GetByCode(db, rm.list_water, out list_water))
{
EGH01DB.Types.WaterProtectionArea list_waterArea = new EGH01DB.Types.WaterProtectionArea();
if (EGH01DB.Types.WaterProtectionArea.GetByCode(db, rm.list_waterArea, out list_waterArea))
{
EGH01DB.Types.SoilCleaningMethod list_soilCleaning = new EGH01DB.Types.SoilCleaningMethod();
if (EGH01DB.Types.SoilCleaningMethod.GetByCode(db, rm.list_soilCleaning, out list_soilCleaning))
{
EGH01DB.Types.WaterCleaningMethod list_waterCleaning = new EGH01DB.Types.WaterCleaningMethod();
if (EGH01DB.Types.WaterCleaningMethod.GetByCode(db, rm.list_waterCleaning, out list_waterCleaning))
{
EGH01DB.Types.RehabilitationMethod rehabilitationMethod = new EGH01DB.Types.RehabilitationMethod(type_code, list_risk, list_cadastre, list_petrochemical, list_emergency, list_penetration, list_soil, waterachieved, list_water, list_waterArea, list_soilCleaning, list_waterCleaning);
if (EGH01DB.Types.RehabilitationMethod.Create(db, rehabilitationMethod))
{
view = View("RehabilitationMethods", db);
}
}
}
}
}
}
}
}
}
}
}
}
}
else if (menuitem.Equals("RehabilitationMethods.Create.Cancel"))
{
view = View("RehabilitationMethods", db);
}
}
catch (RGEContext.Exception e)
{
ViewBag.msg = e.message;
}
catch (Exception e)
{
ViewBag.msg = e.Message;
}
return(view);
}
public ActionResult WaterPollutionCategoriesCreate(WaterPollutionCategoriesView sp)
{
GEAContext db = null;
ViewBag.EGHLayout = "GEA.WaterPollutionCategories";
ActionResult view = View("Index");
string menuitem = this.HttpContext.Request.Params["menuitem"] ?? "Empty";
try
{
db = new GEAContext(this);
if (!WaterPollutionCategoriesView.Handler(db, this.HttpContext.Request.Params))
{
}
view = View("WaterPollutionCategories", db);
if (menuitem.Equals("WaterPollutionCategories.Create.Create"))
{
int code = -1;
if (EGH01DB.Types.WaterPollutionCategories.GetNextCode(db, out code))
{
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;
EGH01DB.Types.CadastreType cadastre = new EGH01DB.Types.CadastreType();
EGH01DB.Types.CadastreType.GetByCode(db, sp.list_cadastre, out cadastre);
if (min < max)
{
EGH01DB.Types.WaterPollutionCategories water_pollution = new EGH01DB.Types.WaterPollutionCategories(code, name, min, max, cadastre);
if (EGH01DB.Types.WaterPollutionCategories.Create(db, water_pollution))
{
view = View("WaterPollutionCategories", db);
}
}
else
{
ViewBag.Error = "Проверьте введенные данные";
view = View("WaterPollutionCategoriesCreate", db);
return(view);
}
}
}
else if (menuitem.Equals("WaterPollutionCategories.Create.Cancel"))
{
view = View("WaterPollutionCategories", db);
}
}
catch (RGEContext.Exception e)
{
ViewBag.msg = e.message;
}
catch (Exception e)
{
ViewBag.msg = e.Message;
}
return(view);
}
// GET: EGHORTController_WaterPollutionCategories
public ActionResult WaterPollutionCategories()
{
GEAContext db = null;
ViewBag.EGHLayout = "GEA.WaterPollutionCategories";
ActionResult view = View("Index");
string menuitem = this.HttpContext.Request.Params["menuitem"] ?? "Empty";
try
{
db = new GEAContext(this);
WaterPollutionCategoriesView viewcontext = db.GetViewContext("WaterPollutionCategoriesCreate") as WaterPollutionCategoriesView;
ViewBag.msg = "Соединение с базой данных установлено";
view = View("WaterPollutionCategories", db);
if (menuitem.Equals("WaterPollutionCategories.Create"))
{
view = View("WaterPollutionCategoriesCreate");
viewcontext.min = null;
viewcontext.max = null;
viewcontext.name = "";
}
else if (menuitem.Equals("WaterPollutionCategories.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.WaterPollutionCategories wp = new EGH01DB.Types.WaterPollutionCategories();
if (EGH01DB.Types.WaterPollutionCategories.GetByCode(db, c, out wp))
{
view = View("WaterPollutionCategoriesDelete", wp);
}
}
}
}
else if (menuitem.Equals("WaterPollutionCategories.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.WaterPollutionCategories wp = new EGH01DB.Types.WaterPollutionCategories();
if (EGH01DB.Types.WaterPollutionCategories.GetByCode(db, c, out wp))
{
view = View("WaterPollutionCategoriesUpdate", wp);
}
}
}
}
else if (menuitem.Equals("WaterPollutionCategories.Excel"))
{
EGH01DB.Types.WaterPollutionCategoriesList wplist = new EGH01DB.Types.WaterPollutionCategoriesList(db);
XmlNode node = wplist.toXmlNode();
XmlDocument doc = new XmlDocument();
XmlNode nnode = doc.ImportNode(node, true);
doc.AppendChild(nnode);
doc.Save(Server.MapPath("~/App_Data/WaterPollutionCategories.xml"));
view = View("Index");
view = File(Server.MapPath("~/App_Data/WaterPollutionCategories.xml"), "text/plain", "Категории загрязнения грунтовых вод.xml");
}
}
catch (RGEContext.Exception e)
{
ViewBag.msg = e.message;
}
catch (Exception e)
{
ViewBag.msg = e.Message;
}
return(view);
}
