protected void btnProceed_Click(object sender, EventArgs e) { string folderPath = this.Server.MapPath(@"..\Eligibility\TempDirectory"); try { if (fileUploadExcel.HasFile) { //checking extension if (!(fileUploadExcel.FileName.EndsWith(".xls", StringComparison.OrdinalIgnoreCase) || fileUploadExcel.FileName.EndsWith(".xlsx", StringComparison.OrdinalIgnoreCase))) { lblFileError.Text = "Invalid File Extension."; return; } //code to upload file. CreateFileInServer(folderPath); //checking if data and columns of Excel are valid string proceed = CheckExcelForValidData(folderPath + "\\" + fileUploadExcel.FileName); if (proceed.Equals(string.Empty)) { clsEligibilityRights oImportFromExcel = new clsEligibilityRights(); //string IsExists = string.Empty; string result = string.Empty; //IsExists = oImportFromExcel.CheckTableExists("Prov_Src_" + hidUniID.Value + hidFacID.Value + hidCrID.Value + hidMoLrnID.Value + hidPtrnID.Value + hidBrnID.Value + hidCrPrDetailsID.Value + hidCrPrChID.Value); //if (IsExists.Equals("Successful")) //{ string tablename = string.Empty; tablename = "Prov_Src_" + hidUniID.Value + "_" + hidFacID.Value + "_" + hidCrID.Value + "_" + hidMoLrnID.Value + "_" + hidPtrnID.Value + "_" + hidBrnID.Value + "_" + hidCrPrDetailsID.Value + "_" + hidCrPrChID.Value + "_" + DateTime.Now.ToString("ddMMyyyyHHmmss"); string message = oImportFromExcel.CreateTable(folderPath + "\\" + fileUploadExcel.FileName, tablename.Trim()); if (message.Equals("0")) { result = oImportFromExcel.ConfirmProvisionalANDNonProvisionalEligibilityfromExcel(tablename.Trim(), hidFacID.Value, hidCrID.Value, hidMoLrnID.Value, hidPtrnID.Value, hidBrnID.Value, hidCrPrDetailsID.Value, hidCrPrChID.Value, user.User_ID, hid_fk_AcademicYr_ID.Value, rbtCriteria.SelectedValue); if (result.Equals("Successful")) { lblFileError.Text = "Data updated successfully."; lblFileError.CssClass = "saveNote"; } } else { lblFileError.Text = message; lblFileError.CssClass = "errorNote"; } //} oImportFromExcel = null; } else { FileInfo fi = new FileInfo(folderPath + "\\" + fileUploadExcel.FileName); if (fi.Exists) { fi.Delete(); } lblFileError.Text = proceed; return; } } else { string script = "<script language='javascript'>alert('Please select proper file for Importing data.')</script>"; ClientScript.RegisterStartupScript(GetType(), "PopUp", script); } } catch (Exception ex) { lblFileError.Text = "Error in " + ex.Message; } finally { } }