public ActionResult PetrochemicalCategoriesDelete(int type_code)
{
CCOContext db = null;
ViewBag.EGHLayout = "CCO.PetrochemicalCategories";
ActionResult view = View("Index");
string menuitem = this.HttpContext.Request.Params["menuitem"] ?? "Empty";
try
{
db = new CCOContext();
if (menuitem.Equals("PetrochemicalCategories.Delete.Delete"))
{
if (EGH01DB.Types.PetrochemicalCategories.DeleteByCode(db, type_code))
{
view = View("PetrochemicalCategories", db);
}
}
else if (menuitem.Equals("PetrochemicalCategories.Delete.Cancel"))
{
view = View("PetrochemicalCategories", db);
}
}
catch (RGEContext.Exception e)
{
ViewBag.msg = e.message;
}
catch (Exception e)
{
ViewBag.msg = e.Message;
}
return(view);
}
public ActionResult PetrochemicalCategoriesCreate(PetrochemicalCategoriesView pcv)
{
CCOContext db = null;
ViewBag.EGHLayout = "CCO.PetrochemicalCategories";
ActionResult view = View("Index");
string menuitem = this.HttpContext.Request.Params["menuitem"] ?? "Empty";
try
{
db = new CCOContext();
view = View("PetrochemicalCategories", db);
if (menuitem.Equals("PetrochemicalCategories.Create.Create"))
{
int id = -1;
if (EGH01DB.Types.PetrochemicalCategories.GetNextCode(db, out id))
{
int type_code = pcv.type_code;
string name = pcv.name;
PetrochemicalCategories pc = new PetrochemicalCategories(type_code, name);
if (EGH01DB.Types.PetrochemicalCategories.Create(db, pc))
{
view = View("PetrochemicalCategories", db);
}
else if (menuitem.Equals("PetrochemicalCategories.Create.Cancel"))
{
view = View("PetrochemicalCategories", db);
}
}
}
else if (menuitem.Equals("PetrochemicalCategories.Create.Cancel"))
{
view = View("PetrochemicalCategories", db);
}
}
catch (RGEContext.Exception e)
{
ViewBag.msg = e.message;
}
catch (Exception e)
{
ViewBag.msg = e.Message;
}
return(view);
}
public ActionResult Index()
{
ViewBag.EGHLayout = "CCO";
CCOContext db = null;
try
{
db = new CCOContext();
ViewBag.msg = "Соединение с базой данных установлено";
}
catch (RGEContext.Exception e)
{
ViewBag.msg = e.message;
}
finally
{
//if (db != null) db.Disconnect();
}
return(View("PetrochemicalType", db));
}
public ActionResult PetrochemicalCategories()
{
CCOContext db = null;
ViewBag.EGHLayout = "CCO.PetrochemicalCategories";
ActionResult view = View("Index");
string menuitem = this.HttpContext.Request.Params["menuitem"] ?? "Empty";
try
{
db = new CCOContext();
ViewBag.msg = "Соединение с базой данных установлено";
view = View("PetrochemicalCategories", db);
if (menuitem.Equals("PetrochemicalCategories.Create"))
{
view = View("PetrochemicalCategoriesCreate");
}
else if (menuitem.Equals("PetrochemicalCategories.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))
{
PetrochemicalCategories pt = new PetrochemicalCategories();
if (EGH01DB.Types.PetrochemicalCategories.GetByCode(db, c, out pt))
{
view = View("PetrochemicalCategoriesDelete", pt);
}
}
}
}
else if (menuitem.Equals("PetrochemicalCategories.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))
{
PetrochemicalCategories pt = new PetrochemicalCategories();
if (EGH01DB.Types.PetrochemicalCategories.GetByCode(db, c, out pt))
{
view = View("PetrochemicalCategoriesUpdate", pt);
}
}
}
}
else if (menuitem.Equals("PetrochemicalCategories.Excel"))
{
EGH01DB.Types.PetrochemicalCategoriesList list = new PetrochemicalCategoriesList(db);
XmlNode node = list.toXmlNode();
XmlDocument doc = new XmlDocument();
XmlNode nnode = doc.ImportNode(node, true);
doc.AppendChild(nnode);
doc.Save(Server.MapPath("~/App_Data/PetrochemicalCategories.xml"));
view = View("Index");
view = File(Server.MapPath("~/App_Data/PetrochemicalCategories.xml"), "text/plain", "Категория нефтепродукта.xml");
}
}
catch (RGEContext.Exception e)
{
ViewBag.msg = e.message;
}
catch (Exception e)
{
ViewBag.msg = e.Message;
}
return(view);
}
public ActionResult PetrochemicalTypeCreate(PetrochemicalTypeView ptv)
{
CCOContext db = null;
ViewBag.EGHLayout = "CCO";
ActionResult view = View("Index");
string menuitem = this.HttpContext.Request.Params["menuitem"] ?? "Empty";
try
{
db = new CCOContext();
view = View("PetrochemicalType", db);
if (menuitem.Equals("PetrochemicalType.Create.Create"))
{
int id = -1;
if (EGH01DB.Types.PetrochemicalType.GetNextCode(db, out id))
{
int type_code = ptv.code_type;
string name = ptv.name;
string strboilingtemp = this.HttpContext.Request.Params["boilingtemp"] ?? "Empty";
float boilingtemp;
Helper.FloatTryParse(strboilingtemp, out boilingtemp);
string strdensity = this.HttpContext.Request.Params["density"] ?? "Empty";
float density;
Helper.FloatTryParse(strdensity, out density);
string strviscosity = this.HttpContext.Request.Params["viscosity"] ?? "Empty";
float viscosity;
Helper.FloatTryParse(strviscosity, out viscosity);
string strsolubility = this.HttpContext.Request.Params["solubility"] ?? "Empty";
float solubility;
Helper.FloatTryParse(strsolubility, out solubility);
string strtension = this.HttpContext.Request.Params["tension"] ?? "Empty";
float tension;
Helper.FloatTryParse(strtension, out tension);
string strdynamicviscosity = this.HttpContext.Request.Params["dynamicviscosity"] ?? "Empty";
float dynamicviscosity;
Helper.FloatTryParse(strdynamicviscosity, out dynamicviscosity);
string strdiffusion = this.HttpContext.Request.Params["diffusion"] ?? "Empty";
float diffusion;
Helper.FloatTryParse(strdiffusion, out diffusion);
int petrochemicalcategories_type_code = ptv.list_PetrochemicalCategories;
PetrochemicalCategories petrochemicalcategories = new PetrochemicalCategories((int)petrochemicalcategories_type_code);
if (EGH01DB.Types.PetrochemicalCategories.GetByCode(db, petrochemicalcategories_type_code, out petrochemicalcategories))
{
PetrochemicalType pt = new PetrochemicalType((int)type_code, (string)name, (float)boilingtemp, (float)density,
(float)viscosity, (float)solubility, (float)tension, (float)dynamicviscosity, (float)diffusion, petrochemicalcategories);
if (EGH01DB.Types.PetrochemicalType.Create(db, pt))
{
view = View("PetrochemicalType", db);
}
}
else if (menuitem.Equals("PetrochemicalType.Create.Cancel"))
{
view = View("PetrochemicalType", db);
}
}
}
else if (menuitem.Equals("PetrochemicalType.Create.Cancel"))
{
view = View("PetrochemicalType", db);
}
}
catch (RGEContext.Exception e)
{
ViewBag.msg = e.message;
}
catch (Exception e)
{
ViewBag.msg = e.Message;
}
return(view);
}
