//-----------------------------------------------------------------------------------------------------
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();
}
