private List <ExamFormProperty> BindExamFormListObject(DataTable dataTable) { var examFormPropertyList = new List <ExamFormProperty>(); try { if (dataTable.Rows.Count > 0) { for (var j = 0; j < dataTable.Rows.Count; j++) { var objExamFormProperty = new ExamFormProperty { CourseId = Convert.ToInt32(dataTable.Rows[j]["AjCourseId"]), CourseName = Convert.ToString(dataTable.Rows[j]["AjCourseName"]), ExamFormCenter = Convert.ToString(dataTable.Rows[j]["AjExamFormCenter"]), ExamFormDd = Convert.ToString(dataTable.Rows[j]["AjExamFormDD"]), ExamFormId = Convert.ToInt32(dataTable.Rows[j]["AjExamFormId"]), ExamFormKeywords = Convert.ToString(dataTable.Rows[j]["AjExamFormMetaTag"]), ExamFormMetaDesc = Convert.ToString(dataTable.Rows[j]["AjExamFormMetaDesc"]), ExamFormPrice = Convert.ToString(dataTable.Rows[j]["AjExamFormPrice"]), ExamFormResultDate = Convert.ToString(dataTable.Rows[j]["AjExamFormResultDate"]), ExamFormResultDateReamrk = Convert.ToString(dataTable.Rows[j]["AjExamFormResultDateRemark"]), ExamFormResultWebsite = Convert.ToString(dataTable.Rows[j]["AjExamFormResultWebsite"]), ExamFormSaleEndDate = Convert.ToString(dataTable.Rows[j]["AjExamFormSaleEndDate"]), ExamFormSaleEndDateRemark = Convert.ToString(dataTable.Rows[j]["AjExamFormSaleEndDateRemark"]), ExamFormSaleStartDate = Convert.ToString(dataTable.Rows[j]["AjExamFormSaleStartDate"]), ExamFormStatus = Convert.ToBoolean(dataTable.Rows[j]["AjExamFormStatus"]), ExamFormStore = Convert.ToString(dataTable.Rows[j]["AjExamFormStore"]), ExamFormSubject = Convert.ToString(dataTable.Rows[j]["AjExamFormSubject"]), ExamFormSubmitDate = Convert.ToString(dataTable.Rows[j]["AjExamFormSubmitDate"]), ExamFormSubmitDateRemark = Convert.ToString(dataTable.Rows[j]["AjExamFormSubmitDateRemark"]), ExamFormSyllabus = Convert.ToString(dataTable.Rows[j]["AjExamFormSyllabus"]), ExamFormTitle = Convert.ToString(dataTable.Rows[j]["AjExamFormTitle"]), ExamFormUrl = Convert.ToString(dataTable.Rows[j]["AjExamFormUrl"]), ExamFormWebsite = Convert.ToString(dataTable.Rows[j]["AjExamFormWebsite"]), ExamFormYear = Convert.ToString(dataTable.Rows[j]["AjExamFormYear"]), ExamFromSaleStartDateRemark = Convert.ToString(dataTable.Rows[j]["AjExamFormSaleStartDateRemark"]), ExamId = Convert.ToInt32(dataTable.Rows[j]["AjExamId"]), ExamName = Convert.ToString(dataTable.Rows[j]["AjExamName"]) }; examFormPropertyList.Add(objExamFormProperty); } } } catch (Exception ex) { var err = ex.Message; if (ex.InnerException != null) { err = err + " :: Inner Exception :- " + ex.ToString(); } const string addInfo = "Error while executing BindExamFormListObject in Exam.cs :: -> "; var objPub = new ClsExceptionPublisher(); objPub.Publish(err, addInfo); } return(examFormPropertyList); }
public override int UpdateExamFormDetails(ExamFormProperty objExamFormProperty, int modifiedBy, out string errmsg) { _objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure); errmsg = string.Empty; try { _objDataWrapper.AddParameter("@EaxmFormId", objExamFormProperty.ExamFormId); _objDataWrapper.AddParameter("@ExamId", objExamFormProperty.ExamId); _objDataWrapper.AddParameter("@ExamFormUrl", objExamFormProperty.ExamFormUrl); _objDataWrapper.AddParameter("@ExamFormTitle", objExamFormProperty.ExamFormTitle); _objDataWrapper.AddParameter("@ExamFormMetaDesc", objExamFormProperty.ExamFormMetaDesc); _objDataWrapper.AddParameter("@ExamFormMetaTag", objExamFormProperty.ExamFormKeywords); _objDataWrapper.AddParameter("@ExamFormSubject", objExamFormProperty.ExamFormSubject); _objDataWrapper.AddParameter("@ExamFormYear", objExamFormProperty.ExamFormYear); _objDataWrapper.AddParameter("@ExamFormWebsite", objExamFormProperty.ExamFormWebsite); _objDataWrapper.AddParameter("@ExamFormSalesStartDate", objExamFormProperty.ExamFormSaleStartDate); _objDataWrapper.AddParameter("@ExamFormSalesStartDateReamrk", objExamFormProperty.ExamFromSaleStartDateRemark); _objDataWrapper.AddParameter("@ExamFormSalesEndDate", objExamFormProperty.ExamFormSaleEndDate); _objDataWrapper.AddParameter("@ExamFormSalesEndDateReamrk", objExamFormProperty.ExamFormSaleEndDateRemark); _objDataWrapper.AddParameter("@ExamFormSubmitDate", objExamFormProperty.ExamFormSubmitDate); _objDataWrapper.AddParameter("@ExamFormSubmitDateReamrk", objExamFormProperty.ExamFormSubmitDateRemark); _objDataWrapper.AddParameter("@ExamFormResultDate", objExamFormProperty.ExamFormResultDate); _objDataWrapper.AddParameter("@ExamFormResultDateRemark", objExamFormProperty.ExamFormResultDateReamrk); _objDataWrapper.AddParameter("@ExamFormResultWebsite", objExamFormProperty.ExamFormResultWebsite); _objDataWrapper.AddParameter("@ExamFormPrice", objExamFormProperty.ExamFormPrice); _objDataWrapper.AddParameter("@ExamFormStore", objExamFormProperty.ExamFormStore); _objDataWrapper.AddParameter("@ExamFromCenter", objExamFormProperty.ExamFormCenter); _objDataWrapper.AddParameter("@ExamFromDD", objExamFormProperty.ExamFormDd); _objDataWrapper.AddParameter("@ExamFromSyllabus", objExamFormProperty.ExamFormSyllabus); _objDataWrapper.AddParameter("@CreatedBy", modifiedBy); _objDataWrapper.AddParameter("@AjExamFormStatus", objExamFormProperty.ExamFormStatus); var objErrmsg = (SqlParameter) (_objDataWrapper.AddParameter("@ErrMsg", "", SqlDbType.VarChar, ParameterDirection.Output, 128)); _i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_InsertUpdateExamFormDetails"); if (objErrmsg != null && objErrmsg.Value != null) { errmsg = Convert.ToString(objErrmsg.Value); } } catch (Exception ex) { var err = ex.Message; if (ex.InnerException != null) { err = err + " :: Inner Exception :- " + ex.ToString(); } const string addInfo = "Error while executing UpdateExamFormDetails in Exam.cs :: -> "; var objPub = new ClsExceptionPublisher(); objPub.Publish(err, addInfo); } return(_i); }
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); } }
protected void btnExamForm_Click(object sender, EventArgs e) { string ErrorMsg = ""; try { var objExamFormProperty = new ExamFormProperty(); objExamFormProperty.ExamId = Convert.ToInt32(ddlExamName.SelectedValue.ToString()); objExamFormProperty.ExamFormUrl = Convert.ToString(txtExamFormUrl.Text.Trim()); objExamFormProperty.ExamFormTitle = Convert.ToString(txtFormtitle.Text.Trim()); objExamFormProperty.ExamFormMetaDesc = Convert.ToString(txtFormMetaDesc.Text.Trim()); objExamFormProperty.ExamFormKeywords = Convert.ToString(txtFormMataTag.Text.Trim()); objExamFormProperty.ExamFormSubject = Convert.ToString(txtFormSubject.Text.Trim()); objExamFormProperty.ExamFormYear = Convert.ToString(txtFormYear.Text.Trim()); objExamFormProperty.ExamFormWebsite = Convert.ToString(txtFormWebsite.Text.Trim()); if (rbtFormSaleDate.SelectedValue == "1") { objExamFormProperty.ExamFormSaleStartDate = Convert.ToString(txtSaleExectStartDate1.Text.Trim()); } else { objExamFormProperty.ExamFormSaleStartDate = Convert.ToString(txtSaleNotExectStartDate1.Text.Trim()) + "," + Convert.ToString(txtSaleNotExectEndDate1.Text.Trim()); } objExamFormProperty.ExamFromSaleStartDateRemark = Convert.ToString(txtFormSaleStartDateRemark.Text.Trim()); if (rbtFormSaleEndDate.SelectedValue == "1") { objExamFormProperty.ExamFormSaleEndDate = Convert.ToString(txtSaleExectEndDate2.Text.Trim()); } else { objExamFormProperty.ExamFormSaleEndDate = Convert.ToString(txtSaleNotExectStartDate2.Text.Trim()) + "," + Convert.ToString(txtSaleNotExectEndDate2.Text.Trim()); } objExamFormProperty.ExamFormSaleEndDateRemark = Convert.ToString(txtFormSaleEndDateRemark.Text.Trim()); if (rbtFormSubmitDate.SelectedValue == "1") { objExamFormProperty.ExamFormSubmitDate = Convert.ToString(txtFormSubmitExectDate1.Text.Trim()); } else { objExamFormProperty.ExamFormSubmitDate = Convert.ToString(txtFormSubmitStartDate1.Text.Trim()) + "," + Convert.ToString(txtFormSubmitEndDate1.Text.Trim()); } objExamFormProperty.ExamFormSubmitDateRemark = Convert.ToString(txtFormSubmitDateRemark.Text.Trim()); if (rbtResultDate.SelectedValue == "1") { objExamFormProperty.ExamFormResultDate = Convert.ToString(txtResultExactDate.Text.Trim()); } else { objExamFormProperty.ExamFormResultDate = Convert.ToString(txtResultStartDate.Text.Trim()) + "," + Convert.ToString(txtResultEndtDate.Text.Trim()); } objExamFormProperty.ExamFormResultDateReamrk = Convert.ToString(txtResultDateRemark.Text.Trim()); objExamFormProperty.ExamFormResultWebsite = Convert.ToString(txtFormResultWebsite.Text.Trim()); objExamFormProperty.ExamFormPrice = Convert.ToString(txtExamFormPrice.Text.Trim()); objExamFormProperty.ExamFormStore = Convert.ToString(txtExamFormStore.Text.Trim()); objExamFormProperty.ExamFormCenter = Convert.ToString(txtExamFormCenter.Text.Trim()); objExamFormProperty.ExamFormDd = Convert.ToString(txtExamFormDD.Text.Trim()); objExamFormProperty.ExamFormSyllabus = Convert.ToString(txtExamFormSyllabus.Text.Trim()); objExamFormProperty.ExamFormStatus = chkFormStatus.Checked == true ? true : false; int insert = 0; if (btnExamForm.Text == "Add") { insert = ExamProvider.Instance.InsertExamFormDetails(objExamFormProperty, LoggedInUserId, out ErrorMsg); Response.Redirect("ManageExamFormMaster.aspx", true); } else { objExamFormProperty.ExamFormId = Convert.ToInt32(Request.QueryString["ExamFormId"].ToString()); insert = ExamProvider.Instance.UpdateExamFormDetails(objExamFormProperty, LoggedInUserId, out ErrorMsg); btnExamForm.Text = "Add"; Response.Redirect("ManageExamFormMaster.aspx", false); lblInsertUpdate.Text = "Insert"; lblHeader.Text = "Add Exam Form Master"; } if (insert > 0) { lblSeccessMsg.Visible = true; lblSeccessMsg.Text = ErrorMsg; } else { lblErorrMsg.Visible = true; lblErorrMsg.Text = ErrorMsg; } } catch (Exception ex) { var err = ex.Message; if (ex.InnerException != null) { err = err + " :: Inner Exception :- " + ex.InnerException.Message; } const string addInfo = "Error while executing InsertStateDetails in State.cs :: -> "; var objPub = new ClsExceptionPublisher(); objPub.Publish(err, addInfo); } }
public abstract int UpdateExamFormDetails(ExamFormProperty objExamFormProperty, int modifiedBy, out string errmsg);
public abstract int InsertExamFormDetails(ExamFormProperty objExamFormProperty, int createdBy, out string errmsg);