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 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(); }
private void button2_Click_1(object sender, EventArgs e) { Intensiv2018Entities asd = new Intensiv2018Entities(); SysUser user = new SysUser(); user = asd.SysUsers.Where(a => a.login == textBox1.Text && a.pass == textBox2.Text).FirstOrDefault(); if (user.role != "Тренер" && user.role != "Администратор") { MessageBox.Show("Такого пользователя в системе нет"); } else { Form ifrm = new loadForm(user.id, user.login, user.name, user.surname); this.Hide(); // скрываем форму авторизации ifrm.ShowDialog(); // отображаем Главную форму this.Show(); //Снова открываем авторизацию } }