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