private void btnBrowseFileContact_Click(object sender, EventArgs e)
{
try
{
// browse excel import file
OpenFileDialog objOpenFile = new OpenFileDialog();
objOpenFile.Title = "Select an import excel file";
objOpenFile.InitialDirectory = @"c:\";
objOpenFile.Filter = "Excel files (*.xls;*.xlsx)|*.xls;*.xlsx";
objOpenFile.FilterIndex = 2;
objOpenFile.RestoreDirectory = true;
if (objOpenFile.ShowDialog() == DialogResult.OK)
tbxImportFileContact.Text = objOpenFile.FileName;
else
return;
m_objFileHandlerContact = null;
m_objFileHandlerContact = new ObjectFileHandler();
List<string> ExcelSheetNames = new List<string>();
gcMatchedColumnContact.DataSource = null;
cboSheetNameContact.Properties.Items.Clear();
lblRecordStatisticContact.Text = " Number of Records: 0";
WaitDialog.Show("Pulling import file...");
// create temporary copy for importing
if (File.Exists(m_sFileNameContact) && m_sFileNameContact.Length > 0)
File.Delete(m_sFileNameContact);
string _TempFileName = Path.GetFileName(tbxImportFileContact.Text);
string _TempFilePath = tbxImportFileContact.Text.Replace(_TempFileName, "");
m_sFileNameContact = _TempFilePath + "tmp_" + _TempFileName;
if (File.Exists(m_sFileNameContact))
File.Delete(m_sFileNameContact);
File.Copy(tbxImportFileContact.Text, m_sFileNameContact);
// populate sheet name combo box
if (m_objFileHandlerContact.OpenExcelFile(m_sFileNameContact))
{
ExcelSheetNames = m_objFileHandlerContact.GetImportFileSheetNames(m_sFileNameContact);
m_objFileHandlerContact.CloseExcelFile();
}
else
{
tbxImportFileContact.Text = "";
WaitDialog.Close();
MessageBox.Show("Not a valid excel file", "Bright Manager", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
foreach (string SheetName in ExcelSheetNames)
cboSheetNameContact.Properties.Items.Add(SheetName.Replace("$", ""));
cboSheetNameContact.SelectedIndex = 0;
WaitDialog.Close();
gcMatchedColumnContact.DataSource = null;
gcImportFileDataContact.DataSource = null;
btnUpdateToGridContact.Enabled = false;
btnUpdateToMasterDataTableContact.Enabled = false;
}
catch { }
}
/// <summary>
/// Get import file sheet names
/// </summary>
private void GetImportFileSheetNames()
{
WaitDialog.Show("Reading file information ...");
List<string> ExcelSheetNames = new List<string>();
m_objFileHandler = new ObjectFileHandler();
// create a temporary copy of the import file
try {
// delete existing temporary file
if (File.Exists(m_FileName))
File.Delete(m_FileName);
string _TempFileName = Path.GetFileName(txtImportFile.Text);
string _TempFilePath = txtImportFile.Text.Replace(_TempFileName, "");
m_FileName = string.Empty;
m_FileName = String.Format("{0}tmp_{1}", _TempFilePath, _TempFileName);
if (File.Exists(m_FileName))
File.Delete(m_FileName);
File.Copy(txtImportFile.Text, m_FileName);
}
catch (Exception Ex) {
m_FileName = string.Empty;
MessageBox.Show("Was not able to create / delete the temporary file. Please check your path access rights to that file / folder.", "Import File", MessageBoxButtons.OK, MessageBoxIcon.Information);
WaitDialog.Close();
return;
}
if (m_objFileHandler.OpenExcelFile(m_FileName)) {
ExcelSheetNames = m_objFileHandler.GetImportFileSheetNames(m_FileName);
m_objFileHandler.CloseExcelFile();
}
else {
MessageBox.Show("Not a valid excel file", m_MessageBoxCaption, MessageBoxButtons.OK, MessageBoxIcon.Error);
WaitDialog.Close();
return;
}
cboSheetName.Items.Clear();
foreach (string SheetName in ExcelSheetNames)
cboSheetName.Items.Add(SheetName);
WaitDialog.Close();
}
