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