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); }