public bool Reply_Delete(string reply_id) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@tweet_id", reply_id) }; return(SqlDBHelper.ExecuteNonQuery("Reply_Delete", CommandType.StoredProcedure, parameters)); }
public bool ProfileCoverPic_Delete(string user_id) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@user_id", user_id) }; return(SqlDBHelper.ExecuteNonQuery("ProfileCoverPic_Delete", CommandType.StoredProcedure, parameters)); }
public bool Tweet_Delete_Person(string user_id) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@user_id", user_id) }; return(SqlDBHelper.ExecuteNonQuery("Tweet_Delete_Person", CommandType.StoredProcedure, parameters)); }
public bool Tweet_Delete(int tweet_id) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@tweet_id", tweet_id) }; return(SqlDBHelper.ExecuteNonQuery("Tweet_Delete", CommandType.StoredProcedure, parameters)); }
public bool Following_Follower_Delete(string user_id) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@User_id", user_id) }; return(SqlDBHelper.ExecuteNonQuery("Following_Follower_Delete", CommandType.StoredProcedure, parameters)); }
public bool Person_Password_Update(Person person) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@user_id", person.User_id), new SqlParameter("@Password", person.Password) }; return(SqlDBHelper.ExecuteNonQuery("Person_Password_Update", CommandType.StoredProcedure, parameters)); }
public bool Tweet_Update(Tweet tweet) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@tweet_id", tweet.Tweet_id), new SqlParameter("@Message", tweet.Message) }; return(SqlDBHelper.ExecuteNonQuery("Tweet_Update", CommandType.StoredProcedure, parameters)); }
public bool Following_Delete(Following following) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@User_id", following.User_id), new SqlParameter("@Following_id", following.Following_id) }; return(SqlDBHelper.ExecuteNonQuery("Following_Delete", CommandType.StoredProcedure, parameters)); }
public bool Person_Update(Person person) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@user_id", person.User_id), new SqlParameter("@FullName", person.FullName), new SqlParameter("@Email", person.Email), }; return(SqlDBHelper.ExecuteNonQuery("Person_Update", CommandType.StoredProcedure, parameters)); }
public bool Tweet_Add(Tweet tweet) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@User_id", tweet.User_id), new SqlParameter("@Message", tweet.Message), new SqlParameter("@Created", tweet.Created) }; return(SqlDBHelper.ExecuteNonQuery("Tweet_Add", CommandType.StoredProcedure, parameters)); }
public bool Reply_Add(Reply reply) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@tweet_id", reply.User_id), new SqlParameter("@user_id", reply.Message), new SqlParameter("@message", reply.Created), new SqlParameter("@created", reply.Created) }; return(SqlDBHelper.ExecuteNonQuery("Reply_Add", CommandType.StoredProcedure, parameters)); }
public bool Person_Add(Person person) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@user_id", person.User_id), new SqlParameter("@Password", person.Password), new SqlParameter("@FullName", person.FullName), new SqlParameter("@Email", person.Email), new SqlParameter("@Joined", person.Joined), new SqlParameter("@Active", person.Active) }; return(SqlDBHelper.ExecuteNonQuery("Person_Add", CommandType.StoredProcedure, parameters)); }