protected void btnDownloadImportTemplate_Click(object sender, EventArgs e)
{
string appFolder = Server.MapPath("/" + GeneralPage.GetSettingByCode(ETEMEnums.AppSettings.WebApplicationName).SettingValue);
string resourcesFolder = GeneralPage.GetSettingByCode(ETEMEnums.AppSettings.ResourcesFolderName).SettingValue;
string templateFolder = GeneralPage.GetSettingByCode(ETEMEnums.AppSettings.FolderTemplates).SettingValue;
string templateName = GeneralPage.GetSettingByCode(ETEMEnums.AppSettings.Template_SAP_ProductivityAndScrap).SettingValue;
string templatePath = string.Empty;
if (Directory.Exists(appFolder + "\\" + templateFolder))
{
templatePath = appFolder + "\\" + templateFolder;
}
else if (Directory.Exists(resourcesFolder + "\\" + templateFolder))
{
templatePath = resourcesFolder + "\\" + templateFolder;
}
else
{
this.ownerPage.ShowMSG("Template folder not found!", false);
return;
}
string templateFullName = templatePath + "\\" + templateName;
DirectoryInfo dirInfoTemplates = new DirectoryInfo(resourcesFolder + "\\" + templateFolder + "\\Downloads");
if (!Directory.Exists(dirInfoTemplates.FullName))
{
Directory.CreateDirectory(dirInfoTemplates.FullName);
}
string fileNameOnly = Path.GetFileNameWithoutExtension(templateFullName);
string fileFullNameToDownload = dirInfoTemplates.FullName + "\\" + fileNameOnly + "_" + DateTime.Now.ToString(Constants.DATE_PATTERN_FOR_FILE_SUFFIX) + Constants.FILE_XLSX_EXTENSION;
File.Copy(templateFullName, fileFullNameToDownload);
FileInfo fiFileToDownload = new FileInfo(fileFullNameToDownload);
if (fiFileToDownload.Exists)
{
fiFileToDownload.IsReadOnly = false;
}
string param = "FilePath=" + fileFullNameToDownload + "&ContentType=" + BaseHelper.GetMimeType(Constants.FILE_XLSX_EXTENSION) + "&Delete=true";
this.ownerPage.OpenPageForDownloadFile(Constants.DOWNLOAD_PAGE_PATH, param);
}
protected void btnImport_Click(object sender, EventArgs e)
{
if (!this.ownerPage.CheckUserActionPermission(ETEMEnums.SecuritySettings.ProductivityAndScrapImport, false))
{
return;
}
base.RunJavaScriptModalWindow();
if (this.fuImport.HasFile)
{
string selectedFileMimeType = this.fuImport.PostedFile.ContentType;
string excelMimeType = BaseHelper.GetMimeType(Constants.FILE_XLSX_EXTENSION);
if (!string.Equals(selectedFileMimeType, excelMimeType, StringComparison.InvariantCultureIgnoreCase))
{
this.ownerPage.ShowMSG("Selected file is in incorrect format, it must be Excel-2007 or newer version!", false);
return;
}
string fileFullName = string.Empty;
string folderPath = string.Empty;
folderPath = GeneralPage.GetSettingByCode(ETEMModel.Helpers.ETEMEnums.AppSettings.ResourcesFolderName).SettingValue;
folderPath += "\\CostCalculation\\ProductivityAndScrap\\Import\\" + DateTime.Today.Year + "\\";
if (!Directory.Exists(folderPath))
{
Directory.CreateDirectory(folderPath);
}
fileFullName = folderPath + "\\Import_ProductivityAndScrap_" +
DateTime.Now.ToString(Constants.DATE_PATTERN_FOR_FILE_SUFFIX) +
Constants.FILE_XLSX_EXTENSION;
this.fuImport.PostedFile.SaveAs(fileFullName);
this.ownerPage.CallContext = this.ownerPage.CostCalculationRef.ImportProductivityAndScrapCostData(fileFullName, this.hdnRowMasterKey.Value, this.ownerPage.CallContext);
if (this.ownerPage.CallContext.ResultCode == ETEMEnums.ResultEnum.Success)
{
base.AddMessage(this.lbResultContext, this.ownerPage.CallContext.Message);
this.currentEntity = this.ownerPage.CostCalculationRef.GetProductivityAndScrapById(this.hdnRowMasterKey.Value);
if (this.ownerPage is ProductivityAndScrapList)
{
((ProductivityAndScrapList)this.ownerPage).LoadFilteredList();
}
}
else
{
if (!ShowErrors(new List <CallContext>()
{
this.ownerPage.CallContext
}))
{
return;
}
}
}
else
{
this.ownerPage.ShowMSG("Please select file to import!", false);
}
}
