private void btn_Delete_Click(object sender, EventArgs e)
{
if (tabControl.SelectedIndex == 0)
{
int n = dGV_Orders.CurrentRow.Index;
Orders o = new Orders();
o.id_order = Convert.ToInt32(dGV_Orders.Rows[n].Cells[2].Value.ToString());
o.number_red_duck = Convert.ToInt32(dGV_Orders.Rows[n].Cells[5].Value.ToString());
o.number_green_duck = Convert.ToInt32(dGV_Orders.Rows[n].Cells[4].Value.ToString());
o.number_black_duck = Convert.ToInt32(dGV_Orders.Rows[n].Cells[3].Value.ToString());
OrderDuck od = new OrderDuck();
od.id_order = Convert.ToInt32(dGV_Orders.Rows[n].Cells[2].Value.ToString());
Ducks d = new Ducks();
Service1Client service = new Service1Client();
if (o.number_red_duck > 0)
{
d.id_duck = 1;
d.number_in_stock = service.GetDucksInStock(d) + o.number_red_duck;
d.number_leased = service.GetDucksLeased(d) - o.number_red_duck;
service.UpdateDuck(d);
}
if (o.number_green_duck > 0)
{
d.id_duck = 2;
d.number_in_stock = service.GetDucksInStock(d) + o.number_green_duck;
d.number_leased = service.GetDucksLeased(d) - o.number_green_duck;
service.UpdateDuck(d);
}
if (o.number_black_duck > 0)
{
d.id_duck = 3;
d.number_in_stock = service.GetDucksInStock(d) + o.number_black_duck;
d.number_leased = service.GetDucksLeased(d) - o.number_black_duck;
service.UpdateDuck(d);
}
service.DeleteOrderDuck(od);
service.DeleteOrder(o);
UpdateDataOrders();
UpdateDataDucks();
}
}
private void btn_OK_Click(object sender, EventArgs e)
{
if (sp.Price(dTP_DateExpiration.Value, dTP_DateBeginning.Value, numUpDown_Red.Value, numUpDown_Green.Value, numUpDown_Black.Value, lbl_PriceRed.Text, lbl_PriceGreen.Text, lbl_PriceBlack.Text) > 0)
{
Service1Client service = new Service1Client();
Orders o = new Orders();
o.date_beginning = dTP_DateBeginning.Value;
o.date_expiration = dTP_DateExpiration.Value;
o.price = sp.Price(dTP_DateExpiration.Value, dTP_DateBeginning.Value, numUpDown_Red.Value, numUpDown_Green.Value, numUpDown_Black.Value, lbl_PriceRed.Text, lbl_PriceGreen.Text, lbl_PriceBlack.Text);
o.number_red_duck = Convert.ToInt64(numUpDown_Red.Value);
o.number_green_duck = Convert.ToInt64(numUpDown_Green.Value);
o.number_black_duck = Convert.ToInt64(numUpDown_Black.Value);
bool d_red_ok = false,
d_green_ok = false,
d_black_ok = false;
if (cBx_Red.Checked)
{
Ducks d_red = new Ducks();
d_red.id_duck = 1;
d_red.number_in_stock = Convert.ToInt64(lbl_InStockRed.Text) - Convert.ToInt64(numUpDown_Red.Value);
long duck_leased = sp.DucksLeased(1);
d_red.number_leased = duck_leased + Convert.ToInt64(numUpDown_Red.Value);
service.UpdateDuck(d_red);
d_red_ok = true;
}
if (cBx_Green.Checked)
{
Ducks d_green = new Ducks();
d_green.id_duck = 2;
d_green.number_in_stock = Convert.ToInt64(lbl_InStockGreen.Text) - Convert.ToInt64(numUpDown_Green.Value);
long duck_leased = sp.DucksLeased(2);
d_green.number_leased = duck_leased + Convert.ToInt64(numUpDown_Green.Value);
service.UpdateDuck(d_green);
d_green_ok = true;
}
if (cBx_Black.Checked)
{
Ducks d_black = new Ducks();
d_black.id_duck = 3;
d_black.number_in_stock = Convert.ToInt64(lbl_InStockBlack.Text) - Convert.ToInt64(numUpDown_Black.Value);
long duck_leased = sp.DucksLeased(3);
d_black.number_leased = duck_leased + Convert.ToInt64(numUpDown_Black.Value);
service.UpdateDuck(d_black);
d_black_ok = true;
}
if (service.InsertOrder(o) == 1)
{
OrderDuck od = new OrderDuck();
if (d_red_ok)
{
od.id_order = service.MaxOrderId();
od.id_duck = 1;
service.InsertOrderDuck(od);
}
if (d_green_ok)
{
od.id_order = service.MaxOrderId();
od.id_duck = 2;
service.InsertOrderDuck(od);
}
if (d_black_ok)
{
od.id_order = service.MaxOrderId();
od.id_duck = 3;
service.InsertOrderDuck(od);
}
MessageBox.Show("Заказ добавлен.");
DialogResult = DialogResult.OK;
}
}
else
{
MessageBox.Show("Заказ составлен неверно.");
}
}
private void btn_OK_Click(object sender, EventArgs e)
{
if (sp.Price(dTP_DateExpiration.Value, dTP_DateBeginning.Value, numUpDown_Red.Value, numUpDown_Green.Value, numUpDown_Black.Value, lbl_PriceRed.Text, lbl_PriceGreen.Text, lbl_PriceBlack.Text) > 0)
{
Service1Client service = new Service1Client();
Orders o = new Orders();
o.id_order = id_order;
o.date_beginning = dTP_DateBeginning.Value;
o.date_expiration = dTP_DateExpiration.Value;
o.price = sp.Price(dTP_DateExpiration.Value, dTP_DateBeginning.Value, numUpDown_Red.Value, numUpDown_Green.Value, numUpDown_Black.Value, lbl_PriceRed.Text, lbl_PriceGreen.Text, lbl_PriceBlack.Text);
o.number_red_duck = Convert.ToInt64(numUpDown_Red.Value);
o.number_green_duck = Convert.ToInt64(numUpDown_Green.Value);
o.number_black_duck = Convert.ToInt64(numUpDown_Black.Value);
Ducks d_red = new Ducks();
d_red.id_duck = 1;
d_red.number_in_stock = Convert.ToInt64(lbl_InStockRed.Text) + number_red_duck - Convert.ToInt64(numUpDown_Red.Value);
long duck_leased = sp.DucksLeased(1);
d_red.number_leased = duck_leased - number_red_duck + Convert.ToInt64(numUpDown_Red.Value);
service.UpdateDuck(d_red);
Ducks d_green = new Ducks();
d_green.id_duck = 2;
d_green.number_in_stock = Convert.ToInt64(lbl_InStockGreen.Text) + number_green_duck - Convert.ToInt64(numUpDown_Green.Value);
duck_leased = sp.DucksLeased(2);
d_green.number_leased = duck_leased - number_green_duck + Convert.ToInt64(numUpDown_Green.Value);
service.UpdateDuck(d_green);
Ducks d_black = new Ducks();
d_black.id_duck = 3;
d_black.number_in_stock = Convert.ToInt64(lbl_InStockBlack.Text) + number_black_duck - Convert.ToInt64(numUpDown_Black.Value);
duck_leased = sp.DucksLeased(3);
d_black.number_leased = duck_leased - number_black_duck + Convert.ToInt64(numUpDown_Black.Value);
service.UpdateDuck(d_black);
service.UpdateOrder(o);
OrderDuck od = new OrderDuck();
if (cBx_Red.Checked != d_red_ok_initially)
{
od.id_order = o.id_order;
od.id_duck = 1;
if (cBx_Red.Checked)
{
service.InsertOrderDuck(od);
}
else
{
service.DeleteOrderDuck(od);
}
}
if (cBx_Green.Checked != d_green_ok_initially)
{
od.id_order = o.id_order;
od.id_duck = 2;
if (cBx_Green.Checked)
{
service.InsertOrderDuck(od);
}
else
{
service.DeleteOrderDuck(od);
}
}
if (cBx_Black.Checked != d_black_ok_initially)
{
od.id_order = o.id_order;
od.id_duck = 3;
if (cBx_Black.Checked)
{
service.InsertOrderDuck(od);
}
else
{
service.DeleteOrderDuck(od);
}
}
MessageBox.Show("Заказ отредактирован.");
DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show("Заказ составлен неверно.");
}
}
