public static void UpdateSchedule(UpdateSchedule u)
{
using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString()))
{
cnn.Execute("update Schedule set client = @client where date = @date", u);
}
}
private void makeOrderButton_Click(object sender, EventArgs e)
{
int help = 0;
Order newOrder = new Order();
UpdateSchedule us = new UpdateSchedule();
if (Convert.ToString(comboDate.SelectedItem) == "" || Convert.ToString(comboJumpType.SelectedItem) == "")
{
MessageBox.Show("Please check if all data is correct");
}
else if (couponNumber.Text != "")
{
for (int i = 0; i < coupones.Count; i++)
{
if (coupones[i].code == couponNumber.Text)
{
newOrder.coupon = coupones[i].ID;
i = coupones.Count + 1;
help = 1;
}
}
if (help == 0)
{
MessageBox.Show("You entered wrong code. Please try again!");
}
else
{
if (comboEquipment.SelectedIndex != -1)
{
newOrder.equipment = comboEquipment.SelectedIndex;
}
newOrder.peopleNumber = Convert.ToInt32(peopleNUpDown.Value);
newOrder.ID = orders.Count;
newOrder.admin = 0;
newOrder.schedule = comboDate.SelectedIndex;
newOrder.jumpType = comboJumpType.SelectedIndex;
newOrder.status = "Confirming";
us.client = State.ActiveClient.ID;
us.date = (string)comboDate.SelectedItem;
for (int j = 0; j < additionalJumpers2.Count; j++)
{
DataBase.SaveAdditionalJumpers(additionalJumpers2[j]);
}
DataBase.UpdateSchedule(us);
DataBase.SaveOrder(newOrder);
UpdateData();
MessageBox.Show("Your order has been saved");
comboDate.Text = "";
comboEquipment.Text = "";
comboJumpType.Text = "";
couponNumber.Text = "";
peopleNUpDown.Value = 0;
addJumperHelper2 = 0;
addJumperHelper = additionalJumpers.Count;
additionalJumpers2.Clear();
}
}
else
{
if (comboEquipment.SelectedIndex != -1)
{
newOrder.equipment = comboEquipment.SelectedIndex;
}
newOrder.peopleNumber = Convert.ToInt32(peopleNUpDown.Value);
newOrder.ID = orders.Count;
newOrder.admin = 0;
newOrder.schedule = comboDate.SelectedIndex;
newOrder.jumpType = comboJumpType.SelectedIndex;
newOrder.status = "Confirming";
us.client = State.ActiveClient.ID;
us.date = (string)comboDate.SelectedItem;
for (int j = 0; j < additionalJumpers2.Count; j++)
{
DataBase.SaveAdditionalJumpers(additionalJumpers2[j]);
}
DataBase.UpdateSchedule(us);
DataBase.SaveOrder(newOrder);
UpdateData();
MessageBox.Show("Your order has been saved");
comboDate.Text = "";
comboEquipment.Text = "";
comboJumpType.Text = "";
couponNumber.Text = "";
peopleNUpDown.Value = 0;
addJumperHelper2 = 0;
addJumperHelper = additionalJumpers.Count;
additionalJumpers2.Clear();
}
}