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!!!"; } }