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