public ActionResult ChoiceEvalutionResult()
{
ViewBag.EGHLayout = "GEA";
GEAContext db = null;
ActionResult view = View("Index", db);
try
{
db = new GEAContext(this);
GEAContextView context = GEAContextView.HandlerChoice(db, this.Request.Params);
switch (context.Regim)
{
case GEAContextView.REGIM.INIT: view = View(db); break;
case GEAContextView.REGIM.CHOICE: view = View("Index", db); context.Regim = GEAContextView.REGIM.INIT; break;
case GEAContextView.REGIM.CANCEL: view = View("Index", db); context.Regim = GEAContextView.REGIM.INIT; break;
default: view = View(db); break;
}
}
catch (RGEContext.Exception e)
{
ViewBag.msg = e.message;
}
finally
{
//if (db != null) db.Disconnect();
}
return(view);
}
public static GEAContextView HandlerClassification(GEAContext db, NameValueCollection parms)
{
GEAContextView rc = db.GetViewContext(VIEWNAME) as GEAContextView;
if (rc == null)
{
db.SaveViewContext(GEAContextView.VIEWNAME, rc = new GEAContextView());
}
string menuitem = parms["menuitem"];
if (menuitem != null)
{
if (menuitem.Equals("Report.Save"))
{
rc.Regim = REGIM.SAVE;
}
}
else if (rc.ecoevolution != null)
{
rc.Regim = REGIM.REPORT;
rc.ecoclassifiation = new GEAContext.ECOClassification(rc.ecoevolution);
}
return(rc);
}
public ActionResult ClassificationEvalution()
{
ViewBag.EGHLayout = "GEA";
ActionResult view = View("Index");
GEAContext db = null;
try
{
db = new GEAContext(this);
GEAContextView context = GEAContextView.HandlerClassification(db, this.Request.Params);
switch (context.Regim)
{
case GEAContextView.REGIM.REPORT: view = View(db); break;
case GEAContextView.REGIM.SAVE:
GEAContext.ECOClassification.Create(db, context.ecoclassifiation);
view = View("Index", db);
break;
case GEAContextView.REGIM.CANCEL: view = View("Index", db); break;
default: view = View(db); break;
}
}
catch (RGEContext.Exception e)
{
ViewBag.msg = e.message;
}
finally
{
//if (db != null) db.Disconnect();
}
return(view);
}
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 SoilPollutionCategoriesDelete(int code)
{
GEAContext db = null;
ViewBag.EGHLayout = "GEA.SoilPollutionCategories";
ActionResult view = View("Index");
string menuitem = this.HttpContext.Request.Params["menuitem"] ?? "Empty";
try
{
db = new GEAContext();
if (menuitem.Equals("SoilPollutionCategories.Delete.Delete"))
{
if (EGH01DB.Types.SoilPollutionCategories.DeleteByCode(db, code))
{
view = View("SoilPollutionCategories", db);
}
}
else if (menuitem.Equals("SoilPollutionCategories.Delete.Cancel"))
{
view = View("SoilPollutionCategories", db);
}
}
catch (RGEContext.Exception e)
{
ViewBag.msg = e.message;
}
catch (Exception e)
{
ViewBag.msg = e.Message;
}
return(view);
}
public static bool Handler(GEAContext context, NameValueCollection parms)
{
bool rc = false;
WaterPollutionCategoriesView viewcontext = null;
string menuitem = parms["menuitem"] ?? "Empty";
if ((viewcontext = context.GetViewContext("WaterPollutionCategoriesCreate") as WaterPollutionCategoriesView) != null)
{
viewcontext.Regim = REGIM.INIT;
string Name = parms["name"];
if (String.IsNullOrEmpty(Name))
{
viewcontext.Regim = REGIM.ERROR;
}
else
{
viewcontext.name = Name;
}
string Min = parms["min"];
if (String.IsNullOrEmpty(Min))
{
viewcontext.Regim = REGIM.ERROR;
}
else
{
float m = 0.0f;
if (Helper.FloatTryParse(Min, out m))
{
viewcontext.min = m;
}
}
string Max = parms["max"];
if (String.IsNullOrEmpty(Max))
{
viewcontext.Regim = REGIM.ERROR;
}
else
{
float mx = 0.0f;
if (Helper.FloatTryParse(Max, out mx))
{
viewcontext.max = mx;
}
}
}
return(rc);
}
public ActionResult Index()
{
ViewBag.EGHLayout = "GEA";
GEAContext db = null;
try
{
db = new GEAContext(this);
}
catch (RGEContext.Exception e)
{
ViewBag.msg = e.message;
}
finally
{
//if (db != null) db.Disconnect();
}
return(View(db));
}
public static GEAContextView HandlerChoice(GEAContext db, NameValueCollection parms)
{
GEAContextView rc = db.GetViewContext(VIEWNAME) as GEAContextView;
if (rc == null)
{
db.SaveViewContext(GEAContextView.VIEWNAME, rc = new GEAContextView());
}
string menuitem = parms["menuitem"];
if (menuitem != null)
{
if (menuitem.Equals("ChoiceEvalutionResult.Choice"))
{
rc.Regim = REGIM.CHOICE;
if (!string.IsNullOrEmpty(parms["ChoiceEvalutionResult.id"]))
{
int id = 0;
if (int.TryParse(parms["ChoiceEvalutionResult.id"], out id))
{
rc.ecoevolution = CEQContext.ECOEvalution.GetById(db, id);
}
else
{
rc.ecoevolution = null;
}
}
}
else if (menuitem.Equals("ChoiceEvalutionResult.Cancel"))
{
rc.Regim = REGIM.CANCEL;
}
}
else
{
rc.Regim = REGIM.INIT;
}
return(rc);
}
public ActionResult ReportDelete(int id)
{
GEAContext db = null;
ViewBag.EGHLayout = "GEA.Report";
ActionResult view = View("Index");
ViewBag.stage = "С";
string menuitem = this.HttpContext.Request.Params["menuitem"] ?? "Empty";
try
{
db = new GEAContext();
if (menuitem.Equals("Report.Delete.Delete"))
{
if (EGH01DB.Primitives.Report.DeleteById(db, id))
{
view = View("Report", db);
}
}
else if (menuitem.Equals("Report.Delete.Cancel"))
{
view = View("Report", db);
}
}
catch (RGEContext.Exception e)
{
ViewBag.msg = e.message;
}
catch (Exception e)
{
ViewBag.msg = e.Message;
}
return(view);
}
// GET: EGHGEAController_Report
public ActionResult Report()
{
GEAContext db = null;
ViewBag.EGHLayout = "GEA.Report";
ActionResult view = View("Index");
ViewBag.stage = "С";
string menuitem = this.HttpContext.Request.Params["menuitem"] ?? "Empty";
try
{
db = new GEAContext();
ViewBag.msg = "Соединение с базой данных установлено";
view = View("Report", db);
if (menuitem.Equals("Report.Watch"))
{
string id = this.HttpContext.Request.Params["id"];
string comment = this.HttpContext.Request.Params["comment"];
if (id != null)
{
int c = 0;
if (int.TryParse(id, out c))
{
EGH01DB.Primitives.Report report = new EGH01DB.Primitives.Report();
if (EGH01DB.Primitives.Report.GetById(db, c, out report, out comment))
{
EGH01.Models.EGHRGE.ReportView rv = new Models.EGHRGE.ReportView();
rv.rep = report.ToHTML();
ViewBag.msg = rv.rep;
view = View("ReportWatch", report);
}
}
}
}
else if (menuitem.Equals("Report.Delete"))
{
string id = this.HttpContext.Request.Params["id"];
string comment = this.HttpContext.Request.Params["comment"];
if (id != null)
{
int c = 0;
if (int.TryParse(id, out c))
{
EGH01DB.Primitives.Report report = new EGH01DB.Primitives.Report();
if (EGH01DB.Primitives.Report.GetById(db, c, out report, out comment))
{
view = View("ReportDelete", report);
}
}
}
}
else if (menuitem.Equals("Report.SaveComment"))
{
string id = this.HttpContext.Request.Params["id"];
string comment;
if (id != null)
{
int c = 0;
if (int.TryParse(id, out c))
{
Report report = new Report();
if (EGH01DB.Primitives.Report.GetById(db, c, out report, out comment))
{
comment = this.HttpContext.Request.Params["comment"];
EGH01DB.Primitives.Report.UpdateCommentById(db, c, comment);
view = View("Report", 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);
}
