static public bool Delete(EGH01DB.IDBContext dbcontext, GroundType ground_type)
{
bool rc = false;
using (SqlCommand cmd = new SqlCommand("EGH.DeleteGroundType", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@КодТипаГрунта", SqlDbType.Int);
parm.Value = ground_type.type_code;
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);
}
public bool GetByCoordinates(float x, float y, EGH01DB.IDBContext dbcontext, out GroundType ground_type) // smw: Coordinates
{
bool rc = false;
ground_type = new GroundType();
using (SqlCommand cmd = new SqlCommand("EGH.InSoilMap", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@point1", SqlDbType.VarChar);
parm.Value = x;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@point2", SqlDbType.VarChar);
parm.Value = y;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@exitrc", SqlDbType.Int);
parm.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(parm);
}
try
{
cmd.ExecuteNonQuery();
string name = (string)cmd.Parameters["@OutName"].Value;
float filtration = (float)cmd.Parameters["@OutFiltration"].Value;
float poristost = (float)cmd.Parameters["@OutPoristost"].Value;
float vlagoemkost = (float)cmd.Parameters["@OutVlagoemkost"].Value;
float gumus_depth = (float)cmd.Parameters["@OutGumusDepth"].Value;
string klass = (string)cmd.Parameters["@OutKlass"].Value;
string soil_type = (string)cmd.Parameters["@OutType"].Value;
ground_type = new GroundType();
rc = (int)cmd.Parameters["@exitrc"].Value > 0;
}
catch (Exception e)
{
rc = false;
};
}
return(rc);
}
public static bool GetByMap(IDBContext db, Coordinates coordinates, out GroundType groundtype)
{
bool rc = false;
groundtype = new GroundType();
string aeration_power;
float average_aeration_power;
float max_aeration_power;
string litology;
if (rc = MapHelper.GetAerationZone(db, coordinates, out aeration_power, out average_aeration_power, out max_aeration_power, out litology))
{
if (!(rc = MapHelper.GetGroundCoef(db, coordinates, out groundtype)))
{
groundtype = GroundType.defaulttype;
}
else
{
groundtype.name = litology;
}
}
return(rc);
}
public ActionResult RiskObjectCreate(EGH01.Models.EGHCAI.RiskObject rs)
{
CAIContext db = null;
ViewBag.EGHLayout = "CAI";
ActionResult view = View("Index");
string menuitem = this.HttpContext.Request.Params["menuitem"] ?? "Empty";
try
{
db = new CAIContext();
view = View("RiskObject", db);
if (menuitem.Equals("RiskObject.Create.Create"))
{
int id = -1;
if (EGH01DB.Objects.RiskObject.GetNextId(db, out id))
{
String ownership = "f";
int numberofrefuel = 1;
int volume = 1;
Boolean watertreatment = rs.watertreatment;
Boolean watertreatmentcollect = rs.watertreatmentcollect;
string base64 = rs.base64;
Byte[] map;
if (base64 == null)
{
map = new byte[0];
}
else
{
map = ASCIIEncoding.ASCII.GetBytes(base64);
}
int groundtank = rs.groundtank;
int undergroundtank = rs.undergroundtank;
string strlat_s = this.HttpContext.Request.Params["lat_s"] ?? "Empty";
string strlng_s = this.HttpContext.Request.Params["lng_s"] ?? "Empty";
string strwaterdeep = this.HttpContext.Request.Params["waterdeep"] ?? "Empty";
string strheight = this.HttpContext.Request.Params["height"] ?? "Empty";
float lat_s = 0.0f;
float lng_s = 0.0f;
float waterdeep = 0.0f;
float height = 0.0f;
if (!Helper.FloatTryParse(strlat_s, out lat_s))
{
lat_s = 0.0f;
}
if (!Helper.FloatTryParse(strlng_s, out lng_s))
{
lng_s = 0.0f;
}
if (!Helper.FloatTryParse(strwaterdeep, out waterdeep))
{
waterdeep = 0.0f;
}
if (!Helper.FloatTryParse(strheight, out height))
{
height = 0.0f;
}
Coordinates coordinates = new Coordinates(rs.latitude, rs.lat_m, lat_s, rs.lngitude, rs.lng_m, lng_s);
float latitude = EGH01DB.Primitives.Coordinates.dms_to_d(rs.latitude, rs.lat_m, rs.lat_s);
EGH01DB.Types.GroundType ground_type = new EGH01DB.Types.GroundType();
if (EGH01DB.Types.GroundType.GetByCode(db, rs.list_groundType, out ground_type))
{
Point point = new Point(coordinates, ground_type, waterdeep, height);
EGH01DB.Types.RiskObjectType risk_object_type = new EGH01DB.Types.RiskObjectType();
if (EGH01DB.Types.RiskObjectType.GetByCode(db, rs.selectlist, out risk_object_type))
{
EGH01DB.Types.CadastreType cadastre_type = new EGH01DB.Types.CadastreType();
if (EGH01DB.Types.CadastreType.GetByCode(db, rs.list_cadastre, out cadastre_type))
{
EGH01DB.Types.District district = new EGH01DB.Types.District();
if (EGH01DB.Types.District.GetByCode(db, rs.list_district, out district))
{
EGH01DB.Types.Region region = new EGH01DB.Types.Region();
if (EGH01DB.Types.Region.GetByCode(db, rs.list_region, out region))
{
DateTime foundationdate = rs.foundationdate;
if (foundationdate.Year == 0001)
{
foundationdate = new DateTime(1900, 01, 01);
}
DateTime reconstractiondate = rs.reconstractiondate;
if (reconstractiondate.Year == 0001)
{
reconstractiondate = new DateTime(1900, 01, 01);
}
string name = rs.name;
String phone = rs.phone;
String fax = rs.fax;
string address = rs.adress;
String email = rs.email;
String fueltype = rs.fax;
String geodescription = rs.fax;
EGH01DB.Objects.RiskObject risk_object = new EGH01DB.Objects.RiskObject(id, point, risk_object_type, cadastre_type, name,
district, region, address, ownership, phone, fax, email, foundationdate, reconstractiondate, numberofrefuel, volume, watertreatment,
watertreatmentcollect, map, groundtank, undergroundtank, fueltype, 0, 0.0f, 0.0f, geodescription);
if (EGH01DB.Objects.RiskObject.Create(db, risk_object))
{
view = View("RiskObject", db);
}
}
}
}
}
else if (menuitem.Equals("RiskObject.Create.Cancel"))
{
view = View("RiskObject", db);
}
}
}
}
}
catch (RGEContext.Exception e)
{
ViewBag.msg = e.message;
}
catch (Exception e)
{
ViewBag.msg = e.Message;
}
return(view);
}
public ActionResult SpreadingCoefficientCreate(SpreadingCoefficientView scv)
{
RGEContext db = null;
ViewBag.EGHLayout = "RGE.SpreadingCoefficient";
ActionResult view = View("Index");
string menuitem = this.HttpContext.Request.Params["menuitem"] ?? "Empty";
try
{
db = new RGEContext();
view = View("SpreadingCoefficient", db);
if (menuitem.Equals("SpreadingCoefficient.Create.Create"))
{
EGH01DB.Types.GroundType type_groud = new EGH01DB.Types.GroundType();
if (EGH01DB.Types.GroundType.GetByCode(db, scv.list_groundType, out type_groud))
{
EGH01DB.Types.PetrochemicalType petrochemical_type = new PetrochemicalType();
if (EGH01DB.Types.PetrochemicalType.GetByCode(db, scv.list_petrochemicalType, ref petrochemical_type))
{
int code = scv.code;
string strmin_angle = this.HttpContext.Request.Params["min_angle"] ?? "Empty";
float min_angle;
Helper.FloatTryParse(strmin_angle, out min_angle);
string strmax_angle = this.HttpContext.Request.Params["max_angle"] ?? "Empty";
float max_angle;
Helper.FloatTryParse(strmax_angle, out max_angle);
string strmin_volume = this.HttpContext.Request.Params["min_volume"] ?? "Empty";
float min_volume;
Helper.FloatTryParse(strmin_volume, out min_volume);
string strmax_volume = this.HttpContext.Request.Params["max_volume"] ?? "Empty";
float max_volume;
Helper.FloatTryParse(strmax_volume, out max_volume);
string strkoef = this.HttpContext.Request.Params["koef"] ?? "Empty";
float koef;
Helper.FloatTryParse(strkoef, out koef);
SpreadingCoefficient sc = new EGH01DB.Primitives.SpreadingCoefficient((int)code, type_groud, petrochemical_type, (float)min_volume, (float)max_volume, (float)min_angle, (float)max_angle, (float)koef);
// исправить тип нефтепродукта
//koef = EGH01DB.Primitives.SpreadingCoefficient.Get(db, sc);
//sc = new EGH01DB.Primitives.SpreadingCoefficient((int)code, type_groud, (float)min_volume, (float)max_volume, (float)min_angle, (float)max_angle, (float)koef);
if (EGH01DB.Primitives.SpreadingCoefficient.Create(db, sc))
{
view = View("SpreadingCoefficient", db);
}
else if (menuitem.Equals("SpreadingCoefficient.Create.Cancel"))
{
view = View("SpreadingCoefficient", db);
}
}
else if (menuitem.Equals("SpreadingCoefficient.Create.Cancel"))
{
view = View("SpreadingCoefficient", db);
}
}
}
}
catch (RGEContext.Exception e)
{
ViewBag.msg = e.message;
}
catch (Exception e)
{
ViewBag.msg = e.Message;
}
return(view);
}
static public bool Update(EGH01DB.IDBContext dbcontext, GroundType ground_type)
{
bool rc = false;
using (SqlCommand cmd = new SqlCommand("EGH.UpdateGroundType", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@КодТипаГрунта", SqlDbType.Int);
parm.Value = ground_type.type_code;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@НаименованиеТипаГрунта", SqlDbType.VarChar);
parm.Value = ground_type.name;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@КоэфПористости", SqlDbType.Real);
parm.Value = ground_type.porosity;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@КоэфЗадержкиМиграции", SqlDbType.Real);
parm.Value = ground_type.holdmigration;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@КоэфФильтрацииВоды", SqlDbType.Real);
parm.Value = ground_type.waterfilter;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@КоэфДиффузии", SqlDbType.Real);
parm.Value = ground_type.diffusion;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@КоэфРаспределения", SqlDbType.Real);
parm.Value = ground_type.distribution;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@КоэфСорбции", SqlDbType.Real);
parm.Value = ground_type.sorption;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@КоэфКапВлагоемкости", SqlDbType.Real);
parm.Value = ground_type.watercapacity;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@ВлажностьГрунта", SqlDbType.Real);
parm.Value = ground_type.soilmoisture;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@КоэфАверьянова", SqlDbType.Real);
parm.Value = ground_type.аveryanovfactor;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@Водопроницаемость", SqlDbType.Real);
parm.Value = ground_type.permeability;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@СредняяПлотностьГрунта", SqlDbType.Real);
parm.Value = ground_type.density;
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, out GroundType ground_type)
{
bool rc = false;
ground_type = new GroundType();
using (SqlCommand cmd = new SqlCommand("EGH.GetGroundTypeByCode", 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 porosity = (float)reader["КоэфПористости"];
float holmigration = (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["СредняяПлотностьГрунта"];
if (rc = (int)cmd.Parameters["@exitrc"].Value > 0)
{
ground_type = new GroundType((int)type_code,
(string)name,
(float)porosity,
(float)holmigration,
(float)waterfilter,
(float)diffusion,
(float)distribution,
(float)sorption,
(float)watercapacity,
(float)soilmoisture,
(float)аveryanovfactor,
(float)permeability,
(float)density);
}
}
reader.Close();
}
catch (Exception e)
{
rc = false;
};
}
return(rc);
}
public ActionResult EcoObjectCreate(EGH01.Models.EGHRGE.EcoObjectView eo)
{
RGEContext db = null;
ViewBag.EGHLayout = "RGE.EcoObject";
ActionResult view = View("Index");
string menuitem = this.HttpContext.Request.Params["menuitem"] ?? "Empty";
try
{
db = new RGEContext();
view = View("EcoObject", db);
if (menuitem.Equals("EcoObjectCreateEco.Create"))
{
view = View("EcoObjectCreateEco");
return(view);
}
if (menuitem.Equals("EcoObject.Create.Create"))
{
int id = -1;
if (EGH01DB.Objects.EcoObject.GetNextId(db, out id))
{
String name = eo.name;
CadastreType type_cadastre = new CadastreType();
if (EGH01DB.Types.CadastreType.GetByCode(db, eo.list_cadastre, out type_cadastre))
{
EcoObjectType eco_type = new EcoObjectType();
if (EGH01DB.Types.EcoObjectType.GetByCode(db, eo.list_ecoType, out eco_type))
{
bool iswaterobject = eo.iswaterobject;
string strlat_s = this.HttpContext.Request.Params["lat_s"] ?? "Empty";
string strlng_s = this.HttpContext.Request.Params["lng_s"] ?? "Empty";
string strwaterdeep = this.HttpContext.Request.Params["waterdeep"] ?? "Empty";
string strheight = this.HttpContext.Request.Params["height"] ?? "Empty";
float lat_s = 0.0f;
float lng_s = 0.0f;
float waterdeep = 0.0f;
float height = 0.0f;
if (!Helper.FloatTryParse(strlat_s, out lat_s))
{
lat_s = 0.0f;
}
if (!Helper.FloatTryParse(strlng_s, out lng_s))
{
lng_s = 0.0f;
}
if (!Helper.FloatTryParse(strwaterdeep, out waterdeep))
{
waterdeep = 0.0f;
}
if (!Helper.FloatTryParse(strheight, out height))
{
height = 0.0f;
}
Coordinates coordinates = new Coordinates(eo.latitude, eo.lat_m, lat_s, eo.lngitude, eo.lng_m, lng_s);
EGH01DB.Types.GroundType ground_type = new EGH01DB.Types.GroundType();
if (EGH01DB.Types.GroundType.GetByCode(db, eo.list_groundType, out ground_type))
{
Point point = new Point(coordinates, ground_type, waterdeep, height);
EGH01DB.Objects.EcoObject eco_object = new EGH01DB.Objects.EcoObject(id, point, eco_type, type_cadastre, name, iswaterobject);
if (EGH01DB.Objects.EcoObject.Create(db, eco_object))
{
view = View("EcoObject", db);
}
}
}
}
else if (menuitem.Equals("EcoObject.Create.Cancel"))
{
view = View("EcoObject", db);
}
}
}
}
catch (RGEContext.Exception e)
{
ViewBag.msg = e.message;
}
catch (Exception e)
{
ViewBag.msg = e.Message;
}
return(view);
}
public ActionResult GroundTypeCreate(EGH01.Models.EGHRGE.GroundTypeView gt)
{
RGEContext db = null;
ViewBag.EGHLayout = "RGE.GroundType";
ActionResult view = View("Index");
string menuitem = this.HttpContext.Request.Params["menuitem"] ?? "Empty";
try
{
db = new RGEContext(this);
if (!GroundTypeView.Handler(db, this.HttpContext.Request.Params))
{
}
view = View(db);
if (menuitem.Equals("GroundType.Create.Create"))
{
GroundTypeView viewcontext = db.GetViewContext(GroundTypeView.VIEWNAME) as GroundTypeView;
if (viewcontext != null)
{
int type_code = -1;
float diffusion;
string strdiffusion = this.HttpContext.Request.Params["diffusion"] ?? "Empty";
if (!Helper.FloatTryParse(strdiffusion, out diffusion))
{
diffusion = 0.0f;
}
float distribution;
string strdistribution = this.HttpContext.Request.Params["distribution"] ?? "Empty";
if (!Helper.FloatTryParse(strdistribution, out distribution))
{
distribution = 0.0f;
}
float sorption = 0.0f;
string strsorption = this.HttpContext.Request.Params["sorption"] ?? "Empty";
if (!Helper.FloatTryParse(strsorption, out sorption))
{
sorption = 0.0f;
}
float permeability = 0.2f;
string strpermeability = this.HttpContext.Request.Params["permeability"] ?? "Empty";
if (!Helper.FloatTryParse(strpermeability, out permeability))
{
permeability = 0.0f;
}
String name = gt.name;
string strporosity = this.HttpContext.Request.Params["porosity"] ?? "Empty";
float porosity = 0.1f;
if (!Helper.FloatTryParse(strporosity, out porosity))
{
porosity = 0.0f;
}
string strsoilmoisture = this.HttpContext.Request.Params["soilmoisture"] ?? "Empty";
float soilmoisture = 0.1f;//влажность
if (!Helper.FloatTryParse(strsoilmoisture, out soilmoisture))
{
soilmoisture = 0.0f;
}
string strwatercapacity = this.HttpContext.Request.Params["watercapacity"] ?? "Empty";
float watercapacity = 0.1f;//влагоемкость
if (!Helper.FloatTryParse(strwatercapacity, out watercapacity))
{
watercapacity = 0.0f;
}
string strholdmigration = this.HttpContext.Request.Params["holdmigration"] ?? "Empty";
float holdmigration = 0.1f;//задержки
if (!Helper.FloatTryParse(strholdmigration, out holdmigration))
{
holdmigration = 0.0f;
}
string strwaterfilter = this.HttpContext.Request.Params["waterfilter"] ?? "Empty";
float waterfilter = 0.1f;//фильтрации
if (!Helper.FloatTryParse(strwaterfilter, out waterfilter))
{
waterfilter = 0.0f;
}
string strаveryanovfactor = this.HttpContext.Request.Params["аveryanovfactor"] ?? "Empty";
float аveryanovfactor = 0.1f;//аверьянова коэф
if (!Helper.FloatTryParse(strаveryanovfactor, out аveryanovfactor))
{
аveryanovfactor = 0.0f;
}
string strdensity = this.HttpContext.Request.Params["density"] ?? "Empty";
float density = 0.1f;
if (!Helper.FloatTryParse(strdensity, out density))
{
density = 0.0f;
}
if ((watercapacity < porosity) && (soilmoisture >= watercapacity) && (soilmoisture <= porosity))
{
EGH01DB.Types.GroundType ground_type = new EGH01DB.Types.GroundType(type_code, name, porosity, holdmigration, waterfilter, diffusion, distribution, sorption, watercapacity, soilmoisture, аveryanovfactor, permeability, density);
if (EGH01DB.Types.GroundType.Create(db, ground_type))
{
view = View("GroundType", db);
}
}
else
{
GroundTypeView viewcontexts = db.GetViewContext("GroundTypeCreate") as GroundTypeView;
ViewBag.Error = "Проверьте введенные данные";
view = View("GroundTypeCreate", db);
return(view);
}
}
}
if (menuitem.Equals("GroundType.Create.Cancel"))
{
view = View("GroundType", db);
}
}
catch (RGEContext.Exception e)
{
ViewBag.msg = e.message;
}
catch (Exception e)
{
ViewBag.msg = e.Message;
}
return(view);
}
public ActionResult GroundType()
{
RGEContext db = null;
ViewBag.EGHLayout = "RGE.GroundType";
ActionResult view = View("Index");
string menuitem = this.HttpContext.Request.Params["menuitem"] ?? "Empty";
try
{
db = new RGEContext(this);
ViewBag.msg = "Соединение с базой данных установлено";
// view = View("GroundType", db);
view = View(db);
if (menuitem.Equals("GroundType.Create"))
{
view = View("GroundTypeCreate");
}
else if (menuitem.Equals("GroundType.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))
{
EGH01DB.Types.GroundType gt = new EGH01DB.Types.GroundType();
if (EGH01DB.Types.GroundType.GetByCode(db, c, out gt))
{
view = View("GroundTypeDelete", gt);
}
}
}
}
else if (menuitem.Equals("GroundType.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.GroundType gt = new EGH01DB.Types.GroundType();
if (EGH01DB.Types.GroundType.GetByCode(db, c, out gt))
{
view = View("GroundTypeUpdate", gt);
}
}
}
}
else if (menuitem.Equals("GroundType.Excel"))
{
EGH01DB.Types.GroundTypeList list = new EGH01DB.Types.GroundTypeList(db);
XmlNode node = list.toXmlNode();
XmlDocument doc = new XmlDocument();
XmlNode nnode = doc.ImportNode(node, true);
doc.AppendChild(nnode);
doc.Save(Server.MapPath("~/App_Data/GroundType.xml"));
view = View("Index");
view = File(Server.MapPath("~/App_Data/GroundType.xml"), "text/plain", "Типы грунтов.xml");
}
}
catch (RGEContext.Exception e)
{
ViewBag.msg = e.message;
}
catch (Exception e)
{
ViewBag.msg = e.Message;
}
return(view);
}
public ActionResult AnchorPointCreatePoint(AnchorPointView ah)
{
RGEContext db = null;
ViewBag.EGHLayout = "RGE.AnchorPoint";
ActionResult view = View("Index");
string menuitem = this.HttpContext.Request.Params["menuitem"] ?? "Empty";
try
{
db = new RGEContext();
view = View("AnchorPoint", db);
if (menuitem.Equals("AnchorPointCreate.Create.Create"))
{
int id = -1;
if (EGH01DB.Points.AnchorPoint.GetNextId(db, out id))
{
float lat_s = 0.0f;
string strlat_s = this.HttpContext.Request.Params["lat_s"] ?? "Empty";
if (!Helper.FloatTryParse(strlat_s, out lat_s))
{
lat_s = 0.0f;
}
float angel = 0.0f;
string strangel = this.HttpContext.Request.Params["angel"] ?? "Empty";
if (!Helper.FloatTryParse(strangel, out angel))
{
angel = 0.0f;
}
float distance = 0.0f;
string strdistance = this.HttpContext.Request.Params["distance"] ?? "Empty";
if (!Helper.FloatTryParse(strdistance, out distance))
{
distance = 0.0f;
}
float lng_s = 0.0f;
string strlng_s = this.HttpContext.Request.Params["lng_s"] ?? "Empty";
if (!Helper.FloatTryParse(strlng_s, out lng_s))
{
lng_s = 0.0f;
}
Coordinates coordinates = new Coordinates(ah.Lat_d, ah.lat_m, lat_s, ah.lngitude, ah.lng_m, lng_s);
float waterdeep = 0.0f;
int list_cadastre = ah.list_cadastre;
float height = 0.0f;
string strheight = this.HttpContext.Request.Params["height"] ?? "Empty";
if (!Helper.FloatTryParse(strheight, out height))
{
height = 0.0f;
}
string strwaterdeep = this.HttpContext.Request.Params["waterdeep"] ?? "Empty";
if (!Helper.FloatTryParse(strwaterdeep, out waterdeep))
{
waterdeep = 0.0f;
}
EGH01DB.Types.GroundType ground_type = new EGH01DB.Types.GroundType();
if (EGH01DB.Types.GroundType.GetByCode(db, ah.list_groundType, out ground_type))
{
Point point = new Point(coordinates, ground_type, waterdeep, height);
CadastreType type_cadastre = new CadastreType();
if (EGH01DB.Types.CadastreType.GetByCode(db, ah.list_cadastre, out type_cadastre))
{
EGH01DB.Points.AnchorPoint anchor_point = new EGH01DB.Points.AnchorPoint(id, point, type_cadastre);
if (EGH01DB.Points.AnchorPoint.Create(db, anchor_point, angel, distance))
{
view = View("AnchorPoint", db);
}
else if (menuitem.Equals("AnchorPoint.Create.Cancel"))
{
view = View("AnchorPoint", db);
}
{
}
}
}
}
}
}
catch (RGEContext.Exception e)
{
ViewBag.msg = e.message;
}
catch (Exception e)
{
ViewBag.msg = e.Message;
}
return(view);
}
