private bool loadPRI()
{
string sUnitID = string.Empty;
SqlConnection conn = new SqlConnection(holder.RepairConnectionString);
string query = "SELECT * FROM TechnicianSubmission WHERE ID = '" + PRI.ID + "'";
string logQuery = "SELECT * FROM TechLogs WHERE ID = @logID";
string actionQuery = "SELECT * FROM TechLogActions WHERE ActionID = @aid";
string customerQuery = "SELECT * FROM RepairCustomerInformation WHERE CustomerNumber = @CustNum";
SqlCommand cmd = new SqlCommand(query, conn);
SqlCommand customerCmd = new SqlCommand(customerQuery, conn);
SqlCommand logCmd = new SqlCommand(logQuery, conn); logCmd.Parameters.Add("@logID", System.Data.SqlDbType.Int);
SqlCommand actionCmd = new SqlCommand(actionQuery, conn); actionCmd.Parameters.Add("@aid", System.Data.SqlDbType.Int);
try
{
conn.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
sUnitID = reader["ID"].ToString().EmptyIfNull();
txtTechName.Text = reader["Technician"].ToString().EmptyIfNull();
txtDateReceived.Text = reader["DateReceived"].ToString().EmptyIfNull();
txtDateSubmitted.Text = reader["DateSubmitted"].ToString().EmptyIfNull();
txtPartName.Text = reader["PartName"].ToString().EmptyIfNull();
txtPartNumber.Text = reader["PartNumber"].ToString().EmptyIfNull();
txtPartSeries.Text = reader["Series"].ToString().EmptyIfNull();
txtCommSubClass.Text = reader["CommoditySubClass"].ToString().EmptyIfNull();
txtSW.Text = reader["SoftwareVersion"].ToString().EmptyIfNull();
txtTOR.Text = reader["TypeOfReturn"].ToString().EmptyIfNull();
txtTOF.Text = reader["TypeOfFailure"].ToString().EmptyIfNull();
txtHOU.Text = reader["HoursOnUnit"].ToString().EmptyIfNull();
rtbAddComm.AppendText(reader["AdditionalComments"].ToString().EmptyIfNull());
txtTechAct1.Text = reader["TechAct1"].ToString().EmptyIfNull();
txtTechAct2.Text = reader["TechAct2"].ToString().EmptyIfNull();
txtTechAct3.Text = reader["TechAct3"].ToString().EmptyIfNull();
txtCustNum.Text = reader["CustomerNumber"].ToString().EmptyIfNull();
if (!string.IsNullOrEmpty(txtCustNum.Text))
{
customerCmd.Parameters.AddWithValue("@CustNum", int.Parse(txtCustNum.Text));
}
rtbQCDQEComments.AppendText(reader["QCDQEComments"].ToString().EmptyIfNull());
}
}
if (!string.IsNullOrEmpty(txtCustNum.Text)) // if number available, load customer info
{
using (SqlDataReader customerReader = customerCmd.ExecuteReader())
{
while (customerReader.Read())
{
txtCustName.Text = customerReader["CustomerName"].ToString();
CurrentCustomer = new CustomerInformation()
{
CustomerNumber = customerReader["CustomerNumber"].ToString().EmptyIfNull(),
CustomerName = customerReader["CustomerName"].ToString().EmptyIfNull(),
CustomerAddy1 = customerReader["CustomerAddressLine1"].ToString().EmptyIfNull(),
CustomerAddy2 = customerReader["CustomerAddressLine2"].ToString().EmptyIfNull(),
CustomerAddy3 = customerReader["CustomerAddressLine3"].ToString().EmptyIfNull(),
CustomerAddy4 = customerReader["CustomerAddressLine4"].ToString().EmptyIfNull(),
CustomerCity = customerReader["CustomerCity"].ToString().EmptyIfNull(),
CustomerState = customerReader["CustomerState"].ToString().EmptyIfNull(),
CustomerPostalCode = customerReader["CustomerPostalCode"].ToString().EmptyIfNull(),
CustomerCountryCode = customerReader["CustomerCountryCode"].ToString().EmptyIfNull()
};
}
}
}
conn.Close();
if (!string.IsNullOrEmpty(sUnitID))
{
System.Collections.Generic.List <UnitIssueModel> lRMI = csCrossClassInteraction.GetRepairUnitIssues(sUnitID);
foreach (UnitIssueModel issue in lRMI)
{
if (string.IsNullOrEmpty(ucIssues[0].ReportedIssue))
{
#region First Issue
ucIssues[0].FillUnitIssue(
issue.ReportedIssue,
issue.TestResult,
issue.TestResultAbort,
issue.Issue,
issue.Cause,
issue.Replacement,
issue.Item,
issue.Problem
);
if (issue.SinglePartReplaced != null)
{
ucIssues[0].AddUnitIssuePart(
issue.SinglePartReplaced.RefDesignator,
issue.SinglePartReplaced.PartReplaced,
issue.SinglePartReplaced.PartsReplacedPartDescription);
}
else if (issue.MultiPartsReplaced != null)
{
foreach (MultiplePartsReplaced mpr in issue.MultiPartsReplaced)
{
ucIssues[0].AddUnitIssuePart(mpr.RefDesignator, mpr.PartReplaced,
mpr.PartsReplacedPartDescription);
}
}
#endregion
continue;
}
(System.Windows.Controls.TabItem Tab, int ActualTabIndex) = ucIssues.AddTabItem();
ucIssues[ActualTabIndex].FillUnitIssue(
issue.ReportedIssue,
issue.TestResult,
issue.TestResultAbort,
issue.Issue,
issue.Cause,
issue.Replacement,
issue.Item,
issue.Problem
);
if (issue.SinglePartReplaced != null)
{
ucIssues[ActualTabIndex].AddUnitIssuePart(
issue.SinglePartReplaced.RefDesignator,
issue.SinglePartReplaced.PartReplaced,
issue.SinglePartReplaced.PartsReplacedPartDescription);
}
else if (issue.MultiPartsReplaced != null)
{
foreach (MultiplePartsReplaced mpr in issue.MultiPartsReplaced)
{
ucIssues[ActualTabIndex].AddUnitIssuePart(mpr.RefDesignator, mpr.PartReplaced,
mpr.PartsReplacedPartDescription);
}
}
}
}
if (logCmd.Parameters[0].Value == null || logCmd.Parameters[0].Value == DBNull.Value)
{
conn.Close();
return(true);
}
btnViewLog.Visibility = Visibility.Visible;
using (SqlDataReader reader = logCmd.ExecuteReader())
{
reader.Read(); // only one record
actionCmd.Parameters.AddWithValue("@aid", reader["ActionID"].ToString().EmptyIfNull());
PRILogView.LogToView = new csLog()
{
Tech = reader["Tech"].ToString().EmptyIfNull(),
LogCreationTime = DateTime.Parse(reader["LogCreationTime"].ToString().EmptyIfNull()),
LogSubmitTime = DateTime.Parse(reader["LogSubmitTime"].ToString().EmptyIfNull())
};
}
using (SqlDataReader reader = actionCmd.ExecuteReader())
{
while (reader.Read())
{
csLogAction @action = new csLogAction()
{
ControlType = reader["ControlType"].ToString().EmptyIfNull(),
ControlName = reader["ControlName"].ToString().EmptyIfNull(),
ControlContent = reader["ControlContent"].ToString().EmptyIfNull(),
EventType = (csLogging.LogState)Enum.Parse(typeof(csLogging.LogState),
reader["LogState"].ToString().EmptyIfNull()),
EventTiming = DateTime.Parse(reader["EventTiming"].ToString().EmptyIfNull()),
LogNote = reader["LogNote"].ToString().EmptyIfNull(),
LogError = reader.GetBoolean(reader.GetOrdinal("LogError"))
};
PRILogView.LogToView.lActions.Add(@action);
}
}
return(true);
}
catch (Exception ex)
{
if (conn != null)
{
conn.Close();
}
MessageBox.Show("Error loading the previous repair information for this submission.\nError Message: " + ex.Message, "Load Issue", MessageBoxButton.OK, MessageBoxImage.Error);
csExceptionLogger.csExceptionLogger.Write("RepairPRI_Issues", ex);
return(false);
}
}
public frmFullCustomerInformation(CustomerInformation _ci)
{
InitializeComponent();
ciCustInfo = _ci;
}
