public FindPhoneForImportDataSet FindPhoneForImport(int intExtension)
{
try
{
aFindPhoneForImportDataSet = new FindPhoneForImportDataSet();
aFindPhoneForImportTableAdapter = new FindPhoneForImportDataSetTableAdapters.FindPhoneForImportTableAdapter();
aFindPhoneForImportTableAdapter.Fill(aFindPhoneForImportDataSet.FindPhoneForImport, intExtension);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Phone Class // Find Phone For Import " + Ex.Message);
}
return(aFindPhoneForImportDataSet);
}
private void expImportCalls_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 strCallType;
string strExtension;
int intExtension;
string strDialedDigits;
string strStartTime;
DateTime datStartTime;
string strCallDuration;
int intPhoneID;
int intEmployeeID;
string strFirstName;
string strLastName;
int intRecordsReturned;
double douDate;
bool blnIsNotNumeric;
double douTime;
try
{
expImportCalls.IsExpanded = false;
TheImportedPhoneCallsDataSet.importedphonecalls.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 = 1; intCounter <= intNumberOfRecords; intCounter++)
{
strCallType = Convert.ToString((range.Cells[intCounter, 1] as Excel.Range).Value2).ToUpper();
strExtension = Convert.ToString((range.Cells[intCounter, 2] as Excel.Range).Value2).ToUpper();
strDialedDigits = Convert.ToString((range.Cells[intCounter, 4] as Excel.Range).Value2).ToUpper();
strStartTime = Convert.ToString((range.Cells[intCounter, 5] as Excel.Range).Value2).ToUpper();
strCallDuration = Convert.ToString((range.Cells[intCounter, 6] as Excel.Range).Value2).ToUpper();
blnIsNotNumeric = TheDataValidationClass.VerifyIntegerData(strExtension);
if (blnIsNotNumeric == false)
{
intExtension = Convert.ToInt32(strExtension);
TheFindPhoneForImportDataSet = ThePhonesClass.FindPhoneForImport(intExtension);
intRecordsReturned = TheFindPhoneForImportDataSet.FindPhoneForImport.Rows.Count;
if (intRecordsReturned > 0)
{
intPhoneID = TheFindPhoneForImportDataSet.FindPhoneForImport[0].TransactionID;
intEmployeeID = TheFindPhoneForImportDataSet.FindPhoneForImport[0].EmployeeID;
TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intEmployeeID);
strFirstName = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName;
strLastName = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].LastName;
douDate = Convert.ToDouble(strStartTime);
datStartTime = DateTime.FromOADate(douDate);
douTime = Convert.ToDouble(strCallDuration);
TimeSpan tspInterval = TimeSpan.FromDays(douTime);
strCallDuration = tspInterval.ToString();
ImportedPhoneCallsDataSet.importedphonecallsRow NewCallRow = TheImportedPhoneCallsDataSet.importedphonecalls.NewimportedphonecallsRow();
NewCallRow.CallDuration = strCallDuration;
NewCallRow.CallType = strCallType;
NewCallRow.DialedDigits = strDialedDigits;
NewCallRow.PhoneExtension = intExtension;
NewCallRow.EmployeeID = intEmployeeID;
NewCallRow.FirstName = strFirstName;
NewCallRow.LastName = strLastName;
NewCallRow.PhoneID = intPhoneID;
NewCallRow.StartTime = datStartTime;
TheImportedPhoneCallsDataSet.importedphonecalls.Rows.Add(NewCallRow);
}
}
}
dgrPhoneCalls.ItemsSource = TheImportedPhoneCallsDataSet.importedphonecalls;
PleaseWait.Close();
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Import Phone Calls // Import Excel " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
