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 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 bool IncrementPackingSlipSuffix()
{
/*I used the command "GRANT UPDATE ON [WTF_App].[dbo].[co] TO WTFApp" to grant the update priveleges
* "REVOKE UPDATE ON [WTF_App].[dbo].[co] TO WTFApp" is the SQL to remove the privelege.
* Note that I needed to make a new query in order for a successful execution; each time I tried to use an existing Query, it failed
*/
SqlCommand objSQLCommand;
string strSQL;
SL8_WTF_DataBaseSettings objSL8_WTF_DataBaseSettings;
objSL8_WTF_DataBaseSettings = new SL8_WTF_DataBaseSettings();
strSQL = QueryDefinitions.GetQuery("UpdatePackingSlipPrintSequence", new string[] { CustomerOrderNumber.Trim() });
objSL8_WTF_DataBaseSettings.SQLConnection.Open();
objSQLCommand = objSL8_WTF_DataBaseSettings.SQLConnection.CreateCommand();
objSQLCommand.CommandText = strSQL;
if (objSQLCommand.ExecuteNonQuery() == 1)//appropriate row was affected
{
return(true);
}
else
{
return(false);
}
}
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 SortableSearchableBindingList<StockLocation> StockLocations
//{
// get
// {
// SortableSearchableBindingList<StockLocation> objStockLocationList = new SortableSearchableBindingList<StockLocation>();
// StockLocation objStockLocation;
// SL8_WTF_DataBaseSettings objSL8_WTF_DataBaseSettings = new SL8_WTF_DataBaseSettings();
// DataTable objDataTable = new DataTable();
// SqlDataAdapter objDataAdapter;
// SqlCommand objSQLCommand;
// string strSQL;
// strSQL = QueryDefinitions.GetQuery("SelectStockRoomLocations");
// objSL8_WTF_DataBaseSettings.SQLConnection.Open();
// objSQLCommand = new SqlCommand(strSQL, objSL8_WTF_DataBaseSettings.SQLConnection);
// objDataAdapter = new SqlDataAdapter(objSQLCommand);
// objDataAdapter.Fill(objDataTable);
// foreach (DataRow objRow in objDataTable.Rows)
// {
// objStockLocation = new StockLocation();
// objStockLocation.Location = objRow["loc"].ToString();
// objStockLocation.LocationDescription = objRow["description"].ToString();
// objStockLocation.LocationType = objRow["loc_type"].ToString()[0];
// objStockLocationList.Add(objStockLocation);
// }
// return objStockLocationList;
// }
//}
//public static BindingList<ComboBoxItem> StockLocations
//{
// get
// {
// string strSQL;
// SL8_WTF_DataBaseSettings objSL8_WTF_DataBaseSettings = new SL8_WTF_DataBaseSettings();
// SqlCommand objSQLCommand;
// SqlDataAdapter objDataAdapter;
// DataTable objDataTable;
// BindingList<ComboBoxItem> objBindingList;
// objBindingList = new BindingList<ComboBoxItem>();
// objSL8_WTF_DataBaseSettings = new SL8_WTF_DataBaseSettings();
// strSQL = QueryDefinitions.GetQuery("SelectStockRoomLocations");
// objSL8_WTF_DataBaseSettings.SQLConnection.Open();
// objSQLCommand = new SqlCommand(strSQL, objSL8_WTF_DataBaseSettings.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][0].ToString() });
// return objBindingList;
// }
// else
// return objBindingList;
// }
//}
public bool Insert()
{
/*I used the command "GRANT INSERT ON [WTF_App].[dbo].[jobtran] TO WTFApp" to grant the insert priveleges
* "REVOKE INSERT ON [WTF_App].[dbo].[jobtran] TO WTFApp" is the SQL to remove the privelege.
* Note that I needed to make a new query in order for a successful execution; each time I tried to use an existing Query, it failed
*/
SortableSearchableBindingList <Operation> objOperationList = new SortableSearchableBindingList <Operation>();
SL8_WTF_DataBaseSettings objSL8_WTF_DataBaseSettings = new SL8_WTF_DataBaseSettings();
DataTable objDataTable = new DataTable();
SqlCommand objSQLCommand;
string strSQL;
int intCompleteOperation, intCloseJob;
intCompleteOperation = CompleteOperation ? 1 : 0;
intCloseJob = CloseJob ? 1 : 0;
strSQL = QueryDefinitions.GetQuery("InsertIntoJobTran", new string[] { JobNumber, Suffix.ToString(), TransactionType.ToString().ToUpper(), DateTime.Now.ToString(), QtyComplete.ToString(), Operation.ToString(),
QtyMoved.ToString(), Warehouse, Location.ToString(), TransactionClass.ToString().ToUpper(), Operation.WorkCenter, UserCode, intCompleteOperation.ToString(), intCloseJob.ToString(), NextOperation.ToString() });
objSL8_WTF_DataBaseSettings.SQLConnection.Open();
objSQLCommand = objSL8_WTF_DataBaseSettings.SQLConnection.CreateCommand();
objSQLCommand.CommandText = strSQL;
if (objSQLCommand.ExecuteNonQuery() == 1) //the appropriate record was affected
{
return(true);
}
else
{
return(false);
}
}
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 SortableSearchableBindingList<VendorAddress> Search(string strVendorNumber, int intMaxRecordCount = 100, string strSearchBy = "vend_num")//Retrieves a list of customers that match the customer number
{
SortableSearchableBindingList<VendorAddress> objVendorAddressList;
SL8_WTF_DataBaseSettings objSL8_WTF_DataBaseSettings;
DataTable objDataTable = new DataTable();
SqlDataAdapter objDataAdapter;
SqlCommand objSQLCommand;
VendorAddress objVendorAddress;
string strSQL;
objSL8_WTF_DataBaseSettings = new SL8_WTF_DataBaseSettings();
strSQL = QueryDefinitions.GetQuery("SelectTopNVendorAddresses", new string[] { intMaxRecordCount.ToString(), strSearchBy, strVendorNumber, strSearchBy });
objSL8_WTF_DataBaseSettings.SQLConnection.Open();
objSQLCommand = new SqlCommand(strSQL, objSL8_WTF_DataBaseSettings.SQLConnection);
objDataAdapter = new SqlDataAdapter(objSQLCommand);
objDataAdapter.Fill(objDataTable);
objVendorAddressList = new SortableSearchableBindingList<VendorAddress>();
if (objDataTable.Rows.Count > 0)
{
foreach (DataRow objRow in objDataTable.Rows)
{
objVendorAddress = new VendorAddress();
objVendorAddress.VendorNumber = objRow["vend_num"].ToString();
objVendorAddress.Name = objRow["Name"].ToString();
objVendorAddress.AddressLine1 = objRow["Addr##1"].ToString();
objVendorAddress.AddressLine2 = objRow["Addr##2"].ToString();
objVendorAddress.AddressLine3 = objRow["Addr##3"].ToString();
objVendorAddress.AddressLine4 = objRow["Addr##4"].ToString();
objVendorAddress.City = objRow["City"].ToString();
objVendorAddress.State = objRow["State"].ToString();
objVendorAddress.ZipCode = objRow["ZIP"].ToString();
objVendorAddress.Country = objRow["country"].ToString();
objVendorAddressList.Add(objVendorAddress);
}
}
return objVendorAddressList;
}
public static SortableSearchableBindingList <CustomerAddress> Find(string strCustomerNumber)//Retrieves a list of addresses of the specified customer
{
SortableSearchableBindingList <CustomerAddress> objCustomerAddressList;
SL8_WTF_DataBaseSettings objSL8_WTF_DataBaseSettings;
DataTable objDataTable = new DataTable();
SqlDataAdapter objDataAdapter;
SqlCommand objSQLCommand;
CustomerAddress objCustomerAddress;
string strSQL;
objSL8_WTF_DataBaseSettings = new SL8_WTF_DataBaseSettings();
strSQL = QueryDefinitions.GetQuery("SelectCustomerAddresses", new string[] { strCustomerNumber });
objSL8_WTF_DataBaseSettings.SQLConnection.Open();
objSQLCommand = new SqlCommand(strSQL, objSL8_WTF_DataBaseSettings.SQLConnection);
objDataAdapter = new SqlDataAdapter(objSQLCommand);
objDataAdapter.Fill(objDataTable);
objCustomerAddressList = new SortableSearchableBindingList <CustomerAddress>();
if (objDataTable.Rows.Count > 0)
{
foreach (DataRow objRow in objDataTable.Rows)
{
objCustomerAddress = new CustomerAddress();
objCustomerAddress.CustomerNumber = objRow["cust_num"].ToString();
objCustomerAddress.Name = objRow["Name"].ToString();
objCustomerAddress.AddressLine1 = objRow["Addr##1"].ToString();
objCustomerAddress.AddressLine2 = objRow["Addr##2"].ToString();
objCustomerAddress.AddressLine3 = objRow["Addr##3"].ToString();
objCustomerAddress.AddressLine4 = objRow["Addr##4"].ToString();
objCustomerAddress.City = objRow["City"].ToString();
objCustomerAddress.State = objRow["State"].ToString();
objCustomerAddress.ZipCode = objRow["ZIP"].ToString();
objCustomerAddress.Country = objRow["country"].ToString();
objCustomerAddressList.Add(objCustomerAddress);
}
}
return(objCustomerAddressList);
}
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 Order(string strOrderNumber)
{
SqlCommand objSQLCommand;
string strSQL;
SL8_WTF_DataBaseSettings objSL8_WTF_DataBaseSettings;
SqlDataReader objDataReader;
DateTime dtmTemp;
double dblTemp;
int intTemp;
objSL8_WTF_DataBaseSettings = new SL8_WTF_DataBaseSettings();
strSQL = QueryDefinitions.GetQuery("SelectTopNOrders", new string[] { "1", "co.co_num", strOrderNumber.Trim(), "co.co_num" });
objSL8_WTF_DataBaseSettings.SQLConnection.Open();
objSQLCommand = objSL8_WTF_DataBaseSettings.SQLConnection.CreateCommand();
objSQLCommand.CommandText = strSQL;
objDataReader = objSQLCommand.ExecuteReader();
if (objDataReader.HasRows)
{
objDataReader.Read();
CustomerOrderNumber = objDataReader["co_num"].ToString();
IsBlanketOrder = objDataReader["type"].ToString().ToUpper().Trim().Equals("B") ? true : false;//Types are either B-Blanket, R-Regular or E-?
CustomerPO = objDataReader["cust_po"].ToString();
CustomerNumber = objDataReader["cust_num"].ToString();
CustomerName = objDataReader["name"].ToString();
OrderDate = DateTime.TryParse(objDataReader["order_date"].ToString(), out dtmTemp) ? dtmTemp : DateTime.MinValue;
RowPointer = objDataReader["RowPointer"].ToString();
PackingSlipPrintSequence = double.TryParse(objDataReader["decifld1"].ToString(), out dblTemp) ? (int)dblTemp : 0;
SelectedAddressNo = int.TryParse(objDataReader["cust_seq"].ToString(), out intTemp) ? intTemp : 0;
//Notes = this.GetInternalNotes();
}
else
{
throw new Exception("Order does not exist!");
}
}
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 static List <Note> GetNotesListByGUID(string strGUID)
{
SqlCommand objSQLCommand;
string strSQL;
SL8_WTF_DataBaseSettings objSL8_WTF_DataBaseSettings;
SqlDataReader objDataReader;
Note objNote;
List <Note> objNoteList;
objSL8_WTF_DataBaseSettings = new SL8_WTF_DataBaseSettings();
strSQL = QueryDefinitions.GetQuery("SelectNotesByGUID", new string[] { strGUID });
objSL8_WTF_DataBaseSettings.SQLConnection.Open();
objSQLCommand = objSL8_WTF_DataBaseSettings.SQLConnection.CreateCommand();
objSQLCommand.CommandText = strSQL;
objDataReader = objSQLCommand.ExecuteReader();
objNoteList = new List <Note>();
if (objDataReader.HasRows)
{
while (objDataReader.Read())
{
objNote = new Note();
objNote.Description = objDataReader["Description"].ToString();
objNote.Notes = objDataReader["Note"].ToString();
objNote.IsSpecificNote = objDataReader["IsSpecificNote"].ToString().Equals("0") ? false : true;
objNote.TableName = objDataReader["TableName"].ToString();
objNote.RefRowPointer = objDataReader["RefRowPointer"].ToString();
objNote.IsInternalNote = objDataReader["IsInternalNote"].ToString().Equals("0") ? false : true;
objNoteList.Add(objNote);
}
}
return(objNoteList);
}
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);
}
public Item(string strItemNo)
{
SqlCommand objSQLCommand;
string strSQL;
double dblTemp;
SL8_WTF_DataBaseSettings objSL8_WTF_DataBaseSettings;
SqlDataReader objDataReader;
Match objMFGMatch, objDashIntMatch;
objMFGMatch = Regex.Match(strItemNo, @"-MFG\Z", RegexOptions.IgnoreCase);
objDashIntMatch = Regex.Match(strItemNo, @"-[0-9]\Z", RegexOptions.IgnoreCase);
objSL8_WTF_DataBaseSettings = new SL8_WTF_DataBaseSettings();
strSQL = QueryDefinitions.GetQuery("SelectTopNItems", new string[] { "1", "item.item", strItemNo, "item.item" });
objSL8_WTF_DataBaseSettings.SQLConnection.Open();
objSQLCommand = objSL8_WTF_DataBaseSettings.SQLConnection.CreateCommand();
objSQLCommand.CommandText = strSQL;
objDataReader = objSQLCommand.ExecuteReader();
if (objDataReader.HasRows)
{
objDataReader.Read();
ItemID = objDataReader["Item"].ToString();
Description = objDataReader["Description"].ToString();
Revision = objDataReader["revision"].ToString();
QtyOnHand = double.TryParse(objDataReader["qty_on_hand"].ToString(), out dblTemp) ? dblTemp : 0.0;
//CustomerItem = objDataReader["drawing_nbr"].ToString();
CustomerItem = objDataReader["charfld1"].ToString();
//IsMFG = ItemID.ToUpper().EndsWith("MFG");
IsSubItem = objMFGMatch.Success || objDashIntMatch.Success;//Implemented so isMFG functionality could be utilized for -1, -2, etc items
SetAvgUnitWeight();
try
{
MaxUnitWeightHistoryCount = Settings.GetMaxItemPieceUnitWeightHistoryCount();
}
catch
{
throw new Exception("Unable to get ItemPieceWeightHistoryCount from the Settings Table.");
}
}
else
{
throw new Exception("Item does not exist!");
}
//SL8WebServiceSettings objSL8WebServiceSettings;
//DataSet objDataSet;
//ValidateItemNo(strItemNo);
//objSL8WebServiceSettings = new SL8WebServiceSettings();
//objDataSet = objSL8WebServiceSettings.WebService.LoadDataSet(objSL8WebServiceSettings.SessionToken, "SL.SLItems", "Item, Description", "Item LIKE '" + strItemNo + "'", "Item", string.Empty, 1);
//if (objDataSet.Tables[0].Rows.Count > 0)
//{
// ItemID = objDataSet.Tables[0].Rows[0]["Item"].ToString();
// Description = objDataSet.Tables[0].Rows[0]["Description"].ToString();
// IsMFG = ItemID.ToUpper().EndsWith("MFG");
// SetAvgUnitWeight();
// MaxUnitWeightHistoryCount = 5;
//}
//else
// throw new Exception("Item does not exist!");
}