public List <PostFeedback> GetPostCount(string PostID, string IsActive, string User) // 1 { List <PostFeedback> listData = new List <PostFeedback>(); PostFeedback ObjItem = new PostFeedback(); if (PostID == "" || PostID == null) { ObjItem.PostID = "-1"; } else { ObjItem.PostID = PostID; } if (IsActive == "" || IsActive == null) { ObjItem.IsActive = "-1"; } else { ObjItem.IsActive = IsActive; } listData = GetData(LoadPostCount, ObjItem, User); return(listData); }
public OutputResult SavePostFeedback(PostFeedback objItem, string UserBy) { try { cmd = new SqlCommand(setSP, DataManager.cnConnection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@SaveOption", SqlDbType.Int).Value = SaveOption.SaveRow; cmd.Parameters.Add("@PostFeedbackID", SqlDbType.Int).Value = objItem.PostFeedbackID; cmd.Parameters.Add("@PostID", SqlDbType.Int).Value = objItem.PostID; cmd.Parameters.Add("@PostComment", SqlDbType.VarChar).Value = objItem.PostComment; cmd.Parameters.Add("@PostLike", SqlDbType.Int).Value = objItem.PostLike; cmd.Parameters.Add("@PostDislike", SqlDbType.Int).Value = objItem.PostDislike; cmd.Parameters.Add("@IsActive", SqlDbType.Int).Value = objItem.IsActive; cmd.Parameters.Add("@UserBy", SqlDbType.VarChar).Value = UserBy; SqlParameter paramIdentityValue = new SqlParameter("@IdentityValue", SqlDbType.Int, 20, ParameterDirection.Output, false, 0, 0, "", DataRowVersion.Default, null); cmd.Parameters.Add(paramIdentityValue); SqlParameter ErrNo = new SqlParameter("@ErrNo", SqlDbType.Int, 20, ParameterDirection.Output, false, 0, 0, "", DataRowVersion.Default, null); cmd.Parameters.Add(ErrNo); DataManager.cnConnection.Open(); objResult.NoofRows = cmd.ExecuteNonQuery(); objResult.ErrorNo = int.Parse(cmd.Parameters["@ErrNo"].Value.ToString()); objResult.ResultId = int.Parse(cmd.Parameters["@IdentityValue"].Value.ToString()); if (objResult.NoofRows > 0 && objResult.ResultId > 0) { objResult.Message = "Save operation successful."; } else { if (objResult.ErrorNo == -1) { objResult.Message = "Save operation failed."; } } } catch (Exception ex) { objResult.ExceptionError = ex.ToString(); objResult.ResultId = 0; objResult.ErrorNo = -1; objResult.Message = "Exception: Save operation failed."; } finally { DataManager.cnConnection.Close(); cmd = null; } return(objResult); }
private List <PostFeedback> GetData(int LoadOption, PostFeedback ObjItem, string UserID) { List <PostFeedback> listData = new List <PostFeedback>(); try { cmd = new SqlCommand(getSP, DataManager.cnConnection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@LoadOption", SqlDbType.Int).Value = LoadOption; cmd.Parameters.Add("@PostFeedbackID", SqlDbType.Int).Value = ObjItem.PostFeedbackID; cmd.Parameters.Add("@PostID", SqlDbType.Int).Value = ObjItem.PostID; cmd.Parameters.Add("@IsActive", SqlDbType.Int).Value = ObjItem.IsActive; dt = DataManager.ExecuteQuerySqlCommand(cmd); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { PostFeedback listItem = new PostFeedback(); if (LoadOption == LoadPostFeedback) // 1 { listItem.PostFeedbackID = dt.Rows[i]["PostFeedbackID"].ToString(); listItem.PostID = dt.Rows[i]["PostID"].ToString(); listItem.PostComment = dt.Rows[i]["PostComment"].ToString(); listItem.PostLike = dt.Rows[i]["PostLike"].ToString(); listItem.PostDislike = dt.Rows[i]["PostDislike"].ToString(); listItem.IsActive = dt.Rows[i]["IsActive"].ToString(); listItem.Status = dt.Rows[i]["Status"].ToString(); } else if (LoadOption == LoadPostCount) // 2 { listItem.PostLike = dt.Rows[i]["PostLike"].ToString(); listItem.PostDislike = dt.Rows[i]["PostDislike"].ToString(); } listData.Add(listItem); } } } catch (Exception ex) { objResult.ExceptionError = ex.ToString(); } finally { objResult.IsLogin = "******"; } return(listData); }