public void upload()
{
flytbBook.Controls.Clear();
flytbMusic.Controls.Clear();
flytbMagazine.Controls.Clear();
VeritabaniIslemleri database = VeritabaniIslemleri.bagOlustur("SatisVeritabani");
int i = 0;
string query = "select * from UrunlerTablosu where productType = 1 and visibility= 1";
DataTable table = database.veriCek(query);
foreach (DataRow item in table.Rows)
{
Product book = addNewProductFromDatabase.CreateNewItem(item);
BookControl cont = new BookControl((Book)book, mainform.shoppingCard);
flytbBook.Controls.Add(cont);
i++;
if (i == 6)
{
break;
}
}
pctrbxsitephoto.Image = new Bitmap("kitap" + (pictureindex % 3 + 1).ToString() + ".jpg");
query = "select * from UrunlerTablosu where productType = 2 and visibility= 1";
table = database.veriCek(query);
i = 0;
foreach (DataRow item in table.Rows)
{
Product music = addNewProductFromDatabase.CreateNewItem(item);
MusicCdControl cont = new MusicCdControl((MusicCD)music, mainform.shoppingCard);
flytbMusic.Controls.Add(cont);
i++;
if (i == 6)
{
break;
}
}
query = "select * from UrunlerTablosu where productType = 3 and visibility= 1";
table = database.veriCek(query);
i = 0;
foreach (DataRow item in table.Rows)
{
Product magazine = addNewProductFromDatabase.CreateNewItem(item);
MagazineControl cont = new MagazineControl((Magazine)magazine, mainform.shoppingCard);
flytbMagazine.Controls.Add(cont);
i++;
if (i == 6)
{
break;
}
}
}
/// <summary>
/// when this button clicked,
/// if user == null the login page appear
/// else the pnlUserNameClicked appear or vice versa
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void bttnUserName_Click(object sender, EventArgs e)
{
Program.NotifyObserver(this.Name, ((Button)sender).Name);
if (user == null)
{
LoginForm login = new LoginForm();
DialogResult result = login.ShowDialog();
if (result == DialogResult.Yes)
{
bttnUserName.Text = user.Name;
VeritabaniIslemleri database = VeritabaniIslemleri.bagOlustur("SatisVeritabani");
string query = "select * from SepetTablosu where customerId = " + user.UserID + " and siparisId = 'none'";
DataTable table = database.veriCek(query);
foreach (DataRow item in table.Rows)
{
query = "select * from UrunlerTablosu where productId = '" + item[1].ToString() + "'";
DataTable tablee = database.veriCek(query);
shoppingCard.addProduct(new ItemToPurchase(addNewProductFromDatabase.CreateNewItem(tablee.Rows[0]), Convert.ToInt32(item[3])));
}
query = "delete from SepetTablosu where customerId = " + user.UserID + " and siparisId = 'none'";
database.veriKaydet(query);
query = "delete from ShoppingCartTable where CustomerId = " + user.UserID + " and siparisId = 'none'";
database.veriKaydet(query);
}
}
else
{
if (pnlUserNameClicked.Visible == false)
{
pnlUserNameClicked.Visible = true;
}
else
{
pnlUserNameClicked.Visible = false;
}
}
this.MainForm_Activated(this, new EventArgs());
}