private static void ClearAssignedToPaidBill(int billId)
        {
            string sql = $"sp_ClearAssignedOnBillClosed {billId}";

            SqlDataAccess.ExecuteQuery(sql);
        }
        private static void RemoveAssignedBill(int billId, int roommateId)
        {
            string sql = $"sp_RemoveAssignedBill '{billId}', '{roommateId}'";

            SqlDataAccess.ExecuteQuery(sql);
        }