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