private void InsertUpdateCollegeTestimonial(int testimonialId) { try { var errMsg = ""; var objAdmissionJankariTestimonial = new AdmissionJankariTestimonial { TestimonialId = testimonialId, TestimonialPersonName = txtPersonName.Text.Trim(), TestimonialPeronDesignation = txtPersondesig.Text.Trim(), TestimonialImage = hdnImageFile.Value.Trim(), TestimonialPriority = txtPriority.Text, TestimonialStatus = chkTestimonialStatus.Checked, TestimonialText = txtTestimonial.FckValue }; var result = UserManagerProvider.Instance.InsertUpdateTestimonialAdmssionjankari(objAdmissionJankariTestimonial, new SecurePage().LoggedInUserId, out errMsg); lblResult.Text = errMsg; lblResult.Visible = true; if (result > 0) { ClearFields(); BindTestimonial(); lblResult.CssClass = "success"; } else { lblResult.CssClass = "error"; } } catch (Exception ex) { var err = ex.Message; if (ex.InnerException != null) { err = err + " :: Inner Exception :- " + ex.ToString(); } const string addInfo = "Error while executing btnSave_Click in AdminPanel/AdmissionjanklariTestimonial.aspx :: -> "; var objPub = new ClsExceptionPublisher(); objPub.Publish(err, addInfo); } }
public override int InsertUpdateTestimonialAdmssionjankari(AdmissionJankariTestimonial objAdmissionJankariTestimonial, int createdBy, out string errMsg) { _objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure); errMsg = ""; try { _objDataWrapper.AddParameter("@TestimonialId", objAdmissionJankariTestimonial.TestimonialId); _objDataWrapper.AddParameter("@TestimonialPersonName", objAdmissionJankariTestimonial.TestimonialPersonName); _objDataWrapper.AddParameter("@TestimonialPersonDesgination", objAdmissionJankariTestimonial.TestimonialPeronDesignation); _objDataWrapper.AddParameter("@TestimonialPriority", objAdmissionJankariTestimonial.TestimonialPriority); _objDataWrapper.AddParameter("@TestimonialText", objAdmissionJankariTestimonial.TestimonialText); _objDataWrapper.AddParameter("@TestimonialStatus", objAdmissionJankariTestimonial.TestimonialStatus); _objDataWrapper.AddParameter("@TestimonialPersonImage", objAdmissionJankariTestimonial.TestimonialImage); _objDataWrapper.AddParameter("@CreatedBy", createdBy); var ObjerrMsg = (SqlParameter)(_objDataWrapper.AddParameter("@ErrMsg", "", SqlDbType.VarChar, ParameterDirection.Output, 128)); _i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_InsertUpdateAdmissionjankariTestimonial"); 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 InsertUpdateTestimonialAdmssionjankari in UserManager.cs :: -> "; var objPub = new ClsExceptionPublisher(); objPub.Publish(err, addInfo); } return(_i); }
public abstract int InsertUpdateTestimonialAdmssionjankari(AdmissionJankariTestimonial objUserCategoryProperty, int createdOn, out string errMsg);