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("Заказ составлен неверно."); } }