public Composition() { InitializeComponent(); ColorScheme.ApplyColor(this); SqlDataAdapter adapter = new SqlDataAdapter("SELECT Name FROM Performer", connection); connection.Open(); adapter.Fill(dt); connection.Close(); for (int i = 0; i < dt.Rows.Count; i++) { compAuthor.Items.Add((string)dt.Rows[i][0]); } adapter = new SqlDataAdapter("SELECT Name FROM Composition", connection); connection.Open(); adapter.Fill(dt); connection.Close(); adapter = new SqlDataAdapter("SELECT Composition.*,Album.Name, Album.Performer, Album.Id, Containing.Id FROM Composition,Containing,Album WHERE Containing.Album=Album.Id and Containing.Composition=Composition.Id", connection); dt = new DataTable(); adapter.Fill(dt); connection.Close(); for (int i = 0; i < dt.Rows.Count; i++) { if (!compBox.Items.Contains((string)dt.Rows[i][1])) { compBox.Items.Add(dt.Rows[i][1]); } } }
public Album(int num) { InitializeComponent(); ColorScheme.ApplyColor(this); connection.Open(); SqlDataAdapter adapter = new SqlDataAdapter("SELECT Performer.Name, Composition.Name, Album.Name,Album.Cover, Composition.Id FROM Performer,Composition, Containing, Album WHERE Album.Id=" + num + " and Containing.Album=Album.Id and Containing.Composition=Composition.Id and Performer.Name=Album.Performer ORDER BY Composition.Name", connection); DataTable dt = new DataTable(); string name = ""; string perf = ""; List <string> comps = new List <string>(); try { adapter.Fill(dt); perf = (string)dt.Rows[0][0]; name = (string)dt.Rows[0][2]; try { pictureBox.Image = Image.FromFile((string)dt.Rows[0][3]); } catch { } } catch { MessageBox.Show("К сожалению, информация об альбоме неполная. Добавьте в альбом хотя бы одно произведение"); this.Close(); } finally { connection.Close(); } perfLink.Text = perf; nameLabel.Text = name; for (int i = 0; i < dt.Rows.Count; i++) { listComps.Items.Add(dt.Rows[i][1]); idComp.Add((int)dt.Rows[i][4]); } }
public Composition(int num) { InitializeComponent(); ColorScheme.ApplyColor(this); connection.Open(); SqlDataAdapter adapter = new SqlDataAdapter("SELECT Performer.Name, Composition.Name, Album.Name,Text,Album.Id FROM Performer,Composition, Containing, Album WHERE Composition.Id=" + num + " and Containing.Album=Album.Id and Containing.Composition=Composition.Id and Performer.Name=Album.Performer", connection); DataTable dt = new DataTable(); string text = "Текст песни недоступен"; string name = ""; string perf = ""; List <string> albums = new List <string>(); try { adapter.Fill(dt); perf = (string)dt.Rows[0][0]; name = (string)dt.Rows[0][1]; text = (string)dt.Rows[0][3]; } catch { } for (int i = 0; i < dt.Rows.Count; i++) { if (!albums.Contains((string)dt.Rows[i][2])) { albums.Add((string)dt.Rows[i][2]); } idAlbums.Add((int)dt.Rows[i][4]); } connection.Close(); nameLabel.Text = name; perfLink.Text = perf; songBox.Text = text; foreach (string element in albums) { listAlbums.Items.Add(element); } }
public Performer() { InitializeComponent(); ColorScheme.ApplyColor(this); openFileDialog1.Filter = "Image Files(*.BMP;*.JPG;*.GIF;*.JPEG;*.PNG)|*.BMP;*.JPG;*.GIF;*.JPEG;*.PNG"; openFileDialog1.InitialDirectory = @"Images\"; }
public Composition() { InitializeComponent(); ColorScheme.ApplyColor(this); DataTable dt = new DataTable(); connection.Open(); SqlDataAdapter adapter = new SqlDataAdapter("SELECT Name FROM Performer", connection); adapter.Fill(dt); connection.Close(); for (int i = 0; i < dt.Rows.Count; i++) { perfBox.Items.Add(dt.Rows[i][0]); } dt = new DataTable(); connection.Open(); adapter = new SqlDataAdapter("SELECT Name FROM Genre", connection); adapter.Fill(dt); connection.Close(); for (int i = 0; i < dt.Rows.Count; i++) { genreBox.Items.Add(dt.Rows[i][0]); } }
public DirectGenre() { InitializeComponent(); ColorScheme.ApplyColor(this); tabControl.TabPages.Clear(); DataTable direct = new DataTable(); SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM Direction", connection); connection.Open(); adapter.Fill(direct); connection.Close(); DataTable genres = new DataTable(); for (int i = 0; i < direct.Rows.Count; i++) { genres = new DataTable(); adapter = new SqlDataAdapter("SELECT * FROM Genre WHERE Direct='" + (string)direct.Rows[i][0] + "'", connection); connection.Open(); adapter.Fill(genres); connection.Close(); tabControl.TabPages.Add((string)direct.Rows[i][0]); for (int j = 0; j < genres.Rows.Count; j++) { tabControl.TabPages[i].Controls.Add(new RichTextBox()); var temp = tabControl.TabPages[i].Controls[tabControl.TabPages[i].Controls.Count - 1]; ((RichTextBox)temp).Font = new Font("Trebuchet MS", 9); ((RichTextBox)temp).Dock = DockStyle.Top; ((RichTextBox)temp).Text = (string)genres.Rows[j][1]; tabControl.TabPages[i].Controls.Add(new TextBox()); temp = tabControl.TabPages[i].Controls[tabControl.TabPages[i].Controls.Count - 1]; ((TextBox)temp).Font = new Font("Trebuchet MS", 10); ((TextBox)temp).Dock = DockStyle.Top; ((TextBox)temp).Text = (string)genres.Rows[j][0]; ((TextBox)temp).BackColor = this.BackColor; } TextBox genrelabel = new TextBox(); genrelabel.Font = new Font("Trebuchet MS", 19); genrelabel.Text = "Жанры:"; genrelabel.BackColor = this.BackColor; genrelabel.Dock = DockStyle.Top; tabControl.TabPages[i].Controls.Add(genrelabel); genrelabel.ReadOnly = true; genrelabel.TabStop = false; RichTextBox text = new RichTextBox(); text.Font = new Font("Trebuchet MS", 9); text.Dock = DockStyle.Top; text.Text = (string)direct.Rows[i][1]; tabControl.TabPages[i].Controls.Add(text); tabControl.TabPages[i].AutoScroll = true; } }
public Direct() { InitializeComponent(); ColorScheme.ApplyColor(this); connection.Open(); SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM Direction", connection); adapter.Fill(dt); connection.Close(); for (int i = 0; i < dt.Rows.Count; i++) { directBox.Items.Add(dt.Rows[i][0]); } }
public PlayList() { InitializeComponent(); ColorScheme.ApplyColor(this); #region заполнение списка исполнителей SqlDataAdapter adapter = new SqlDataAdapter("SELECT Name FROM Performer", connection); try { connection.Open(); adapter.Fill(dt); } catch (SqlException ex) { MessageBox.Show(ex.Message); } finally { connection.Close(); } for (int i = 0; i < dt.Rows.Count; i++) { perfBox.Items.Add((string)dt.Rows[i][0]); } #endregion #region заполнение списка жанров adapter = new SqlDataAdapter("SELECT Name FROM Genre", connection); dt = new DataTable(); try { connection.Open(); adapter.Fill(dt); } catch (SqlException ex) { MessageBox.Show(ex.Message); } finally { connection.Close(); } for (int i = 0; i < dt.Rows.Count; i++) { genreBox.Items.Add((string)dt.Rows[i][0]); } #endregion SqlDataAdapter m = new SqlDataAdapter("SELECT COUNT(Id) as 'Max' FROM Composition", connection); DataTable d = new DataTable(); connection.Open(); m.Fill(d); connection.Close(); numericUpDown1.Maximum = (int)d.Rows[0][0] * t / 60; }
public Album() { InitializeComponent(); ColorScheme.ApplyColor(this); openFileDialog1.Filter = "Image Files(*.BMP;*.JPG;*.GIF;*.JPEG;*.PNG)|*.BMP;*.JPG;*.GIF;*.JPEG;*.PNG"; openFileDialog1.InitialDirectory = @"Images\"; DataTable dt = new DataTable(); connection.Open(); SqlDataAdapter adapter = new SqlDataAdapter("SELECT Name FROM Performer", connection); adapter.Fill(dt); connection.Close(); for (int i = 0; i < dt.Rows.Count; i++) { perfBox.Items.Add(dt.Rows[i][0]); } }
public CompSelect() { InitializeComponent(); ColorScheme.ApplyColor(this); SqlDataAdapter adapter = new SqlDataAdapter("SELECT Count(Id) as Max FROM Composition", connection); DataTable max = new DataTable(); try { connection.Open(); adapter.Fill(max); } finally { connection.Close(); } numericUpDown1.Maximum = (int)max.Rows[0][0]; }
public Album() { InitializeComponent(); ColorScheme.ApplyColor(this); openFileDialog1.Filter = "Image Files(*.BMP;*.JPG;*.GIF;*.JPEG;*.PNG)|*.BMP;*.JPG;*.GIF;*.JPEG;*.PNG"; openFileDialog1.InitialDirectory = @"Images\"; SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM Album", connection); connection.Open(); adapter.Fill(dt); connection.Close(); for (int i = 0; i < dt.Rows.Count; i++) { albumName.Items.Add((string)dt.Rows[i][1]); if (!albumPerf.Items.Contains((string)dt.Rows[i][3])) { albumPerf.Items.Add((string)dt.Rows[i][3]); } } }
public PerfSelect() { InitializeComponent(); ColorScheme.ApplyColor(this); }
public Performer(string name) { n = name; InitializeComponent(); ColorScheme.ApplyColor(this); connection.Open(); SqlDataAdapter adapter = new SqlDataAdapter("SELECT Photo, Biography, Birth FROM Performer WHERE [Name]='" + name + "'", connection); DataTable dt = new DataTable(); string path = ""; string bio = ""; try { adapter.Fill(dt); path = (string)dt.Rows[0][0]; bio = (string)dt.Rows[0][1]; dateLabel.Text += ((DateTime)dt.Rows[0][2]).ToLongDateString(); } catch { } adapter = new SqlDataAdapter("SELECT DISTINCT Composition.Name, Composition.Id FROM Composition, Album, Containing WHERE Album.Performer='" + name + "' and Containing.Album=Album.Id and Containing.Composition=Composition.Id ORDER BY Composition.Name", connection); dt = new DataTable(); adapter.Fill(dt); List <string> comps = new List <string>(); List <string> albums = new List <string>(); idComps = new List <int>(); idAlbums = new List <int>(); for (int i = 0; i < dt.Rows.Count; i++) { comps.Add((string)dt.Rows[i][0]); idComps.Add((int)dt.Rows[i][1]); } connection.Close(); connection.Open(); adapter = new SqlDataAdapter("SELECT Name, Id FROM Album WHERE Performer='" + name + "'", connection); dt = new DataTable(); adapter.Fill(dt); connection.Close(); for (int i = 0; i < dt.Rows.Count; i++) { if (!idAlbums.Contains((int)dt.Rows[i][1])) { albums.Add((string)dt.Rows[i][0]); idAlbums.Add((int)dt.Rows[i][1]); } } try { pictureBox.Image = Image.FromFile(path); } catch { } nameLabel.Text = name; biographyBox.Text = bio; foreach (string element in comps) { listComp.Items.Add(element); } foreach (string element in albums) { listAlbums.Items.Add(element); } }