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