public static Boolean InsertUpdateRiskAssessor_Comment(clsRiskAssessor_Comment objRiskAssessor_Comment) { bool isAdded = false; string SpName = "usp_InsertUpdateRiskAssessor_Comment"; try { using (IDbConnection db = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["databaseConnection"])) { db.Execute(SpName, objRiskAssessor_Comment, commandType: CommandType.StoredProcedure); } isAdded = true; } catch (Exception ex) { ErrorHandler.ErrorLogging(ex, false); ErrorHandler.ReadError(); } return(isAdded); }
protected void CommentEnter(object sender, EventArgs e) { string strInspectorRiskAssId = Request["cgi"].ToString() == null ? string.Empty : Request["cgi"].ToString(); if (GlobalMethods.ValueIsNull(strInspectorRiskAssId).Length > 0) { strInspectorRiskAssId = objcryptoJS.AES_decrypt(HttpUtility.UrlEncode(Request["cgi"].ToString()), AppConstants.secretKey, AppConstants.initVec).ToString(); } else { ErrorHandler.ErrorPage(); } clsRiskAssessor_Comment objComm = new clsRiskAssessor_Comment(); objComm.InspectorRiskAssId = Convert.ToInt32(strInspectorRiskAssId); objComm.Comment = GlobalMethods.KillChars(txtComment.Text); objComm.CreatedDate = DateTime.Now; objComm.CreatedBy = HttpContext.Current.Session["UserAuthId"].ToString(); objComm.IsActive = 1; if (!RiskAssessor_CommentDAL.InsertRiskAssessor_Comment(objComm)) { } #region Getting all the Comments by Application Id. StringBuilder strMessenger = new StringBuilder(""); List <clsRiskAssessor_Comment> lstComments = new List <clsRiskAssessor_Comment>(); lstComments = RiskAssessor_CommentDAL.SelectDynamicRiskAssessor_Comment("InspectorRiskAssId = " + strInspectorRiskAssId + "", "InspectorRiskAssId"); if (lstComments != null) { if (lstComments.Count > 0) { for (int i = 0; i < lstComments.Count; i++) { strMessenger.Append(GlobalMethods.Messenger(lstComments[i].CreatedBy.ToString(), Convert.ToDateTime(lstComments[i].CreatedDate).ToLongDateString(), lstComments[i].Comment.ToString()).ToString()); } } } pnlComments.Controls.Add(new LiteralControl(strMessenger.ToString())); #endregion }
public static clsRiskAssessor_Comment SelectRiskAssessor_CommentById(int?RiskAssessorCommentId) { clsRiskAssessor_Comment objRiskAssessor_Comment = new clsRiskAssessor_Comment(); bool isnull = true; string SpName = "usp_SelectRiskAssessor_Comment"; var objPar = new DynamicParameters(); if (String.IsNullOrEmpty(RiskAssessorCommentId.ToString())) { throw new ArgumentException("Function parameters cannot be blank!"); } else { try { objPar.Add("@RiskAssessorCommentId", RiskAssessorCommentId, dbType: DbType.Int32); using (IDbConnection db = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["databaseConnection"])) { objRiskAssessor_Comment = db.Query <clsRiskAssessor_Comment>(SpName, objPar, commandType: CommandType.StoredProcedure).SingleOrDefault(); isnull = false; } } catch (Exception ex) { ErrorHandler.ErrorLogging(ex, false); ErrorHandler.ReadError(); } } if (isnull) { return(null); } else { return(objRiskAssessor_Comment); } }