//----------------------------------------------------------------------------------------------------- private void btnSaveToDatabase_Click(object sender, EventArgs e) { try { ClassLibrary.CustomerOrder customerorder = new ClassLibrary.CustomerOrder(); ClassLibrary.SupplierPart supplierpart = new ClassLibrary.SupplierPart(); ClassLibrary.SupplierOrder sorder = new ClassLibrary.SupplierOrder(); ClassLibrary.SupplierOrderDetails sorderdetail = new ClassLibrary.SupplierOrderDetails(); if (CheckSuppliersExists(supplierpart) == true) { //update customer order status to 'sent to suppliers' customerorder.Id = ordId; customerorder.Status = "Sent To Suppliers"; customerorder.UpdateOrderStatus(); //add sorder sorder.OrderId = ordId; sorder.OrderDate = DateTime.Today; sorder.Status = ""; sorder.TotalPrice = totalOrderPrice; int lastInsertId = sorder.Add(); foreach (PartsInTheOrder2 item in partList2) { //supplierpart.PartId = item.PartID; //supplierpart.SupplierId = item.SupplierID; //DataTable thisTable = supplierpart.GetSupplierPartsId().Tables[0]; //int supplierpartId = (int)thisTable.Rows[0].ItemArray[0]; //add sorder details sorderdetail.PartId = item.PartID; sorderdetail.SupplierId = item.SupplierID; sorderdetail.SorderId = lastInsertId; sorderdetail.Price = item.PartQuantity * Convert.ToDecimal(item.SupplierPrice.Replace("$", "")); sorderdetail.Quantity = item.PartQuantity; sorderdetail.DateDelivery = DateTime.MinValue; sorderdetail.Add(); } MessageBox.Show("an order has been made successfully!", "", MessageBoxButtons.OK, MessageBoxIcon.Information); formDisOrder.DisplayAllOrders(); Close(); } } catch (Exception ex) { } }
private void btnSaveToDatabase_Click(object sender, EventArgs e) { ClassLibrary.CustomerOrder order = new ClassLibrary.CustomerOrder(); DataRowView selectedCustomer = (DataRowView)cmbCustomers.SelectedItem; //add order order.CustId = (int)selectedCustomer.Row.ItemArray[0]; order.OrderDate = Convert.ToDateTime(cmbDate.Text); order.TotalPrice = totalPrice; order.Status = txtStatus.Text; //ADDING MODE if (drOrder == null) { int lastInsertedId = order.Add(); //add OrderDetails ClassLibrary.CustomerOrderDetails orderdetails = new ClassLibrary.CustomerOrderDetails(); orderdetails.OrderId = lastInsertedId; foreach (OrderDetails o in ord) { orderdetails.Price = Convert.ToDecimal(o.Price.ToString().Replace("$", "")); orderdetails.ProductId = o.ProductID; orderdetails.Quantity = o.Quantity; orderdetails.AddOrderDetails(); } } //EDITING MODE else { try { if (dateTimePicker1.Enabled == true) { order.DateDelivery = Convert.ToDateTime(dateTimePicker1.Text); } else { order.DateDelivery = DateTime.MinValue; } order.Id = Convert.ToInt32(drOrder.ItemArray[0]); order.Update(); //add OrderDetails ClassLibrary.CustomerOrderDetails orderdetails = new ClassLibrary.CustomerOrderDetails(); orderdetails.OrderId = order.Id; orderdetails.Delete(); foreach (OrderDetails o in ord) { orderdetails.ProductId = o.ProductID; orderdetails.Quantity = o.Quantity; orderdetails.AddOrderDetails(); } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } } frmDisOrder.DisplayAllOrders(); Close(); }