internal void CreateExcelFile()
{
try
{
xclFile = new Excel.Application();
xclWBook = xclFile.Workbooks.Add(missingValue);
xclSheet = xclWBook.Worksheets.get_Item(1);
xclSheet.Name = "Spoils_Audit";
xclSheet.Cells[1, 1] = "Starting Number";
xclSheet.Cells[1, 2] = "Ending Number";
xclSheet.Cells[1, 3] = "Quantity";
firstFileCreated = true;
xclWBook.SaveAs(GetNewPathName(), Excel.XlFileFormat.xlWorkbookNormal, missingValue, missingValue, missingValue, missingValue,
Excel.XlSaveAsAccessMode.xlExclusive, missingValue, missingValue, missingValue, missingValue, missingValue);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
fileExists = FileSave.AddSuffix(path, ".txt", true);
CloseExcelFile();
}
}
private string GetNewPathName()
{
if (excelFileName == string.Empty)
{
excelFileName = FileSave.AddSuffix(path, ".xls", firstFileCreated);
}
FileInfo fi = new FileInfo(excelFileName);
return(fi.Directory.ToString() + "\\" + fi.Name);
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
string path = lblPath.Content.ToString();
string header = lblHeader.Content.ToString();
DataTable dtAsc = dt2.Clone();
SpoilsData spoilsData = null;
try
{
if (dtAsc.Columns[0].ColumnName == "KEY")
{
FileSave.RemoveDuplicateRows(dt2, "KEY");
dtAsc = FileSave.SortAscending("KEY", dt2);
}
else if (dtAsc.Columns[0].ColumnName == "Count")
{
FileSave.RemoveDuplicateRows(dt2, "Count");
dtAsc = FileSave.SortAscending("Count", dt2);
}
else if (dtAsc.Columns[1].ColumnName == "Sequence")
{
FileSave.RemoveDuplicateRows(dt2, "Sequence");
dtAsc = FileSave.SortAscending("Sequence", dt2);
}
else
{
FileSave.RemoveDuplicateRows(dt2, "Seq");
dtAsc = FileSave.SortAscending("Seq", dt2);
}
string newFilename = FileSave.SaveSpoilsFile(path, dtAsc, header);
var lines = File.ReadAllLines(newFilename);
File.WriteAllLines(newFilename, lines.Take(lines.Length - 1).ToArray());
int recordCount = dtAsc.Rows.Count;
bool isNewMailing = false;
spoilsData = new SpoilsData(dtAsc);
MessageBoxResult processQuestion = MessageBox.Show("Are you processing as new mailing?", "??? IS THIS A NEW MAILING ???", MessageBoxButton.YesNoCancel, MessageBoxImage.Question);
if (processQuestion != MessageBoxResult.Cancel)
{
if (processQuestion == MessageBoxResult.Yes)
{
isNewMailing = true;
isNewMailing = spoilsData.NewMailing;
}
FileInfo emailFile = new FileInfo(newFilename);
FileSave.SendEmail_Outlook(emailFile, isNewMailing, recordCount);
MessageBox.Show(recordCount + " records have been saved! \n\nEmail has been sent.", "'" + recordCount + "'" + " - RECORD(s) EXPORTED", MessageBoxButton.OK);
}
else
{
MessageBox.Show(recordCount + " records have been saved!", "'" + recordCount + "'" + " - RECORD(s) EXPORTED", MessageBoxButton.OK);
}
//spoilsData.PopulateReportDataTable();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
ClearAllData();
ChangeVisibility(true);
}
}