public void resetStaticVars() { SelectedIssue = -1; SelectedPartNumberPartName = new DGVPARTNUMNAMEITEM { PartNumber = "", PartName = "", PartSeries = "" }; SelectedRPNumber = new DGVMULTIPLERP { RPNumber = "", LineNumber = -1, CustInfo = new CustomerInformation() }; LogHandler.resetLog(); }
private void LoadRPView() { string query = "SELECT * FROM CustomerRepairOrderFromJDE WHERE OrderNumber = '" + sOrderNumber + "'"; SqlConnection conn = new SqlConnection(holder.RepairConnectionString); SqlCommand cmd = new SqlCommand(query, conn); try { conn.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { DGVMULTIPLERP dmpr = new DGVMULTIPLERP { RPNumber = reader["ItemNumber"].ToString().TrimEnd(), LineNumber = Convert.ToDouble(reader["LineNumber"]), CustomerNumber = reader["CustomerNumber"].ToString(), CustomerName = reader["CustomerName"].ToString(), CustInfo = new CustomerInformation() { CustomerNumber = reader["CustomerNumber"].ToString(), CustomerName = reader["CustomerName"].ToString(), CustomerAddy1 = reader["CustomerAddressLine1"].ToString(), CustomerAddy2 = reader["CustomerAddressLine2"].ToString(), CustomerAddy3 = reader["CustomerAddressLine3"].ToString(), CustomerAddy4 = reader["CustomerAddressLine4"].ToString(), CustomerCity = reader["CustomerCity"].ToString(), CustomerState = reader["CustomerState"].ToString(), CustomerPostalCode = reader["CustomerPostalCode"].ToString(), CustomerCountryCode = reader["CustomerCountryCode"].ToString() } }; dgItemInfo.Items.Add(dmpr); } } conn.Close(); } catch (Exception ex) { if (conn != null) { conn.Close(); } MessageBox.Show("There was an issue loading the Customer Information.\nError Message: " + ex.Message, "loadDGView()", MessageBoxButton.OK, MessageBoxImage.Error); } }