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;
}
