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 static bool GetByCode(EGH01DB.IDBContext dbcontext, int code, out SpreadingCoefficient spreading_coefficient) { bool rc = false; spreading_coefficient = new SpreadingCoefficient(); using (SqlCommand cmd = new SqlCommand("EGH.GetSpreadingCoefficientByCode", dbcontext.connection)) { cmd.CommandType = CommandType.StoredProcedure; { SqlParameter parm = new SqlParameter("@КодКоэффициентаРазлива", SqlDbType.Int); parm.Value = code; cmd.Parameters.Add(parm); } { SqlParameter parm = new SqlParameter("@exitrc", SqlDbType.Int); parm.Direction = ParameterDirection.ReturnValue; cmd.Parameters.Add(parm); } try { cmd.ExecuteNonQuery(); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { int ground_type_code = (int)reader["ТипГрунта"]; string ground_type_name = (string)reader["НаименованиеТипаГрунта"]; float porosity = (float)reader["КоэфПористости"]; float holdmigration = (float)reader["КоэфЗадержкиМиграции"]; float waterfilter = (float)reader["КоэфФильтрацииВоды"]; float diffusion = (float)reader["КоэфДиффузииГрунта"]; float distribution = (float)reader["КоэфРаспределения"]; float sorption = (float)reader["КоэфСорбции"]; float watercapacity = (float)reader["КоэфКапВлагоемкости"]; float soilmoisture = (float)reader["ВлажностьГрунта"]; float аveryanovfactor = (float)reader["КоэфАверьянова"]; float permeability = (float)reader["Водопроницаемость"]; float density = (float)reader["СредняяПлотностьГрунта"]; GroundType ground_type = new GroundType((int)ground_type_code, (string)ground_type_name, (float)porosity, (float)holdmigration, (float)waterfilter, (float)diffusion, (float)distribution, (float)sorption, (float)watercapacity, (float)soilmoisture, (float)аveryanovfactor, (float)permeability, (float)density); int petrochemical_type_code = (int)reader["КодТипаНефтепродукта"]; string name = (string)reader["НаименованиеТипаНефтепродукта"]; float boilingtemp = (float)reader["ТемператураКипения"]; float petrochemical_density = (float)reader["Плотность"]; float viscosity = (float)reader["КинематическаяВязкость"]; float solubility = (float)reader["Растворимость"]; float tension = (float)reader["КоэфНатяжения"]; float dynamicviscosity = (float)reader["ДинамическаяВязкость"]; float petrochemical_diffusion = (float)reader["КоэфДиффузииНП"]; int petrochemicalcategories = (int)reader["КодКатегорииНефтепродукта"]; string petrochemicalcategoriesname = (string)reader["НаименованиеКатегорииНефтепродукта"]; PetrochemicalCategories petro_cat = new PetrochemicalCategories(petrochemicalcategories, petrochemicalcategoriesname); PetrochemicalType petrochemical_type = new PetrochemicalType(petrochemical_type_code, name, (float)boilingtemp, (float)petrochemical_density, (float)viscosity, (float)solubility, (float)tension, (float)dynamicviscosity, (float)petrochemical_diffusion, petro_cat); float min_volume = (float)reader["МинПролива"]; float max_volume = (float)reader["МаксПролива"]; float min_angle = (float)reader["МинУклона"]; float max_angle = (float)reader["МаксУклона"]; double koef = (double)reader["КоэффициентРазлива"]; if (rc = (int)cmd.Parameters["@exitrc"].Value > 0) { spreading_coefficient = new SpreadingCoefficient(code, ground_type, petrochemical_type, (float)min_volume, (float)max_volume, (float)min_angle, (float)max_angle, (float)koef); } } reader.Close(); } catch (Exception e) { rc = false; }; } return(rc); }
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); }