private void buttonRemove_Click(object sender, RoutedEventArgs e)
{
int position=listRoutes.SelectedIndex;
listRoutes.Items.RemoveAt(position);
MySQL MySQLHandle = new MySQL(GlobalVar.sqlhost, GlobalVar.sqlport, GlobalVar.sqldatabase, GlobalVar.sqlusername, "");
MySqlConnection sqlWriter = MySQLHandle.Connect();
MySQLHandle.Delete("DELETE FROM `shipping_log_routes` WHERE ID=" + routeids[position].ToString() + ";", sqlWriter);
routeids.RemoveAt(position);
}
private void buttonAdd_Click(object sender, RoutedEventArgs e)
{
string currenttext=textName.Text;
listRoutes.Items.Add(currenttext);
textName.Text = "";
MySQL MySQLHandle = new MySQL(GlobalVar.sqlhost, GlobalVar.sqlport, GlobalVar.sqldatabase, GlobalVar.sqlusername, "");
MySqlConnection sqlWriter = MySQLHandle.Connect();
string insertquery="INSERT INTO `shipping_log_routes` (ID,Route) VALUES(0,'"+currenttext+"');";
long insertid = MySQLHandle.Insert(insertquery,sqlWriter);
routeids.Add((int)insertid);
}
public Window1()
{
InitializeComponent();
routeids = new List<int>();
MySQL MySQLHandle = new MySQL(GlobalVar.sqlhost, GlobalVar.sqlport, GlobalVar.sqldatabase, GlobalVar.sqlusername, "");
MySqlConnection sqlReader = MySQLHandle.Connect();
List<Shipping_Log_Route> shippinglogroutes = MySQLHandle.GetShippingLogRoutes(sqlReader);
for (int i = 0; i < shippinglogroutes.Count; i++)
{
listRoutes.Items.Add(shippinglogroutes[i].name);
routeids.Add(shippinglogroutes[i].ID);
}
}