protected void UpdtaeFaqCategory() { string errMsg; _objFaqCategoryProperty = new FAQCategoryProperty { FAQCategoryId = Convert.ToInt16(hdnFAQCategoryMaster.Value), FAQCategoryName = txtFAQCategoryName.Text, FAQCategoryStatus = chkFAQDetailsStatus.Checked, }; var result = FAQProvider.Instance.UpdtaeFAQCategory(_objFaqCategoryProperty, LoggedInUserId, out errMsg); if (result > 0) { btnSave.Text = "Update"; lblSuccess.Visible = true; lblSuccess.Text = errMsg; lblError.Text = ""; lblInform.Text = string.Empty; lblInsert.Text = "Insert"; lblError.Text = ""; lblSuccess.Focus(); lblHeader.Text = "Add FAQ Category Master"; } else { lblError.Visible = true; lblError.Text = errMsg; lblSuccess.Text = ""; } lblInsert.Text = "Insert"; btnSave.Text = "Save"; }
protected void InsertFaqCategory() { string errMsg; _objFaqCategoryProperty = new FAQCategoryProperty { FAQCategoryName = txtFAQCategoryName.Text, FAQCategoryStatus = chkFAQDetailsStatus.Checked, }; var result = FAQProvider.Instance.InsertFAQCategory(_objFaqCategoryProperty, LoggedInUserId, out errMsg); if (result > 0) { btnSave.Text = "Save"; lblSuccess.Visible = true; lblSuccess.Text = errMsg; lblError.Text = ""; lblInform.Text = ""; } else { lblError.Visible = true; lblError.Text = errMsg; } }
public override int UpdtaeFAQCategory(FAQCategoryProperty objFAQCategoryProperty, int modifiedBy, out string errmsg) { _objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure); errmsg = ""; try { _objDataWrapper.AddParameter("@FAQCategoryId", objFAQCategoryProperty.FAQCategoryId); _objDataWrapper.AddParameter("@FAQCategoryName", objFAQCategoryProperty.FAQCategoryName); _objDataWrapper.AddParameter("@FAQCategoryStatus", objFAQCategoryProperty.FAQCategoryStatus); _objDataWrapper.AddParameter("@CreatedBy", modifiedBy); var errMsg = (SqlParameter)(_objDataWrapper.AddParameter("@ErrMsg", "", SqlDbType.VarChar, ParameterDirection.Output, 128)); _i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_InsertUpdateFAQCategory"); 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 UpdtaeFAQCategory in FAQ.cs :: -> "; var objPub = new ClsExceptionPublisher(); objPub.Publish(err, addInfo); } return(_i); }
// Method to Bind The private member of the the Class private List <FAQCategoryProperty> BindFAQCategoryObjectList(DataTable datatable) { var objFAQCategoryList = new List <FAQCategoryProperty>(); try { if (datatable != null && datatable.Rows.Count > 0) { for (var j = 0; j < datatable.Rows.Count; j++) { var objFAQCategory = new FAQCategoryProperty { FAQCategoryId = Convert.ToInt32(datatable.Rows[j]["AjFaqCategoryId"]), FAQCategoryName = Convert.ToString(datatable.Rows[j]["AjFaqCategoryName"]), FAQCategoryStatus = Convert.ToBoolean(datatable.Rows[j]["AjFaqStatus"]) }; objFAQCategoryList.Add(objFAQCategory); } } } catch (Exception ex) { var err = ex.Message; if (ex.InnerException != null) { err = err + " :: Inner Exception :- " + ex.ToString(); } const string addInfo = "Error while executing BindFAQCategoryObjectList in FAQ.cs :: -> "; var objPub = new ClsExceptionPublisher(); objPub.Publish(err, addInfo); } return(objFAQCategoryList); }
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); } }
public abstract int UpdtaeFAQCategory(FAQCategoryProperty objFAQCategoryProperty, int modifiedBy, out string errmsg);
public abstract int InsertFAQCategory(FAQCategoryProperty objFAQCategoryProperty, int createdBy, out string errmsg);