public static Subheader RemoveFriend(ServerUserInformation serverUser, FriendInformation friendInfo)
{
MySqlCommand cmd;
try
{
cmd = new MySqlCommand("DELETE FROM Friends WHERE friend_id = '" + friendInfo.friend_id + "';", con);
}
catch (Exception) { return(Subheader.PROJ_ERROR); }
try
{
if (cmd.ExecuteNonQuery() <= 0)
{
return(Subheader.DBQRY_ERROR);
}
return(Subheader.NULL);
}
catch (MySqlException e)
{
if (e.Number == 2627)
{
return(Subheader.DBEXST_ERROR);
}
return(Subheader.DBQRY_ERROR);
}
}
public static Subheader UpdateFriendRequest(ServerUserInformation serverUser, FriendInformation friendInfo)
{
MySqlCommand cmd;
try
{
cmd = new MySqlCommand("UPDATE Friends SET friend_status = '" + Enum.GetName(typeof(FriendStatus), friendInfo.friend_status) +
"' WHERE friend_id = '" + friendInfo.friend_id + "';", con);
}
catch { return(Subheader.DBCON_ERROR); }
try
{
if (cmd.ExecuteNonQuery() <= 0)
{
return(Subheader.DBREG_ERROR);
}
return(Subheader.NULL);
}
catch (MySqlException e)
{
if (e.Number == 2627)
{
return(Subheader.DBEXST_ERROR);
}
return(Subheader.DBQRY_ERROR);
}
}
