public string Index2(string node)
{
var arr = node.Split(new char[] { '(', ')' }, StringSplitOptions.RemoveEmptyEntries);
if (arr.Length > 4)
{
DataDA obj = new DataDA();
string center = "";
string latLng = "";
for (int i = 0; i < arr.Length; i++)
{
if (i == arr.Length - 1)
{
center = arr[i];
}
else
{
latLng += i == arr.Length - 2 ? arr[i] : arr[i] + ";";
}
}
obj.Center = center;
obj.LatLng = latLng;
var entities = new MapEntities();
entities.DataDA.AddObject(obj);
entities.SaveChanges();
return("Success!");
}
return("Fail!");
}
private void buttonUredu_Click(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(polyNameBox.Text) && !String.IsNullOrEmpty(polyOpisBox.Text))
{
using (var mapDB = new MapEntities())
{
var poly = mapDB.Supan_Regions.Where(r => r.ID == regionToEdit.ID).FirstOrDefault();
poly.NAZIV_REGIJE = polyNameBox.Text;
poly.OPIS_REGIJE = polyOpisBox.Text;
mapDB.SaveChanges();
}
savingSuccessFull = true;
this.Hide();
}
else
{
MessageBox.Show("Molimo unesite valjanje vrijednosti naziva/opisa poligona!", "Upozorenje", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void buttonUredu_Click(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(placeNameBox.Text) && !String.IsNullOrEmpty(ulicaBox.Text) && !String.IsNullOrEmpty(gradBox.Text) && !String.IsNullOrEmpty(drzavaBox.Text))
{
using (var mapDB = new MapEntities())
{
var place = mapDB.Supan_Places.Where(p => p.PLACE_LAT == placeToEdit.PLACE_LAT && p.PLACE_LNG == placeToEdit.PLACE_LNG).FirstOrDefault();
place.PLACE_NAME = placeNameBox.Text;
place.PLACE_ADDRESS = ulicaBox.Text + zarez + gradBox.Text + zarez + drzavaBox.Text;
place.PLACE_DESCRIPTION = placeOpisBox.Text;
mapDB.SaveChanges();
}
savingSuccessFull = true;
this.Hide();
}
else
{
MessageBox.Show("Molimo unesite vrijednosti naziva/adrese lokacije!", "Upozorenje", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void buttonUredu_Click(object sender, EventArgs e)
{
try
{
using (var mapDB = new MapEntities())
{
var placeAlreadyInDataBase = mapDB.Supan_Places.Where(p => p.PLACE_NAME == place.PLACE_NAME && p.PLACE_ADDRESS == place.PLACE_ADDRESS).FirstOrDefault();
if (placeAlreadyInDataBase != null)
{
MessageBox.Show("Ta lokacija već je zapisana u bazi! Provjerite spremljene lokacije.", "Upozorenje", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
}
else
{
place.PLACE_DESCRIPTION = placeOpisBox.Text;
mapDB.Supan_Places.Add(place);
mapDB.SaveChanges();
MessageBox.Show("Uspješno ste spremili lokaciju.\n Spremljena lokacija nalazi se pod opcijom 'Spremljene lokacije'.", "Upozorenje", MessageBoxButtons.OK, MessageBoxIcon.Information);
savingSuccessfull = true;
}
}
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
this.Hide();
}
private void buttonUredu_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(nazivPoligonaTextBox.Text) || string.IsNullOrWhiteSpace(opisPoligonaTextBox.Text))
{
MessageBox.Show("Molimo unesite valjani naziv/opis.");
}
else
{
try
{
using (var mapDB = new MapEntities())
{
var polyAlreadyInDataBase = mapDB.Supan_Regions.Where(p => p.NAZIV_REGIJE == nazivPoligonaTextBox.Text && p.OPIS_REGIJE == opisPoligonaTextBox.Text).FirstOrDefault();
if (polyAlreadyInDataBase != null)
{
MessageBox.Show("Ta regija već je zapisana u bazi!\n Provjerite spremljene poligone.", "Upozorenje", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
}
else
{
var regionToSave = new Supan_Regions {
NAZIV_REGIJE = nazivPoligonaTextBox.Text, OPIS_REGIJE = opisPoligonaTextBox.Text
};
mapDB.Supan_Regions.Add(regionToSave);
mapDB.SaveChanges();
var regionId = mapDB.Supan_Regions.Where(r => r.NAZIV_REGIJE == regionToSave.NAZIV_REGIJE && r.OPIS_REGIJE == regionToSave.OPIS_REGIJE).Select(r => r.ID).FirstOrDefault();
foreach (var point in polygon.Points)
{
decimal lat = Convert.ToDecimal(point.Lat);
decimal lng = Convert.ToDecimal(point.Lng);
lat = decimal.Round(lat, 6, MidpointRounding.AwayFromZero);
lng = decimal.Round(lng, 6, MidpointRounding.AwayFromZero);
mapDB.Supan_RegionPoints.Add(
new Supan_RegionPoints {
ID_REGIJE = regionId, LAT = lat, LNG = lng
});
}
try
{
mapDB.SaveChanges();
}
catch (Exception)
{
MessageBox.Show("Dogodila se pogreška!'.");
throw;
}
MessageBox.Show("Uspješno ste spremili regiju.\n Spremljeni poligon nalazi se pod opcijom\n 'Spremljene lokacije / poligoni'.", "Upozorenje", MessageBoxButtons.OK, MessageBoxIcon.Information);
savingSuccessfull = true;
this.Hide();
}
}
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
}
}
