static public bool Delete(EGH01DB.IDBContext dbcontext, PetrochemicalType petrochemical_type)
{
bool rc = false;
using (SqlCommand cmd = new SqlCommand("EGH.DeletePetrochemicalType", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@КодТипаНефтепродукта", SqlDbType.Int);
parm.Value = petrochemical_type.code_type;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@exitrc", SqlDbType.Int);
parm.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(parm);
}
try
{
cmd.ExecuteNonQuery();
rc = (int)cmd.Parameters["@exitrc"].Value > 0;
}
catch (Exception e)
{
rc = false;
};
}
return(rc);
}
static public bool GetByCode(EGH01DB.IDBContext dbcontext, int type_code, ref PetrochemicalType petrochemical_type)
{
bool rc = false;
petrochemical_type = new PetrochemicalType(type_code);
using (SqlCommand cmd = new SqlCommand("EGH.GetPetrochemicalTypeByCode", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@КодТипаНефтепродукта", SqlDbType.Int);
parm.Value = type_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())
{
string name = (string)reader["НаименованиеТипаНефтепродукта"];
float boilingtemp = (float)reader["ТемператураКипения"];
float density = (float)reader["Плотность"];
float viscosity = (float)reader["КинематическаяВязкость"];
float solubility = (float)reader["Растворимость"];
float tension = (float)reader["КоэфНатяжения"];
float dynamicviscosity = (float)reader["ДинамическаяВязкость"];
float diffusion = (float)reader["КоэфДиффузии"];
int petrochemicalcategories = (int)reader["КодКатегорииНефтепродукта"];
string petrochemicalcategoriesname = (string)reader["НаименованиеКатегорииНефтепродукта"];
PetrochemicalCategories petro_cat = new PetrochemicalCategories(petrochemicalcategories, petrochemicalcategoriesname);
if (rc = (int)cmd.Parameters["@exitrc"].Value > 0)
{
petrochemical_type = new PetrochemicalType(type_code, name,
(float)boilingtemp,
(float)density,
(float)viscosity,
(float)solubility,
(float)tension,
(float)dynamicviscosity,
(float)diffusion,
petro_cat);
}
}
reader.Close();
}
catch (Exception e)
{
rc = false;
};
}
return(rc);
}
static public bool Update(EGH01DB.IDBContext dbcontext, PetrochemicalType petrochemical_type)
{
bool rc = false;
using (SqlCommand cmd = new SqlCommand("EGH.UpdatePetrochemicalType", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@КодТипаНефтепродукта", SqlDbType.Int);
parm.Value = petrochemical_type.code_type;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@НаименованиеТипаНефтепродукта", SqlDbType.VarChar);
parm.Value = petrochemical_type.name;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@ТемператураКипения", SqlDbType.Real);
parm.Value = petrochemical_type.boilingtemp;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@Плотность", SqlDbType.Real);
parm.Value = petrochemical_type.density;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@КинематическаяВязкость", SqlDbType.Real);
parm.Value = petrochemical_type.viscosity;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@Растворимость", SqlDbType.Real);
parm.Value = petrochemical_type.solubility;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@КоэфНатяжения", SqlDbType.Real);
parm.Value = petrochemical_type.tension;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@ДинамическаяВязкость", SqlDbType.Real);
parm.Value = petrochemical_type.dynamicviscosity;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@КоэфДиффузии", SqlDbType.Real);
parm.Value = petrochemical_type.diffusion;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@КодКатегорииНефтепродукта", SqlDbType.Int);
parm.Value = petrochemical_type.petrochemicalcategories.type_code;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@exitrc", SqlDbType.Real);
parm.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(parm);
}
try
{
cmd.ExecuteNonQuery();
rc = (int)cmd.Parameters["@exitrc"].Value > 0;
}
catch (Exception e)
{
rc = false;
};
}
return(rc);
}
public ActionResult PetrochemicalType()
{
CCOContext db = null;
ViewBag.EGHLayout = "CCO";
ActionResult view = View("Index");
string menuitem = this.HttpContext.Request.Params["menuitem"] ?? "Empty";
try
{
db = new CCOContext();
ViewBag.msg = "Соединение с базой данных установлено";
view = View("PetrochemicalType", db);
if (menuitem.Equals("PetrochemicalType.Create"))
{
view = View("PetrochemicalTypeCreate");
}
else if (menuitem.Equals("PetrochemicalType.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))
{
PetrochemicalType pt = new PetrochemicalType();
if (EGH01DB.Types.PetrochemicalType.GetByCode(db, c, ref pt))
{
view = View("PetrochemicalTypeDelete", pt);
}
}
}
}
else if (menuitem.Equals("PetrochemicalType.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.PetrochemicalType pt = new EGH01DB.Types.PetrochemicalType();
if (EGH01DB.Types.PetrochemicalType.GetByCode(db, c, ref pt))
{
view = View("PetrochemicalTypeUpdate", pt);
}
}
}
}
else if (menuitem.Equals("PetrochemicalType.Excel"))
{
EGH01DB.Types.PetrochemicalTypeList list = new PetrochemicalTypeList(db);
XmlNode node = list.toXmlNode();
XmlDocument doc = new XmlDocument();
XmlNode nnode = doc.ImportNode(node, true);
doc.AppendChild(nnode);
doc.Save(Server.MapPath("~/App_Data/PetrochemicalType.xml"));
view = View("Index");
view = File(Server.MapPath("~/App_Data/PetrochemicalType.xml"), "text/plain", "Химический состав нефтей.xml");
}
}
catch (RGEContext.Exception e)
{
ViewBag.msg = e.message;
}
catch (Exception e)
{
ViewBag.msg = e.Message;
}
return(view);
}