public static int GetMaxItemPieceUnitWeightHistoryCount()
{
ExtraSytelineTablesSettings objExtraSytelineTableSettings;
SqlCommand objSQLCommand;
SqlDataReader objDataReader;
string strSQL;
int intTemp;
objExtraSytelineTableSettings = new ExtraSytelineTablesSettings();
strSQL = QueryDefinitions.GetQuery("SelectSetting", new string[] { "ItemPieceWeightHistoryCount" });
objExtraSytelineTableSettings.SQLConnection.Open();
objSQLCommand = objExtraSytelineTableSettings.SQLConnection.CreateCommand();
objSQLCommand.CommandText = strSQL;
objDataReader = objSQLCommand.ExecuteReader();
objDataReader.Read();
if (int.TryParse(objDataReader["Setting"].ToString(), out intTemp))
{
return(intTemp);
}
else
{
throw new Exception("Unable to get a valid ItemPieceWeightHistoryCount from the Settings Table.");
}
}
public void UpdateAvgUnitWeightHistory(Single sngUnitWeight, int intQuantity)
{
ExtraSytelineTablesSettings objExtraSytelineTableSettings;
SqlCommand objSQLCommand;
string strSQL;
//if (sngUnitWeight <= 0.0)
// throw new Exception("Unit Weight cannot be < or = to 0.0");
//if (intQuantity <= 0)
// throw new Exception("Quantity cannot be < or = to 0.0");
objExtraSytelineTableSettings = new ExtraSytelineTablesSettings();
strSQL = QueryDefinitions.GetQuery("DeleteOldestItemUnitWeightHistory", new string[] { ItemID });
objExtraSytelineTableSettings.SQLConnection.Open();
objSQLCommand = new SqlCommand(strSQL, objExtraSytelineTableSettings.SQLConnection);
for (int intCounter = UnitWeightHistoryCount - MaxUnitWeightHistoryCount; intCounter >= 0; --intCounter)
{
objSQLCommand.ExecuteNonQuery();
}
strSQL = QueryDefinitions.GetQuery("InsertNewItemUnitWeightHistory", new string[] { ItemID, sngUnitWeight.ToString(), intQuantity.ToString() });
objSQLCommand = new SqlCommand(strSQL, objExtraSytelineTableSettings.SQLConnection);
objSQLCommand.ExecuteNonQuery();
objExtraSytelineTableSettings.SQLConnection.Close();
SetAvgUnitWeight();
}
public void SetAvgUnitWeight()
{
ExtraSytelineTablesSettings objExtraSytelineTableSettings;
SqlCommand objSQLCommand;
SqlDataReader objReader;
Single sngTemp = 0.0F;
int intTemp = 0;
string strSQL;
objExtraSytelineTableSettings = new ExtraSytelineTablesSettings();
strSQL = QueryDefinitions.GetQuery("GetItemAvgUnitWeightAndCount", new string[] { ItemID });
objExtraSytelineTableSettings.SQLConnection.Open();
objSQLCommand = new SqlCommand(strSQL, objExtraSytelineTableSettings.SQLConnection);
objReader = objSQLCommand.ExecuteReader();
objReader.Read();
Single.TryParse(objReader[0].ToString(), out sngTemp);
PieceWgt = sngTemp;
int.TryParse(objReader[1].ToString(), out intTemp);
mUnitWeightHistoryCount = intTemp;
objExtraSytelineTableSettings.SQLConnection.Close();
}
public static string GetLabelPath()
{
ExtraSytelineTablesSettings objExtraSytelineTableSettings;
SqlCommand objSQLCommand;
SqlDataReader objDataReader;
string strSQL;
objExtraSytelineTableSettings = new ExtraSytelineTablesSettings();
strSQL = QueryDefinitions.GetQuery("SelectSetting", new string[] { "LabelPath" });
objExtraSytelineTableSettings.SQLConnection.Open();
objSQLCommand = objExtraSytelineTableSettings.SQLConnection.CreateCommand();
objSQLCommand.CommandText = strSQL;
objDataReader = objSQLCommand.ExecuteReader();
objDataReader.Read();
if (string.IsNullOrEmpty(objDataReader["Setting"].ToString()) || !Directory.Exists(objDataReader["Setting"].ToString()))
{
throw new Exception("Unable to get a Valid File Path from LabelPath record of the Settings Table.");
}
else
{
return(objDataReader["Setting"].ToString());
}
}
private static int UpdateNextSequenceNumber(long lngNextSequenceNo, string strTableName, string strGUID)
{
ExtraSytelineTablesSettings objExtraSytelineTableSettings;
SqlCommand objSQLCommand;
string strSQL;
objExtraSytelineTableSettings = new ExtraSytelineTablesSettings();
strSQL = QueryDefinitions.GetQuery("UpdateNextSequenceNumber", new string[] { lngNextSequenceNo.ToString(), GetGUID(), strTableName, strGUID });
objExtraSytelineTableSettings.SQLConnection.Open();
objSQLCommand = new SqlCommand(strSQL, objExtraSytelineTableSettings.SQLConnection);
return(objSQLCommand.ExecuteNonQuery());
}
public static bool ShipItemFromInventory(ItemHistoryTransaction objItemHistoryTransaction)
{
SqlCommand objSQLCommand;
string strSQL;
ExtraSytelineTablesSettings objExtraSytelineTableSettings;
SqlDataReader objDataReader;
if (!string.IsNullOrEmpty(objItemHistoryTransaction.ShippedTimeStamp))
{
throw new Exception("History Transaction " + objItemHistoryTransaction.RecievedItemID + " was already shipped on " + objItemHistoryTransaction.ShippedTimeStamp);
}
objExtraSytelineTableSettings = new ExtraSytelineTablesSettings();
strSQL = QueryDefinitions.GetQuery("SelectRecievedAccumulatorID", new string[] { objItemHistoryTransaction.ItemID, objItemHistoryTransaction.Job, objItemHistoryTransaction.Suffix.ToString() });
objExtraSytelineTableSettings.SQLConnection.Open();
objSQLCommand = objExtraSytelineTableSettings.SQLConnection.CreateCommand();
objSQLCommand.CommandText = strSQL;
objDataReader = objSQLCommand.ExecuteReader();
if (objDataReader.Read())
{
strSQL = QueryDefinitions.GetQuery("UpdateRecievedItemAccumulator",//fix this
new string[] { "- " + objItemHistoryTransaction.Quantity, DateTime.Now.ToString("MM/dd/yyyy hh:mm:ss"), objDataReader["JobOrderNumber"].ToString(), objDataReader["ReceivedItemAccumulatorID"].ToString() });
}
else
{
throw new Exception("No accumulator record found for job " + objItemHistoryTransaction.Job);
}
objDataReader.Close();
objSQLCommand.CommandText = strSQL;
if (objSQLCommand.ExecuteNonQuery() == 1)//the appropriate row was affected
{
return(ShipItem(objItemHistoryTransaction.RecievedItemID));
}
else
{
throw new Exception("Unable to update accumulator record for job " + objItemHistoryTransaction.Job);
}
}
private static long GetNextSequenceNumber(string strTableName)
{
SqlCommand objSQLCommand;
string strSQL;
long lngSequenceNo;
string strGUID;
ExtraSytelineTablesSettings objExtraSytelineTableSettings;
SqlDataReader objDataReader;
objExtraSytelineTableSettings = new ExtraSytelineTablesSettings();
strSQL = QueryDefinitions.GetQuery("GetNextSequenceNumber", new string[] { strTableName });
objExtraSytelineTableSettings.SQLConnection.Open();
objSQLCommand = objExtraSytelineTableSettings.SQLConnection.CreateCommand();
objSQLCommand.CommandText = strSQL;
objDataReader = objSQLCommand.ExecuteReader();
if (objDataReader.Read())
{
long.TryParse(objDataReader["NextSequence"].ToString(), out lngSequenceNo);
strGUID = objDataReader["GUID"].ToString();
}
else
{
throw new Exception("Unable to get record from TableSequence. TABLE: " + strTableName);
}
lngSequenceNo = ++lngSequenceNo;
if (UpdateNextSequenceNumber(lngSequenceNo, strTableName, strGUID) == 1)
{
return(lngSequenceNo);
}
else
{
throw new Exception("Failed to update TableSequence on Table: " + strTableName);
}
}
public bool Recieve(int intQuantity, string strOperator)
{
SqlCommand objSQLCommand;
string strSQL;
ExtraSytelineTablesSettings objExtraSytelineTableSettings;
SqlDataReader objDataReader;
objExtraSytelineTableSettings = new ExtraSytelineTablesSettings();
strSQL = QueryDefinitions.GetQuery("SelectRecievedAccumulatorID", new string[] { ItemID, SelectedJob.JobNumber, SelectedJob.Suffix.ToString() });
objExtraSytelineTableSettings.SQLConnection.Open();
objSQLCommand = objExtraSytelineTableSettings.SQLConnection.CreateCommand();
objSQLCommand.CommandText = strSQL;
objDataReader = objSQLCommand.ExecuteReader();
if (objDataReader.Read())
{
strSQL = QueryDefinitions.GetQuery("UpdateRecievedItemAccumulator",
new string[] { "+ " + intQuantity, DateTime.Now.ToString("MM/dd/yyyy hh:mm:ss"), SelectedJob.JobOrderNumber, objDataReader["ReceivedItemAccumulatorID"].ToString() });
}
else
{
strSQL = QueryDefinitions.GetQuery("InsertIntoRecievedItemAccumulator",
new string[] { ItemID, SelectedJob.JobNumber, SelectedJob.JobOrderNumber, intQuantity.ToString(), SelectedJob.Suffix.ToString() });
}
objDataReader.Close();
objSQLCommand.CommandText = strSQL;
if (objSQLCommand.ExecuteNonQuery() == 1)//the appropriate row was affected
{
return(true);
}
else
{
return(false);
}
}
public static bool ShipItem(int intRecieveditemID)
{
SqlCommand objSQLCommand;
ExtraSytelineTablesSettings objExtraSytelineTableSettings;
string strSQL;
objExtraSytelineTableSettings = new ExtraSytelineTablesSettings();
strSQL = QueryDefinitions.GetQuery("UpdateRecievedItemHistory", new string[] { DateTime.Now.ToString("MM/dd/yyyy hh:mm:ss"), intRecieveditemID.ToString() });
objExtraSytelineTableSettings.SQLConnection.Open();
objSQLCommand = objExtraSytelineTableSettings.SQLConnection.CreateCommand();
objSQLCommand.CommandText = strSQL;
if (objSQLCommand.ExecuteNonQuery() == 1)
{
return(true);
}
else
{
throw new Exception("Unable to update RecievedItemHistory ID " + intRecieveditemID);
}
}
public bool AddToReceiveHistory(int intQuantity, string strOperator, double dblGrossWeight, int intPalletCount)
{
SqlCommand objSQLCommand;
string strSQL;
ExtraSytelineTablesSettings objExtraSytelineTableSettings;
objExtraSytelineTableSettings = new ExtraSytelineTablesSettings();
strSQL = QueryDefinitions.GetQuery("InsertIntoRecievedItemHistory", new string[] { SelectedJob.JobNumber, ItemID, intQuantity.ToString(),
strOperator, dblGrossWeight.ToString(), LabelSequence.ToString(), SelectedOrder.CustomerOrderNumber, intPalletCount.ToString(), SelectedJob.Suffix.ToString() });
objExtraSytelineTableSettings.SQLConnection.Open();
objSQLCommand = objExtraSytelineTableSettings.SQLConnection.CreateCommand();
objSQLCommand.CommandText = strSQL;
if (objSQLCommand.ExecuteNonQuery() == 1) //appropriate row was affected
{
return(true);
}
else
{
return(false);
}
}
private BindingList <ComboBoxItem> GetList(string strSelectStatement)
{
string strSQL;
ExtraSytelineTablesSettings objExtraSytelineTablesSettings;
SqlCommand objSQLCommand;
SqlDataAdapter objDataAdapter;
DataTable objDataTable;
BindingList <ComboBoxItem> objBindingList;
objBindingList = new BindingList <ComboBoxItem>();
objExtraSytelineTablesSettings = new ExtraSytelineTablesSettings();
strSQL = QueryDefinitions.GetQuery(strSelectStatement);
objExtraSytelineTablesSettings.SQLConnection.Open();
objSQLCommand = new SqlCommand(strSQL, objExtraSytelineTablesSettings.SQLConnection);
objDataAdapter = new SqlDataAdapter(objSQLCommand);
objDataTable = new DataTable();
objDataAdapter.Fill(objDataTable);
if (objDataTable.Rows.Count > 0)
{
objBindingList = new BindingList <ComboBoxItem>();
//objBindingList.Add(new ComboBoxItem { Text = "--- Select Carrier ---", Value = "0" });
for (int intCounter = 0; intCounter < objDataTable.Rows.Count; intCounter++)
{
objBindingList.Add(new ComboBoxItem {
Value = objDataTable.Rows[intCounter][0].ToString(), Text = objDataTable.Rows[intCounter][1].ToString()
});
}
return(objBindingList);
}
else
{
return(objBindingList);
}
}
public SortableSearchableBindingList<ItemHistoryTransaction> GetHistory(ItemHistoryView enuItemHistoryView, string strJobNo = null, int intSuffix = 0)
{
SortableSearchableBindingList<ItemHistoryTransaction> objItemHistoryList = new SortableSearchableBindingList<ItemHistoryTransaction>();
ItemHistoryTransaction objItemHistoryTransaction;
SqlCommand objSQLCommand;
ExtraSytelineTablesSettings objExtraSytelineTableSettings;
SqlDataReader objDataReader;
string strSQL;
string strJobParameter;
objExtraSytelineTableSettings = new ExtraSytelineTablesSettings();
if (strJobNo != null)
strJobParameter = " AND job = '" + strJobNo + "' AND suffix = " + intSuffix.ToString();
else
strJobParameter = string.Empty;
switch (enuItemHistoryView)
{
case ItemHistoryView.All:
strSQL = QueryDefinitions.GetQuery("SelectAllItemHistory", new string[] { ItemID, strJobParameter });
break;
case ItemHistoryView.Shipped:
strSQL = QueryDefinitions.GetQuery("SelectShippedItemHistory", new string[] { ItemID, strJobParameter });
break;
case ItemHistoryView.Recieved:
strSQL = QueryDefinitions.GetQuery("SelectRecievedItemHistory", new string[] { ItemID, strJobParameter });
break;
default:
strSQL = string.Empty;
break;
}
objExtraSytelineTableSettings.SQLConnection.Open();
objSQLCommand = objExtraSytelineTableSettings.SQLConnection.CreateCommand();
objSQLCommand.CommandText = strSQL;
objDataReader = objSQLCommand.ExecuteReader();
while (objDataReader.Read())
{
objItemHistoryTransaction = new ItemHistoryTransaction();
objItemHistoryTransaction.LabelSequence = int.Parse(objDataReader["LabelSequence"].ToString());
objItemHistoryTransaction.ItemID = objDataReader["item"].ToString();
objItemHistoryTransaction.Job = objDataReader["job"].ToString();
objItemHistoryTransaction.CustomerOrderNumber = objDataReader["co"].ToString();
objItemHistoryTransaction.Quantity = int.Parse(objDataReader["Quantity"].ToString());
objItemHistoryTransaction.RecievedTimeStamp = string.Format("{0:MM/dd/yyyy hh:mm:ss tt}", objDataReader["ReceivedTimestamp"]);
objItemHistoryTransaction.ShippedTimeStamp = string.Format("{0:MM/dd/yyyy hh:mm:ss tt}", objDataReader["ShippedTimestamp"]);
objItemHistoryTransaction.Operator = objDataReader["operator"].ToString();
objItemHistoryTransaction.GrossWeight = double.Parse(objDataReader["GrossWgt"].ToString());
objItemHistoryTransaction.PalletCount = int.Parse(objDataReader["PalletCt"].ToString());
objItemHistoryTransaction.RecievedItemID = int.Parse(objDataReader["ReceivedItemID"].ToString());
objItemHistoryTransaction.Suffix = int.Parse(objDataReader["suffix"].ToString());
objItemHistoryList.Add(objItemHistoryTransaction);
}
return objItemHistoryList;
}
private BindingList<ComboBoxItem> GetList(string strSelectStatement)
{
string strSQL;
ExtraSytelineTablesSettings objExtraSytelineTablesSettings;
SqlCommand objSQLCommand;
SqlDataAdapter objDataAdapter;
DataTable objDataTable;
BindingList<ComboBoxItem> objBindingList;
objBindingList = new BindingList<ComboBoxItem>();
objExtraSytelineTablesSettings = new ExtraSytelineTablesSettings();
strSQL = QueryDefinitions.GetQuery(strSelectStatement);
objExtraSytelineTablesSettings.SQLConnection.Open();
objSQLCommand = new SqlCommand(strSQL, objExtraSytelineTablesSettings.SQLConnection);
objDataAdapter = new SqlDataAdapter(objSQLCommand);
objDataTable = new DataTable();
objDataAdapter.Fill(objDataTable);
if (objDataTable.Rows.Count > 0)
{
objBindingList = new BindingList<ComboBoxItem>();
//objBindingList.Add(new ComboBoxItem { Text = "--- Select Carrier ---", Value = "0" });
for (int intCounter = 0; intCounter < objDataTable.Rows.Count; intCounter++)
objBindingList.Add(new ComboBoxItem { Value = objDataTable.Rows[intCounter][0].ToString(), Text = objDataTable.Rows[intCounter][1].ToString() });
return objBindingList;
}
else
return objBindingList;
}
public SortableSearchableBindingList <ItemHistoryTransaction> GetHistory(ItemHistoryView enuItemHistoryView, string strJobNo = null, int intSuffix = 0)
{
SortableSearchableBindingList <ItemHistoryTransaction> objItemHistoryList = new SortableSearchableBindingList <ItemHistoryTransaction>();
ItemHistoryTransaction objItemHistoryTransaction;
SqlCommand objSQLCommand;
ExtraSytelineTablesSettings objExtraSytelineTableSettings;
SqlDataReader objDataReader;
string strSQL;
string strJobParameter;
objExtraSytelineTableSettings = new ExtraSytelineTablesSettings();
if (strJobNo != null)
{
strJobParameter = " AND job = '" + strJobNo + "' AND suffix = " + intSuffix.ToString();
}
else
{
strJobParameter = string.Empty;
}
switch (enuItemHistoryView)
{
case ItemHistoryView.All:
strSQL = QueryDefinitions.GetQuery("SelectAllItemHistory", new string[] { ItemID, strJobParameter });
break;
case ItemHistoryView.Shipped:
strSQL = QueryDefinitions.GetQuery("SelectShippedItemHistory", new string[] { ItemID, strJobParameter });
break;
case ItemHistoryView.Recieved:
strSQL = QueryDefinitions.GetQuery("SelectRecievedItemHistory", new string[] { ItemID, strJobParameter });
break;
default:
strSQL = string.Empty;
break;
}
objExtraSytelineTableSettings.SQLConnection.Open();
objSQLCommand = objExtraSytelineTableSettings.SQLConnection.CreateCommand();
objSQLCommand.CommandText = strSQL;
objDataReader = objSQLCommand.ExecuteReader();
while (objDataReader.Read())
{
objItemHistoryTransaction = new ItemHistoryTransaction();
objItemHistoryTransaction.LabelSequence = int.Parse(objDataReader["LabelSequence"].ToString());
objItemHistoryTransaction.ItemID = objDataReader["item"].ToString();
objItemHistoryTransaction.Job = objDataReader["job"].ToString();
objItemHistoryTransaction.CustomerOrderNumber = objDataReader["co"].ToString();
objItemHistoryTransaction.Quantity = int.Parse(objDataReader["Quantity"].ToString());
objItemHistoryTransaction.RecievedTimeStamp = string.Format("{0:MM/dd/yyyy hh:mm:ss tt}", objDataReader["ReceivedTimestamp"]);
objItemHistoryTransaction.ShippedTimeStamp = string.Format("{0:MM/dd/yyyy hh:mm:ss tt}", objDataReader["ShippedTimestamp"]);
objItemHistoryTransaction.Operator = objDataReader["operator"].ToString();
objItemHistoryTransaction.GrossWeight = double.Parse(objDataReader["GrossWgt"].ToString());
objItemHistoryTransaction.PalletCount = int.Parse(objDataReader["PalletCt"].ToString());
objItemHistoryTransaction.RecievedItemID = int.Parse(objDataReader["ReceivedItemID"].ToString());
objItemHistoryTransaction.Suffix = int.Parse(objDataReader["suffix"].ToString());
objItemHistoryList.Add(objItemHistoryTransaction);
}
return(objItemHistoryList);
}
public static bool ShipItem(int intRecieveditemID)
{
SqlCommand objSQLCommand;
ExtraSytelineTablesSettings objExtraSytelineTableSettings;
string strSQL;
objExtraSytelineTableSettings = new ExtraSytelineTablesSettings();
strSQL = QueryDefinitions.GetQuery("UpdateRecievedItemHistory", new string[] { DateTime.Now.ToString("MM/dd/yyyy hh:mm:ss"), intRecieveditemID.ToString() });
objExtraSytelineTableSettings.SQLConnection.Open();
objSQLCommand = objExtraSytelineTableSettings.SQLConnection.CreateCommand();
objSQLCommand.CommandText = strSQL;
if (objSQLCommand.ExecuteNonQuery() == 1)
return true;
else
throw new Exception("Unable to update RecievedItemHistory ID " + intRecieveditemID);
}
public void UpdateAvgUnitWeightHistory(Single sngUnitWeight, int intQuantity)
{
ExtraSytelineTablesSettings objExtraSytelineTableSettings;
SqlCommand objSQLCommand;
string strSQL;
//if (sngUnitWeight <= 0.0)
// throw new Exception("Unit Weight cannot be < or = to 0.0");
//if (intQuantity <= 0)
// throw new Exception("Quantity cannot be < or = to 0.0");
objExtraSytelineTableSettings = new ExtraSytelineTablesSettings();
strSQL = QueryDefinitions.GetQuery("DeleteOldestItemUnitWeightHistory", new string[] { ItemID });
objExtraSytelineTableSettings.SQLConnection.Open();
objSQLCommand = new SqlCommand(strSQL, objExtraSytelineTableSettings.SQLConnection);
for (int intCounter = UnitWeightHistoryCount - MaxUnitWeightHistoryCount; intCounter >= 0; --intCounter)
objSQLCommand.ExecuteNonQuery();
strSQL = QueryDefinitions.GetQuery("InsertNewItemUnitWeightHistory", new string[] { ItemID, sngUnitWeight.ToString(), intQuantity.ToString() });
objSQLCommand = new SqlCommand(strSQL, objExtraSytelineTableSettings.SQLConnection);
objSQLCommand.ExecuteNonQuery();
objExtraSytelineTableSettings.SQLConnection.Close();
SetAvgUnitWeight();
}
public static string GetLabelPath()
{
ExtraSytelineTablesSettings objExtraSytelineTableSettings;
SqlCommand objSQLCommand;
SqlDataReader objDataReader;
string strSQL;
objExtraSytelineTableSettings = new ExtraSytelineTablesSettings();
strSQL = QueryDefinitions.GetQuery("SelectSetting", new string[] { "LabelPath" });
objExtraSytelineTableSettings.SQLConnection.Open();
objSQLCommand = objExtraSytelineTableSettings.SQLConnection.CreateCommand();
objSQLCommand.CommandText = strSQL;
objDataReader = objSQLCommand.ExecuteReader();
objDataReader.Read();
if (string.IsNullOrEmpty(objDataReader["Setting"].ToString()) || !Directory.Exists(objDataReader["Setting"].ToString()))
throw new Exception("Unable to get a Valid File Path from LabelPath record of the Settings Table.");
else
return objDataReader["Setting"].ToString();
}
public static bool ShipItemFromInventory(ItemHistoryTransaction objItemHistoryTransaction)
{
SqlCommand objSQLCommand;
string strSQL;
ExtraSytelineTablesSettings objExtraSytelineTableSettings;
SqlDataReader objDataReader;
if (!string.IsNullOrEmpty(objItemHistoryTransaction.ShippedTimeStamp))
throw new Exception("History Transaction " + objItemHistoryTransaction.RecievedItemID + " was already shipped on " + objItemHistoryTransaction.ShippedTimeStamp);
objExtraSytelineTableSettings = new ExtraSytelineTablesSettings();
strSQL = QueryDefinitions.GetQuery("SelectRecievedAccumulatorID", new string[] { objItemHistoryTransaction.ItemID, objItemHistoryTransaction.Job, objItemHistoryTransaction.Suffix.ToString() });
objExtraSytelineTableSettings.SQLConnection.Open();
objSQLCommand = objExtraSytelineTableSettings.SQLConnection.CreateCommand();
objSQLCommand.CommandText = strSQL;
objDataReader = objSQLCommand.ExecuteReader();
if (objDataReader.Read())
strSQL = QueryDefinitions.GetQuery("UpdateRecievedItemAccumulator",//fix this
new string[] { "- " + objItemHistoryTransaction.Quantity, DateTime.Now.ToString("MM/dd/yyyy hh:mm:ss"), objDataReader["JobOrderNumber"].ToString(), objDataReader["ReceivedItemAccumulatorID"].ToString() });
else
throw new Exception("No accumulator record found for job " + objItemHistoryTransaction.Job);
objDataReader.Close();
objSQLCommand.CommandText = strSQL;
if (objSQLCommand.ExecuteNonQuery() == 1)//the appropriate row was affected
return ShipItem(objItemHistoryTransaction.RecievedItemID);
else
throw new Exception("Unable to update accumulator record for job " + objItemHistoryTransaction.Job);
}
public bool AddToReceiveHistory(int intQuantity, string strOperator, double dblGrossWeight, int intPalletCount)
{
SqlCommand objSQLCommand;
string strSQL;
ExtraSytelineTablesSettings objExtraSytelineTableSettings;
objExtraSytelineTableSettings = new ExtraSytelineTablesSettings();
strSQL = QueryDefinitions.GetQuery("InsertIntoRecievedItemHistory", new string[] { SelectedJob.JobNumber, ItemID, intQuantity.ToString(),
strOperator, dblGrossWeight.ToString(), LabelSequence.ToString(), SelectedOrder.CustomerOrderNumber, intPalletCount.ToString(), SelectedJob.Suffix.ToString() });
objExtraSytelineTableSettings.SQLConnection.Open();
objSQLCommand = objExtraSytelineTableSettings.SQLConnection.CreateCommand();
objSQLCommand.CommandText = strSQL;
if (objSQLCommand.ExecuteNonQuery() == 1) //appropriate row was affected
return true;
else
return false;
}
public bool Recieve(int intQuantity, string strOperator)
{
SqlCommand objSQLCommand;
string strSQL;
ExtraSytelineTablesSettings objExtraSytelineTableSettings;
SqlDataReader objDataReader;
objExtraSytelineTableSettings = new ExtraSytelineTablesSettings();
strSQL = QueryDefinitions.GetQuery("SelectRecievedAccumulatorID", new string[] { ItemID, SelectedJob.JobNumber, SelectedJob.Suffix.ToString() });
objExtraSytelineTableSettings.SQLConnection.Open();
objSQLCommand = objExtraSytelineTableSettings.SQLConnection.CreateCommand();
objSQLCommand.CommandText = strSQL;
objDataReader = objSQLCommand.ExecuteReader();
if (objDataReader.Read())
strSQL = QueryDefinitions.GetQuery("UpdateRecievedItemAccumulator",
new string[] { "+ " + intQuantity, DateTime.Now.ToString("MM/dd/yyyy hh:mm:ss"), SelectedJob.JobOrderNumber, objDataReader["ReceivedItemAccumulatorID"].ToString() });
else
strSQL = QueryDefinitions.GetQuery("InsertIntoRecievedItemAccumulator",
new string[] { ItemID, SelectedJob.JobNumber, SelectedJob.JobOrderNumber, intQuantity.ToString(), SelectedJob.Suffix.ToString() });
objDataReader.Close();
objSQLCommand.CommandText = strSQL;
if (objSQLCommand.ExecuteNonQuery() == 1)//the appropriate row was affected
return true;
else
return false;
}
public void SetAvgUnitWeight()
{
ExtraSytelineTablesSettings objExtraSytelineTableSettings;
SqlCommand objSQLCommand;
SqlDataReader objReader;
Single sngTemp = 0.0F;
int intTemp = 0;
string strSQL;
objExtraSytelineTableSettings = new ExtraSytelineTablesSettings();
strSQL = QueryDefinitions.GetQuery("GetItemAvgUnitWeightAndCount", new string[] { ItemID });
objExtraSytelineTableSettings.SQLConnection.Open();
objSQLCommand = new SqlCommand(strSQL, objExtraSytelineTableSettings.SQLConnection);
objReader = objSQLCommand.ExecuteReader();
objReader.Read();
Single.TryParse(objReader[0].ToString(), out sngTemp);
PieceWgt = sngTemp;
int.TryParse(objReader[1].ToString(), out intTemp);
mUnitWeightHistoryCount = intTemp;
objExtraSytelineTableSettings.SQLConnection.Close();
}
private void LoadLabelFormatsList()
{
ExtraSytelineTablesSettings objExtraSytelineTableSettings;
DataTable objDataTable = new DataTable();
SqlDataAdapter objDataAdapter;
SqlCommand objSQLCommand;
WTFClassLibrary.Label objLabel;
string strSQL;
long lngTemp;
int intTemp;
objExtraSytelineTableSettings = new ExtraSytelineTablesSettings();
strSQL = QueryDefinitions.GetQuery("SelectCustomerLabels", new string[] { mintCustomerNumber.ToString() });
objExtraSytelineTableSettings.SQLConnection.Open();
objSQLCommand = objExtraSytelineTableSettings.SQLConnection.CreateCommand();
objSQLCommand.CommandText = strSQL;
objDataAdapter = new SqlDataAdapter(objSQLCommand);
objDataAdapter.Fill(objDataTable);
cboLabels.Items.Clear();
objLabel = new WTFClassLibrary.Label();
objLabel.Description = "--- Select Label Format ---";
cboLabels.Items.Add(objLabel);
foreach (DataRow objRow in objDataTable.Rows)
{
objLabel = new WTFClassLibrary.Label();
if (long.TryParse(objRow["CustomerLabelID"].ToString(), out lngTemp))
objLabel.CustomerLabelID = lngTemp;
else
objLabel.CustomerLabelID = 0;
if (int.TryParse(objRow["AddrLineCt"].ToString(), out intTemp))
objLabel.AddressLineCount = intTemp;
else
objLabel.AddressLineCount = 0;
objLabel.Description = objRow["Description"].ToString();
objLabel.LabelFile = objRow["LabelFile"].ToString();
objLabel.SupplierNumber = objRow["SupplierNumber"].ToString();
if (long.TryParse(objRow["Sequence"].ToString(), out lngTemp))
objLabel.Sequence = lngTemp;
else
objLabel.Sequence = 0;
cboLabels.Items.Add(objLabel);
}
cboLabels.SelectedIndex = 0;
}
public static int GetMaxItemPieceUnitWeightHistoryCount()
{
ExtraSytelineTablesSettings objExtraSytelineTableSettings;
SqlCommand objSQLCommand;
SqlDataReader objDataReader;
string strSQL;
int intTemp;
objExtraSytelineTableSettings = new ExtraSytelineTablesSettings();
strSQL = QueryDefinitions.GetQuery("SelectSetting", new string[] { "ItemPieceWeightHistoryCount" });
objExtraSytelineTableSettings.SQLConnection.Open();
objSQLCommand = objExtraSytelineTableSettings.SQLConnection.CreateCommand();
objSQLCommand.CommandText = strSQL;
objDataReader = objSQLCommand.ExecuteReader();
objDataReader.Read();
if (int.TryParse(objDataReader["Setting"].ToString(), out intTemp))
return intTemp;
else
throw new Exception("Unable to get a valid ItemPieceWeightHistoryCount from the Settings Table.");
}