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));
}
