public FindHelpDeskTicketsByTicketIDDataSet FindHelpDeskTicketByTicketID(int intTicketID)
{
try
{
aFindHelpDeskTicketsByTicketIDDateSet = new FindHelpDeskTicketsByTicketIDDataSet();
aFindHelpDeskTicketsByTicketIDTableAdapter = new FindHelpDeskTicketsByTicketIDDataSetTableAdapters.FindHelpDeskTicketsByTicketIDTableAdapter();
aFindHelpDeskTicketsByTicketIDTableAdapter.Fill(aFindHelpDeskTicketsByTicketIDDateSet.FindHelpDeskTicketsByTicketID, intTicketID);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Help Desk Class // Find Help Desk Tickets By Ticket ID " + Ex.Message);
}
return(aFindHelpDeskTicketsByTicketIDDateSet);
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
//setting local variables
int intCounter;
int intNumberOfRecords;
int intRecordsReturned;
int intEmployeeID;
int intPhoneExtension = 0;
string strProblemStatus;
int intSelectedIndex = 0;
string strUpdates = "";
bool blnEmailNotCorrect = false;
try
{
cboTicketStatus.Items.Clear();
cboTicketStatus.Items.Add("Select Status");
cboTicketStatus.Items.Add("OPEN");
cboTicketStatus.Items.Add("IN PROCESS");
cboTicketStatus.Items.Add("WAITING ON USER");
cboTicketStatus.Items.Add("WAITING ON PARTS");
cboTicketStatus.Items.Add("CLOSED");
cboTicketStatus.SelectedIndex = 0;
TheFindHelpDeskTicketsByTicketIDDataSet = TheHelpDeskClass.FindHelpDeskTicketByTicketID(MainWindow.gintTicketID);
intEmployeeID = TheFindHelpDeskTicketsByTicketIDDataSet.FindHelpDeskTicketsByTicketID[0].EmployeeID;
TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intEmployeeID);
if (TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].IsEmailAddressNull() == true)
{
gstrUserEmailAddress = "*****@*****.**";
}
else
{
gstrUserEmailAddress = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].EmailAddress;
blnEmailNotCorrect = TheDataValidationClass.VerifyEmailAddress(gstrUserEmailAddress);
if (blnEmailNotCorrect == true)
{
gstrUserEmailAddress = "*****@*****.**";
}
}
TheFindPhoneExtensionByEmployeeIDDataSet = ThePhoneClass.FindPhoneExtensionByEmployeeID(intEmployeeID);
intRecordsReturned = TheFindPhoneExtensionByEmployeeIDDataSet.FindPhoneExtensionByEmployeeID.Rows.Count;
if (intRecordsReturned < 1)
{
intPhoneExtension = 0;
}
else if (intRecordsReturned > 0)
{
intPhoneExtension = TheFindPhoneExtensionByEmployeeIDDataSet.FindPhoneExtensionByEmployeeID[0].Extension;
}
txtExtension.Text = Convert.ToString(intPhoneExtension);
txtFirstName.Text = TheFindHelpDeskTicketsByTicketIDDataSet.FindHelpDeskTicketsByTicketID[0].FirstName;
txtLastName.Text = TheFindHelpDeskTicketsByTicketIDDataSet.FindHelpDeskTicketsByTicketID[0].LastName;
txtProblem.Text = TheFindHelpDeskTicketsByTicketIDDataSet.FindHelpDeskTicketsByTicketID[0].ReportedProblem;
txtProblemType.Text = TheFindHelpDeskTicketsByTicketIDDataSet.FindHelpDeskTicketsByTicketID[0].ProblemType;
txtTicketDate.Text = Convert.ToString(TheFindHelpDeskTicketsByTicketIDDataSet.FindHelpDeskTicketsByTicketID[0].TicketDate);
txtTicketID.Text = Convert.ToString(MainWindow.gintTicketID);
strProblemStatus = TheFindHelpDeskTicketsByTicketIDDataSet.FindHelpDeskTicketsByTicketID[0].TicketStatus;
intNumberOfRecords = cboTicketStatus.Items.Count;
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
cboTicketStatus.SelectedIndex = intCounter;
if (strProblemStatus == cboTicketStatus.SelectedItem.ToString())
{
intSelectedIndex = intCounter;
}
}
cboTicketStatus.SelectedIndex = intSelectedIndex;
TheFindHelpDeskTicketUpdatesByTicketIDDataSet = TheHelpDeskClass.FindHelpDeskTicketUpdatesByTicketID(MainWindow.gintTicketID);
intNumberOfRecords = TheFindHelpDeskTicketUpdatesByTicketIDDataSet.FindHelpDeskTicketUpdatesByTicketID.Rows.Count;
if (intNumberOfRecords > 0)
{
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
strUpdates += Convert.ToString(TheFindHelpDeskTicketUpdatesByTicketIDDataSet.FindHelpDeskTicketUpdatesByTicketID[intCounter].TransactionDate);
strUpdates += " - ";
strUpdates += TheFindHelpDeskTicketUpdatesByTicketIDDataSet.FindHelpDeskTicketUpdatesByTicketID[intCounter].UpdateNotes;
strUpdates += "\n\n";
}
}
txtProblemUpdates.Text = strUpdates;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Update Ticket Information // Window Loaded " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void dgrOpenTickets_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
DataGrid dataGrid;
DataGridRow selectedRow;
DataGridCell TicketID;
string strTicketID;
int intRecordsReturned;
int intEmployeeID;
int intProblemTypeID;
int intAssignedEmployeeID;
int intCounter;
int intNumberOfRecords;
int intSelectedIndex = 0;
string strTicketStatus = "";
string strTicketUpdate;
bool blnFatalError;
try
{
if (dgrOpenTickets.SelectedIndex > -1)
{
//setting local variable
dataGrid = dgrOpenTickets;
selectedRow = (DataGridRow)dataGrid.ItemContainerGenerator.ContainerFromIndex(dataGrid.SelectedIndex);
TicketID = (DataGridCell)dataGrid.Columns[0].GetCellContent(selectedRow).Parent;
strTicketID = ((TextBlock)TicketID.Content).Text;
//find the record
MainWindow.gintTicketID = Convert.ToInt32(strTicketID);
TheFindHelpDeskTicketsByTicketIDDataSet = TheHelpDeskClass.FindHelpDeskTicketByTicketID(MainWindow.gintTicketID);
intEmployeeID = TheFindHelpDeskTicketsByTicketIDDataSet.FindHelpDeskTicketsByTicketID[0].EmployeeID;
txtComputerName.Text = TheFindHelpDeskTicketsByTicketIDDataSet.FindHelpDeskTicketsByTicketID[0].ComputerName;
strTicketUpdate = TheFindHelpDeskTicketsByTicketIDDataSet.FindHelpDeskTicketsByTicketID[0].FirstName + " ";
strTicketUpdate += TheFindHelpDeskTicketsByTicketIDDataSet.FindHelpDeskTicketsByTicketID[0].LastName + " - ";
strTicketUpdate += Convert.ToString(TheFindHelpDeskTicketsByTicketIDDataSet.FindHelpDeskTicketsByTicketID[0].TicketDate) + " - ";
strTicketUpdate += TheFindHelpDeskTicketsByTicketIDDataSet.FindHelpDeskTicketsByTicketID[0].ReportedProblem + "\n\n";
TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intEmployeeID);
if (TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].IsEmailAddressNull() == true)
{
gstrUserEmailAddress = "*****@*****.**";
}
else
{
gstrUserEmailAddress = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].EmailAddress;
blnFatalError = TheDataValidationClass.VerifyEmailAddress(gstrUserEmailAddress);
if (blnFatalError == true)
{
gstrUserEmailAddress = "*****@*****.**";
}
}
TheFindHelpDeskCurrentAssignmentDataSet = TheHelpDeskClass.FindHelpDeskTicketCurrentAssignment(MainWindow.gintTicketID);
intRecordsReturned = TheFindHelpDeskCurrentAssignmentDataSet.FindHelpDeskTicketCurrentAssignment.Rows.Count;
if (intRecordsReturned > 0)
{
intAssignedEmployeeID = TheFindHelpDeskCurrentAssignmentDataSet.FindHelpDeskTicketCurrentAssignment[0].EmployeeID;
intNumberOfRecords = TheFindEmployeeByDepartmentDataSet.FindEmployeeByDepartment.Rows.Count;
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
if (intAssignedEmployeeID == TheFindEmployeeByDepartmentDataSet.FindEmployeeByDepartment[intCounter].EmployeeID)
{
cboSelectEmployee.SelectedIndex = intCounter + 1;
}
}
}
else
{
cboSelectEmployee.SelectedIndex = 0;
}
intProblemTypeID = TheFindHelpDeskTicketsByTicketIDDataSet.FindHelpDeskTicketsByTicketID[0].ProblemTypeID;
intNumberOfRecords = TheFindSortedHelpDeskProblemTypeDataSet.FindSortedHelpDeskProblemType.Rows.Count;
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
if (intProblemTypeID == TheFindSortedHelpDeskProblemTypeDataSet.FindSortedHelpDeskProblemType[intCounter].ProblemTypeID)
{
cboProblemType.SelectedIndex = intCounter + 1;
}
}
strTicketStatus = TheFindHelpDeskTicketsByTicketIDDataSet.FindHelpDeskTicketsByTicketID[0].TicketStatus;
intNumberOfRecords = cboTicketStatus.Items.Count;
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
cboTicketStatus.SelectedIndex = intCounter;
if (strTicketStatus == cboTicketStatus.SelectedItem.ToString())
{
intSelectedIndex = intCounter;
}
}
cboTicketStatus.SelectedIndex = intSelectedIndex;
TheFindPhoneExtensionByEmployeeIDDataSet = ThePhoneClass.FindPhoneExtensionByEmployeeID(intEmployeeID);
intRecordsReturned = TheFindPhoneExtensionByEmployeeIDDataSet.FindPhoneExtensionByEmployeeID.Rows.Count;
if (intRecordsReturned > 0)
{
txtExtension.Text = Convert.ToString(TheFindPhoneExtensionByEmployeeIDDataSet.FindPhoneExtensionByEmployeeID[0].Extension);
}
else
{
txtExtension.Text = "0";
}
TheFindHelpDeskTicketUpdatesByTicketIDDataSet = TheHelpDeskClass.FindHelpDeskTicketUpdatesByTicketID(MainWindow.gintTicketID);
intNumberOfRecords = TheFindHelpDeskTicketUpdatesByTicketIDDataSet.FindHelpDeskTicketUpdatesByTicketID.Rows.Count;
if (intNumberOfRecords > 0)
{
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
strTicketUpdate += Convert.ToString(TheFindHelpDeskTicketUpdatesByTicketIDDataSet.FindHelpDeskTicketUpdatesByTicketID[intCounter].TransactionDate) + " - ";
strTicketUpdate += TheFindHelpDeskTicketUpdatesByTicketIDDataSet.FindHelpDeskTicketUpdatesByTicketID[intCounter].FirstName + " ";
strTicketUpdate += TheFindHelpDeskTicketUpdatesByTicketIDDataSet.FindHelpDeskTicketUpdatesByTicketID[intCounter].LastName + " - ";
strTicketUpdate += TheFindHelpDeskTicketUpdatesByTicketIDDataSet.FindHelpDeskTicketUpdatesByTicketID[intCounter].UpdateNotes + "\n\n";
}
}
txtTicketUpdates.Text = strTicketUpdate;
}
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Update Help Desk Tickets // dgr Open Tickets Grid Selection " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
