public List <PostInformation> GetPostFeedBack(string PostID, string IsActive, string User) // 1 { List <PostInformation> listData = new List <PostInformation>(); PostInformation ObjItem = new PostInformation(); if (PostID == "" || PostID == null) { ObjItem.PostID = "-1"; } else { ObjItem.PostID = PostID; } if (IsActive == "" || IsActive == null) { ObjItem.IsActive = "-1"; } else { ObjItem.IsActive = IsActive; } listData = GetData(LoadPostFeedBack, ObjItem, User); return(listData); }
public List <PostInformation> GetPostFeedBack_API() // 1 { List <PostInformation> listData = new List <PostInformation>(); try { cmd = new SqlCommand(getSP, DataManager.cnConnection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@LoadOption", SqlDbType.Int).Value = 2; cmd.Parameters.Add("@PostID", SqlDbType.Int).Value = "-1"; cmd.Parameters.Add("@IsActive", SqlDbType.Int).Value = "-1"; dt = DataManager.ExecuteQuerySqlCommand(cmd); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { PostInformation listItem = new PostInformation(); listItem.PostID = dt.Rows[i]["PostID"].ToString(); listItem.PostHead = dt.Rows[i]["PostHead"].ToString(); listItem.PostImage = dt.Rows[i]["PostImage"].ToString(); listItem.PostImageBase64Bytes = GetPostImage(dt.Rows[i]["PostID"].ToString(), dt.Rows[i]["PostImage"].ToString()); listItem.IsActive = dt.Rows[i]["IsActive"].ToString(); listItem.Status = dt.Rows[i]["Status"].ToString(); listItem.PostCreatedBy = dt.Rows[i]["PostCreatedBy"].ToString(); listItem.PostCreatedUserName = dt.Rows[i]["PostCreatedUserName"].ToString(); listItem.PostCreatedDate = dt.Rows[i]["PostCreatedDate"].ToString(); listItem.PostUpdatedBy = dt.Rows[i]["PostUpdatedBy"].ToString(); listItem.PostUpdatedUserName = dt.Rows[i]["PostUpdatedUserName"].ToString(); listItem.PostUpdatedDate = dt.Rows[i]["PostUpdatedDate"].ToString(); listItem.PostFeedbackID = dt.Rows[i]["PostFeedbackID"].ToString(); listItem.PostComment = dt.Rows[i]["PostComment"].ToString(); listItem.PostLike = dt.Rows[i]["PostLike"].ToString(); listItem.PostDislike = dt.Rows[i]["PostDislike"].ToString(); listItem.PostFeedbackCreatedBy = dt.Rows[i]["PostFeedbackCreatedBy"].ToString(); listItem.PostFeedbackCreatedUserName = dt.Rows[i]["PostFeedbackCreatedUserName"].ToString(); listItem.PostFeedbackCreatedDate = dt.Rows[i]["PostFeedbackCreatedDate"].ToString(); listItem.PostFeedbackUpdatedBy = dt.Rows[i]["PostFeedbackUpdatedBy"].ToString(); listItem.PostFeedbackUpdatedUserName = dt.Rows[i]["PostFeedbackUpdatedUserName"].ToString(); listItem.PostFeedbackUpdatedDate = dt.Rows[i]["PostFeedbackUpdatedDate"].ToString(); listData.Add(listItem); } } } catch (Exception ex) { objResult.ExceptionError = ex.ToString(); } finally { objResult.IsLogin = "******"; } return(listData); }
public OutputResult UpdatePost(PostInformation objItem, string UserBy) { try { cmd = new SqlCommand(setSP, DataManager.cnConnection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("SaveOption", SqlDbType.Int).Value = SaveOption.UpdateRow; cmd.Parameters.Add("@PostID", SqlDbType.Int).Value = objItem.PostID; cmd.Parameters.Add("@PostHead", SqlDbType.VarChar).Value = objItem.PostHead; cmd.Parameters.Add("@PostImage", SqlDbType.VarChar).Value = objItem.PostImage; 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 = "Update operation successful."; } else { if (objResult.ErrorNo == -1) { objResult.Message = "Update operation failed."; } } } catch (Exception ex) { objResult.ExceptionError = ex.ToString(); objResult.ResultId = 0; objResult.ErrorNo = -1; objResult.Message = "Exception: Update operation failed."; } finally { DataManager.cnConnection.Close(); cmd = null; } return(objResult); }