protected void btnUpload_Click(object sender, EventArgs e)
{
hfNumberTab.Value = "2";
if (fuUploader.HasFile)
{
try
{
string[] allowedExtensions = { ".xls" };
string extension = Path.GetExtension(fuUploader.FileName);
if (allowedExtensions.Contains(extension))
{
string fileName = Server.MapPath("~/" + Path.GetFileName(fuUploader.FileName));
fuUploader.SaveAs(fileName);
CCTExcelValidationProvider excelProvider = new CCTExcelValidationProvider();
excelProvider.UpdateDatabase(fileName);
File.Delete(fileName);
lblUploadResult.Text = "The database was succesfully updated!";
lblUploadResult.ForeColor = Color.Black;
}
}
catch (Exception ex)
{
lblUploadResult.Text = string.Format("Error");
lblUploadResult.ForeColor = Color.Red;
}
}
}
protected void btnUpload_Click(object sender, EventArgs e)
{
if (fuUploader.HasFile)
{
try
{
string[] allowedExtensions = { ".xls", ".xlsx" };
string extension = Path.GetExtension(fuUploader.FileName);
if (allowedExtensions.Contains(extension))
{
string fileName = Server.MapPath("~/" + Path.GetFileName(fuUploader.FileName));
fuUploader.SaveAs(fileName);
CCTExcelValidationProvider excelProvider = new CCTExcelValidationProvider();
excelProvider.UpdateDatabase(fileName);
File.Delete(fileName);
lblUploadResult.Text = "The database was succesfully updated!";
}
else
{
lblUploadResult.Text = string.Format("You can't upload file with \"{0}\" extension!!!", extension);
}
}
catch (Exception ex)
{
lblUploadResult.Text = string.Format("Error: {0}", ex.Message);
}
}
else
{
lblUploadResult.Text = "You didn't select a file!!!";
}
}
