protected void BtnUploadClick(object sender, EventArgs e) { _objCommon = new Common(); try { _objFaqDetailsProperty = new FAQDetailsProperty(); var objClsOledbdatalayer = new ClsOleDBDataWrapper(); var path = MapPath(fileUploadExcel.FileName); fileUploadExcel.SaveAs(path); var excelSheets = objClsOledbdatalayer.CountTotalSheets(path); if (excelSheets.Length > 0) { foreach (var t in excelSheets) { var ds = objClsOledbdatalayer.getdata(path, t); if (ds.Tables[0].Rows.Count <= 0) { continue; } for (var j = 0; j <= ds.Tables[0].Rows.Count - 1; j++) { _objFaqDetailsProperty = new FAQDetailsProperty { FAQCategoryId = Convert.ToInt16(ds.Tables[0].Rows[j]["FAQCategoryId"]), FAQDetailsQuestion = ds.Tables[0].Rows[j]["FAQDetailsQuestion"].ToString(), FAQDetailsAnswer = ds.Tables[0].Rows[j]["FAQDetailsAnswer"].ToString(), FAQDetailsStatus = Convert.ToBoolean(ds.Tables[0].Rows[j]["FAQDetailsStatus"].ToString()) }; string errMsg; var result = FAQProvider.Instance.InsertFAQDetails(_objFaqDetailsProperty, LoggedInUserId, out errMsg); if (result <= 0) { continue; } lblRecordsInserted.Text = ""; lblRecordsInserted.Text = j + " row inserted out of " + ds.Tables[0].Rows.Count; } lblSuccess.Text = _objCommon.GetErrorMessage("lblSucessMsg"); lblSuccess.Visible = true; Response.Redirect("FAQDetails.aspx"); } } else { lblError.Text = _objCommon.GetErrorMessage("lblErrMsg"); } } catch (Exception ex) { var err = ex.Message; if (ex.InnerException != null) { err = err + " :: Inner Exception :- " + ex.InnerException.Message; } const string addInfo = "Error while executing BtnUploadClick in AddFAQDetails.aspx :: -> "; var objPub = new ClsExceptionPublisher(); objPub.Publish(err, addInfo); } }
protected void BtnUploadExcel(object sender, EventArgs e) { _objCommon = new Common(); try { var objClsOledbdatalayer = new ClsOleDBDataWrapper(); var path = MapPath(fulUploadExcel.FileName); fulUploadExcel.SaveAs(path); var excelSheets = objClsOledbdatalayer.CountTotalSheets(path); if (excelSheets.Length <= 0) { return; } foreach (string t in excelSheets) { DataSet ds = objClsOledbdatalayer.getdata(path, t); if (ds.Tables[0].Rows.Count > 0) { for (var j = 0; j <= ds.Tables[0].Rows.Count - 1; j++) { var errMsg = ""; _objNoticeDetails = new NoticeDetails { NoticeUrl = ds.Tables[0].Rows[j]["NoticeUrl"].ToString(), NoticeTitle = ds.Tables[0].Rows[j]["NoticeTitle"].ToString(), NoticeSubject = ds.Tables[0].Rows[j]["NoticeSubject"].ToString(), NoticeMetaTag = ds.Tables[0].Rows[j]["NoticeMetaTag"].ToString(), NoticeShortDesc = ds.Tables[0].Rows[j]["NoticeShortDesc"].ToString(), NoticeMetaDesc = ds.Tables[0].Rows[j]["NoticeMetaDesc"].ToString(), NoticeDesc = ds.Tables[0].Rows[j]["NoticeDesc"].ToString(), NoticeStatus = ds.Tables[0].Rows[j]["NoticeStatus"].ToString() == "True" ? true : false, RealtedCollegeId = Convert.ToInt16( ds.Tables[0].Rows[j]["RealtedCollegeId"].ToString()), NoticeImage = ds.Tables[0].Rows[j]["NoticeImage"].ToString(), NoticeTypeId = Convert.ToInt16(ds.Tables[0].Rows[j]["NoticeTypeId"].ToString()) }; var result = NewsArticleNoticeProvider.Instance.InsertNoticeDetails(_objNoticeDetails, LoggedInUserId, out errMsg); } } } } catch (Exception ex) { var err = ex.Message; if (ex.InnerException != null) { err = err + " :: Inner Exception :- " + ex.ToString(); } const string addInfo = "Error while executing in BtnUploadExcel at page AddNoticeDetails.aspx.cs :: -> "; var objPub = new ClsExceptionPublisher(); objPub.Publish(err, addInfo); } }
protected void btnUpload_Click(object sender, EventArgs e) { var errMsg = ""; _objCommon = new Common(); try { var _objUniversityCategoryProperty = new UniversityCategoryProperty(); DataSet _ds = new DataSet(); var _objClsOledbdatalayer = new ClsOleDBDataWrapper(); var excelSheets = new String[0]; string path = MapPath(fileUploadExcel.FileName); fileUploadExcel.SaveAs(path); excelSheets = _objClsOledbdatalayer.CountTotalSheets(path); if (excelSheets.Length > 0) { foreach (string t in excelSheets) { _ds = _objClsOledbdatalayer.getdata(path, t); if (_ds.Tables[0].Rows.Count > 0) { for (int j = 0; j <= _ds.Tables[0].Rows.Count - 1; j++) { _objUniversityCategoryProperty = new UniversityCategoryProperty { UniversityCategoryName = _ds.Tables[0].Rows[j]["UniversityCategoryName"].ToString(), }; int result = UniversityProvider.Instance.InsertUniversityCategoryDetails(_objUniversityCategoryProperty, LoggedInUserId, out errMsg); if (result > 0) { lblRecordsInserted.Text = ""; lblRecordsInserted.Text = j + " row inserted out of " + _ds.Tables[0].Rows.Count; } } lblSuccess.Text = _objCommon.GetErrorMessage("lblSucessMsg"); lblSuccess.Visible = true; BindGetAllUniversityCategoryList(); } } } else { lblError.Text = _objCommon.GetErrorMessage("lblErrMsg"); } } catch (Exception ex) { var err = ex.Message; if (ex.InnerException != null) { err = err + " :: Inner Exception :- " + ex.ToString(); } const string addInfo = "Error while executing btnUpload_Click in Exam.cs :: -> "; var objPub = new ClsExceptionPublisher(); objPub.Publish(err, addInfo); } }
protected void btnUpload_Click1(object sender, EventArgs e) { var errMsg = ""; _objCommon = new Common(); try { _objCollegeAssociationCategoryProperty = new CollegeAssociationCategoryProperty(); DataSet _ds = new DataSet(); var _objClsOledbdatalayer = new ClsOleDBDataWrapper(); var excelSheets = new String[0]; string path = MapPath(fileUploadExcel.FileName); fileUploadExcel.SaveAs(path); excelSheets = _objClsOledbdatalayer.CountTotalSheets(path); if (excelSheets.Length > 0) { foreach (string t in excelSheets) { _ds = _objClsOledbdatalayer.getdata(path, t); if (_ds.Tables[0].Rows.Count > 0) { for (int j = 0; j <= _ds.Tables[0].Rows.Count - 1; j++) { _objCollegeAssociationCategoryProperty = new CollegeAssociationCategoryProperty { AssociationCategoryType = _ds.Tables[0].Rows[j]["AssociationCategoryType"].ToString(), AssociationCategoryStatus = Convert.ToBoolean(_ds.Tables[0].Rows[j]["AssociationCategoryStatus"].ToString()) }; int result = CollegeProvider.Instance.UpdateCollegeAssociationCategoryType(_objCollegeAssociationCategoryProperty, LoggedInUserId, out errMsg); if (result > 0) { lblRecordsInserted.Text = ""; lblRecordsInserted.Text = j + " row inserted out of " + _ds.Tables[0].Rows.Count; } } lblSeccessMsg.Text = _objCommon.GetErrorMessage("lblSucessMsg"); Response.Redirect("CollegeGroupMaster.aspx"); } } } else { lblSeccessMsg.Text = _objCommon.GetErrorMessage("lblErrMsg"); } } catch (Exception ex) { var err = ex.Message; if (ex.InnerException != null) { err = err + " :: Inner Exception :- " + ex.ToString(); } const string addInfo = "Error while executing btnUpload_Click1 in AdminPanel/College/CollegeAssociationGroupMaster.aspx :: -> "; var objPub = new ClsExceptionPublisher(); objPub.Publish(err, addInfo); } }
protected void btnUpload_Click(object sender, EventArgs e) { _objCommon = new Common(); try { _objFaqCategoryProperty = new FAQCategoryProperty(); var objClsOledbdatalayer = new ClsOleDBDataWrapper(); string[] excelSheets; var path = MapPath(fileUploadExcel.FileName); fileUploadExcel.SaveAs(path); excelSheets = objClsOledbdatalayer.CountTotalSheets(path); if (excelSheets.Length > 0) { foreach (var t in excelSheets) { var _ds = objClsOledbdatalayer.getdata(path, t); if (_ds.Tables[0].Rows.Count <= 0) { continue; } for (int j = 0; j <= _ds.Tables[0].Rows.Count - 1; j++) { _objFaqCategoryProperty = new FAQCategoryProperty { FAQCategoryName = _ds.Tables[0].Rows[j]["FAQCategoryName"].ToString(), FAQCategoryStatus = Convert.ToBoolean(_ds.Tables[0].Rows[j]["FAQCategoryStatus"].ToString()) }; var errMsg = ""; int result = FAQProvider.Instance.InsertFAQCategory(_objFaqCategoryProperty, LoggedInUserId, out errMsg); if (result > 0) { lblRecordsInserted.Text = ""; lblRecordsInserted.Text = j + " row inserted out of " + _ds.Tables[0].Rows.Count; } } lblSuccess.Text = _objCommon.GetErrorMessage("lblSucessMsg"); lblSuccess.Visible = true; } } else { lblError.Text = _objCommon.GetErrorMessage("lblErrMsg"); } } catch (Exception ex) { var err = ex.Message; if (ex.InnerException != null) { err = err + " :: Inner Exception :- " + ex.InnerException.Message; } const string addInfo = "Error while executing btnUpload_Click in FAQCategoryMaster.aspx :: -> "; var objPub = new ClsExceptionPublisher(); objPub.Publish(err, addInfo); } }
protected void BtnUploadClick(object sender, EventArgs e) { _objCommon = new Common(); try { _objExamProperty = new ExamProperty(); var _ds = new DataSet(); var objClsOledbdatalayer = new ClsOleDBDataWrapper(); var path = MapPath(fileUploadExcel.FileName); fileUploadExcel.SaveAs(path); var excelSheets = objClsOledbdatalayer.CountTotalSheets(path); if (excelSheets.Length > 0) { foreach (var t in excelSheets) { _ds = objClsOledbdatalayer.getdata(path, t); if (_ds != null && _ds.Tables.Count > 0) { for (int j = 0; j <= _ds.Tables[0].Rows.Count - 1; j++) { _objExamProperty.CourseId = Convert.ToInt32(_ds.Tables[0].Rows[j]["CourseId"]); _objExamProperty.ExamName = Convert.ToString(_ds.Tables[0].Rows[j]["ExamName"]); _objExamProperty.ExamFullName = Convert.ToString(_ds.Tables[0].Rows[j]["ExamFullName"]); _objExamProperty.ExamLogo = Convert.ToString(_ds.Tables[0].Rows[j]["ExamLogo"]); _objExamProperty.ExamDesc = Convert.ToString(_ds.Tables[0].Rows[j]["ExamDesc"]); _objExamProperty.ExamWebSite = Convert.ToString(_ds.Tables[0].Rows[j]["ExamWebsite"]); _objExamProperty.ExamPopularName = Convert.ToString(_ds.Tables[0].Rows[j]["ExamPopularName"]); _objExamProperty.ExamEligiblityCriteria = Convert.ToString(_ds.Tables[0].Rows[j]["ExamEligiblityCriteria"]); _objExamProperty.ExamStatus = Convert.ToBoolean(_ds.Tables[0].Rows[j]["ExamStatus"]); var errMsg = ""; var insert = ExamProvider.Instance.InsertExamDetails(_objExamProperty, 1, out errMsg); if (insert <= 0) { continue; } lblRecordsInserted.Text = ""; lblRecordsInserted.Text = j + " row inserted out of " + _ds.Tables[0].Rows.Count; } } } lblSeccessMsg.Text = _objCommon.GetErrorMessage("lblSucessMsg"); lblSeccessMsg.Visible = true; BindAllCourseList(); } else { lblErorrMsg.Text = _objCommon.GetErrorMessage("lblErrMsg"); } } catch (Exception ex) { } }
//BtnUploadClick1 event to upload course data from excel .. by Indu Kumar Pandey protected void BtnUploadClick1(object sender, EventArgs e) { _objCommon = new Common(); try { var objClsOledbdatalayer = new ClsOleDBDataWrapper(); var path = MapPath(fulUploadExcel.FileName); fulUploadExcel.SaveAs(path); var excelSheets = objClsOledbdatalayer.CountTotalSheets(path); if (excelSheets.Length > 0) { foreach (string t in excelSheets) { DataSet ds = objClsOledbdatalayer.getdata(path, t); if (ds != null && ds.Tables.Count > 0) { for (int j = 0; j <= ds.Tables[0].Rows.Count - 1; j++) { var errMsg = ""; var result = CourseProvider.Instance.InsertCourseMasterDetails(ds.Tables[0].Rows[j]["CourseName"].ToString(), ds.Tables[0].Rows[j]["CourseUrl"].ToString(), ds.Tables[0].Rows[j]["CourseTitle"].ToString(), ds.Tables[0].Rows[j]["CourseMetaTag"].ToString(), ds.Tables[0].Rows[j]["CourseMetaDesc"].ToString(), ds.Tables[0].Rows[j]["CourseDesc"].ToString(), ds.Tables[0].Rows[j]["CourseShortName"].ToString(), ds.Tables[0].Rows[j]["CoursePopularName"].ToString(), Convert.ToInt16( ds.Tables[0].Rows[j]["CourseCategoryId"].ToString ()), Convert.ToInt16( ds.Tables[0].Rows[j]["CourseEligibiltyId"].ToString ()), LoggedInUserId, out errMsg, ds.Tables[0].Rows[j]["AjCourseImage"].ToString(), ds.Tables[0].Rows[j]["HelpLineNo"].ToString(), ds.Tables[0].Rows[j]["CourseStatus"].ToString() == "True" ? true : false); } } } lblExcelSuccess.Text = _objCommon.GetErrorMessage("lblSucessMsg"); lblExcelSuccess.Visible = true; } else { lblError.Text = _objCommon.GetErrorMessage("lblErrMsg"); } } catch (Exception ex) { } }
//code for Excel upload protected void btnUpload_Click(object sender, EventArgs e) { lblSuccess.Visible = false; var errMsg = ""; try { _objCollegeGroupProperty = new CollegeGroupProperty(); _objCommon = new Common(); DataSet _ds = new DataSet(); var _objClsOledbdatalayer = new ClsOleDBDataWrapper(); var excelSheets = new String[0]; string path = MapPath(fileUploadExcel.FileName); fileUploadExcel.SaveAs(path); excelSheets = _objClsOledbdatalayer.CountTotalSheets(path); if (excelSheets.Length > 0) { foreach (string t in excelSheets) { _ds = _objClsOledbdatalayer.getdata(path, t); if (_ds.Tables[0].Rows.Count > 0) { for (int j = 0; j <= _ds.Tables[0].Rows.Count - 1; j++) { _objCollegeGroupProperty = new CollegeGroupProperty { CollegeGroupName = _ds.Tables[0].Rows[j]["CollegeGroupName"].ToString(), CollegeGropuStatus = Convert.ToBoolean(_ds.Tables[0].Rows[j]["CollegeGropuStatus"].ToString()) }; int result = CollegeProvider.Instance.InsertCollegeGroupDetails(_objCollegeGroupProperty, LoggedInUserId, out errMsg); if (result > 0) { lblRecordsInserted.Text = ""; lblRecordsInserted.Text = j + " row inserted out of " + _ds.Tables[0].Rows.Count; } } lblSuccess.Text = _objCommon.GetErrorMessage("lblSucessMsg"); Response.Redirect("CollegeGroupMaster.aspx"); } } } else { lblError.Text = _objCommon.GetErrorMessage("lblErrMsg"); } } catch (Exception ex) { } }
protected void btnUpload_Click(object sender, EventArgs e) { _objCommon = new Common(); try { var objClsOledbdatalayer = new ClsOleDBDataWrapper(); var path = MapPath(fileUploadExcel.FileName); fileUploadExcel.SaveAs(path); var excelSheets = objClsOledbdatalayer.CountTotalSheets(path); if (excelSheets.Length > 0) { foreach (string t in excelSheets) { DataSet _ds = objClsOledbdatalayer.getdata(path, t); if (_ds.Tables[0].Rows.Count > 0) { for (var j = 0; j <= _ds.Tables[0].Rows.Count - 1; j++) { var errMsg = ""; _objStateProperty = new StateProperty { CountryId = Convert.ToInt16(_ds.Tables[0].Rows[j]["CountryId"]), ZoneId = Convert.ToInt16(_ds.Tables[0].Rows[j]["ZoneId"]), StateName = _ds.Tables[0].Rows[j]["StateName"].ToString() }; int _insert = StateProvider.Instance.InsertStateDetails(Convert.ToString(_ds.Tables[0].Rows[j]["StateName"]), Convert.ToInt32(_ds.Tables[0].Rows[j]["ZoneId"]), Convert.ToInt32(_ds.Tables[0].Rows[j]["CountryId"]), LoggedInUserId, out errMsg); } lblMsg.Focus(); lblMsg.Text = _objCommon.GetErrorMessage("lblSucessMsg"); lblMsg.Visible = true; BindAllState(); } } } else { lblErrorMsg.Text = _objCommon.GetErrorMessage("lblErrMsg"); } } catch (Exception ex) { }; }
//event BtnUploadClick to upload stream detials by indu kumar pandey... protected void BtnUploadClick(object sender, EventArgs e) { _objCommon = new Common(); try { var objClsOledbdatalayer = new ClsOleDBDataWrapper(); var path = MapPath(fulUploadExcel.FileName); fulUploadExcel.SaveAs(path); var excelSheets = objClsOledbdatalayer.CountTotalSheets(path); if (excelSheets.Length > 0) { foreach (string t in excelSheets) { DataSet ds = objClsOledbdatalayer.getdata(path, t); if (ds.Tables[0].Rows.Count > 0) { for (var j = 0; j <= ds.Tables[0].Rows.Count - 1; j++) { var errMsg = ""; _objCourseStreamProperty = new CourseStreamProperty { CourseStreamName = Convert.ToString(ds.Tables[0].Rows[j]["AjCourseStreamName"]), CourseId = Convert.ToInt16(ds.Tables[0].Rows[j]["CourseId"]), CourseStreamHistory = Convert.ToString(ds.Tables[0].Rows[j]["AjCourseStreamHistory"]), CourseSteamFuture = Convert.ToString(ds.Tables[0].Rows[j]["AjCourseStreamFuture"]), CourseStreamRelatedIndustry = Convert.ToString(ds.Tables[0].Rows[j]["AjCourseStreamRelatedIndustry"]), CourseStreamStatus = ds.Tables[0].Rows[j]["AjCourseStreamStatus"].ToString() == "True" ? true : false, CourseStreamDesc = Convert.ToString(ds.Tables[0].Rows[j]["AjCourseStreamDesc"]), CourseStreamCoreCompanies = Convert.ToString(ds.Tables[0].Rows[j]["AjCourseStreamCoreCompanies"]) }; var result = StreamProvider.Instance.InsertCourseStreamDetails(_objCourseStreamProperty, LoggedInUserId, out errMsg); } lblSuccess.Text = _objCommon.GetErrorMessage("lblSucessMsg"); Response.Redirect("CourseStreamMaster.aspx"); } } } else { lblError.Text = _objCommon.GetErrorMessage("lblErrMsg"); } } catch (Exception ex) { } }
protected void btnUpload_Click(object sender, EventArgs e) { var errMsg = ""; _objCommon = new Common(); try { _objCountryProperty = new CountryProperty(); DataSet _ds = new DataSet(); var _objClsOledbdatalayer = new ClsOleDBDataWrapper(); var excelSheets = new String[0]; string path = MapPath(fileUploadExcel.FileName); fileUploadExcel.SaveAs(path); excelSheets = _objClsOledbdatalayer.CountTotalSheets(path); if (excelSheets.Length > 0) { foreach (string t in excelSheets) { _ds = _objClsOledbdatalayer.getdata(path, t); if (_ds.Tables[0].Rows.Count > 0) { for (int j = 0; j <= _ds.Tables[0].Rows.Count - 1; j++) { int result = CountryProvider.Instance.InsertCountry(_ds.Tables[0].Rows[j]["CountryName"].ToString(), LoggedInUserId, out errMsg, _ds.Tables[0].Rows[j]["CountryCode"].ToString()); if (result > 0) { lblRecordsInserted.Text = ""; lblRecordsInserted.Text = j + " row inserted out of " + _ds.Tables[0].Rows.Count; } } lblSuccess.Text = _objCommon.GetErrorMessage("lblSucessMsg"); lblSuccess.Visible = true; //CountryMasterBind(); } } } else { lblError.Text = _objCommon.GetErrorMessage("lblErrMsg"); } } catch (Exception ex) { } }
protected void BtnUploadClick(object sender, EventArgs e) { _objCommon = new Common(); try { var objClsOledbdatalayer = new ClsOleDBDataWrapper(); var path = MapPath(fulUploadExcel.FileName); fulUploadExcel.SaveAs(path); var excelSheets = objClsOledbdatalayer.CountTotalSheets(path); if (excelSheets.Length > 0) { foreach (var t in excelSheets) { var ds = objClsOledbdatalayer.getdata(path, t); if (ds.Tables[0].Rows.Count <= 0) { continue; } for (var j = 0; j <= ds.Tables[0].Rows.Count - 1; j++) { string errMsg; NewsArticleNoticeProvider.Instance.InsertNoticeCategory(Convert.ToString(ds.Tables[0].Rows[j]["NoticeCategory"]), ds.Tables[0].Rows[j]["NoticeCategoryStatus"].ToString() == "True", LoggedInUserId, out errMsg); } lblSuccess.Text = _objCommon.GetErrorMessage("lblSucessMsg"); BindNoticeCategory(); } } else { lblError.Text = _objCommon.GetErrorMessage("lblErrMsg"); } } catch (Exception ex) { var err = ex.Message; if (ex.InnerException != null) { err = err + " :: Inner Exception :- " + ex.InnerException.Message; } const string addInfo = "Error while executing BtnUploadClick in CommonWebServices.asmx :: -> "; var objPub = new ClsExceptionPublisher(); objPub.Publish(err, addInfo); } }
protected void BtnUploadClick1(object sender, EventArgs e) { _objCommon = new Common(); try { var objClsOledbdatalayer = new ClsOleDBDataWrapper(); var path = MapPath(fulUploadExcel.FileName); fulUploadExcel.SaveAs(path); var excelSheets = objClsOledbdatalayer.CountTotalSheets(path); if (excelSheets.Length <= 0) { return; } foreach (string t in excelSheets) { DataSet ds = objClsOledbdatalayer.getdata(path, t); if (ds != null && ds.Tables.Count > 0) { for (int j = 0; j <= ds.Tables[0].Rows.Count - 1; j++) { var errMsg = ""; _objNewsDetails = new NewsArticleProperty { NewsSubject = ds.Tables[0].Rows[j]["NewsSubject"].ToString(), NewsUrl = ds.Tables[0].Rows[j]["NewsUrl"].ToString(), NewsTitle = ds.Tables[0].Rows[j]["NewsTitle"].ToString(), NewsTag = ds.Tables[0].Rows[j]["NewsTag"].ToString(), NewsMetaDesc = ds.Tables[0].Rows[j]["NewsMetaDesc"].ToString(), NewsDesc = ds.Tables[0].Rows[j]["NewsDesc"].ToString(), NewsImage = ds.Tables[0].Rows[j]["NewsImage"].ToString(), NewsShortDesc = ds.Tables[0].Rows[j]["NewsShortDesc"].ToString(), NewsStatus = ds.Tables[0].Rows[j]["NewsStatus"].ToString() == "True" ? true : false, NewsBy = ds.Tables[0].Rows[j]["NewsBy"].ToString(), NewsDate = ds.Tables[0].Rows[j]["NewsDate"].ToString() == "" ? DateTime.Now : Convert.ToDateTime(ds.Tables[0].Rows[j]["NewsDate"].ToString()), }; var result = NewsArticleNoticeProvider.Instance.InsertNewsDetails(_objNewsDetails, LoggedInUserId, out errMsg); } } } } catch (Exception EX) { } }
protected void BtnUploadClick(object sender, EventArgs e) { _objCommon = new Common(); try { var _ds = new DataSet(); var _objClsOledbdatalayer = new ClsOleDBDataWrapper(); var excelSheets = new String[0]; var path = MapPath(fulUploadExcel.FileName); fulUploadExcel.SaveAs(path); excelSheets = _objClsOledbdatalayer.CountTotalSheets(path); if (excelSheets.Length > 0) { foreach (string t in excelSheets) { _ds = _objClsOledbdatalayer.getdata(path, t); if (_ds != null && _ds.Tables.Count > 0) { for (int j = 0; j < _ds.Tables[0].Rows.Count - 1; j++) { System.Threading.Thread.Sleep(500); var errMsg = ""; var result = CourseProvider.Instance.InsertCourseCategory(_ds.Tables[0].Rows[j]["CourseCategoryName"].ToString(), out errMsg, LoggedInUserId, _ds.Tables[0].Rows[j]["CourseCategoryStatus"].ToString() == "True" ? true : false); if (result > 0) { exclSuccessCount.SetProgress(j + 1, _ds.Tables[0].Rows.Count - 1); } } lblSuccess.Text = _objCommon.GetErrorMessage("lblSucessMsg"); lblSuccess.Visible = true; BindCourseCategory(); } } } else { lblError.Text = _objCommon.GetErrorMessage("lblErrMsg"); } } catch (Exception ex) { } }
protected void btnUpload_Click(object sender, EventArgs e) { _objCommon = new Common(); try { var objClsOledbdatalayer = new ClsOleDBDataWrapper(); var path = MapPath(fileUploadExcel.FileName); fileUploadExcel.SaveAs(path); var excelSheets = objClsOledbdatalayer.CountTotalSheets(path); if (excelSheets.Length > 0) { foreach (string t in excelSheets) { DataSet ds = objClsOledbdatalayer.getdata(path, t); if (ds.Tables[0].Rows.Count > 0) { for (var j = 0; j <= ds.Tables[0].Rows.Count - 1; j++) { var errMsg = ""; _objZoneProperty = new ZoneProperty { ZoneName = ds.Tables[0].Rows[j]["ZoneName"].ToString(), }; var result = ZoneProvider.Instance.InsertZoneDetails(ds.Tables[0].Rows[j]["ZoneName"].ToString(), LoggedInUserId, out errMsg); } lblMsg.Text = _objCommon.GetErrorMessage("lblSucessMsg"); lblMsg.Visible = true; BindAllZoneList(); } } } else { lblErrorMsg.Text = _objCommon.GetErrorMessage("lblErrMsg"); lblMsg.Visible = false; lblErrorMsg.Visible = true; } } catch (Exception ex) { } }
protected void BtnUploadClick(object sender, ImageClickEventArgs e) { _objCommon = new Common(); var objClsOledbdatalayer = new ClsOleDBDataWrapper(); var path = MapPath(fulUploadExcel.FileName); fulUploadExcel.SaveAs(path); var excelSheets = objClsOledbdatalayer.CountTotalSheets(path); if (excelSheets.Length <= 0) { return; } foreach (DataSet ds in excelSheets.Select(t => objClsOledbdatalayer.getdata(path, t)).Where(ds => ds.Tables[0].Rows.Count > 0)) { for (var j = 0; j <= ds.Tables[0].Rows.Count - 1; j++) { var errMsg = ""; _objUniversityPropertyr = new UniversityProperty { UniversityName = ds.Tables[0].Rows[j]["AjUniversityName"].ToString(), UniversityWebsite = ds.Tables[0].Rows[j]["AjUniversityWebsite"].ToString(), UniversityshortName = ds.Tables[0].Rows[j]["AjUniversityShortName"].ToString(), UniversityPopularName = ds.Tables[0].Rows[j]["AjUniversityPopularName"].ToString(), UniversityPhoneNo = ds.Tables[0].Rows[j]["AJuniversityPhone"].ToString(), UniversityMobile = ds.Tables[0].Rows[j]["AjUniversityMobile"].ToString(), UniversityFax = ds.Tables[0].Rows[j]["AjUniversityFax"].ToString(), UniversityEst = Convert.ToInt32(ds.Tables[0].Rows[j]["AjUniversityEst"].ToString()), UniversityEmailId = ds.Tables[0].Rows[j]["AjUniversityEmailId"].ToString(), UniversityDesc = ds.Tables[0].Rows[j]["AjUniversityDesc"].ToString(), UniversityAddrs = ds.Tables[0].Rows[j]["AjUniversityAddress"].ToString(), UniversityCategoryName = ds.Tables[0].Rows[j]["AjUniversityCategoryId"].ToString(), UniversityCityName = ds.Tables[0].Rows[j]["AjUniversityCityId"].ToString(), UniversityCountryName = ds.Tables[0].Rows[j]["AjUniversityCountryId"].ToString(), UniversityStateName = ds.Tables[0].Rows[j]["AjUniversityStateId"].ToString() }; var result = UniversityProvider.Instance.InsertUniversityDetailsUpload(_objUniversityPropertyr, LoggedInUserId, out errMsg); } Response.Redirect("UniversityMaster.aspx"); } }
protected void BtnUploadClick1(object sender, EventArgs e) { _objCommon = new Common(); try { var objClsOledbdatalayer = new ClsOleDBDataWrapper(); var path = MapPath(fulUploadExcel.FileName); fulUploadExcel.SaveAs(path); var excelSheets = objClsOledbdatalayer.CountTotalSheets(path); if (excelSheets.Length > 0) { foreach (string t in excelSheets) { DataSet ds = objClsOledbdatalayer.getdata(path, t); if (ds != null && ds.Tables.Count > 0) { for (int j = 0; j <= ds.Tables[0].Rows.Count - 1; j++) { var errMsg = ""; _objHostelCategoryProperty = new HostelCategoryProperty { HostelCategoryType = Convert.ToString(ds.Tables[0].Rows[j]["HostelCategoryType"]), HostelCategoryStatus = ds.Tables[0].Rows[j]["HostelCategoryStatus"].ToString() == "True" ? true : false }; } lblSuccess.Text = _objCommon.GetErrorMessage("lblSucessMsg"); lblSuccess.Visible = true; BindHostelTypeDetails(); } } } else { lblError.Text = _objCommon.GetErrorMessage("lblErrMsg"); } } catch (Exception ex) { } }
protected void BtnUploadClick1(object sender, EventArgs e) { _objCommon = new Common(); try { var objClsOledbdatalayer = new ClsOleDBDataWrapper(); var path = MapPath(fulUploadExcel.FileName); fulUploadExcel.SaveAs(path); var excelSheets = objClsOledbdatalayer.CountTotalSheets(path); if (excelSheets.Length > 0) { foreach (var t in excelSheets) { DataSet ds = objClsOledbdatalayer.getdata(path, t); if (ds.Tables[0].Rows.Count <= 0) { continue; } for (var j = 0; j <= ds.Tables[0].Rows.Count - 1; j++) { var errMsg = ""; _objInstituteTypeProperty = new InstituteTypeProperty { InstituteType = Convert.ToString(ds.Tables[0].Rows[j]["InstituteType"]) }; } } lblSuccess.Text = _objCommon.GetErrorMessage("lblSucessMsg"); lblSuccess.Visible = true; BindInstituteTypeDetails(); } else { lblError.Text = _objCommon.GetErrorMessage("lblErrMsg"); } } catch (Exception ex) { } }
protected void btnUpload_Click(object sender, EventArgs e) { Common _objCommon = new Common(); try { var errMsg = ""; DataSet _ds = new DataSet(); var _objClsOledbdatalayer = new ClsOleDBDataWrapper(); var excelSheets = new String[0]; string path = MapPath(fulUploadCollegeImage.FileName); fulUploadCollegeImage.SaveAs(path); excelSheets = _objClsOledbdatalayer.CountTotalSheets(path); if (excelSheets.Length > 0) { foreach (string t in excelSheets) { _ds = _objClsOledbdatalayer.getdata(path, t); if (_ds != null && _ds.Tables.Count > 0) { for (int j = 0; j <= _ds.Tables[0].Rows.Count - 1; j++) { var _insert = _objCommon.UploadCollegeImage(Convert.ToString(_ds.Tables[0].Rows[j]["CollegeName"]), Convert.ToString(_ds.Tables[0].Rows[j]["CollegeImage"])); if (_insert > 0) { } } } } } } catch (Exception ex) { } }
protected void btnUpload_Click(object sender, EventArgs e) { _objCommon = new Common(); try { var objExamFormProperty = new ExamFormProperty(); _objClsOledbdatalayer = new ClsOleDBDataWrapper(); string path = MapPath(fileUploadExcel.FileName); string[] excelSheets = _objClsOledbdatalayer.CountTotalSheets(path); if (excelSheets.Length > 0) { foreach (var ds in excelSheets.Select(t => _objClsOledbdatalayer.getdata(path, t)).Where(_ds => _ds.Tables[0].Rows.Count > 0)) { for (int j = 0; j < ds.Tables[0].Rows.Count - 1; j++) { objExamFormProperty.ExamId = Convert.ToInt32(ds.Tables[0].Rows[j]["ExamId"]); objExamFormProperty.ExamFormUrl = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormUrl"]); objExamFormProperty.ExamFormTitle = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormTitle"]); objExamFormProperty.ExamFormMetaDesc = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormMetaDesc"]); objExamFormProperty.ExamFormKeywords = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormMetaTag"]); objExamFormProperty.ExamFormSubject = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormSubject"]); objExamFormProperty.ExamFormYear = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormYear"]); objExamFormProperty.ExamFormWebsite = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormWebsite"]); objExamFormProperty.ExamFormSaleStartDate = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormSaleStartDate"]); objExamFormProperty.ExamFromSaleStartDateRemark = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormSaleStartDateRemark"]); objExamFormProperty.ExamFormSaleEndDate = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormSaleEndDate"]); objExamFormProperty.ExamFormSaleEndDateRemark = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormSaleEndDateRemark"]); objExamFormProperty.ExamFormSubmitDate = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormSubmitDate"]); objExamFormProperty.ExamFormSubmitDateRemark = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormSubmitDateRemark"]); objExamFormProperty.ExamFormResultDate = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormResultDate"]); objExamFormProperty.ExamFormResultDateReamrk = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormResultDateRemark"]); objExamFormProperty.ExamFormResultWebsite = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormResultWebsite"]); objExamFormProperty.ExamFormPrice = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormPrice"]); objExamFormProperty.ExamFormStore = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormStore"]); objExamFormProperty.ExamFormCenter = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormCenter"]); objExamFormProperty.ExamFormDd = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormDD"]); objExamFormProperty.ExamFormSyllabus = Convert.ToString(ds.Tables[0].Rows[j]["ExamFormSyllabus"]); objExamFormProperty.ExamFormStatus = Convert.ToBoolean(ds.Tables[0].Rows[j]["ExamFormStatus"]); var errMsg = ""; var _insert = ExamProvider.Instance.InsertExamFormDetails(objExamFormProperty, LoggedInUserId, out errMsg); } lblSeccessMsg.Text = _objCommon.GetErrorMessage("lblSucessMsg"); lblSeccessMsg.Visible = true; Response.Redirect("ManageExamFormMaster.aspx", true); } } else { lblErorrMsg.Visible = true; lblErorrMsg.Text = _objCommon.GetErrorMessage("lblErrMsg"); } } catch (Exception ex) { string err = ex.Message; if (ex.InnerException != null) { err = err + " :: Inner Exception :- " + ex.InnerException.Message; } string addInfo = "Error :: -> "; ClsExceptionPublisher objPub = new ClsExceptionPublisher(); objPub.Publish(err, addInfo); } }