private void TxtEnterLastFour_TextChanged(object sender, TextChangedEventArgs e)
{
//setting local variables
string strValueForValidation;
int intLength;
bool blnFatalError = false;
int intRecordsReturned;
strValueForValidation = txtEnterLastFour.Text;
intLength = strValueForValidation.Length;
if (intLength == 4)
{
blnFatalError = TheDataValidationClass.VerifyIntegerData(strValueForValidation);
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage("The Information Entered is not an Integer");
return;
}
TheFindCellPhoneByLastFourDataSet = ThePhoneClass.FindCellPhoneByLastFour(strValueForValidation);
intRecordsReturned = TheFindCellPhoneByLastFourDataSet.FindCellPhoneByLastFour.Rows.Count;
if (intRecordsReturned == 0)
{
TheMessagesClass.ErrorMessage("Cell Phone Not Found");
return;
}
txtCellPhoneNumber.Text = TheFindCellPhoneByLastFourDataSet.FindCellPhoneByLastFour[0].PhoneNumber;
txtCurrentAssignment.Text = TheFindCellPhoneByLastFourDataSet.FindCellPhoneByLastFour[0].FirstName + " " + TheFindCellPhoneByLastFourDataSet.FindCellPhoneByLastFour[0].LastName;
MainWindow.gintPhoneID = TheFindCellPhoneByLastFourDataSet.FindCellPhoneByLastFour[0].PhoneID;
}
}
public FindCellPhoneByLastFourDataSet FindCellPhoneByLastFour(string strPhoneNumber)
{
try
{
aFindCellPhoneByLastFourDataSet = new FindCellPhoneByLastFourDataSet();
aFindCellPhoneByLastFourTableAdapter = new FindCellPhoneByLastFourDataSetTableAdapters.FindCellPhoneByLastFourTableAdapter();
aFindCellPhoneByLastFourTableAdapter.Fill(aFindCellPhoneByLastFourDataSet.FindCellPhoneByLastFour, strPhoneNumber);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Phone Class // Find Cell Phone By Last Four " + Ex.Message);
}
return(aFindCellPhoneByLastFourDataSet);
}
private void txtLastFour_TextChanged(object sender, TextChangedEventArgs e)
{
//setting local variables
string strValueForValidation;
int intLength;
bool blnFatalError = false;
int intRecordsReturned;
try
{
strValueForValidation = txtLastFour.Text;
intLength = strValueForValidation.Length;
if (intLength == 4)
{
blnFatalError = TheDataValidationClass.VerifyIntegerData(strValueForValidation);
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage("The Information Entered is not an Integer");
return;
}
TheFindCellPhoneByLastFourDataSet = ThePhoneClass.FindCellPhoneByLastFour(strValueForValidation);
intRecordsReturned = TheFindCellPhoneByLastFourDataSet.FindCellPhoneByLastFour.Rows.Count;
if (intRecordsReturned == 0)
{
TheMessagesClass.ErrorMessage("Cell Phone Not Found");
return;
}
txtCellPhoneNumber.Text = TheFindCellPhoneByLastFourDataSet.FindCellPhoneByLastFour[0].PhoneNumber;
txtCurrentAssignment.Text = TheFindCellPhoneByLastFourDataSet.FindCellPhoneByLastFour[0].FirstName + " " + TheFindCellPhoneByLastFourDataSet.FindCellPhoneByLastFour[0].LastName;
MainWindow.gintPhoneID = TheFindCellPhoneByLastFourDataSet.FindCellPhoneByLastFour[0].PhoneID;
}
}
catch (Exception Ex)
{
TheSendEmailClass.SendEventLog("New Blue Jay ERP // Assign Cell Phone // Last Four Text Box " + Ex.Message);
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Assign Cell Phone // Last Four Text Box " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void btnProcess_Click(object sender, RoutedEventArgs e)
{
//this will run the report
//setting up local variables
string strValueForValidation;
bool blnThereIsAProblem = false;
bool blnFatalError = false;
string strErrorMessage = "";
int intCounter;
int intNumberOfRecords;
int intRecordsReturned;
string strLastFour;
DateTime datTransactionDate;
string strPhoneNumber;
string strFullName;
string strTargetNumber;
string strDestination;
string strTargetName;
int intCallMinutes;
string strEmployeeNumber;
try
{
TheCellCallRosterDataSet.cellcallroster.Rows.Clear();
if (cboReportType.SelectedIndex < 1)
{
blnFatalError = true;
strErrorMessage += "The Report Type Was Not Selected\n";
}
if (gblnEmployeeSearch == true)
{
if (cboSelectEmployee.SelectedIndex < 1)
{
blnFatalError = true;
strErrorMessage += "The Employee Was Not Selected\n";
}
}
strValueForValidation = txtStartDate.Text;
blnThereIsAProblem = TheDataValidationClass.VerifyDateData(strValueForValidation);
if (blnThereIsAProblem == true)
{
blnFatalError = true;
strErrorMessage += "The Start Date is not a Date\n";
}
else
{
gdatStartDate = Convert.ToDateTime(strValueForValidation);
}
strValueForValidation = txtEndDate.Text;
blnThereIsAProblem = TheDataValidationClass.VerifyDateData(strValueForValidation);
if (blnThereIsAProblem == true)
{
blnFatalError = true;
strErrorMessage += "The End Date is not a Date\n";
}
else
{
gdatEndDate = Convert.ToDateTime(strValueForValidation);
}
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage(strErrorMessage);
return;
}
else
{
blnFatalError = TheDataValidationClass.verifyDateRange(gdatStartDate, gdatEndDate);
if (blnFatalError == true)
{
strErrorMessage = "The Start Date Is After The End Date";
return;
}
}
if (gblnEmployeeSearch == true)
{
TheFindCellPhoneCallsForEmployeeDataSet = TheCellPhoneCallsClass.FindCellPhoneCallsForEmployee(gintEmployeeID, gdatStartDate, gdatEndDate);
intNumberOfRecords = TheFindCellPhoneCallsForEmployeeDataSet.FindCellPhoneCallsForEmployee.Rows.Count;
if (intNumberOfRecords > 0)
{
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
datTransactionDate = TheFindCellPhoneCallsForEmployeeDataSet.FindCellPhoneCallsForEmployee[intCounter].TransactionDate;
strPhoneNumber = TheFindCellPhoneCallsForEmployeeDataSet.FindCellPhoneCallsForEmployee[intCounter].PhoneNumber;
strTargetNumber = TheFindCellPhoneCallsForEmployeeDataSet.FindCellPhoneCallsForEmployee[intCounter].TransactionNumber;
strDestination = TheFindCellPhoneCallsForEmployeeDataSet.FindCellPhoneCallsForEmployee[intCounter].Destination;
strTargetName = "UNKNOWN";
intCallMinutes = TheFindCellPhoneCallsForEmployeeDataSet.FindCellPhoneCallsForEmployee[intCounter].CallMinutes;
strLastFour = strTargetNumber.Substring(6, 4);
TheFindCellPhoneByLastForDataSet = ThePhoneClass.FindCellPhoneByLastFour(strLastFour);
intRecordsReturned = TheFindCellPhoneByLastForDataSet.FindCellPhoneByLastFour.Rows.Count;
if (strLastFour == "2828")
{
strTargetName = "BLUE JAY COMMUNICATIONS";
}
else if (intRecordsReturned > 0)
{
strTargetName = TheFindCellPhoneByLastForDataSet.FindCellPhoneByLastFour[0].FirstName + " ";
strTargetName += TheFindCellPhoneByLastForDataSet.FindCellPhoneByLastFour[0].LastName;
}
else if (intRecordsReturned < 1)
{
TheFindEmployeeByPhoneNumberDataSet = TheEmployeeClass.FindEmployeeByPhoneNumber(strLastFour);
intRecordsReturned = TheFindEmployeeByPhoneNumberDataSet.FindEmployeeByPhoneNumber.Rows.Count;
if (intRecordsReturned > 0)
{
strEmployeeNumber = TheFindEmployeeByPhoneNumberDataSet.FindEmployeeByPhoneNumber[0].PhoneNumber;
strEmployeeNumber = strEmployeeNumber.Substring(0, 3);
if (strTargetNumber.Contains(strEmployeeNumber) == true)
{
strEmployeeNumber = TheFindEmployeeByPhoneNumberDataSet.FindEmployeeByPhoneNumber[0].PhoneNumber;
strEmployeeNumber = strEmployeeNumber.Substring(4, 3);
if (strTargetNumber.Contains(strEmployeeNumber) == true)
{
strTargetName = TheFindEmployeeByPhoneNumberDataSet.FindEmployeeByPhoneNumber[0].FirstName + " ";
strTargetName += TheFindEmployeeByPhoneNumberDataSet.FindEmployeeByPhoneNumber[0].LastName;
}
}
}
}
CellCallRosterDataSet.cellcallrosterRow NewCallRoster = TheCellCallRosterDataSet.cellcallroster.NewcellcallrosterRow();
NewCallRoster.TransactionDate = datTransactionDate;
NewCallRoster.PhoneNumber = strPhoneNumber;
NewCallRoster.FullName = gstrFullName;
NewCallRoster.TargetNumber = strTargetNumber;
NewCallRoster.Destination = strDestination;
NewCallRoster.TargetName = strTargetName;
NewCallRoster.CallMinutes = intCallMinutes;
TheCellCallRosterDataSet.cellcallroster.Rows.Add(NewCallRoster);
}
}
}
else if (gblnEmployeeSearch == false)
{
TheFindCellPhoneCallsByCallerDataSet = TheCellPhoneCallsClass.FindCellPhoneCallsByCaller(gdatStartDate, gdatEndDate, gstrLastFour);
intNumberOfRecords = TheFindCellPhoneCallsByCallerDataSet.FindCellPhoneCallsByCaller.Rows.Count;
if (intNumberOfRecords > 0)
{
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
datTransactionDate = TheFindCellPhoneCallsByCallerDataSet.FindCellPhoneCallsByCaller[intCounter].TransactionDate;
strPhoneNumber = TheFindCellPhoneCallsByCallerDataSet.FindCellPhoneCallsByCaller[intCounter].PhoneNumber;
strFullName = TheFindCellPhoneCallsByCallerDataSet.FindCellPhoneCallsByCaller[intCounter].FirstName + " ";
strFullName += TheFindCellPhoneCallsByCallerDataSet.FindCellPhoneCallsByCaller[intCounter].LastName;
strTargetNumber = TheFindCellPhoneCallsByCallerDataSet.FindCellPhoneCallsByCaller[intCounter].TransactionNumber;
strDestination = TheFindCellPhoneCallsByCallerDataSet.FindCellPhoneCallsByCaller[intCounter].Destination;
strTargetName = "UNKNOWN";
intCallMinutes = TheFindCellPhoneCallsByCallerDataSet.FindCellPhoneCallsByCaller[intCounter].CallMinutes;
strLastFour = strTargetNumber.Substring(6, 4);
TheFindCellPhoneByLastForDataSet = ThePhoneClass.FindCellPhoneByLastFour(strLastFour);
intRecordsReturned = TheFindCellPhoneByLastForDataSet.FindCellPhoneByLastFour.Rows.Count;
if (strLastFour == "2828")
{
strTargetName = "BLUE JAY COMMUNICATIONS";
}
else if (intRecordsReturned > 0)
{
strTargetName = TheFindCellPhoneByLastForDataSet.FindCellPhoneByLastFour[0].FirstName + " ";
strTargetName += TheFindCellPhoneByLastForDataSet.FindCellPhoneByLastFour[0].LastName;
}
else if (intRecordsReturned < 1)
{
TheFindEmployeeByPhoneNumberDataSet = TheEmployeeClass.FindEmployeeByPhoneNumber(strLastFour);
intRecordsReturned = TheFindEmployeeByPhoneNumberDataSet.FindEmployeeByPhoneNumber.Rows.Count;
if (intRecordsReturned > 0)
{
strEmployeeNumber = TheFindEmployeeByPhoneNumberDataSet.FindEmployeeByPhoneNumber[0].PhoneNumber;
strEmployeeNumber = strEmployeeNumber.Substring(0, 3);
if (strTargetNumber.Contains(strEmployeeNumber) == true)
{
strEmployeeNumber = TheFindEmployeeByPhoneNumberDataSet.FindEmployeeByPhoneNumber[0].PhoneNumber;
strEmployeeNumber = strEmployeeNumber.Substring(4, 3);
if (strTargetNumber.Contains(strEmployeeNumber) == true)
{
strTargetName = TheFindEmployeeByPhoneNumberDataSet.FindEmployeeByPhoneNumber[0].FirstName + " ";
strTargetName += TheFindEmployeeByPhoneNumberDataSet.FindEmployeeByPhoneNumber[0].LastName;
}
}
}
}
CellCallRosterDataSet.cellcallrosterRow NewCallRoster = TheCellCallRosterDataSet.cellcallroster.NewcellcallrosterRow();
NewCallRoster.TransactionDate = datTransactionDate;
NewCallRoster.PhoneNumber = strPhoneNumber;
NewCallRoster.FullName = strFullName;
NewCallRoster.TargetNumber = strTargetNumber;
NewCallRoster.Destination = strDestination;
NewCallRoster.TargetName = strTargetName;
NewCallRoster.CallMinutes = intCallMinutes;
TheCellCallRosterDataSet.cellcallroster.Rows.Add(NewCallRoster);
}
}
}
dgrCellCalls.ItemsSource = TheCellCallRosterDataSet.cellcallroster;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Cell Phone Call Search // Process Button " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void expFindMessages_Expanded(object sender, RoutedEventArgs e)
{
//setting up local variables
bool blnFatalError = false;
bool blnThereIsAProblem = false;
string strErrorMessage = "";
string strValueForValidation;
int intCounter;
int intNumberOfRecords;
string strLastFour;
string strRespondent;
DateTime datTransactionDate;
string strPhoneNumber;
string strTransactionNumber;
string strMessageDirection;
string strMessageType;
int intRecordsReturned;
bool blnItemFound;
try
{
expFindMessages.IsExpanded = false;
if (cboReportType.SelectedIndex < 1)
{
blnFatalError = true;
strErrorMessage += "The Report Type Was Not Selected\n";
}
strValueForValidation = txtStartDate.Text;
blnThereIsAProblem = TheDataValidationClass.VerifyDateData(strValueForValidation);
if (blnThereIsAProblem == true)
{
blnFatalError = true;
strErrorMessage += "The Start Date Is Not a Date\n";
}
else
{
gdatStartDate = Convert.ToDateTime(strValueForValidation);
}
strValueForValidation = txtEndDate.Text;
blnThereIsAProblem = TheDataValidationClass.VerifyDateData(strValueForValidation);
if (blnThereIsAProblem == true)
{
blnFatalError = true;
strErrorMessage += "The End Date Is Not a Date\n";
}
else
{
gdatEndDate = Convert.ToDateTime(strValueForValidation);
}
if (cboReportType.SelectedIndex == 1)
{
if (gstrTransactionNumber.Length != 4)
{
blnFatalError = true;
strErrorMessage += "The Number Of Digits is not Correct\n";
}
}
else if (cboReportType.SelectedIndex == 2)
{
if (cboSelectEmployee.SelectedIndex < 1)
{
blnFatalError = true;
strErrorMessage += "The Employee Was Not Selected\n";
}
}
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage(strErrorMessage);
return;
}
else
{
blnFatalError = TheDataValidationClass.verifyDateRange(gdatStartDate, gdatEndDate);
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage("The Start Date is after the End Date");
return;
}
}
PleaseWait PleaseWait = new PleaseWait();
PleaseWait.Show();
TheMessagesForEmployeeDataSet.messagesforemployee.Rows.Clear();
if (cboReportType.SelectedIndex == 1)
{
TheFindCellPhoneMessagesForNumberDataSet = TheCellPhoneCallsClass.FindCellPhoneMessagesForNumber(gstrTransactionNumber, gdatStartDate, gdatEndDate);
intNumberOfRecords = TheFindCellPhoneMessagesForNumberDataSet.FindCellPhoneMessagesForNumber.Rows.Count;
if (intNumberOfRecords > 0)
{
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
blnItemFound = false;
strRespondent = "UNKNOWN";
datTransactionDate = TheFindCellPhoneMessagesForNumberDataSet.FindCellPhoneMessagesForNumber[intCounter].TransactionDate;
gstrFullName = TheFindCellPhoneMessagesForNumberDataSet.FindCellPhoneMessagesForNumber[intCounter].FirstName + " ";
gstrFullName += TheFindCellPhoneMessagesForNumberDataSet.FindCellPhoneMessagesForNumber[intCounter].LastName;
strPhoneNumber = TheFindCellPhoneMessagesForNumberDataSet.FindCellPhoneMessagesForNumber[intCounter].PhoneNumber;
strTransactionNumber = TheFindCellPhoneMessagesForNumberDataSet.FindCellPhoneMessagesForNumber[intCounter].TransactionNumber;
strLastFour = strTransactionNumber.Substring(8, 4);
strMessageDirection = TheFindCellPhoneMessagesForNumberDataSet.FindCellPhoneMessagesForNumber[intCounter].MessageDirection;
strMessageType = TheFindCellPhoneMessagesForNumberDataSet.FindCellPhoneMessagesForNumber[intCounter].MessageType;
TheFindCellPhoneByLastForDataSet = ThePhonesClass.FindCellPhoneByLastFour(strLastFour);
intRecordsReturned = TheFindCellPhoneByLastForDataSet.FindCellPhoneByLastFour.Rows.Count;
if (intRecordsReturned > 0)
{
strRespondent = TheFindCellPhoneByLastForDataSet.FindCellPhoneByLastFour[0].FirstName + " ";
strRespondent += TheFindCellPhoneByLastForDataSet.FindCellPhoneByLastFour[0].LastName;
blnItemFound = true;
}
if (blnItemFound == false)
{
TheFindEmployeeBylastFourPhoneDigitsDataSet = TheEmployeeClass.FindEmployeeByLastFourPhoneDigits(strLastFour);
intRecordsReturned = TheFindEmployeeBylastFourPhoneDigitsDataSet.FindEmployeeByLastFourPhoneDigits.Rows.Count;
if (intRecordsReturned > 0)
{
if (strTransactionNumber == TheFindEmployeeBylastFourPhoneDigitsDataSet.FindEmployeeByLastFourPhoneDigits[0].PhoneNumber)
{
strRespondent = TheFindEmployeeBylastFourPhoneDigitsDataSet.FindEmployeeByLastFourPhoneDigits[0].FirstName + " ";
strRespondent += TheFindEmployeeBylastFourPhoneDigitsDataSet.FindEmployeeByLastFourPhoneDigits[0].LastName;
}
}
}
MessagesForEmployeeDataSet.messagesforemployeeRow NewMessageRow = TheMessagesForEmployeeDataSet.messagesforemployee.NewmessagesforemployeeRow();
NewMessageRow.Employee = gstrFullName;
NewMessageRow.MessageDirection = strMessageDirection;
NewMessageRow.MessageType = strMessageType;
NewMessageRow.PhoneNumber = strPhoneNumber;
NewMessageRow.Respondent = strRespondent;
NewMessageRow.TransactionDate = datTransactionDate;
NewMessageRow.TransactionNumber = strTransactionNumber;
TheMessagesForEmployeeDataSet.messagesforemployee.Rows.Add(NewMessageRow);
}
}
}
else if (cboReportType.SelectedIndex == 2)
{
TheFindCellPhoneMesagesForEmployeeDataSet = TheCellPhoneCallsClass.FindCellPhoneMessagesForEmployee(gintEmployeeID, gdatStartDate, gdatEndDate);
intNumberOfRecords = TheFindCellPhoneMesagesForEmployeeDataSet.FindCellPhoneMessagesForEmployee.Rows.Count;
if (intNumberOfRecords > 0)
{
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
blnItemFound = false;
strRespondent = "UNKNOWN";
datTransactionDate = TheFindCellPhoneMesagesForEmployeeDataSet.FindCellPhoneMessagesForEmployee[intCounter].TransactionDate;
strPhoneNumber = TheFindCellPhoneMesagesForEmployeeDataSet.FindCellPhoneMessagesForEmployee[intCounter].PhoneNumber;
strTransactionNumber = TheFindCellPhoneMesagesForEmployeeDataSet.FindCellPhoneMessagesForEmployee[intCounter].TransactionNumber;
strLastFour = strTransactionNumber.Substring(8, 4);
strMessageDirection = TheFindCellPhoneMesagesForEmployeeDataSet.FindCellPhoneMessagesForEmployee[intCounter].MessageDirection;
strMessageType = TheFindCellPhoneMesagesForEmployeeDataSet.FindCellPhoneMessagesForEmployee[intCounter].MessageType;
TheFindCellPhoneByLastForDataSet = ThePhonesClass.FindCellPhoneByLastFour(strLastFour);
intRecordsReturned = TheFindCellPhoneByLastForDataSet.FindCellPhoneByLastFour.Rows.Count;
if (intRecordsReturned > 0)
{
strRespondent = TheFindCellPhoneByLastForDataSet.FindCellPhoneByLastFour[0].FirstName + " ";
strRespondent += TheFindCellPhoneByLastForDataSet.FindCellPhoneByLastFour[0].LastName;
blnItemFound = true;
}
if (blnItemFound == false)
{
TheFindEmployeeBylastFourPhoneDigitsDataSet = TheEmployeeClass.FindEmployeeByLastFourPhoneDigits(strLastFour);
intRecordsReturned = TheFindEmployeeBylastFourPhoneDigitsDataSet.FindEmployeeByLastFourPhoneDigits.Rows.Count;
if (intRecordsReturned > 0)
{
if (strTransactionNumber == TheFindEmployeeBylastFourPhoneDigitsDataSet.FindEmployeeByLastFourPhoneDigits[0].PhoneNumber)
{
strRespondent = TheFindEmployeeBylastFourPhoneDigitsDataSet.FindEmployeeByLastFourPhoneDigits[0].FirstName + " ";
strRespondent += TheFindEmployeeBylastFourPhoneDigitsDataSet.FindEmployeeByLastFourPhoneDigits[0].LastName;
}
}
}
MessagesForEmployeeDataSet.messagesforemployeeRow NewMessageRow = TheMessagesForEmployeeDataSet.messagesforemployee.NewmessagesforemployeeRow();
NewMessageRow.Employee = gstrFullName;
NewMessageRow.MessageDirection = strMessageDirection;
NewMessageRow.MessageType = strMessageType;
NewMessageRow.PhoneNumber = strPhoneNumber;
NewMessageRow.Respondent = strRespondent;
NewMessageRow.TransactionDate = datTransactionDate;
NewMessageRow.TransactionNumber = strTransactionNumber;
TheMessagesForEmployeeDataSet.messagesforemployee.Rows.Add(NewMessageRow);
}
}
}
dgrCellMessages.ItemsSource = TheMessagesForEmployeeDataSet.messagesforemployee;
PleaseWait.Close();
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Cell Message Search // Find Messages Expander " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void btnProcess_Click(object sender, RoutedEventArgs e)
{
bool blnFatalError = false;
bool blnThereIsAProblem = false;
string strLastFour;
string strErrorMessage = "";
int intRecordsReturned = 0;
try
{
strLastFour = txtLastFour.Text;
if (strLastFour.Length == 4)
{
blnThereIsAProblem = TheDataValidationClass.VerifyIntegerRange(strLastFour);
if (blnThereIsAProblem == true)
{
blnFatalError = true;
strErrorMessage += "The Extension Entered is not Numeric\n";
}
else
{
TheFindCellPhoneByLastFourDataSet = ThePhoneClass.FindCellPhoneByLastFour(strLastFour);
intRecordsReturned = TheFindCellPhoneByLastFourDataSet.FindCellPhoneByLastFour.Rows.Count;
if (intRecordsReturned < 1)
{
blnFatalError = true;
strErrorMessage += "The Cell Phone Entered was not Found\n";
}
MainWindow.gintPhoneID = TheFindCellPhoneByLastFourDataSet.FindCellPhoneByLastFour[0].PhoneID;
}
if (cboSelectEmployee.SelectedIndex < 1)
{
blnFatalError = true;
strErrorMessage += "The Employee Was Not Selected\n";
}
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage(strErrorMessage);
return;
}
blnFatalError = ThePhoneClass.UpdateCellPhoneUser(MainWindow.gintPhoneID, MainWindow.gintEmployeeID);
if (blnFatalError == true)
{
throw new Exception();
}
blnFatalError = TheCellPhoneHistoryClass.InsertCellPhoneHistory(MainWindow.gintEmployeeID, MainWindow.gintPhoneID, "CHANGED PHONE USER");
if (blnFatalError == true)
{
throw new Exception();
}
TheMessagesClass.InformationMessage("Cell Phone Has Been Assigned");
ResetControls();
}
}
catch (Exception Ex)
{
TheSendEmailClass.SendEventLog("New Blue Jay ERP // Assign Cell Phones // Proces Button " + Ex.Message);
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Assign Cell Phones // Proces Button " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void btnProcess_Click(object sender, RoutedEventArgs e)
{
string strCellNumber;
string strEquipmentNotes;
int intRecordsReturned;
bool blnFatalError = false;
bool blnThereIsAProblem = false;
string strErrorMessage = "";
string strLastFour;
int intPhoneID;
try
{
strCellNumber = txtEnterCellNumber.Text;
blnThereIsAProblem = TheDataValidationClass.VerifyPhoneNumberFormat(strCellNumber);
if (blnThereIsAProblem == true)
{
blnFatalError = true;
strErrorMessage += "The Cell Phone Number is not the Correct Format\n";
}
if (cboSelectEmployee.SelectedIndex < 1)
{
blnFatalError = true;
strErrorMessage += "The Employee Was Not Selected\n";
}
if (cboSelectOffice.SelectedIndex < 1)
{
blnFatalError = true;
strErrorMessage += "The Office was not Selected\n";
}
strEquipmentNotes = txtEquipmentNotes.Text;
if (strEquipmentNotes.Length < 10)
{
blnFatalError = true;
strErrorMessage += "The Equipment Notes are not Long Enought\n";
}
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage(strErrorMessage);
return;
}
strLastFour = strCellNumber.Substring(8, 4);
TheFindCellPhoneByLastFourDataSet = ThePhonesClass.FindCellPhoneByLastFour(strLastFour);
intRecordsReturned = TheFindCellPhoneByLastFourDataSet.FindCellPhoneByLastFour.Rows.Count;
if (intRecordsReturned > 0)
{
TheMessagesClass.ErrorMessage("The Last Four Numbers Of The\nCell Phone Number Exists");
return;
}
blnFatalError = ThePhonesClass.InsertCellPhone(strCellNumber, MainWindow.gintEmployeeID, MainWindow.gintWarehouseID, strEquipmentNotes);
if (blnFatalError == true)
{
throw new Exception();
}
TheFindCellPhoneByLastFourDataSet = ThePhonesClass.FindCellPhoneByLastFour(strCellNumber);
intPhoneID = TheFindCellPhoneByLastFourDataSet.FindCellPhoneByLastFour[0].PhoneID;
blnFatalError = TheCellPhoneHistoryClass.InsertCellPhoneHistory(MainWindow.gintEmployeeID, intPhoneID, "Phone Was Created");
if (blnFatalError == true)
{
throw new Exception();
}
TheMessagesClass.InformationMessage("The Cell Phone Number has been Inserted");
ResetControls();
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Add Cell Phone // Process Button " + Ex.Message);
TheSendEmailClass.SendEventLog(Ex.ToString());
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void expImportExcel_Expanded(object sender, RoutedEventArgs e)
{
Excel.Application xlDropOrder;
Excel.Workbook xlDropBook;
Excel.Worksheet xlDropSheet;
Excel.Range range;
int intColumnRange = 0;
int intCounter;
int intNumberOfRecords;
string strCellNumber;
string strLastFour;
int intPhoneID;
int intEmployeeID;
string strFirstName;
string strLastName;
string strTransactionDate;
DateTime datTransactionDate;
string strGigaBytesUsed;
decimal decGigaBytesUsed;
int intRecordsReturned;
double douDate;
try
{
expImportExcel.IsExpanded = false;
TheImportCellPhoneDataDataSet.importcellphonedata.Rows.Clear();
Microsoft.Win32.OpenFileDialog dlg = new Microsoft.Win32.OpenFileDialog();
dlg.FileName = "Document"; // Default file name
dlg.DefaultExt = ".xlsx"; // Default file extension
dlg.Filter = "Excel (.xlsx)|*.xlsx"; // Filter files by extension
// Show open file dialog box
Nullable <bool> result = dlg.ShowDialog();
// Process open file dialog box results
if (result == true)
{
// Open document
string filename = dlg.FileName;
}
PleaseWait PleaseWait = new PleaseWait();
PleaseWait.Show();
xlDropOrder = new Excel.Application();
xlDropBook = xlDropOrder.Workbooks.Open(dlg.FileName, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
xlDropSheet = (Excel.Worksheet)xlDropOrder.Worksheets.get_Item(1);
range = xlDropSheet.UsedRange;
intNumberOfRecords = range.Rows.Count;
intColumnRange = range.Columns.Count;
for (intCounter = 2; intCounter <= intNumberOfRecords; intCounter++)
{
strCellNumber = Convert.ToString((range.Cells[intCounter, 2] as Excel.Range).Value2).ToUpper();
strTransactionDate = Convert.ToString((range.Cells[intCounter, 6] as Excel.Range).Value2).ToUpper();
strGigaBytesUsed = Convert.ToString((range.Cells[intCounter, 11] as Excel.Range).Value2).ToUpper();
strLastFour = strCellNumber.Substring(8, 4);
if (strLastFour != "5546")
{
TheFindCellPhoneByLastFourDataSet = ThePhonesClass.FindCellPhoneByLastFour(strLastFour);
intRecordsReturned = TheFindCellPhoneByLastFourDataSet.FindCellPhoneByLastFour.Rows.Count;
if (intRecordsReturned < 1)
{
TheMessagesClass.ErrorMessage(strCellNumber + " Cell Number Does Not Exist");
return;
}
intPhoneID = TheFindCellPhoneByLastFourDataSet.FindCellPhoneByLastFour[0].PhoneID;
intEmployeeID = TheFindCellPhoneByLastFourDataSet.FindCellPhoneByLastFour[0].EmployeeID;
strFirstName = TheFindCellPhoneByLastFourDataSet.FindCellPhoneByLastFour[0].FirstName;
strLastName = TheFindCellPhoneByLastFourDataSet.FindCellPhoneByLastFour[0].LastName;
douDate = Convert.ToDouble(strTransactionDate);
datTransactionDate = DateTime.FromOADate(douDate);
decGigaBytesUsed = Convert.ToDecimal(strGigaBytesUsed);
TheFindCellPhoneDataValidationDataSet = TheCellPhoneCallsClass.FindCellPhoneDataValidation(intPhoneID, intEmployeeID, datTransactionDate, decGigaBytesUsed);
intRecordsReturned = TheFindCellPhoneDataValidationDataSet.FindCellPhoneDataValidation.Rows.Count;
if (intRecordsReturned < 1)
{
ImportCellPhoneDataDataSet.importcellphonedataRow NewDataRow = TheImportCellPhoneDataDataSet.importcellphonedata.NewimportcellphonedataRow();
NewDataRow.EmployeeID = intEmployeeID;
NewDataRow.FirstName = strFirstName;
NewDataRow.GigaByteUsed = decGigaBytesUsed;
NewDataRow.LastName = strLastName;
NewDataRow.PhoneID = intPhoneID;
NewDataRow.PhoneNumber = strCellNumber;
NewDataRow.TransactionDate = datTransactionDate;
TheImportCellPhoneDataDataSet.importcellphonedata.Rows.Add(NewDataRow);
}
}
}
dgrCellData.ItemsSource = TheImportCellPhoneDataDataSet.importcellphonedata;
PleaseWait.Close();
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Import Cell Data // Import Excel " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
