public List <Product> MusicCDLoader()
{
List <Product> musiclist = new List <Product>();
sqlConnection = new SqlConnection(connectionString);
sqlConnection.Open();
command = new SqlCommand("SELECT * FROM [dbo].[MusicCd]", sqlConnection);
sqlDataReader = command.ExecuteReader();
MusicCD music;
while (sqlDataReader.Read())
{
music = new MusicCD("", "", 0);
music.ID = (string)sqlDataReader["Id"];
music.Name = (string)sqlDataReader["Name"];
music.Singer = (string)sqlDataReader["Singer"];
music.Isbn = (string)sqlDataReader["Isbn"];
music.Price = (double)sqlDataReader["Price"];
music.ReleaseDate = (int)sqlDataReader["ReleaseDate"];
music.Category = MusicCD.GetMusicType((string)sqlDataReader["Type"].ToString().Trim()).ToString();
music.Content = (string)sqlDataReader["CdContent"];
try
{
music.Picture = Image.FromFile(Application.StartupPath + @"\Resources\" + music.ID.Trim() + ".jpg");
}
catch (Exception)
{
}
musiclist.Add(music);
}
sqlConnection.Close();
return(musiclist);
}
/// <summary>
/// This function is Constructor.
/// </summary>
/// <param name="musicCD">This parameter is a list of MusicCD class.</param>
/// <returns> This function does not return a value </returns>
public MusicCdDesign(MusicCD musicCD)
{
InitializeComponent();
this.musicCD = musicCD;
lblName.Text += musicCD.Name;
lblSinger.Text += musicCD.Singer;
lblType.Text += musicCD.Type.ToString();
lblPrice.Text += musicCD.Price.ToString() + " ₺";
picMusicCD.Image = this.musicCD.Image;
}
/// <summary>
/// This function save elements of the ProductList.xml file.
/// </summary>
/// <param name="product">This parameter is a object of Product class.</param>
/// <returns> This function does not return a value </returns>
public static void Save(Product product)
{
XDocument xDoc = XDocument.Load(@"data/ProductList.xml");
XElement rootElement = xDoc.Root;
XElement newElementProduct = new XElement("Product");
if (product is Book)
{
Book temp = (Book)product;
XAttribute attClassType = new XAttribute("Class", "Book");
XAttribute attID = new XAttribute("ID", temp.ID1);
XElement name = new XElement("Name", temp.Name);
XElement price = new XElement("Price", temp.Price);
XElement image = new XElement("Image", UtilConvert.ImageToBase64(temp.Image, temp.Image.RawFormat));
XElement isbn = new XElement("ISBN", temp.ISBN1);
XElement author = new XElement("Author", temp.Author);
XElement publisher = new XElement("Publisher", temp.Publisher);
XElement pages = new XElement("Pages", temp.Pages);
newElementProduct.Add(attClassType, attID, name, price, image, isbn, author, publisher, pages);
rootElement.Add(newElementProduct);
xDoc.Save(@"data/ProductList.xml");
return;
}
else if (product is Magazine)
{
Magazine temp = (Magazine)product;
XAttribute attClassType = new XAttribute("Class", "Magazine");
XAttribute attID = new XAttribute("ID", temp.ID1);
XElement name = new XElement("Name", temp.Name);
XElement price = new XElement("Price", temp.Price);
XElement image = new XElement("Image", UtilConvert.ImageToBase64(temp.Image, temp.Image.RawFormat));
XElement issue = new XElement("Issue", temp.Issue);
XElement magazineType = new XElement("MagazineType", temp.Type);
newElementProduct.Add(attClassType, attID, name, price, image, issue, magazineType);
rootElement.Add(newElementProduct);
xDoc.Save(@"data/ProductList.xml");
return;
}
else
{
MusicCD temp = (MusicCD)product;
XAttribute attClassType = new XAttribute("Class", "MusicCD");
XAttribute attID = new XAttribute("ID", temp.ID1);
XElement name = new XElement("Name", temp.Name);
XElement price = new XElement("Price", temp.Price);
XElement image = new XElement("Image", UtilConvert.ImageToBase64(temp.Image, temp.Image.RawFormat));
XElement singer = new XElement("Singer", temp.Singer);
XElement musicCDType = new XElement("MusicCDType", temp.Type);
newElementProduct.Add(attClassType, attID, name, price, image, singer, musicCDType);
rootElement.Add(newElementProduct);
xDoc.Save(@"data/ProductList.xml");
return;
}
}
/// <summary>
/// This function update elements of the ProductList.xml file.
/// </summary>
/// <param name="product">This parameter is a object of Product class.</param>
/// <returns> This function does not return a value </returns>
public static void Update(Product product)
{
try
{
XDocument xDoc = XDocument.Load(@"data/ProductList.xml");
XElement rootElement = xDoc.Root;
foreach (XElement item in rootElement.Elements())
{
if (item.Attribute("ID").Value == product.ID1)
{
if (product is Book)
{
Book temp = (Book)product;
item.Element("Name").Value = temp.Name;
item.Element("Price").Value = temp.Price.ToString();
item.Element("Image").Value = UtilConvert.ImageToBase64(temp.Image, temp.Image.RawFormat);
item.Element("ISBN").Value = temp.ISBN1;
item.Element("Author").Value = temp.Author;
item.Element("Publisher").Value = temp.Publisher;
item.Element("Pages").Value = temp.Pages.ToString();
xDoc.Save(@"data/ProductList.xml");
return;
}
else if (product is Magazine)
{
Magazine temp = (Magazine)product;
item.Element("Name").Value = temp.Name;
item.Element("Price").Value = temp.Price.ToString();
item.Element("Image").Value = UtilConvert.ImageToBase64(temp.Image, temp.Image.RawFormat);
item.Element("Issue").Value = temp.Issue;
item.Element("MagazineType").Value = temp.Type.ToString();
xDoc.Save(@"data/ProductList.xml");
return;
}
else
{
MusicCD temp = (MusicCD)product;
item.Element("Name").Value = temp.Name;
item.Element("Price").Value = temp.Price.ToString();
item.Element("Image").Value = UtilConvert.ImageToBase64(temp.Image, temp.Image.RawFormat);
item.Element("Singer").Value = temp.Singer;
item.Element("MusicCDType").Value = temp.Type.ToString();
xDoc.Save(@"data/ProductList.xml");
return;
}
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
/// <summary>
/// This function holds the music cd information and create listview item.
/// </summary>
/// <returns> This function does not return a value </returns>
private void ToListView()
{
foreach (Product product in StoreMainScreen.productList)
{
if (product is MusicCD)
{
MusicCD musicCD = (MusicCD)product;
string id = musicCD.ID1;
string name = musicCD.Name;
string price = musicCD.Price.ToString();
string singer = musicCD.Singer;
string type = musicCD.Type.ToString();
string[] stringItems = { id, name, price, singer, type };
ListViewItem item = new ListViewItem(stringItems);
listViewMusicCDs.Items.Add(item);
}
}
}
/// <summary>
/// This function update selected music cd button click operation.
/// This function is used to changed enabled.
/// </summary>
/// <returns> This function does not return a value </returns>
private void btnUpdateSelected_Click(object sender, EventArgs e)
{
Logger.GetLogger().WriteLog(LoginedCustomer.getInstance().User.Username, btnUpdateSelected.Text, DateTime.Now);
if (selectedIndex == -1)
{
MessageBox.Show("Please select a book from list!");
return;
}
panelAddMusicCD.Visible = true;
selectedID = listViewMusicCDs.Items[selectedIndex].SubItems[0].Text;
foreach (Product product in StoreMainScreen.productList)
{
if (product.ID1 == selectedID)
{
MusicCD musicCD = (MusicCD)product;
pboxMusicCD.Image = musicCD.Image;
txtName.Text = musicCD.Name;
txtID.Text = musicCD.ID1;
txtPrice.Text = musicCD.Price.ToString();
txtSinger.Text = musicCD.Singer;
switch (musicCD.Type)
{
case MusicCD_Type.Romance:
cBoxType.SelectedIndex = 0;
break;
case MusicCD_Type.HardRock:
cBoxType.SelectedIndex = 1;
break;
case MusicCD_Type.Country:
cBoxType.SelectedIndex = 2;
break;
default:
break;
}
}
}
btnAdd.Visible = false;
btnUpdate.Visible = true;
txtID.Enabled = false;
}
public MusicForm(MusicCD musicCD)
{
this.musicCD = musicCD;
InitializeComponent();
this.Text = musicCD.Name;
txtName.Text = musicCD.Name;
txtSinger.Text = musicCD.Singer;
txtCategory.Text = musicCD.Category;
txtPrice.Text = musicCD.Price + " TL";
pbMusic.Image = musicCD.Picture;
txtIsbn.Text = musicCD.Isbn;
txtReleaseYear.Text = musicCD.ReleaseDate.ToString();
pbMusic.SizeMode = PictureBoxSizeMode.StretchImage;
txtCounter.Text = "1";
string[] contentText = musicCD.Content.Split(',');
for (int i = 0; i < contentText.Length; i++)
{
txtContent.Text += contentText[i] + Environment.NewLine;
}
}
public static Product createProduct(ProductType pType, string id, string name, double price)
{
Product product = null;
switch (pType)
{
case ProductType.Book:
product = new Book(id, name, price);
break;
case ProductType.Magazine:
product = new Magazine(id, name, price);
break;
case ProductType.MusicCD:
product = new MusicCD(id, name, price);
break;
default:
break;
}
return(product);
}
public MusicCdPanel(MusicCD musicCd)
{
this.musicCD = musicCd;
this.BackColor = Color.FromArgb(160, 0, 190, 190);
this.Size = new Size(290, 190);
this.BorderStyle = BorderStyle.None;
Picture = new PictureBox();
Picture.Size = new Size(105, 160);
Picture.BackgroundImage = musicCd.Picture;
Picture.BackgroundImageLayout = ImageLayout.Zoom;
Picture.BackColor = Color.Transparent;
Show_Details = new PictureBox();
Show_Details.Size = new Size(32, 32);
Show_Details.BackgroundImage = Properties.Resources.loupe;
Show_Details.BackgroundImageLayout = ImageLayout.Stretch;
Show_Details.Cursor = Cursors.Hand;
Show_Details.BackColor = Color.Transparent;
Show_Details.Click += new EventHandler(panelClick);
name = new Label();
name.AutoSize = true;
name.Text = musicCd.Name;
name.BackColor = Color.Transparent;
name.TextAlign = ContentAlignment.MiddleLeft;
name.ForeColor = Color.White;
name.Font = new Font("Calibri", (float)13);
this.Controls.Add(name);
Singer = new Label();
Singer.AutoSize = true;
Singer.Text = musicCd.Singer;
Singer.BackColor = Color.Transparent;
Singer.ForeColor = Color.White;
Singer.Font = new Font("Calibri", (float)12);
this.Controls.Add(Singer);
Type = new Label();
Type.AutoSize = true;
Type.Text = musicCd.Category;
Type.BackColor = Color.Transparent;
Type.Font = new Font("Calibri", (float)10);
Type.ForeColor = Color.White;
this.Controls.Add(Type);
Price = new Label();
Price.AutoSize = true;
Price.Text = musicCd.Price + " TL";
Price.BackColor = Color.Transparent;
Price.Font = new Font("Calibri", (float)11.25);
Price.ForeColor = Color.White;
this.Controls.Add(Price);
Add_Cart = new PictureBox();
Add_Cart.Size = new Size(32, 32);
Add_Cart.BackgroundImage = Properties.Resources.showDetails;
Add_Cart.BackgroundImageLayout = ImageLayout.Stretch;
Add_Cart.Cursor = Cursors.Hand;
Add_Cart.BackColor = Color.Transparent;
Add_Cart.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); // Price label
this.Controls[3].BringToFront();
this.Controls.Add(Picture);
this.Controls[4].Location = new Point(10, 15); //Picturebox
this.Controls.Add(Show_Details);
this.Controls[5].Location = new Point(175, 140); //Magnifier image
this.Controls.Add(Add_Cart);
this.Controls[6].Location = new Point(225, 140); //Add to cart image
}
