private void editWarehouseOrder()
{
using (Session4Entities db = new Session4Entities())
{
var swid = ((Warehouse)sourcewarehousebox.SelectedItem).ID;
var dwid = ((Warehouse)destinationwarehousebox.SelectedItem).ID;
var date = Convert.ToDateTime(dateTimePicker1.Value);
//retrieving existing warehouse order
var existingwarehouseorder = db.Orders.Where(a => a.ID == OID).FirstOrDefault();
existingwarehouseorder.SourceWarehouseID = swid;
existingwarehouseorder.DestinationWarehouseID = dwid;
existingwarehouseorder.Date = date;
//retrieving existing orderitems related to the order
var existingwarehouseorderitems = db.OrderItems.Where(oit => oit.OrderID == OID).ToList();
foreach (var item in existingwarehouseorderitems)
{
db.OrderItems.Remove(item);
}
foreach (var item in listofparts)
{
OrderItem newOrderitem = new OrderItem();
newOrderitem.OrderID = (long)OID;
newOrderitem.PartID = item.partid;
newOrderitem.BatchNumber = item.batchnumber;
newOrderitem.Amount = item.amount;
db.OrderItems.Add(newOrderitem);
}
try
{
db.SaveChanges();
db.Dispose();
this.Close();
}
catch (Exception error)
{
MessageBox.Show("Whoops, an error has occured. Error Message: " + error.ToString());
}
}
}
private void createNewOrder(object sender, EventArgs e)
{
//Getting Order details from the view
var destination_warehouse = ((KeyValuePair <long, string>)warehousebox.SelectedItem).Key;
var supplier_id = ((KeyValuePair <long, string>)supplierbox.SelectedItem).Key;
Order newOrder = new Order();
newOrder.TransactionTypeID = 1;
newOrder.SupplierID = Convert.ToInt64(supplier_id);
newOrder.SourceWarehouseID = null;
newOrder.DestinationWarehouseID = Convert.ToInt64(destination_warehouse);
newOrder.Date = Convert.ToDateTime(dateTimePicker1.Value).Date;
db.Orders.Add(newOrder);
long ordernum = newOrder.ID;
foreach (var part in listofparts)
{
OrderItem orderitem = new OrderItem();
orderitem.OrderID = ordernum;
orderitem.PartID = part.partid;
orderitem.BatchNumber = part.batchnumber;
orderitem.Amount = part.amount;
db.OrderItems.Add(orderitem);
}
try
{
db.SaveChanges();
db.Dispose();
this.Close();
}
catch (Exception error)
{
MessageBox.Show("An Error has occured. Details: " + error.Message);
}
}
private void newWarehouseOrder()
{
using (Session4Entities db = new Session4Entities())
{
var swid = ((Warehouse)sourcewarehousebox.SelectedItem).ID;
var dwid = ((Warehouse)destinationwarehousebox.SelectedItem).ID;
var date = Convert.ToDateTime(dateTimePicker1.Value);
Order newOrder = new Order();
newOrder.SourceWarehouseID = swid;
newOrder.DestinationWarehouseID = dwid;
newOrder.TransactionTypeID = 2;
newOrder.Supplier = null;
newOrder.Date = date;
db.Orders.Add(newOrder);
foreach (var item in listofparts)
{
OrderItem orderItem = new OrderItem();
orderItem.OrderID = newOrder.ID;
orderItem.PartID = item.partid;
orderItem.BatchNumber = item.batchnumber;
orderItem.Amount = item.amount;
db.OrderItems.Add(orderItem);
}
try
{
db.SaveChanges();
db.Dispose();
this.Close();
}
catch (Exception error)
{
MessageBox.Show("Whoops, an Error has occured. Error Message: " + error.ToString());
}
}
}