private void AddPointClick(object sender, RoutedEventArgs e)
{
string korp = "0";
if (City.Text == null || Street.Text == "" || House.Text == "")
{
System.Windows.MessageBox.Show("Не все обязательные значения введены");
}
else
{
//pointRN = (int)wayNumber.Value; // получаем введенное значение
//if (pointNumber < db.FindLastPoint(wayVal + 1, interVal) + 1)
// db.Shift(wayVal + 1, interVal, pointNumber);
if (Corpes.Text != "")
{
korp = Corpes.Text;
}
var orderNumber = Order.Text;
var house = House.Text;
var city = City.Text;
var street = Street.Text;
var interval = interVal;
var number = 0; //заглушка?
//Если номер больше 0, то вызываем метод сдвига
if (wayNumber.Value > 0)
{
//Метод возвращает (утверждает) номер точки, осуществляя по необходимости сдвиг
pointRN = GUI.PointRN.NumberInsert((int)wayNumber.Value, db.GetRoutsBySession(sessionID), db.getPointBySession(sessionID), wayVal);
}
//если равен или меньше то ставим в конец
else
{
DBWork db = new DBWork();
pointRN = GUI.PointRN.FirstNumber(db.GetRoutsBySession(sessionID), db.getPointBySession(sessionID), wayVal);
}
db.InsertPoint(orderNumber, city, street, house, korp, interval, number, pointRN, sessionID, wayVal);
DataChangedEventHandler handler = DataChanged;
if (handler != null)
{
handler(this, new EventArgs());
}
this.Close();
}
}
private void Save_Click(object sender, RoutedEventArgs e)
{
var route = wayVal;
var interval = interVal;
var number = 0; //заглушка?
string comment = Comment.Text;
addr_street = tB_Addr_street.Text;
addr_house = tB_Addr_house.Text;
addr_korp = tB_Addr_korp.Text;
order = tB_order.Text;
if ((addr_street == "") || (addr_house == "") || (order == ""))
{
MessageBox.Show("Введите улицу/дом/номер заказа");
}
//Если номер точки изменился используем метод перестроения ряда
if (wayNumber.Value != pointRN & wayNumber.Value > 0)
{
try
{
//Вызов метода сдвига точек при изменении номера
pointRN = GUI.PointRN.NumberMove((int)wayNumber.Value, pointRN, db.GetRoutsBySession(sessionID), db.getPointBySession(sessionID), wayVal);
}
catch (Exception)
{
MessageBox.Show("Неверный ввод номера точки в маршруте");
return;
}
}
db.ChangePoint(point.ID_Point, route, interval, number, pointRN, sessionID, comment, addr_street, addr_house, addr_korp, order);
GUI.PointRN.SpaceChecking(db.GetRoutsBySession(sessionID), db.getPointBySession(sessionID), wayVal);
var Data = db.getPointBySession(sessionID);
db.ChangePoint(point.ID_Point, route, interval, number, pointRN, sessionID, comment, addr_street, addr_house, addr_korp, order);
DataChangedEventHandler handler = DataChanged;
if (handler != null)
{
handler(this, new EventArgs());
}
this.Close();
}
private void ComboBox_Loaded(object sender, RoutedEventArgs e)
{
ComboBox comboBox = sender as ComboBox;
var routes = db.GetRoutsBySession(sesID);
List <int> routeValues = new List <int>();
foreach (var route in routes)
{
routeValues.Add(route.RouteNumber);
}
comboBox.ItemsSource = routeValues;
comboBox.SelectedIndex = 0;
}
public void setRoutes()
{
db = new DBWork();
Routes = new ObservableCollection <newRoute> {
};
var Data = db.getPointBySession(sessionId);
var sizeData = Data.Count;
string dataPoint = "";
var dbRoutes = db.GetRoutsBySession(sessionId);
foreach (var item in dbRoutes)
{
if (item.RouteNumber == routeId)
{
List <NewPoints> pointSet1 = new List <NewPoints>();
List <NewPoints> pointSet2 = new List <NewPoints>();
List <NewPoints> pointSet3 = new List <NewPoints>();
List <NewPoints> pointSet4 = new List <NewPoints>();
List <NewPoints> pointSet5 = new List <NewPoints>();
for (var k = 0; k < sizeData; k++)
{
var elem = Data[k];
var city = elem.City;
var street = elem.Street;
var house = elem.House + "";
var korp = elem.Korp + "";
var interval = elem.Interval;
var route = elem.ID_Route;
var pointID = elem.ID_Point;
if (route == item.ID_Route)
{
string streetAndHouse;
if ((korp == "") || (korp == "0"))
{
streetAndHouse = "ул. " + street + ", " + house;
dataPoint = " #1" + ": " + streetAndHouse;
}
else
{
streetAndHouse = "ул. " + street + ", " + house + " к" + korp;
dataPoint = " #1" + ": " + streetAndHouse;
}
var newPoint = new NewPoints
{
pointId = elem.ID_Point,
pointText = dataPoint,
Order = elem.OrderNumber,
Address = city + ", " + streetAndHouse
};
switch (interval)
{
case ("с 9:00 до 12:00"):
pointSet1.Add(newPoint);
break;
case ("с 12:00 до 15:00"):
pointSet2.Add(newPoint);
break;
case ("с 15:00 до 18:00"):
pointSet3.Add(newPoint);
break;
case ("с 18:00 до 21:00"):
pointSet4.Add(newPoint);
break;
case ("с 9:00 до 21:00"):
pointSet5.Add(newPoint);
break;
}
}
}
if (item.RouteNumber == 0)
{
Routes.Add(new newRoute
{
routeText = "Без маршрута",
point1 = pointSet1,
point2 = pointSet2,
point3 = pointSet3,
point4 = pointSet4,
point5 = pointSet5,
GUIroute = item,
RouteColor = item.Color
});
}
else
{
Routes.Add(new newRoute
{
routeText = "Маршрут " + item.RouteNumber,
point1 = pointSet1,
point2 = pointSet2,
point3 = pointSet3,
point4 = pointSet4,
point5 = pointSet5,
GUIroute = item,
RouteColor = item.Color
});
}
}
}
routesList.ItemsSource = Routes;
}
