/**
* A list of allMusicCDs in the MusicCDsClass' getAllMusicCDsFromDB() function is created.
* musicCDsUserControls is created from the MusicCDUserControl.
* The size of musicCDsUserControls is up to the length of allMusicCDs.
*/
private void populateMusicCDsViewInHomePage()
{
List <MusicCDsClass> allMusicCDs = MusicCDsClass.getAllMusicCDsFromDB();
MusicCDUserControl[] musicCDsUserControls = new MusicCDUserControl[allMusicCDs.Count];
if (flpHomePage.Controls.Count > 0)
{
flpHomePage.Controls.Clear();
}
int i = 0;
foreach (var item in allMusicCDs)
{
musicCDsUserControls[i] = new MusicCDUserControl();
musicCDsUserControls[i].musicCDID = item.id;
musicCDsUserControls[i].musicCDName = item.name;
musicCDsUserControls[i].musicCDPrice = item.price;
musicCDsUserControls[i].musicCDSinger = item.singer;
musicCDsUserControls[i].stock = item.stock;
musicCDsUserControls[i].picture = item.cover_page_picture;
flpHomePage.Controls.Add(musicCDsUserControls[i]);
i++;
}
}
/**
* musicCDsList created from MusicCDsClass
* this function reads musicCDs items in database
* and add in musicCDsList
* @return musicCDsList
*/
public static List <MusicCDsClass> getAllMusicCDsFromDB()
{
List <MusicCDsClass> musicCDsList = new List <MusicCDsClass>();
DatabaseHelperClass dbHelper = DatabaseHelperClass.Instance; //SINGLETON PATTERN
SqlConnection connection = dbHelper.getConnection();
SqlCommand command = new SqlCommand("SELECT * FROM MusicCDsTable", connection);
SqlDataReader readMusicCDs = command.ExecuteReader();
if (readMusicCDs != null)
{
while (readMusicCDs.Read())
{
MusicCDsClass musicCDs = new MusicCDsClass();
musicCDs.id = readMusicCDs["id"].ToString();
musicCDs.name = readMusicCDs["name"].ToString();
musicCDs.price = Convert.ToDouble(readMusicCDs["price"]);
musicCDs.singer = readMusicCDs["singer"].ToString();
musicCDs.stock = Convert.ToInt32(readMusicCDs["stock"]);
musicCDs.cover_page_picture = readMusicCDs["picture"].ToString();
musicCDsList.Add(musicCDs);
}
}
return(musicCDsList);
}
/** @ brief adds the purchased musicCDs to the shopping cart
* create a book from MusicCDsClass
* and item added shoppingcartclass
*/
private void btnMusicCDsAddToCart_Click(object sender, EventArgs e)
{
MusicCDsClass musicCDs = new MusicCDsClass();
musicCDs = MusicCDsClass.getAMusicCDsFromDB(musicCDID);
ShoppingCartClass.addProduct(new ItemToPurchaseClass(musicCDs, Convert.ToInt32(Math.Round(nudQuantity.Value, 0))));
System.Windows.Forms.Form f = System.Windows.Forms.Application.OpenForms["BookShopForm"];
int quantity = 0;
foreach (var item in ShoppingCartClass.itemsToPurchase)
{
quantity += item.quantity;
}
((BookShopForm)f).lblShoppinCartValue.Text = quantity.ToString();
MessageBox.Show("Added to cart.", "INFORMATION", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private void btnUpdateMusicCDs_Click(object sender, EventArgs e)
{
MusicCDsClass music = new MusicCDsClass(txtMusicName.Text, txtMusicCDsId.Text, Convert.ToDouble(txtMusicPrice.Text), Convert.ToInt32(txtMusicCDsStock.Text), txtMusicSinger.Text, txtMusicType.Text, txtMusicCDsImage.Text);
//bool affected = dbHelper.updateAProductAtDB(music);
AdminUserClass adminOps = AdminUserClass.Instance;
bool affected = adminOps.updateProduct(music);
if (!affected)
{
MessageBox.Show("Error not successful");
}
else
{
MessageBox.Show("Music CDs updated successfully", "INFORMATION", MessageBoxButtons.OK, MessageBoxIcon.Information);
clearMusicCDsControl();
}
}
/**this function read a musicCDs item in a database
* @param string id
* @return musicCDs
*/
public static MusicCDsClass getAMusicCDsFromDB(string id)
{
DatabaseHelperClass dbHelper = DatabaseHelperClass.Instance; //SINGLETON PATTERN
SqlConnection connection = dbHelper.getConnection();
SqlCommand command = new SqlCommand("SELECT * FROM MusicCDsTable where id=@id", connection);
command.Parameters.AddWithValue("@id", Convert.ToInt32(id));
SqlDataReader readMusicCDs = command.ExecuteReader();
MusicCDsClass musicCDs = new MusicCDsClass();
if (readMusicCDs != null)
{
while (readMusicCDs.Read())
{
musicCDs.id = readMusicCDs["id"].ToString();
musicCDs.name = readMusicCDs["name"].ToString();
musicCDs.price = Convert.ToDouble(readMusicCDs["price"]);
musicCDs.singer = readMusicCDs["singer"].ToString();
musicCDs.stock = Convert.ToInt32(readMusicCDs["stock"]);
musicCDs.cover_page_picture = readMusicCDs["picture"].ToString();
}
}
return(musicCDs);
}
