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; }
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."); }