public ActionResult ChoiceForecastResult()
{
ViewBag.EGHLayout = "CEQ";
ActionResult rc = View("Index");
try
{
CEQContext ceq = new CEQContext(this);
CEQViewContext context = CEQViewContext.HandlerChoiceForecast(ceq, this.HttpContext.Request.Params);
if (context != null && context.RegimChoice == CEQViewContext.REGIM_CHOICE.CHOICE)
{
EGH01DB.RGEContext.ECOForecast forecast = new EGH01DB.RGEContext.ECOForecast();
string comment = string.Empty;
if (EGH01DB.RGEContext.ECOForecast.GetById(ceq, (int)context.idforecat, out forecast, out comment))
{
context.ecoevalution = new CEQContext.ECOEvalution(forecast);
rc = View("Index", ceq);
}
}
else
{
rc = View(ceq);
}
}
catch (EGHDBException e)
{
rc = View("Index");
}
catch (Exception e)
{
rc = View("Index");
}
return(rc);
}
//public static CEQViewContext HandlerEvalutionForecast(CEQContext db, NameValueCollection parms)
//{
// CEQViewContext rc = db.GetViewContext(VIEWNAME) as CEQViewContext;
// if ((rc = db.GetViewContext(VIEWNAME) as CEQViewContext) != null)
// {
// rc.RegimEvalution = rc.RegimEvalution == REGIM_EVALUTION.CANCEL? REGIM_EVALUTION.INIT: rc.RegimEvalution;
// string menuitem = parms["menuitem"];
// if (menuitem != null)
// {
// if (menuitem.Equals("CEQReport.Save")) rc.RegimEvalution = REGIM_EVALUTION.SAVE;
// else if (menuitem.Equals("CEQReport.Cancel")) rc.RegimEvalution = REGIM_EVALUTION.CANCEL;
// }
// }
// return rc;
//}
public static CEQViewContext HandlerChoiceForecast(CEQContext db, NameValueCollection parms)
{
CEQViewContext rc = null;
if ((rc = db.GetViewContext(VIEWNAME) as CEQViewContext) != null)
{
rc.RegimChoice = REGIM_CHOICE.INIT;
string menuitem = parms["menuitem"];
if (menuitem != null)
{
if (menuitem.Equals("ChoiceForecastResult.Choice"))
{
string formid = parms["ChoiceForecastResult.id"];
int id = -1;
if (!string.IsNullOrEmpty(formid) && int.TryParse(formid, out id))
{
rc.idforecat = id;
EGH01DB.RGEContext.ECOForecast ef = rc.ecoforecat = null;
string comment = string.Empty;
if (EGH01DB.RGEContext.ECOForecast.GetById(db, id, out ef, out comment))
{
rc.ecoforecat = ef;
rc.RegimChoice = REGIM_CHOICE.CHOICE;
}
else
{
rc.RegimChoice = REGIM_CHOICE.ERROR;
}
}
else
{
rc.RegimChoice = REGIM_CHOICE.ERROR;
}
}
else if (menuitem.Equals("ChoiceForecastResult.Cancel"))
{
rc.RegimChoice = REGIM_CHOICE.CANCEL;
}
else if (menuitem.Equals("ConfirmChoiceForecastResult.Confirm"))
{
rc.RegimChoice = REGIM_CHOICE.REPORT;
}
else if (menuitem.Equals("ConfirmChoiceForecastResult.Cancel"))
{
rc.RegimChoice = REGIM_CHOICE.INIT;
}
else if (menuitem.Equals("CEQReport.Save"))
{
rc.RegimChoice = REGIM_CHOICE.SAVE;
}
else if (menuitem.Equals("CEQReport.Cancel"))
{
rc.RegimChoice = REGIM_CHOICE.CANCEL;
}
}
}
return(rc);
}
public ActionResult CadastreTypeUpdate(CadastreTypeView cd)
{
CEQContext db = null;
ViewBag.EGHLayout = "CEQ";
ActionResult view = View("Index");
string menuitem = this.HttpContext.Request.Params["menuitem"] ?? "Empty";
try
{
db = new CEQContext(this);
view = View("CadastreType", db);
if (menuitem.Equals("CadastreType.Update.Update"))
{
int id = cd.type_code;
String name = cd.name;
float pdk_coef = cd.pdk_coef;
String strpdk_coef = this.HttpContext.Request.Params["pdk_coef"] ?? "Empty";;
if (!Helper.FloatTryParse(strpdk_coef, out pdk_coef))
{
pdk_coef = 0.0f;
}
float water_pdk_coef = cd.water_pdk_coef;
String strwater_pdk_coef = this.HttpContext.Request.Params["water_pdk_coef"] ?? "Empty";;
if (!Helper.FloatTryParse(strwater_pdk_coef, out water_pdk_coef))
{
water_pdk_coef = 0.0f;
}
String water_doc_coef = cd.water_doc_name;
String pdk_doc_coef = cd.ground_doc_name;
EGH01DB.Types.CadastreType cadastre_type = new EGH01DB.Types.CadastreType(id, name, pdk_coef, water_pdk_coef, pdk_doc_coef, water_doc_coef);
if (EGH01DB.Types.CadastreType.Update(db, cadastre_type))
{
view = View("CadastreType", db);
}
}
else if (menuitem.Equals("CadastreType.Update.Cancel"))
{
view = View("CadastreType", db);
}
}
catch (RGEContext.Exception e)
{
ViewBag.msg = e.message;
}
catch (Exception e)
{
ViewBag.msg = e.Message;
}
return(view);
}
public ActionResult ChoiceForecastResult()
{
ViewBag.EGHLayout = "CEQ";
ActionResult rc = View("Index");
try
{
CEQContext db = new CEQContext(this);
CEQViewContext context = CEQViewContext.HandlerChoiceForecast(db, this.HttpContext.Request.Params);
if (context != null && context.RegimChoice == CEQViewContext.REGIM_CHOICE.CHOICE)
{
EGH01DB.RGEContext.Report rgereport = new RGEContext.Report();
if (EGH01DB.RGEContext.Report.GetById(db, (int)context.idforecat, out rgereport))
{
context.report = new EGH01DB.CEQContext.Report(db, rgereport);
rc = View("CEQReport", context.report);
}
}
else if (context != null && context.RegimChoice == CEQViewContext.REGIM_CHOICE.SAVE)
{
rc = View("Index");
XmlNode xn = context.report.toXmlNode();
EGH01DB.Primitives.Report report = new EGH01DB.Primitives.Report(1000, "Р", DateTime.Now, xn);
EGH01DB.Primitives.Report.Create(db, report);
int k = 1;
//XmlNode xn = fvc.ecoforecastx.CreateReport().toXmlNode();
//EGH01DB.Primitives.Report report = new EGH01DB.Primitives.Report(1000, "П", DateTime.Now, xn);
//EGH01DB.Primitives.Report.Create(db, report);
}
else if (context != null && context.RegimChoice == CEQViewContext.REGIM_CHOICE.CANCEL)
{
rc = View("Index");
}
else
{
rc = View(db);
}
}
catch (EGHDBException e)
{
rc = View("Index");
}
catch (Exception e)
{
rc = View("Index");
}
return(rc);
}
public ActionResult Index()
{
ViewBag.EGHLayout = "CEQ";
CEQContext db = null;
try
{
db = new CEQContext(this);
}
catch (RGEContext.Exception e)
{
ViewBag.msg = e.message;
}
finally
{
//if (db != null) db.Disconnect();
}
return(View("Index", db));
}
public static CEQViewContext HandlerEvalutionForecast(CEQContext db, NameValueCollection parms)
{
CEQViewContext rc = db.GetViewContext(VIEWNAME) as CEQViewContext;
if ((rc = db.GetViewContext(VIEWNAME) as CEQViewContext) != null)
{
rc.RegimEvalution = rc.RegimEvalution == REGIM_EVALUTION.CANCEL? REGIM_EVALUTION.INIT: rc.RegimEvalution;
string menuitem = parms["menuitem"];
if (menuitem != null)
{
if (menuitem.Equals("Report.Save"))
{
rc.RegimEvalution = REGIM_EVALUTION.SAVE;
}
else if (menuitem.Equals("Report.Cancel"))
{
rc.RegimEvalution = REGIM_EVALUTION.CANCEL;
}
}
}
return(rc);
}
public ActionResult ReportDelete(int id)
{
CEQContext db = null;
ViewBag.EGHLayout = "CEQ.Report";
ActionResult view = View("Index");
ViewBag.stage = "Р";
string menuitem = this.HttpContext.Request.Params["menuitem"] ?? "Empty";
try
{
db = new CEQContext();
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);
}
public ActionResult EvalutionForecast()
{
ViewBag.EGHLayout = "CEQ";
CEQContext db = null;
ActionResult rc = View("Index");
try
{
db = new CEQContext(this);
rc = View("Index", db);
CEQViewContext context = CEQViewContext.HandlerEvalutionForecast(db, this.HttpContext.Request.Params);
switch (context.RegimEvalution)
{
case CEQViewContext.REGIM_EVALUTION.INIT: rc = View(db); break;
case CEQViewContext.REGIM_EVALUTION.CHOICE: rc = View(db); break;
case CEQViewContext.REGIM_EVALUTION.REPORT: rc = View(db); break;
case CEQViewContext.REGIM_EVALUTION.SAVE: rc = View("Index", db);
CEQContext.ECOEvalution.Create(db, context.ecoevalution, "отладка");
context.RegimEvalution = CEQViewContext.REGIM_EVALUTION.CHOICE;
break;
default: rc = View("Index", db); break;
}
}
catch (EGHDBException e)
{
rc = View("Index", db);
}
catch (Exception e)
{
rc = View("Index", db);
}
return(rc);
}
// GET: EGHCEQController_Report
public ActionResult Report()
{
CEQContext db = null;
ViewBag.EGHLayout = "CEQ.Report";
ActionResult view = View("Index");
ViewBag.stage = "Р";
string menuitem = this.HttpContext.Request.Params["menuitem"] ?? "Empty";
try
{
db = new CEQContext();
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 CadastreType()
{
CEQContext db = null;
ViewBag.EGHLayout = "CEQ.CadastreType";
ActionResult view = View("Index");
string menuitem = this.HttpContext.Request.Params["menuitem"] ?? "Empty";
try
{
db = new CEQContext(this);
ViewBag.msg = "Соединение с базой данных установлено";
view = View("CadastreType", db);
if (menuitem.Equals("CadastreType.Create"))
{
view = View("CadastreTypeCreate");
}
else if (menuitem.Equals("CadastreType.Delete"))
{
string type_code_item = this.HttpContext.Request.Params["type_code"];
if (type_code_item != null)
{
int c = 0;
if (int.TryParse(type_code_item, out c))
{
EGH01DB.Types.CadastreType cd = new EGH01DB.Types.CadastreType();
if (EGH01DB.Types.CadastreType.GetByCode(db, c, out cd))
{
view = View("CadastreTypeDelete", cd);
}
}
}
}
else if (menuitem.Equals("CadastreType.Update"))
{
string type_code_item = this.HttpContext.Request.Params["type_code"];
if (type_code_item != null)
{
int c = 0;
if (int.TryParse(type_code_item, out c))
{
EGH01DB.Types.CadastreType cd = new EGH01DB.Types.CadastreType();
if (EGH01DB.Types.CadastreType.GetByCode(db, c, out cd))
{
view = View("CadastreTypeUpdate", cd);
}
}
}
}
}
catch (RGEContext.Exception e)
{
ViewBag.msg = e.message;
}
catch (Exception e)
{
ViewBag.msg = e.Message;
}
return(view);
}
