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