public MusicCD GetMusicCD(int id)
{
MusicCD musicCD = null;
SqlConnection connection = new SqlConnection(ConnectionString);
connection.Open();
SqlCommand command = new SqlCommand("select * from musicCD", connection);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
if (id == Convert.ToInt32(reader["id"]))
{
MusicCDType type = MusicCD.getMusicCDType(reader["type"].ToString().Trim());
musicCD = new MusicCD(reader["singer"].ToString().Trim(), type, reader["name"].ToString(), Convert.ToInt32(reader["id"]), Convert.ToDouble(reader["price"]), reader["demo"].ToString().Trim(), reader["picture"].ToString(), reader["issue"].ToString());
musicCD.Id = Convert.ToInt32(reader["id"]);
if (musicCD.Id > Product.Idcount)
{
Product.Idcount = musicCD.Id;
}
}
}
connection.Close();
return(musicCD);
}
public void GetProduct(List <Product> productList)
{
SqlConnection connection = new SqlConnection(ConnectionString);
connection.Open();
SqlCommand command = new SqlCommand("select * from product", connection);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
if (reader["type"].ToString().Trim() == "book")
{
Book book = GetBook(Convert.ToInt32(reader["id"]));
productList.Add(book);
}
else if (reader["type"].ToString().Trim() == "musicCD")
{
MusicCD musicCD = GetMusicCD(Convert.ToInt32(reader["id"]));
productList.Add(musicCD);
}
else if (reader["type"].ToString().Trim() == "magazine")
{
Magazine magazine = GetMagazine(Convert.ToInt32(reader["id"]));
productList.Add(magazine);
}
else
{
//invalid type.
}
}
connection.Close();
}
public void addNewMusicCD(String singer, MusicCDType type, String name, int id, double price, String picture, String issue)
{
MusicCD musicCD = (MusicCD)ProductFactory.CreateProduct(ProductNames.MusicCD, name, id, price, picture, issue);
if (musicCD is MusicCD)
{
musicCD.Type = type;
musicCD.Singer = singer;
}
data.addmusicCD(musicCD);
}
private void btnAddMusicCD_Click(object sender, EventArgs e)
{
;
MusicCDType type = MusicCD.getMusicCDType(cmbMusicType.SelectedItem.ToString());
adminUser.addNewMusicCD(txtMusicSinger.Text, type, txtMusicName.Text, Product.Idcount, Convert.ToDouble(txtMusicPrice.Text.Trim()), txtMusicName.Text.Trim() + ".jpg", txtMusicIssue.Text);
DataTable dataTable = new DataTable();
DataTable = data.datagrid(dataTable, "musicCD");
dtgMusicCD.DataSource = DataTable;
}
public MusicCD addNewMusicCD(String singer, MusicCDType type, String name, int id, double price)
{
MusicCD musicCD = (MusicCD)ProductFactory.CreateProduct(ProductName.MusicCD, name, id, price);
if (musicCD is MusicCD)
{
musicCD.Type = type;
musicCD.Singer = singer;
}
return(musicCD);
}
void LoadMusicCD(String category)
{
foreach (Product item in products)
{
if (item is MusicCD)
{
MusicCD musicCD = (MusicCD)item;
if (category == musicCD.Type.ToString())
{
currentProducts.Add(item);
ProductPanel productPanel = ProductPanelCreator.CreatePanel(item);
flPanel.Controls.Add(productPanel);
}
}
}
}
public void addmusicCD(MusicCD musicCD)
{
SqlConnection connection = new SqlConnection(ConnectionString);
string sorgu = "Insert into musicCD (id,name,price,type,picture,issue,singer,demo) values (@id,@name,@price,@type,@picture,@issue,@singer,@demo)";
SqlCommand komut = new SqlCommand(sorgu, connection);
komut.Parameters.AddWithValue("@id", musicCD.Id);
komut.Parameters.AddWithValue("@singer", musicCD.Singer);
komut.Parameters.AddWithValue("@name", musicCD.Name);
komut.Parameters.AddWithValue("@price", musicCD.Price);
komut.Parameters.AddWithValue("@demo", musicCD.Name + ".wav");
komut.Parameters.AddWithValue("@type", musicCD.Type.ToString());
komut.Parameters.AddWithValue("@picture", musicCD.Picture);
komut.Parameters.AddWithValue("@issue", musicCD.Issue);
connection.Open();
komut.ExecuteNonQuery();
connection.Close();
addProduct("musicCD", musicCD.Id);
updateProductCount(musicCD.Id);
}
public static Product CreateProduct(ProductNames ProductName, String name, int id, double price, String picture, String issue)
{
Product product = null;
switch (ProductName)
{
case ProductNames.Magazine:
product = new Magazine(name, id, price, picture, issue);
break;
case ProductNames.MusicCD:
product = new MusicCD(name, id, price, picture, issue);
break;
case ProductNames.Book:
product = new Book(name, id, price, picture, issue);
break;
default:
break;
}
return(product);
}
public MusicCDForm(MusicCD musicCD)
{
this.musicCD = musicCD;
InitializeComponent();
}
public MusicCDPanel(MusicCD item)
{
musicCD = item;
this.BackColor = Color.Transparent;
this.Size = new Size(400, 200);
this.BorderStyle = BorderStyle.FixedSingle;
picBox = new PictureBox();
picBox.Size = new Size(105, 160);
try
{
picBox.BackgroundImage = Image.FromFile(Application.StartupPath + @"\resources\musicCds\" + item.Picture);
}
catch
{
picBox.BackgroundImage = Image.FromFile(Application.StartupPath + @"\resources\not-found.png");
}
picBox.BackgroundImageLayout = ImageLayout.Zoom;
show = new Button();
show.Size = new Size(64, 64);
show.BackgroundImage = Image.FromFile(Application.StartupPath + @"\resources\show.png");
show.BackgroundImageLayout = ImageLayout.Zoom;
show.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
show.FlatAppearance.BorderSize = 0;
show.FlatAppearance.MouseDownBackColor = Color.Transparent;
show.FlatAppearance.MouseOverBackColor = Color.Transparent;
show.BackColor = Color.Transparent;
show.Cursor = Cursors.Hand;
show.Click += new EventHandler(showClick);
purchase = new Button();
purchase.Size = new Size(64, 64);
purchase.BackgroundImage = Image.FromFile(Application.StartupPath + @"\resources\purchase.png");
purchase.BackgroundImageLayout = ImageLayout.Zoom;
purchase.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
purchase.FlatAppearance.BorderSize = 0;
purchase.BackColor = Color.Transparent;
purchase.FlatAppearance.MouseDownBackColor = Color.Transparent;
purchase.FlatAppearance.MouseOverBackColor = Color.Transparent;
purchase.Cursor = Cursors.Hand;
purchase.Click += new EventHandler(purchaseClick);
name = new Label();
name.AutoSize = true;
name.Text = musicCD.Name;
name.TextAlign = ContentAlignment.MiddleLeft;
name.Font = new Font("OCR A", (float)10, FontStyle.Bold);
this.Controls.Add(name);
Singer = new Label();
Singer.AutoSize = true;
Singer.Text = item.Singer;
Singer.Font = new Font("OCR A", (float)8.25);
this.Controls.Add(Singer);
Price = new Label();
Price.AutoSize = true;
Price.Text = musicCD.Price.ToString() + " TL";
Price.Font = new Font("OCR A", (float)11.25, FontStyle.Bold);
Price.ForeColor = Color.Black;
this.Controls.Add(Price);
this.Controls[0].Location = new Point(125, 20); // Name
this.Controls[0].BringToFront();
this.Controls[1].Location = new Point(125, 50); // Author
this.Controls[1].BringToFront();
this.Controls[2].Location = new Point(125, 110); // Price
this.Controls[2].BringToFront();
this.Controls.Add(picBox);
this.Controls[3].Location = new Point(10, 15); //Item image
this.Controls.Add(show);
this.Controls[4].Location = new Point(170, 140);
this.Controls.Add(purchase);
this.Controls[5].Location = new Point(240, 140);
}
