private void BtnComplete_Click(object sender, EventArgs e) { _myOrder = _myOrderManager.GetOrderByID(_myOrderId); _myOrder.ShippingOrderLineItemList = _myOrderDetails.GetLineItemsByID(_myOrderId); Boolean success = _myOrderManager.UpdatePickedTrue(_myOrder); Boolean success2 = _myOrderManager.ClearUserId(_myOrderManager.GetOrderByID(_myOrderId)); if (success == true && success2 == true) { if(lvItemsForPick.Items.Count.Equals(0)) { Close(); MessageBox.Show("Order has been sent to shipping.", "Pick Complete"); } } else { if (success == false) { MessageBox.Show("Error picking order.", "Pick Fail"); } if (success == false) { MessageBox.Show("Error shifting ownership.", "Ownership Change Fail"); } } }
public frmPrintPackReport(ShippingOrder order, AccessToken _myAccessToken) { InitializeComponent(); var RoleAccess = new RoleAccess(_myAccessToken, this); _currentOrder = order; Instance = this; }
//When would this be done? public bool ClearShippedDate(ShippingOrder order) { //Need to do error checking... Try/Catch. foreach (ShippingOrderLineItem item in order.ShippingOrderLineItemList) { prodMan.AddToOnHand(item.Quantity, item.ProductId); } return ShippingOrderDAL.UnshipShippingOrder(order, _connection); }
public static bool AddShippingOrder(ShippingOrder shippingOrder, SqlConnection myConnection) { myConnection = myConnection ?? GetInventoryDbConnection(); try { var mySqlCommand = new SqlCommand("proc_InsertIntoShippingOrders", myConnection) { CommandType = CommandType.StoredProcedure }; mySqlCommand.Parameters.AddWithValue("@purchaseOrderID", shippingOrder.PurchaseOrderId); mySqlCommand.Parameters.AddWithValue("@userID", shippingOrder.UserId ?? Convert.DBNull); //could be null mySqlCommand.Parameters.AddWithValue("@picked", shippingOrder.Picked ? 1 : 0); mySqlCommand.Parameters.AddWithValue("@shipDate", (shippingOrder.ShipDate) ?? Convert.DBNull); mySqlCommand.Parameters.AddWithValue("@shippingTermID", shippingOrder.ShippingTermId); mySqlCommand.Parameters.AddWithValue("@shipToName", shippingOrder.ShipToName ?? Convert.DBNull); mySqlCommand.Parameters.AddWithValue("@shipToAddress", shippingOrder.ShipToAddress ?? Convert.DBNull); mySqlCommand.Parameters.AddWithValue("@shipToCity", shippingOrder.ShipToCity ?? Convert.DBNull); mySqlCommand.Parameters.AddWithValue("@shipToState", shippingOrder.ShipToState ?? Convert.DBNull); mySqlCommand.Parameters.AddWithValue("@shipToZip", shippingOrder.ShipToZip ?? Convert.DBNull); myConnection.Open(); if (mySqlCommand.ExecuteNonQuery() == 1) { return true; } } catch (DataException ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("DatabaseException"), ex); } catch (SqlException ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("SqlException"), ex); } catch (Exception ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("Exception"), ex); } finally { myConnection.Close(); } return false; }
public static bool AssignShippingOrder(ShippingOrder shippingOrder, int newUserId, SqlConnection myConnection) { myConnection = myConnection ?? GetInventoryDbConnection(); try { var mySqlCommand = new SqlCommand("proc_UpdateShippingOrderUser", myConnection) { CommandType = CommandType.StoredProcedure }; mySqlCommand.Parameters.AddWithValue("@shippingOrderID", shippingOrder.ID); mySqlCommand.Parameters.AddWithValue("@newUserID", newUserId); myConnection.Open(); if (mySqlCommand.ExecuteNonQuery() == 1) { return true; } } catch (DataException ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("DatabaseException"), ex); } catch (SqlException ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("SqlException"), ex); } catch (Exception ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("Exception"), ex); } finally { myConnection.Close(); } return false; }
public bool ClearUserId(ShippingOrder order) { //Need to do error checking... Try/Catch. return ShippingOrderDAL.UnassignShippingOrder(order, _connection); }
public bool UpdateUserId(ShippingOrder order, int employeeID) { //If the UserId of the current ShippingOrder is the same value as the new value do not call the update procedure. { //Need to do error checking... Try/Catch. return ShippingOrderDAL.AssignShippingOrder(order, employeeID, _connection); } }
public bool UpdateShippedDate(ShippingOrder order) { //Need to do error checking... Try/Catch. foreach (ShippingOrderLineItem item in order.ShippingOrderLineItemList) { prodMan.RemoveFromOnHand(item.Quantity, item.ProductId); } return ShippingOrderDAL.ShipShippingOrder(order, _connection); //Need to update on-hand inventory for all line items once the shipped date is set. }
public bool UpdatePickedTrue(ShippingOrder order) { //Need to do error checking... Try/Catch. foreach(ShippingOrderLineItem item in order.ShippingOrderLineItemList) { prodMan.RemoveFromAvailable(item.Quantity, item.ProductId); } return ShippingOrderDAL.PickShippingOrder(order, _connection); //Should also clear the current UserId. //Can also call ShippingOrderDAL.UnpickShippingOrder... When would this be done? //If necessary add logic to determine which method is called. }
//When would this be done? public bool UpdatePickedFalse(ShippingOrder order) { foreach (ShippingOrderLineItem item in order.ShippingOrderLineItemList) { prodMan.AddToAvailable(item.Quantity, item.ProductId); } //Need to do error checking... Try/Catch. return ShippingOrderDAL.UnpickShippingOrder(order, _connection); }
public bool Update(ShippingOrder order, ShippingOrder originalOrder) { //Need to do error checking... Try/Catch. return ShippingOrderDAL.UpdateShippingOrder(order, originalOrder, _connection); }
public bool Insert(ShippingOrder order) { //Need to do error checking... Try/Catch. return ShippingOrderDAL.AddShippingOrder(order, _connection); }
public List<CLSPackDetails> FetchPackingDetails(ShippingOrder order) { return ReportingDAL.FetchCLSPackDetails(order, _connection); }
public static ShippingOrder GetShippingOrderByPurchaseOrderId(int purchaseOrderId, SqlConnection myConnection) { var shippingOrder = new ShippingOrder(); myConnection = myConnection ?? GetInventoryDbConnection(); try { var mySqlCommand = new SqlCommand("proc_GetShippingOrderByPurchaseOrderID", myConnection) { CommandType = CommandType.StoredProcedure }; mySqlCommand.Parameters.AddWithValue("@purchaseOrderID", purchaseOrderId); myConnection.Open(); var mySqlReader = mySqlCommand.ExecuteReader(); if (mySqlReader.HasRows) { while (mySqlReader.Read()) { shippingOrder = new ShippingOrder(mySqlReader.GetInt32(0)) { PurchaseOrderId = mySqlReader.GetInt32(1), UserId = mySqlReader[2] as int?, UserLastName = mySqlReader[3] as string, UserFirstName = mySqlReader[4] as string, Picked = (Boolean)mySqlReader.GetSqlBoolean(5), ShipDate = mySqlReader[6] as DateTime?, ShippingTermId = mySqlReader.GetInt32(7), ShippingTermDesc = mySqlReader.GetString(8), ShippingVendorName = mySqlReader.GetString(9), ShipToName = mySqlReader[10] as string, ShipToAddress = mySqlReader[11] as string, ShipToCity = mySqlReader[12] as string, ShipToState = mySqlReader[13] as string, ShipToZip = mySqlReader[14] as string }; } // end while } // end if mySqlReader.Close(); } catch (DataException ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("DatabaseException"), ex); } catch (SqlException ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("SqlException"), ex); } catch (Exception ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("Exception"), ex); } finally { myConnection.Close(); } return shippingOrder; }
public static List<ShippingOrder> GetAllShippingOrders(SqlConnection myConnection) { var shippingOrderList = new List<ShippingOrder>(); myConnection = myConnection ?? GetInventoryDbConnection(); try { var mySqlCommand = new SqlCommand("proc_GetAllShippingOrders", myConnection) { CommandType = CommandType.StoredProcedure }; myConnection.Open(); var mySqlReader = mySqlCommand.ExecuteReader(); if (mySqlReader.HasRows) { while (mySqlReader.Read()) { var shippingOrder = new ShippingOrder(mySqlReader.GetInt32(0)) { PurchaseOrderId = mySqlReader.GetInt32(1), UserId = mySqlReader[2] as int?, UserLastName = mySqlReader[3] as string, UserFirstName = mySqlReader[4] as string, Picked = (Boolean)mySqlReader.GetSqlBoolean(5), ShipDate = mySqlReader[6] as DateTime?, ShippingTermId = mySqlReader.GetInt32(7), ShippingTermDesc = mySqlReader.GetString(8), ShippingVendorName = mySqlReader.GetString(9), ShipToName = mySqlReader[10] as string, ShipToAddress = mySqlReader[11] as string, ShipToCity = mySqlReader[12] as string, ShipToState = mySqlReader[13] as string, ShipToZip = mySqlReader[14] as string }; //var shippingOrder = new ShippingOrder(mySqlReader.GetInt32(0)); //shippingOrder.PurchaseOrderId = mySqlReader.GetInt32(1); //shippingOrder.UserId = mySqlReader[2] as int?; //shippingOrder.UserLastName = mySqlReader[3] as string; //shippingOrder.UserFirstName = mySqlReader[4] as string; //shippingOrder.Picked = (Boolean)mySqlReader.GetSqlBoolean(5); //shippingOrder.ShipDate = mySqlReader[6] as DateTime?; //shippingOrder.ShippingTermId = mySqlReader.GetInt32(7); //shippingOrder.ShippingTermDesc = mySqlReader.GetString(8); //shippingOrder.ShippingVendorName = mySqlReader.GetString(9); //shippingOrder.ShipToName = mySqlReader[10] as string; //shippingOrder.ShipToAddress = mySqlReader[11] as string; //shippingOrder.ShipToCity = mySqlReader[12] as string; //shippingOrder.ShipToState = mySqlReader[13] as string; //shippingOrder.ShipToZip = mySqlReader[14] as string; //Add item to list shippingOrderList.Add(shippingOrder); } } mySqlReader.Close(); } catch (DataException ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("DatabaseException"), ex); } catch (SqlException ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("SqlException"), ex); } catch (Exception ex) { Console.WriteLine(ex.Message); throw new ApplicationException(Messeges.GetMessage("Exception"), ex); } finally { myConnection.Close(); } return shippingOrderList; }