private void InsertFaqDetails() { try { string errMsg; _objFaqDetailsProperty = new FAQDetailsProperty { FAQDetailsAnswer = txtFAQDetailsAnswer.Text.Trim(), FAQDetailsQuestion = txtFAQQuestion.Text.Trim(), FAQCategoryId = ddlFAQCategoryId.SelectedIndex, FAQDetailsStatus = chkFAQDetailsStatus.Checked }; var result = FAQProvider.Instance.InsertFAQDetails(_objFaqDetailsProperty, LoggedInUserId, out errMsg); if (result > 0) { Response.Redirect("FAQDetails.aspx"); } } catch (Exception ex) { var err = ex.Message; if (ex.InnerException != null) { err = err + " :: Inner Exception :- " + ex.InnerException.Message; } const string addInfo = "Error while executing InsertFaqDetails in AddFAQDetails.aspx :: -> "; var objPub = new ClsExceptionPublisher(); objPub.Publish(err, addInfo); } }
public override int UpdateFAQDetails(FAQDetailsProperty objFAQDetailsProperty, int modifiedBy, out string errmsg) { _objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure); errmsg = ""; try { _objDataWrapper.AddParameter("@FAQDetailsId", objFAQDetailsProperty.FAQDetailsId); _objDataWrapper.AddParameter("@FAQQuestion", objFAQDetailsProperty.FAQDetailsQuestion); _objDataWrapper.AddParameter("@FAQCategoryId", objFAQDetailsProperty.FAQCategoryId); _objDataWrapper.AddParameter("@FAQAnswer", objFAQDetailsProperty.FAQDetailsAnswer); _objDataWrapper.AddParameter("@FAqQDetailsStatus", objFAQDetailsProperty.FAQDetailsStatus); _objDataWrapper.AddParameter("@CreatedBy", modifiedBy); var errMsg = (SqlParameter)(_objDataWrapper.AddParameter("@ErrMsg", "", SqlDbType.VarChar, ParameterDirection.Output, 128)); _i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_InsertUpdateFAQDetails"); if (errMsg != null && errMsg.Value != null) { errmsg = Convert.ToString(errMsg.Value); } } catch (Exception ex) { var err = ex.Message; if (ex.InnerException != null) { err = err + " :: Inner Exception :- " + ex.ToString(); } const string addInfo = "Error while executing UpdateFAQDetails in FAQ.cs :: -> "; var objPub = new ClsExceptionPublisher(); objPub.Publish(err, addInfo); } return(_i); }
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); } }
private List <FAQDetailsProperty> BindFAQDetailsObjectList(DataTable datatable) { var objFAQDetailsList = new List <FAQDetailsProperty>(); try { if (datatable != null && datatable.Rows.Count > 0) { for (var j = 0; j < datatable.Rows.Count; j++) { var objFAQDetails = new FAQDetailsProperty { FAQCategoryId = Convert.ToInt32(datatable.Rows[j]["AjFaqCategoryId"]), FAQCategoryName = Convert.ToString(datatable.Rows[j]["AjFaqCategoryName"]), FAQDetailsAnswer = Convert.ToString(datatable.Rows[j]["AjFaqAnswer"]), FAQDetailsId = Convert.ToInt32(datatable.Rows[j]["AjFaqId"]), FAQDetailsQuestion = Convert.ToString(datatable.Rows[j]["AjFaqName"]), FAQDetailsStatus = Convert.ToBoolean(datatable.Rows[j]["AjFaqDetailsStatus"]) }; objFAQDetailsList.Add(objFAQDetails); } } } catch (Exception ex) { var err = ex.Message; if (ex.InnerException != null) { err = err + " :: Inner Exception :- " + ex.ToString(); } const string addInfo = "Error while executing BindFAQDetailsObjectList in FAQ.cs :: -> "; var objPub = new ClsExceptionPublisher(); objPub.Publish(err, addInfo); } return(objFAQDetailsList); }
public abstract int UpdateFAQDetails(FAQDetailsProperty objFAQDetailsProperty, int modifiedBy, out string errmsg);
public abstract int InsertFAQDetails(FAQDetailsProperty objFAQDetailsProperty, int createdBy, out string errmsg);