/// <summary>
/// This function updates music.
/// </summary>
private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
string name = txtName.Text;
string id = txtId.Text;
string singer = txtSinger.Text;
string type = txtType.Text;
string price = txtPrice.Text;
MusicCD musicCD = new MusicCD(name, id, price, singer, type, update_image);
db.UpdateMusicCD(musicCD);
List <Product> MCD = Util.FillMusicCDList();
if (MCD.Count != 0)
{
MCD.Clear();
}
ListMusicCDs(MCD);
dgvMusicCDs.Show();
selected_index = -1;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
void getMusicCD()
{
SqlCommand komut = new SqlCommand("Select * From Tbl_MusicCD", bgl.baglanti());
SqlDataReader dr = komut.ExecuteReader();
while (dr.Read())
{
MusicCD musicCD = new MusicCD();
musicCD.ID = Convert.ToUInt16(dr[0]);
musicCD.Singer = dr[1].ToString();
musicCD.Type = dr[2].ToString();
musicCD.Name = dr[3].ToString();
musicCD.Price = Convert.ToDouble(dr[4]);
try
{
musicCD.Image = Image.FromFile(Application.StartupPath + @"\Resources\müzik\" + musicCD.Name + ".png");
}
catch
{
musicCD.Image = Resources.notfound;
}
musicCDlist.Add(musicCD);
}
bgl.baglanti().Close();
}
/**
*\brief A function to get the music CD list
*\return The music CD list
*/
public static List <MusicCD> GetMusicCDList()
{
SqlCommand sqlSelectCommand = MusicCD.GetSelectCommand();
List <MusicCD> MusicCDList = new List <MusicCD>();
try
{
DatabaseHandler.SQL_CONNECTION.Open();
SqlDataReader reader = sqlSelectCommand.ExecuteReader();
while (reader.HasRows && reader.Read())
{
object[] attributesOfMagazine = new object[5]; // MusicCD class has 5 attributes.
reader.GetValues(attributesOfMagazine); // Get the first row.
MusicCD newMusicCD = new MusicCD(0, "a", 0);
newMusicCD.Fill(attributesOfMagazine);
MusicCDList.Add(newMusicCD);
}
DatabaseHandler.SQL_CONNECTION.Close();
return(MusicCDList);
}
catch (Exception error)
{
MessageBox.Show(error.Message);
return(null);
}
}
public static void ItemPicture_Click(object sender, EventArgs e)
{
PictureBox item = (PictureBox)sender;
GroupBox gb = (GroupBox)item.Parent;
string itemName = gb.Controls[1].Text;
string sourceTableName = PresentTabTableName();
if (sourceTableName == "tblBook")
{
List <Book> BookList = Factory.GetBookList();
Book clickedBook = BookList.First(book => book.Name == itemName);
clickedBook.PrintProperties();
}
else if (sourceTableName == "tblMagazine")
{
List <Magazine> MagazineList = Factory.GetMagazineList();
Magazine clickedMagazine = MagazineList.First(magazine => magazine.Name == itemName);
clickedMagazine.PrintProperties();
}
else if (sourceTableName == "tblMusicCD")
{
List <MusicCD> MusicCDList = Factory.GetMusicCDList();
MusicCD clickedMusicCD = MusicCDList.First(magazine => magazine.Name == itemName);
clickedMusicCD.PrintProperties();
}
}
public MusicForm(MusicCD musicCD)
{
this.musicCD = musicCD;
InitializeComponent();
this.Text = musicCD.name;
picBox.Image = musicCD.image;
picBox.SizeMode = PictureBoxSizeMode.StretchImage;
name.Text = musicCD.name;
singer.Text = musicCD.Singer;
category.Text = "Category:" + musicCD.Category;
if (musicCD.Sale > 0 && musicCD.Sale < 100)
{
price1.Text = musicCD.price + " TL %" + musicCD.Sale;
}
else
{
price1.Text = "";
}
price2.Text = (musicCD.price - musicCD.price * (musicCD.Sale / 100)) + " TL";
string[] descriptionText = musicCD.Description.Split('$');
lblDescription.Text = "";
for (int i = 0; i < descriptionText.Length; i++)
{
lblDescription.Text += descriptionText[i] + Environment.NewLine;
}
mtQuantity.Text = "01";
picBox.BackgroundImageLayout = ImageLayout.Zoom;
}
public static MusicCD getInstance()
{
if (instance == null)
{
instance = new MusicCD();
}
return(instance);
}
/// <summary>
/// This parameter is constructor.
/// </summary>
/// <param name="_musicCD">This parameter is musicCD.</param>
public UC_MusicCD(MusicCD _musicCD)
{
this.Size = new Size(284, 453);
InitializeComponent();
lblMusicCDName.Text = _musicCD.Name;
lblSinger.Text = _musicCD.Singer;
lblType.Text = _musicCD.Type;
lblMusicCDPrice.Text = _musicCD.Price;
ID = _musicCD.Id;
picCoverPage.Image = Util.ResizeBitmap(Util.stringToImage(_musicCD.CoverPage),
picCoverPage.Width, picCoverPage.Height);
picBox = _musicCD.CoverPage;
}
private void btnaddtocartmusic_Click(object sender, EventArgs e)
{
if (tbMagazineName.Text != "" || tbMusicCDName.Text != "" || txtBookName.Text != "")
{
ItemToPurchase Item3 = new ItemToPurchase();
MusicCD music = new MusicCD("0", tbMusicCDName.Text, Convert.ToDouble(tbMusicCDPrice.Text));
Item3.Product = music;
Item3.Quantity = int.Parse(tbquantymusic.Text);
itemsOnCart.Add(Item3);
MessageBox.Show("item is added to your shopping cart");
}
else
{
MessageBox.Show("Please Select Product To add Shoppingcart");
}
}
/// <summary>
/// This function deletes music in database.
/// </summary>
private void btnDelete_Click(object sender, EventArgs e)
{
try
{
dgvMusicCDs.FirstDisplayedCell = null;
dgvMusicCDs.ClearSelection();
List <Product> MUList = Util.FillMusicCDList();
if (MUList.Count != 0)
{
for (int i = 0; i < MUList.Count; i++)
{
selected_index = dgvMusicCDs.CurrentCell.RowIndex;
MemoryStream ms = new MemoryStream();
Bitmap img = (Bitmap)dgvMusicCDs.Rows[selected_index].Cells[0].Value;
img.Save(ms, ImageFormat.Jpeg);
byte[] image = ms.ToArray();
string name = dgvMusicCDs.Rows[selected_index].Cells[1].Value.ToString();
string price = dgvMusicCDs.Rows[selected_index].Cells[2].Value.ToString();
string id = dgvMusicCDs.Rows[selected_index].Cells[3].Value.ToString();
string singer = dgvMusicCDs.Rows[selected_index].Cells[4].Value.ToString();
string type = dgvMusicCDs.Rows[selected_index].Cells[5].Value.ToString();
MusicCD musicCD = new MusicCD(name, id, price, singer, type, image);
db.DeleteMusicCD(musicCD);
if (MUList.Count != 0)
{
MUList.Clear();
}
dgvMusicCDs.Rows.RemoveAt(selected_index);
selected_index = -1;
}
}
else
{
MessageBox.Show("MusicCD is Empty!");
btnDelete.Enabled = false;
btnUpdate.Enabled = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// This function is for deleting mucicCD from the database.
/// </summary>
/// <param name="music">This parameter is a music that will be delete from database.</param>
public void DeleteMusicCD(MusicCD music)
{
try
{
connection.Connection();
connection.Open();
SqlCommand command = new SqlCommand("Delete from Tbl_Music where ID=@ProductId", connection.Connect);
command.Parameters.AddWithValue("@ProductId", music.Id);
command.ExecuteNonQuery();
connection.Close();
MessageBox.Show("MusicCD deleted.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public List <Product> MusicCDLoader()
{
List <Product> musiclist = new List <Product>();
dh.connection.Open();
SqlCommand command = new SqlCommand("SELECT * FROM [dbo].[MusicCD]", connection);
SqlDataReader reader = command.ExecuteReader();
MusicCD mc;
while (reader.Read())
{
mc = new MusicCD();
mc.ProductID = (int)reader["ID"];
mc.name = (string)reader["Name"];
mc.Singer = (string)reader["Singer"];
mc.Description = (string)reader["Description"];
mc.demo = (string)reader["Demo"];
mc.price = (double)reader["Price"];
mc.Sale = (double)reader["Sale"];
if (mc.Sale <= 0 || mc.Sale >= 100)
{
mc.discountedPrice = mc.price;
}
else
{
mc.discountedPrice = mc.price - (mc.price * mc.Sale) / 100;
}
mc.Category = (string)reader["Category"];
try
{
mc.image = Image.FromFile(Application.StartupPath + @"\Resources\MusicCdPictures\" + (string)reader["Image"] + ".png");
}
catch (Exception)
{
mc.image = Properties.Resources.noimage;
}
musiclist.Add(mc);
}
dh.connection.Close();
return(musiclist);
}
/// <summary>
/// This function add new music to database.
/// </summary>
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
bool already_exists = false;
List <Product> MUList = Util.FillMusicCDList();
for (int i = 0; i < MUList.Count; i++)
{
MusicCD tmp = new MusicCD(_name, _id, _price, _singer, _type, _coverpage);
tmp = (MusicCD)MUList[i];
if (tmp.Id == txtId.Text)
{
already_exists = true;
MessageBox.Show(tmp.Id + " ID already exists! Please change!");
}
}
if (already_exists == false)
{
if (txtName.Text != "" && txtId.Text != "" && txtPrice.Text != "" && txtSinger.Text != "" && picCoverPage.Image != null && txtType.Text != "")
{
string name = txtName.Text;
string id = txtId.Text;
string price = txtPrice.Text;
string type = txtType.Text;
string singer = txtSinger.Text;
byte[] image = System.IO.File.ReadAllBytes(openFileDialogMusicCDs.FileName);
MusicCD music = new MusicCD(name, id, price, singer, type, image);
db.AddMusicCD(music);
}
else
{
MessageBox.Show("Please! Fill all fields!");
}
}
Tb_Empty();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// This function is for pulling the MusicCD list from the database.
/// </summary>
public void MusicCDList()
{
try
{
musicTable.Clear();
connection.Connection();
connection.Open();
SqlDataAdapter da = new SqlDataAdapter("Select * from Tbl_Music", connection.Connect);
da.Fill(musicTable);
connection.Close();
for (int i = 0; i < musicTable.Rows.Count; i++)
{
music = new MusicCD(musicTable.Rows[i]["Name"].ToString(), musicTable.Rows[i]["ID"].ToString(), musicTable.Rows[i]["Price"].ToString(), musicTable.Rows[i]["Singer"].ToString(), musicTable.Rows[i]["Type"].ToString(), (byte[])musicTable.Rows[i]["Coverpage"]);
musics.Add(music);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// This function is for adding MusicCD to the database.
/// </summary>
/// <param name="music">This parameter is a music that will be add to database.</param>
public void AddMusicCD(MusicCD music)
{
try
{
connection.Connection();
connection.Open();
SqlCommand command = new SqlCommand("Insert into Tbl_Music(ID,Name,Price,Singer,Type,Coverpage) values(@Id,@Name,@Price,@Singer,@Type,@Coverpage)", connection.Connect);
command.Parameters.AddWithValue("@Id", music.Id);
command.Parameters.AddWithValue("@Name", music.Name);
command.Parameters.AddWithValue("@Price", music.Price);
command.Parameters.AddWithValue("@Singer", music.Singer);
command.Parameters.AddWithValue("@Type", music.Type);
command.Parameters.AddWithValue("@Coverpage", music.CoverPage);
command.ExecuteNonQuery();
connection.Close();
MessageBox.Show("Registration successful", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/* MUSIC CD */
/**
*\brief A function to get a group box for a music CD
*\param musicCD: A music CD
*\return A group box for a music CD
*/
public static GroupBox GetBoxFor(MusicCD musicCD)
{
GroupBox MusicCDBox = GetBox();
string MusicCDImagePath = @"..\..\..\ProductPictures\MusicCD\img_" + musicCD.Name + ".jpg";
try
{
Image itemImage = Image.FromFile(MusicCDImagePath);
((PictureBox)MusicCDBox.Controls[0]).Image = Image.FromFile(MusicCDImagePath);
}
catch (Exception)
{
((PictureBox)MusicCDBox.Controls[0]).Image = Image.FromFile(@"..\..\..\ProductPictures\img_Error.png");
}
((Label)MusicCDBox.Controls[1]).Text = musicCD.Name;
((Label)MusicCDBox.Controls[2]).Text = musicCD.Price.ToString() + " ₺";
return(MusicCDBox);
}
private void button3_Click(object sender, EventArgs e)
{
try
{
MusicCD musicCD = new MusicCD();
openFileDialog1.Multiselect = false;
openFileDialog1.Filter = "All Files |*.png; *.jpeg;*.jpg| PNG Files (*.png)|*.png|JPEG Files (*.jpeg)|*.jpeg|JPG Files (*.jpg)|*.jpg";
openFileDialog1.Title = "Dosya seçiniz.";
openFileDialog1.ShowDialog();
string filepath = openFileDialog1.FileName;
string destPath = Application.StartupPath + @"\Resources\müzik\" + musicCD.Name + ".png";
Directory.CreateDirectory(Application.StartupPath + @"\Resources\müzik\");
File.Copy(filepath, destPath, true);
txt_imageName.Text = openFileDialog1.FileName.ToString();
pictureBox1.Image = Image.FromFile(filepath);
cs.Image = Image.FromFile(filepath);
}
catch { }
}
/// <summary>
/// This function is for updating musicCDs to the database.
/// </summary>
/// <param name="music">This parameter is a music that will be update to database.</param>
public void UpdateMusicCD(MusicCD music)
{
try
{
connection.Connection();
connection.Open();
SqlCommand command = new SqlCommand("Update Tbl_Music set Name=@Name,Price=@Price,Singer=@Singer,Type=@Type,CoverPage=@Coverpage where ID=@ProductId", connection.Connect);
command.Parameters.AddWithValue("@Name", music.Name);
command.Parameters.AddWithValue("@Price", music.Price);
command.Parameters.AddWithValue("@Singer", music.Singer);
command.Parameters.AddWithValue("@Type", music.Type);
command.Parameters.AddWithValue("@Coverpage", music.CoverPage);
command.Parameters.AddWithValue("@ProductId", music.Id);
command.ExecuteNonQuery();
connection.Close();
MessageBox.Show("Update successful", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public Product FactoryMethod(ProductType productType)
{
Product product = null;
switch (productType)
{
case ProductType.Book:
product = new Book();
break;
case ProductType.Magazine:
product = new Magazine();
break;
case ProductType.MusicCD:
product = new MusicCD();
break;
default:
break;
}
return(product);
}
/* DATA ADAPTER && DATA SET */
/**
*\brief A function to get the SQL data adapter for the given table name
*\param sourceTableName: Name of the source table
*\return The SQL data adapter
*/
public static SqlDataAdapter GetDataAdapterFor(string sourceTableName)
{
if (sourceTableName == "tblCustomer")
{
return(new SqlDataAdapter(Customer.GetSelectCommand().CommandText, DatabaseHandler.CONNECTION_STRING));
}
if (sourceTableName == "tblBook")
{
return(new SqlDataAdapter(Book.GetSelectCommand().CommandText, DatabaseHandler.CONNECTION_STRING));
}
if (sourceTableName == "tblMagazine")
{
return(new SqlDataAdapter(Magazine.GetSelectCommand().CommandText, DatabaseHandler.CONNECTION_STRING));
}
if (sourceTableName == "tblMusicCD")
{
return(new SqlDataAdapter(MusicCD.GetSelectCommand().CommandText, DatabaseHandler.CONNECTION_STRING));
}
return(null);
}
/// <summary>
/// This function assigns datas into the datagrid for list. .
/// </summary>
/// <param name="_musicCDs">This parameter is product list.</param>
private void ListMusicCDs(List <Product> _musicCDs)
{
try
{
dgvMusicCDs.Rows.Clear();
for (int i = 0; i < _musicCDs.Count; i++)
{
MusicCD tmp = new MusicCD(_name, _id, _price, _singer, _type, _coverpage);
tmp = (MusicCD)_musicCDs[i];
dgvMusicCDs.Rows.Add();
dgvMusicCDs.Rows[i].Cells[0].Value = Util.ResizeBitmap(Util.stringToImage(tmp.CoverPage), 50, 50);
dgvMusicCDs.Rows[i].Cells[1].Value = tmp.Name;
dgvMusicCDs.Rows[i].Cells[2].Value = tmp.Price;
dgvMusicCDs.Rows[i].Cells[3].Value = tmp.Id;
dgvMusicCDs.Rows[i].Cells[4].Value = tmp.Singer;
dgvMusicCDs.Rows[i].Cells[5].Value = tmp.Type;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public MusicCDPanel(MusicCD item)
{
musicCD = item;
this.BackColor = Color.Transparent;
this.Size = new Size(290, 190);
this.BorderStyle = BorderStyle.FixedSingle;
picBox = new PictureBox();
picBox.Size = new Size(105, 160);
picBox.BackgroundImage = item.image;
picBox.BackgroundImageLayout = ImageLayout.Zoom;
magnifier = new PictureBox();
magnifier.Size = new Size(32, 32);
magnifier.BackgroundImage = Properties.Resources.magnifier;
magnifier.BackgroundImageLayout = ImageLayout.Zoom;
magnifier.Cursor = Cursors.Hand;
magnifier.Click += new EventHandler(panelClick);
name = new Label();
name.AutoSize = true;
name.Text = item.name;
name.TextAlign = ContentAlignment.MiddleLeft;
name.Font = new Font("Microsoft Sans Serif", (float)9.75, FontStyle.Italic);
this.Controls.Add(name);
Singer = new Label();
Singer.AutoSize = true;
Singer.Text = item.Singer;
Singer.Font = new Font("Microsoft Sans Serif", (float)8.25);
this.Controls.Add(Singer);
Type = new Label();
Type.AutoSize = true;
Type.Text = item.Category;
Type.Font = new Font("Microsoft Sans Serif", (float)8.25);
Type.ForeColor = Color.DarkGray;
this.Controls.Add(Type);
Price1 = new Label();
Price1.AutoSize = true;
if (item.Sale > 0 && item.Sale < 100)
{
Price1.Text = item.price + "TL %" + item.Sale;
}
else
{
Price1.Text = "";
}
Price1.Font = new Font("Microsoft Sans Serif", (float)11.25, FontStyle.Strikeout | FontStyle.Italic);
Price1.ForeColor = Color.DarkGray;
this.Controls.Add(Price1);
Price2 = new Label();
Price2.AutoSize = true;
Price2.Text = item.discountedPrice + " TL";
Price2.Font = new Font("Microsoft Sans Serif", (float)11.25, FontStyle.Bold);
this.Controls.Add(Price2);
playBtn = new PictureBox();
playBtn.Size = new Size(32, 32);
playBtn.BackgroundImage = Properties.Resources.pnlPlay;
playBtn.BackgroundImageLayout = ImageLayout.Zoom;
playBtn.Cursor = Cursors.Hand;
playBtn.Click += new EventHandler(playBtnClick);
this.Controls.Add(playBtn);
picAdd = new PictureBox();
picAdd.Size = new Size(32, 32);
picAdd.BackgroundImage = Properties.Resources.addcart;
picAdd.BackgroundImageLayout = ImageLayout.Zoom;
picAdd.Cursor = Cursors.Hand;
picAdd.Click += new EventHandler(addCart);
this.Controls[0].Location = new Point(125, 20); // Name label
this.Controls[0].BringToFront();
this.Controls[1].Location = new Point(125, 50); // Singer label
this.Controls[1].BringToFront();
this.Controls[2].Location = new Point(125, 80); // Type label
this.Controls[2].BringToFront();
this.Controls[3].Location = new Point(125, 110); // Price1 label
this.Controls[3].BringToFront();
this.Controls[4].Location = new Point(210, 110); // Price2 label
this.Controls[4].BringToFront();
this.Controls[5].Location = new Point(120, 140); // Play demo button
this.Controls[5].BringToFront();
this.Controls.Add(picBox);
this.Controls[6].Location = new Point(10, 15); //Picturebox
this.Controls.Add(magnifier);
this.Controls[7].Location = new Point(175, 140); //Magnifier image
this.Controls.Add(picAdd);
this.Controls[8].Location = new Point(225, 140); //Add to cart image
}
private void btnRemoveProduct_Click(object sender, EventArgs e)
{
if (cbRemovedProductQuantity.Text == "")
{
MessageBox.Show("Please Set Quantity!");
}
else
{
string[] properties;
int place = 0;
for (int i = 0; i < listProducts.Items.Count; i++)
{
if (listProducts.Items[i].Selected == true)
{
int newQuantity = 0;
if (Convert.ToInt32(listProducts.Items[i].SubItems[0].Text) > 100 && Convert.ToInt32(listProducts.Items[i].SubItems[0].Text) < 200)
{
properties = new string[PropertiesCountOfItem("Book")];
Book myBook = new Book();
place = Convert.ToInt32(listProducts.Items[i].SubItems[0].Text) - 100;
properties = myBook.printProperties(place);
myBook.setID(Convert.ToInt32(properties[0]));
myBook.setName(properties[1]);
myBook.setPrice(Convert.ToInt32(properties[2]));
myBook.setISBN(Convert.ToInt32(properties[3]));
myBook.setAuthor(properties[4]);
myBook.setPublisher(properties[5]);
ItemToPurchase item = new ItemToPurchase(myBook, Convert.ToInt32(cbRemovedProductQuantity.Text));
myShoppingCart.removeProduct(item);
if (Convert.ToInt32(cbRemovedProductQuantity.Text) >= Convert.ToInt32(listProducts.Items[i].SubItems[3].Text))
{
listProducts.Items[i].Remove();
}
else
{
newQuantity = Convert.ToInt32(listProducts.Items[i].SubItems[3].Text) - Convert.ToInt32(cbRemovedProductQuantity.Text);
listProducts.Items[i].SubItems[3].Text = newQuantity.ToString();
listProducts.Refresh();
}
}
else if (Convert.ToInt32(listProducts.Items[i].SubItems[0].Text) > 200 && Convert.ToInt32(listProducts.Items[i].SubItems[0].Text) < 300)
{
properties = new string[PropertiesCountOfItem("Magazine")];
Magazine myMagazine = new Magazine();
place = Convert.ToInt32(listProducts.Items[i].SubItems[0].Text) - 200;
properties = myMagazine.printProperties(place);
myMagazine.setID(Convert.ToInt32(properties[0]));
myMagazine.setName(properties[1]);
myMagazine.setPrice(Convert.ToInt32(properties[2]));
myMagazine.setissue(properties[3]);
myMagazine.setType(properties[4]);
ItemToPurchase item = new ItemToPurchase(myMagazine, Convert.ToInt32(cbRemovedProductQuantity.Text));
myShoppingCart.removeProduct(item);
if (Convert.ToInt32(cbRemovedProductQuantity.Text) >= Convert.ToInt32(listProducts.Items[i].SubItems[3].Text))
{
listProducts.Items[i].Remove();
}
else
{
newQuantity = Convert.ToInt32(listProducts.Items[i].SubItems[3].Text) - Convert.ToInt32(cbRemovedProductQuantity.Text);
listProducts.Items[i].SubItems[3].Text = newQuantity.ToString();
listProducts.Refresh();
}
}
else
{
properties = new string[PropertiesCountOfItem("MusicCD")];
MusicCD myMusicCD = new MusicCD();
place = Convert.ToInt32(listProducts.Items[i].SubItems[0].Text) - 300;
properties = myMusicCD.printProperties(place);
myMusicCD.setID(Convert.ToInt32(properties[0]));
myMusicCD.setName(properties[1]);
myMusicCD.setPrice(Convert.ToInt32(properties[2]));
myMusicCD.setsinger(properties[3]);
myMusicCD.setType(properties[4]);
ItemToPurchase item = new ItemToPurchase(myMusicCD, Convert.ToInt32(cbRemovedProductQuantity.Text));
myShoppingCart.removeProduct(item);
if (Convert.ToInt32(cbRemovedProductQuantity.Text) >= Convert.ToInt32(listProducts.Items[i].SubItems[3].Text))
{
listProducts.Items[i].Remove();
}
else
{
newQuantity = Convert.ToInt32(listProducts.Items[i].SubItems[3].Text) - Convert.ToInt32(cbRemovedProductQuantity.Text);
listProducts.Items[i].SubItems[3].Text = newQuantity.ToString();
listProducts.Refresh();
}
}
}
}
}
}
void SearchBook()
{
BookSearch.Clear();
flowLayoutPanel1.Controls.Clear();
SqlCommand komut = new SqlCommand("Select * From Tbl_Book where author like '%" + TxtAra.Text + "%' or publisher like '%" + TxtAra.Text + "%' or isbnNumber like '%" + TxtAra.Text + "%' or BookName like '%" + TxtAra.Text + "%'", bgl.baglanti());
SqlDataReader dr = komut.ExecuteReader();
while (dr.Read())
{
Book book = new Book();
book.ID = Convert.ToUInt16(dr[0]);
book.ISBN_Number = dr[1].ToString();
book.Author = dr[2].ToString();
book.Page = Convert.ToInt16(dr[3]);
book.Publisher = dr[4].ToString();
book.Name = dr[6].ToString();
book.Price = Convert.ToDouble(dr[7]);
try
{
book.Image = Image.FromFile(Application.StartupPath + @"\Resources\book\" + book.Name + ".png");
}
catch
{
book.Image = Resources.notfound;
}
BookSearch.Add(book);
}
bgl.baglanti().Close();
getComboBook(BookSearch);
MagazineSearch.Clear();
SqlCommand komut3 = new SqlCommand("Select * From Tbl_Magazine where issue like '%" + TxtAra.Text + "%' or type like '%" + TxtAra.Text + "%' or MagazineName like '%" + TxtAra.Text + "%'", bgl.baglanti());
SqlDataReader dr3 = komut3.ExecuteReader();
while (dr3.Read())
{
Magazine magazine = new Magazine();
magazine.ID = Convert.ToUInt16(dr3[0]);
magazine.Issue = dr3[1].ToString();
magazine.Type = dr3[2].ToString();
magazine.Name = dr3[3].ToString();
magazine.Price = Convert.ToDouble(dr3[4]);
try
{
magazine.Image = Image.FromFile(Application.StartupPath + @"\Resources\magazine\" + magazine.Name + ".png");
}
catch
{
magazine.Image = Resources.notfound;
}
MagazineSearch.Add(magazine);
}
bgl.baglanti().Close();
getComboMagazine(MagazineSearch);
MusicSearch.Clear();
SqlCommand komut2 = new SqlCommand("Select * From Tbl_MusicCD where singer like '%" + TxtAra.Text + "%' or type like '%" + TxtAra.Text + "%' or MusicName like '%" + TxtAra.Text + "%'", bgl.baglanti());
SqlDataReader dr2 = komut2.ExecuteReader();
while (dr2.Read())
{
MusicCD musicCD = new MusicCD();
musicCD.ID = Convert.ToUInt16(dr2[0]);
musicCD.Singer = dr2[1].ToString();
musicCD.Type = dr2[2].ToString();
musicCD.Name = dr2[3].ToString();
musicCD.Price = Convert.ToDouble(dr2[4]);
try
{
musicCD.Image = Image.FromFile(Application.StartupPath + @"\Resources\müzik\" + musicCD.Name + ".png");
}
catch
{
musicCD.Image = Resources.notfound;
}
MusicSearch.Add(musicCD);
}
bgl.baglanti().Close();
getComboMusicCD(MusicSearch);
}
void getComboMusicCD(List <MusicCD> bul)
{
for (int j = 0; j < bul.Count; j++)
{
Panel Pnl = new Panel();
Pnl.BackColor = Color.White;
Pnl.BorderStyle = BorderStyle.FixedSingle;
Pnl.Name = "Pnl" + i.ToString();
Size sz = new Size(263, 214);
Pnl.Size = sz;
Label lbl1 = new Label();
Label lbl2 = new Label();
Label lbl3 = new Label();
Label lbl4 = new Label();
Label lbl5 = new Label();
lbl1.Name = "lbl1_" + i.ToString();
lbl2.Name = "lbl2_" + i.ToString();
lbl3.Name = "lbl3_" + i.ToString();
lbl4.Name = "lbl4_" + i.ToString();
lbl5.Name = "lbl5_" + i.ToString();
lbl1.Text = bul[j].Name;
lbl2.Text = bul[j].Singer.ToString();
lbl3.Text = bul[j].Type;
lbl4.Text = "Price: " + bul[j].Price.ToString();
musicmiktar = bul[j].Price;
Point position = new Point(135, 33);
lbl1.Location = position;
Point position2 = new Point(135, 62);
lbl2.Location = position2;
Point position3 = new Point(135, 92);
lbl3.Location = position3;
Point position4 = new Point(135, 150);
lbl4.Location = position4;
PictureBox pcbox = new PictureBox();
pcbox.Name = "pcbox" + i.ToString();
Size sizePic = new Size(115, 154);
pcbox.Size = sizePic;
Point position6 = new Point(2, 22);
pcbox.Location = position6;
pcbox.SizeMode = PictureBoxSizeMode.StretchImage;
pcbox.Image = bul[j].Image;
Button btn = new Button();
Point positionBtn = new Point(192, 183);
btn.Location = positionBtn;
Size sizeBtn = new Size(58, 23);
btn.Size = sizeBtn;
btn.Name = "btn" + i.ToString();
btn.Text = "Add";
MusicCD musicCD = new MusicCD();
musicCD.ID = bul[j].ID;
ComboBox cmbox = new ComboBox();
Point locationCmbox = new Point(143, 183);
cmbox.Location = locationCmbox;
Size sizeCmbox = new Size(44, 23);
cmbox.Size = sizeCmbox;
for (int k = 1; k < 10; k++)
{
cmbox.Items.Add(k);
}
cmbox.SelectedIndex = 0;
btn.Click += delegate
{
for (int l = 0; l < Convert.ToInt16(cmbox.Text); l++)
{
SqlCommand komut = new SqlCommand("insert into Tbl_ShoppingCard (Customerid,ItemtoPurchase,PaymentAmount,PaymentType) values (@p1,@p2,@p3,@p4)", bgl.baglanti());
komut.Parameters.AddWithValue("@p2", "MusicCD");
komut.Parameters.AddWithValue("@p3", musicmiktar);
komut.Parameters.AddWithValue("@p1", cs.CustomerID);
komut.Parameters.AddWithValue("@p4", 1);
komut.ExecuteNonQuery();
}
bgl.baglanti().Close();
MessageBox.Show("Sepete eklendi.");
};
Pnl.Controls.Add(lbl1);
Pnl.Controls.Add(lbl2);
Pnl.Controls.Add(lbl3);
Pnl.Controls.Add(lbl4);
Pnl.Controls.Add(lbl5);
Pnl.Controls.Add(pcbox);
Pnl.Controls.Add(btn);
Pnl.Controls.Add(cmbox);
flowLayoutPanel1.Controls.Add(Pnl);
i++;
}
}
void Listele()
{
SqlCommand komut = new SqlCommand("Select * From Tbl_ShoppingCard", bgl.baglanti());
SqlDataReader dr = komut.ExecuteReader();
int i = 0;
totalPrice = 0;
bookList.Clear();
magazinelist.Clear();
musicCDlist.Clear();
while (dr.Read())
{
int csID = Convert.ToInt16(dr[0]);
if (csID == cs.CustomerID)
{
string type = dr[1].ToString();
if (type == "Book")
{
SqlCommand komut2 = new SqlCommand("Select * From Tbl_Book", bgl.baglanti());
SqlDataReader dr2 = komut2.ExecuteReader();
while (dr2.Read())
{
int tblShopping = Convert.ToInt16(dr[0]);
int tblBook = Convert.ToInt16(dr2[0]);
Book book = new Book();
book.ID = Convert.ToUInt16(dr2[0]);
book.ISBN_Number = dr2[1].ToString();
book.Author = dr2[2].ToString();
book.Page = Convert.ToInt16(dr2[3]);
book.Publisher = dr2[4].ToString();
book.Name = dr2[6].ToString();
//try
//{
// book.Image = Image.FromFile(Application.StartupPath + @"\Resources\BookPictures\" + dr2["Product_Name"] + ".png");
//}
//catch
//{
// book.Image = Resources.notfound;
//}
bookList.Add(book);
Panel Pnl = new Panel();
Pnl.BackColor = Color.White;
Pnl.BorderStyle = BorderStyle.FixedSingle;
Pnl.Name = "Pnl" + i.ToString();
Size sz = new Size(513, 115);
Pnl.Size = sz;
Label lbl1 = new Label();
Label lbl2 = new Label();
lbl1.Name = "lbl1_" + i.ToString();
lbl2.Name = "lbl2_" + i.ToString();
lbl1.Text = book.Name;
Point position = new Point(119, 48);
lbl1.Location = position;
Point position2 = new Point(385, 48);
lbl2.Location = position2;
PictureBox pcbox = new PictureBox();
pcbox.Name = "pcbox";
Point position3 = new Point(4, 4);
pcbox.Location = position3;
Size sizePic = new Size(84, 105);
pcbox.Size = sizePic;
pcbox.SizeMode = PictureBoxSizeMode.StretchImage;
pcbox.Image = book.Image;
ComboBox cmbox = new ComboBox();
for (int j = 1; j < 9; j++)
{
cmbox.Items.Add(j);
}
cmbox.SelectedIndex = 0;
Point position4 = new Point(296, 43);
cmbox.Location = position4;
Size sizeCmBox = new Size(48, 24);
cmbox.Size = sizeCmBox;
shopping.PaymentAmount = Convert.ToInt16(cmbox.Text);
lbl2.Text = shopping.PaymentAmount.ToString() + " TL";
PictureBox pcRemove = new PictureBox();
pcRemove.Name = "pcRemove_" + i.ToString();
Point position5 = new Point(475, 77);
pcRemove.Location = position5;
Size sizePicRemove = new Size(33, 33);
pcRemove.Size = sizePicRemove;
//pcRemove.Image = Resources.remove;
pcRemove.SizeMode = PictureBoxSizeMode.StretchImage;
pcRemove.Cursor = Cursors.Hand;
pcRemove.Click += delegate
{
SqlCommand komut3 = new SqlCommand("DELETE FROM Tbl_ShoppingCard WHERE Customerid=@p1", bgl.baglanti());
komut3.Parameters.AddWithValue("p1", book.ID);
komut3.ExecuteNonQuery();
bgl.baglanti().Close();
flowLayoutPanel1.Controls.Clear();
Listele();
};
CheckBox chbox = new CheckBox();
chbox.Name = "chbox_" + i.ToString();
Point location6 = new Point(464, 47);
chbox.Location = location6;
chbox.UseVisualStyleBackColor = true;
Size sizeCheck = new Size(15, 14);
chbox.Size = Size;
chbox.Text = "Seçim";
Pnl.Controls.Add(lbl1);
Pnl.Controls.Add(lbl2);
Pnl.Controls.Add(pcbox);
//Pnl.Controls.Add(cmbox);
Pnl.Controls.Add(pcRemove);
Pnl.Controls.Add(chbox);
flowLayoutPanel1.Controls.Add(Pnl);
i++;
}
bgl.baglanti().Close();
}
else if (type == "Magazine")
{
SqlCommand komut2 = new SqlCommand("Select * From Tbl_Magazine", bgl.baglanti());
SqlDataReader dr2 = komut2.ExecuteReader();
while (dr2.Read())
{
int tblShopping = Convert.ToInt16(dr[0]);
int tblMagazine = Convert.ToInt16(dr2[0]);
if (tblShopping == tblMagazine)
{
Magazine magazine = new Magazine();
magazine.ID = Convert.ToUInt16(dr2[0]);
magazine.Issue = dr2[1].ToString();
magazine.Type = dr2[2].ToString();
magazine.Name = dr2[3].ToString();
//try
//{
// magazine.Image = Image.FromFile(Application.StartupPath + @"\Resources\MagazinePictures\" + dr2["Product_Name"] + ".png");
//}
//catch
//{
// magazine.Image = Resources.notfound;
//}
magazinelist.Add(magazine);
Panel Pnl = new Panel();
Pnl.BackColor = Color.White;
Pnl.BorderStyle = BorderStyle.FixedSingle;
Pnl.Name = "Pnl" + i.ToString();
Size sz = new Size(513, 115);
Pnl.Size = sz;
Label lbl1 = new Label();
Label lbl2 = new Label();
lbl1.Name = "lbl1_" + i.ToString();
lbl2.Name = "lbl2_" + i.ToString();
lbl1.Text = magazine.Name;
lbl2.Text = magazine.Price.ToString() + " TL";
Point position = new Point(119, 48);
lbl1.Location = position;
Point position2 = new Point(385, 48);
lbl2.Location = position2;
PictureBox pcbox = new PictureBox();
pcbox.Name = "pcbox";
Point position3 = new Point(4, 4);
pcbox.Location = position3;
Size sizePic = new Size(84, 105);
pcbox.Size = sizePic;
pcbox.SizeMode = PictureBoxSizeMode.StretchImage;
pcbox.Image = magazine.Image;
ComboBox cmbox = new ComboBox();
for (int j = 1; j < 9; j++)
{
cmbox.Items.Add(j);
}
cmbox.SelectedIndex = 0;
Point position4 = new Point(296, 43);
cmbox.Location = position4;
Size sizeCmBox = new Size(48, 24);
cmbox.Size = sizeCmBox;
PictureBox pcRemove = new PictureBox();
pcRemove.Name = "pcRemove_" + i.ToString();
Point position5 = new Point(475, 77);
pcRemove.Location = position5;
Size sizePicRemove = new Size(33, 33);
pcRemove.Size = sizePicRemove;
//pcRemove.Image = Resources.remove;
pcRemove.SizeMode = PictureBoxSizeMode.StretchImage;
pcRemove.Cursor = Cursors.Hand;
pcRemove.Click += delegate
{
SqlCommand komut3 = new SqlCommand("DELETE FROM Tbl_ShoppingCard WHERE Customerid=@p1", bgl.baglanti());
komut3.Parameters.AddWithValue("p1", magazine.ID);
komut3.ExecuteNonQuery();
bgl.baglanti().Close();
flowLayoutPanel1.Controls.Clear();
Listele();
};
Pnl.Controls.Add(lbl1);
Pnl.Controls.Add(lbl2);
Pnl.Controls.Add(pcbox);
//Pnl.Controls.Add(cmbox);
Pnl.Controls.Add(pcRemove);
flowLayoutPanel1.Controls.Add(Pnl);
i++;
}
}
bgl.baglanti().Close();
}
else if (type == "Music")
{
SqlCommand komut2 = new SqlCommand("Select * From Tbl_Music", bgl.baglanti());
SqlDataReader dr2 = komut2.ExecuteReader();
while (dr2.Read())
{
int tblShopping = Convert.ToInt16(dr[0]);
int tblMusic = Convert.ToInt16(dr2[0]);
if (tblShopping == tblMusic)
{
MusicCD musicCD = new MusicCD();
musicCD.ID = Convert.ToUInt16(dr2[0]);
musicCD.Singer = dr2[1].ToString();
musicCD.Type = dr2[2].ToString();
musicCD.Name = dr2[3].ToString();
//try
//{
// musicCD.Image = Image.FromFile(Application.StartupPath + @"\Resources\MusicPictures\" + dr2["Product_Name"] + ".png");
//}
//catch
//{
// musicCD.Image = Resources.notfound;
//}
musicCDlist.Add(musicCD);
Panel Pnl = new Panel();
Pnl.BackColor = Color.White;
Pnl.BorderStyle = BorderStyle.FixedSingle;
Pnl.Name = "Pnl" + i.ToString();
Size sz = new Size(513, 115);
Pnl.Size = sz;
Label lbl1 = new Label();
Label lbl2 = new Label();
lbl1.Name = "lbl1_" + i.ToString();
lbl2.Name = "lbl2_" + i.ToString();
lbl1.Text = musicCD.Name;
lbl2.Text = musicCD.Price.ToString() + " TL";
Point position = new Point(119, 48);
lbl1.Location = position;
Point position2 = new Point(385, 48);
lbl2.Location = position2;
PictureBox pcbox = new PictureBox();
pcbox.Name = "pcbox";
Point position3 = new Point(4, 4);
pcbox.Location = position3;
Size sizePic = new Size(84, 105);
pcbox.Size = sizePic;
pcbox.SizeMode = PictureBoxSizeMode.StretchImage;
pcbox.Image = musicCD.Image;
ComboBox cmbox = new ComboBox();
for (int j = 1; j < 9; j++)
{
cmbox.Items.Add(j);
}
cmbox.SelectedIndex = 0;
Point position4 = new Point(296, 43);
cmbox.Location = position4;
Size sizeCmBox = new Size(48, 24);
cmbox.Size = sizeCmBox;
PictureBox pcRemove = new PictureBox();
pcRemove.Name = "pcRemove_" + i.ToString();
Point position5 = new Point(475, 77);
pcRemove.Location = position5;
Size sizePicRemove = new Size(33, 33);
pcRemove.Size = sizePicRemove;
//pcRemove.Image = Resources.remove;
pcRemove.SizeMode = PictureBoxSizeMode.StretchImage;
pcRemove.Cursor = Cursors.Hand;
pcRemove.Click += delegate
{
SqlCommand komut3 = new SqlCommand("DELETE FROM Tbl_ShoppingCard WHERE Product_ID=@p1", bgl.baglanti());
komut3.Parameters.AddWithValue("p1", musicCD.ID);
komut3.ExecuteNonQuery();
bgl.baglanti().Close();
flowLayoutPanel1.Controls.Clear();
Listele();
};
Pnl.Controls.Add(lbl1);
Pnl.Controls.Add(lbl2);
Pnl.Controls.Add(pcbox);
// Pnl.Controls.Add(cmbox);
Pnl.Controls.Add(pcRemove);
flowLayoutPanel1.Controls.Add(Pnl);
i++;
}
}
bgl.baglanti().Close();
}
}
}
bgl.baglanti().Close();
for (int k = 0; k < bookList.Count; k++)
{
totalPrice += bookList[k].Price;
}
for (int k = 0; k < magazinelist.Count; k++)
{
totalPrice += magazinelist[k].Price;
}
for (int k = 0; k < musicCDlist.Count; k++)
{
totalPrice += musicCDlist[k].Price;
}
lbl_price.Text = totalPrice.ToString();
}
