private void btnCreateTempExcel_Click(object sender, System.EventArgs e)
{
try
{
ExcelInputInfoModel.Port = tbPort.Text.ParseToInt().Value - 1;
ExcelInputInfoModel.Supplier = tbSupplier.Text.ParseToInt().Value - 1;
ExcelInputInfoModel.Product = tbProduct.Text.ParseToInt().Value - 1;
ExcelInputInfoModel.Quantity = tbQuantity.Text.ParseToInt().Value - 1;
ExcelInputInfoModel.Date = tbDate.Text.ParseToInt().Value - 1;
ExcelInputInfoModel.VehicleNumber = tbVehicleNumber.Text.ParseToInt().Value - 1;
ExcelInputInfoModel.TTNNumber = tbTTNNumber.Text.ParseToInt().Value - 1;
ExcelInputInfoModel.Contract = tbContact.Text.ParseToInt().Value - 1;
ExcelInputInfoModel.SheetNumber = tbSheetNumber.Text.ParseToInt().Value - 1;
ExcelInputInfoModel.StartRowNumber = tbStartRowNumber.Text.ParseToInt().Value - 1;
}
catch (Exception ex)
{
MessageBox.Show(this, Constants.ParamsInputErrorMessage, Constants.ErrorMessage);
return;
}
if (String.IsNullOrEmpty(ExcelInputInfoModel.InputFilePath) ||
String.IsNullOrEmpty(ExcelInputInfoModel.OutputTempFolderPath))
{
MessageBox.Show(this, Constants.InputFileAndDirectoryExistanceErrorMessage, Constants.ErrorMessage);
return;
}
try
{
SupplierContractsOutputList = _excelService.CreateTempExcelFile(ExcelInputInfoModel);
}
catch (Exception ex)
{
FormsLogger.FormsLoggerInstance.Error(ex);
MessageBox.Show(this, Constants.InputExcelErrorMessage, Constants.ErrorMessage);
return;
}
_excelapp = new Excel.Application
{
Visible = true
};
var excelappworkbook = _excelapp.Workbooks.Open(Path.Combine(ExcelInputInfoModel.OutputTempFolderPath, FileContants.TEMP_EXCEL_FILE_NAME),
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing);
var excelsheets = excelappworkbook.Worksheets;
_contractsWorksheet = (Excel.Worksheet)excelsheets.Item[1];
_contractsWorksheet.Change += ExcelworksheetOnChange;
}