private void button_Delete_Click(object sender, EventArgs e)
{
foreach (DataGridViewRow row in dataGridView1.SelectedRows)
{
int CurrentRow = row.Index;
// //получить значение id выбранной строки
int valueId = Convert.ToInt32(dataGridView1[0, CurrentRow].Value);
Intensiv2018Entities context = new Intensiv2018Entities();
List <User_Track_Playlist> user_Track_Playlists = context.User_Track_Playlist.Where(a => a.playlist_id == valueId).ToList();
List <Track> tracks = new List <Track>();
foreach (User_Track_Playlist temp in user_Track_Playlists)
{
tracks.Add(context.Tracks1.Where(a => a.id == temp.track_id).FirstOrDefault());
}
List <User_Track> list = new List <User_Track>();
foreach (Track track in tracks)
{
User_Track user = context.User_Track.Where(a => a.track_id == track.id).FirstOrDefault();
list.Add(context.User_Track.Where(a => a.track_id == track.id).FirstOrDefault());
}
functions.PlaylistEdit("Удалить", valueId, list);
}
RefreshDGV();
}
private void button1_Click(object sender, EventArgs e)
{
foreach (DataGridViewRow row in dataGridView2.SelectedRows)
{
User_Track track = new User_Track();
track.id = Convert.ToInt32(row.Cells[0].Value.ToString());
track.author = Convert.ToInt32(row.Cells[1].Value.ToString());
track.track_id = Convert.ToInt32(row.Cells[2].Value.ToString());
track.artist = row.Cells[3].Value.ToString();
track.title = row.Cells[4].Value.ToString();
track.genre = row.Cells[5].Value.ToString();
track.mood = row.Cells[6].Value.ToString();
track.bitrate = Convert.ToInt32(row.Cells[7].Value.ToString());
track.source = row.Cells[8].Value.ToString();
track.path = row.Cells[9].Value.ToString();
track.duration = TimeSpan.Parse(row.Cells[10].Value.ToString());
track.date_add = Convert.ToDateTime(row.Cells[11].Value.ToString());
user_Tracks.Add(track);
}
dataGridView1.DataSource = null;
dataGridView1.DataSource = user_Tracks;
dataGridView1.Refresh();
this.Width = 816;
this.Height = 489;
}
private void button_intoPlaylist_Click(object sender, EventArgs e)
{
List <User_Track> user_Tracks = new List <User_Track>();
foreach (DataGridViewRow row in dataGridView1.SelectedRows)
{
User_Track track = new User_Track();
track.id = Convert.ToInt32(row.Cells[0].Value.ToString());
track.author = Convert.ToInt32(row.Cells[1].Value.ToString());
track.track_id = Convert.ToInt32(row.Cells[2].Value.ToString());
track.artist = row.Cells[3].Value.ToString();
track.title = row.Cells[4].Value.ToString();
track.genre = row.Cells[5].Value.ToString();
track.mood = row.Cells[6].Value.ToString();
track.bitrate = Convert.ToInt32(row.Cells[7].Value.ToString());
track.source = row.Cells[8].Value.ToString();
track.path = row.Cells[9].Value.ToString();
track.duration = TimeSpan.Parse(row.Cells[10].Value.ToString());
track.date_add = Convert.ToDateTime(row.Cells[11].Value.ToString());
user_Tracks.Add(track);
}
Edit_MyPlaylist f = new Edit_MyPlaylist("Добавить", user_Tracks, -1, author, login, name, surname);
f.ShowDialog();
}
public Edit_MyTrack(User_Track track)
{
InitializeComponent();
textBox_Author.Text = track.artist;
textBox_Title.Text = track.title;
textBox_Genre.Text = track.genre;
textBox_Mood.Text = track.mood;
textBox_Path.Text = track.path;
new_track = track;
}
private void button_Edit_Click(object sender, EventArgs e)
{
int CurrentRow = dataGridView1.SelectedCells[0].RowIndex;
// //получить значение id выбранной строки
int valueId = Convert.ToInt32(dataGridView1[0, CurrentRow].Value);
User_Track track = functions.context.User_Track.Where(a => a.id == valueId).FirstOrDefault();
Edit_MyTrack f = new Edit_MyTrack(track);
f.ShowDialog();
RefreshDGV();
}
private void button_Edit_Click(object sender, EventArgs e)
{
int CurrentRow = dataGridView1.SelectedCells[0].RowIndex;
// //получить значение id выбранной строки
int valueId = Convert.ToInt32(dataGridView1[0, CurrentRow].Value);
Intensiv2018Entities context = new Intensiv2018Entities();
List <User_Track_Playlist> user_Track_Playlists = context.User_Track_Playlist.Where(a => a.playlist_id == valueId).ToList();
List <Track> tracks = new List <Track>();
foreach (User_Track_Playlist temp in user_Track_Playlists)
{
tracks.Add(context.Tracks1.Where(a => a.id == temp.track_id).FirstOrDefault());
}
List <User_Track> list = new List <User_Track>();
//List<User_Track_for_Playlist> list = new List<User_Track_for_Playlist>();
foreach (Track track in tracks)
{
User_Track user = context.User_Track.Where(a => a.track_id == track.id).FirstOrDefault();
//User_Track_for_Playlist _For_Playlist = new User_Track_for_Playlist();
//_For_Playlist.artist = user.artist;
//_For_Playlist.author = user.author;
//_For_Playlist.bitrate = user.bitrate;
//_For_Playlist.date_add = user.date_add;
//_For_Playlist.duration = user.duration;
//_For_Playlist.genre = user.genre;
//_For_Playlist.id = user.id;
//_For_Playlist.mood = user.mood;
//_For_Playlist.path = user.path;
//_For_Playlist.source = user.source;
//_For_Playlist.title = user.title;
//_For_Playlist.track_id = user.track_id;
//_For_Playlist.user_track_playlist_id = 0;
//list.Add(_For_Playlist);
list.Add(context.User_Track.Where(a => a.track_id == track.id).FirstOrDefault());
}
Edit_MyPlaylist f = new Edit_MyPlaylist("Редактировать", list, valueId, author_id, login, name, surname);
f.ShowDialog();
}
/// <summary>
/// Работа с таблицей User_Track (Треки пользователя, Мои композиции)
/// Функции добавления, редактирования, удаления
/// </summary>
/// <param name="command"></param>
/// <param name="id"></param>
/// <param name="author"></param>
/// <param name="artist"></param>
/// <param name="title"></param>
/// <param name="genre"></param>
/// <param name="mood"></param>
/// <param name="bitrate"></param>
/// <param name="sourse"></param>
/// <param name="path"></param>
/// <param name="duration"></param>
public void User_Track_Edit(string command, int id, int?author = 0, string artist = "", string title = "", string genre = "", string mood = "", int?bitrate = 0,
string sourse = "", string path = "", TimeSpan duration = new TimeSpan())
{
switch (command)
{
case "Добавить":
{
//try
//{
int track_id = context.Tracks1.Where(a => a.source == sourse).Select(a => a.id).FirstOrDefault();
//Добавление в треки пользователя
User_Track user_track = new User_Track();
user_track.id = id;
user_track.track_id = track_id;
user_track.author = author;
user_track.artist = artist;
user_track.title = title;
user_track.genre = genre;
user_track.mood = mood;
user_track.bitrate = bitrate;
user_track.source = sourse;
user_track.path = path;
user_track.duration = duration;
user_track.date_add = DateTime.Now;
context.Entry(user_track).State = EntityState.Added;
context.SaveChanges();
// }
//catch (Exception ex) { Console.WriteLine(ex.Message); }
break;
}
case "Редактировать":
{
try
{
int track_id = context.Tracks1.Where(a => a.source == sourse).Select(a => a.id).FirstOrDefault();
//Добавление в треки пользователя
User_Track user_track = context.User_Track.Find(id);
user_track.track_id = track_id;
user_track.author = author;
user_track.artist = artist;
user_track.title = title;
user_track.genre = genre;
user_track.mood = mood;
user_track.bitrate = bitrate;
user_track.source = sourse;
user_track.path = path;
user_track.duration = duration;
user_track.date_add = DateTime.Now;
context.Entry(user_track).State = EntityState.Modified;
context.SaveChanges();
}
catch (Exception ex) { Console.WriteLine(ex.Message); }
break;
}
case "Удалить":
{
try
{
User_Track user_track = context.User_Track.Find(id);
context.Entry(user_track).State = EntityState.Deleted;
context.SaveChanges();
}
catch (Exception ex) { Console.WriteLine(ex.Message); }
break;
}
}
}
