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