private void btnEkle_Click(object sender, EventArgs e)
{
if (login.Kadi == null)
{
DialogResult result = MessageBox.Show("Sepetinize ürün eklemek için GİRİŞ yapmanız gerekmektedir." + Environment.NewLine + "Giriş yapmak istiyor musunuz?",
"Uyarı",
MessageBoxButtons.YesNo,
MessageBoxIcon.Information,
MessageBoxDefaultButton.Button2);
if (result == DialogResult.Yes)
{
this.btnLogInOut_Click(sender, e);
}
}
else
{
ItemToPurchase item = new ItemToPurchase(prd, (int)nupQuantity.Value);
bool res = login.Cart.addProduct(item);
if (res)
{
MessageBox.Show(item.Product.Name + " adlı ürün sepetinize eklenmiştir", "Ürün eklendi",
MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Bir Alışverişte sepetinizde en fazla 6 farklı ürün bulunabilir." + Environment.NewLine + "Sepetinize giderek ürünlerinizi görebilirsiniz.", "Ürün eklenemedi",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
}
public bool addProduct(ItemToPurchase item)
{
bool res = false;
for (int i = 0; i < itemsToPurchase.Count; i++)
{
if (((ItemToPurchase)itemsToPurchase[i]).Product.Name == item.Product.Name)
{
((ItemToPurchase)itemsToPurchase[i]).Quantity += item.Quantity;
res = true;
}
}
if (itemsToPurchase.Count <= 5 && res == false)
{
itemsToPurchase.Add(item);
res = true;
}
return(res);
}
private void button1_Click(object sender, EventArgs e)
{
if (txtPassword.Text != "Kullanıcı Adı Giriniz" || txtUsername.Text != "Şifre")
{
picLoad.Visible = true;
con = new SqlConnection("Data Source=DESKTOP-ECU28KQ\\SQLEXPRESS;Initial Catalog=OOP2;Integrated Security=True");
da = new SqlDataAdapter("Select * From Users Where username='******' and password='******'", con);
dt = new DataTable();
try
{
con.Open();
da.Fill(dt);
con.Close();
if (dt.Rows.Count == 0)
{
MessageBox.Show("Hatalı kullanıcı adı ya da şifre girdiniz!", "Hata",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
picLoad.Visible = false;
}
else
{
myLogin login = myLogin.CreateLogin();
login.Kadi = txtUsername.Text.Trim();
login.Sifre = txtPassword.Text.Trim();
login.Cart.CustomerID = int.Parse(dt.Rows[0].ItemArray[0].ToString());
MessageBox.Show("Merhaba " + dt.Rows[0].ItemArray[1].ToString() + ";" + Environment.NewLine + "Online Book Store'a hoşgeldin!", "Hoşgeldiniz",
MessageBoxButtons.OK,
MessageBoxIcon.Information);
picLoad.Visible = false;
this.Close();
con.Open();
dall = new DataSet();
cmd = new SqlCommand("Select Prd.ID, Prd.Name, Prd.Price, Book.Author, Book.Publisher, Book.Page, Prd.pType, Prd.Image From dbo.Book AS Book, dbo.Product AS Prd Where Book.ID = Prd.ID", con);
da.SelectCommand = cmd;
cmd.ExecuteNonQuery();
try
{
da.Fill(dall, "Book");
}
catch (Exception)
{
MessageBox.Show("Cannot open connection!");
}
cmd = new SqlCommand("Select Prd.ID, Prd.Name, Prd.Price, Maga.Issue, Maga.Type, Prd.Image, Prd.pType From dbo.Magazine AS Maga, dbo.Product AS Prd Where Maga.ID = Prd.ID", con);
da.SelectCommand = cmd;
cmd.ExecuteNonQuery();
try
{
da.Fill(dall, "Magazine");
}
catch (Exception)
{
MessageBox.Show("Cannot open connection !");
}
cmd = new SqlCommand("Select Prd.ID, Prd.Name, Prd.Price, Music.Singer, Music.Type, Prd.Image, Prd.pType From dbo.MusicCD AS Music, dbo.Product AS Prd Where Music.ID = Prd.ID", con);
da.SelectCommand = cmd;
cmd.ExecuteNonQuery();
try
{
da.Fill(dall, "MusicCD");
}
catch (Exception)
{
MessageBox.Show("Cannot open connection !");
}
dt.Reset();
cmd = new SqlCommand("Select * From Cart Where CustomerID = '" + login.Cart.CustomerID + "'", con);
da.SelectCommand = cmd;
cmd.ExecuteNonQuery();
da.Fill(dt);
if (dt.Rows[0].ItemArray[1].ToString() != "")
{
string[] products = dt.Rows[0].ItemArray[1].ToString().Split(';');
string[] quantities = dt.Rows[0].ItemArray[2].ToString().Split(';');
string[] ptype = dt.Rows[0].ItemArray[3].ToString().Split(';');
Product prd = null;
for (int i = 0; i < products.Length; i++)
{
if (ptype[i].ToString() == "B")
{
for (int j = 0; j < dall.Tables["Book"].Rows.Count; j++)
{
if (dall.Tables["Book"].Rows[j].ItemArray[0].ToString() == products[i])
{
prd = new Book((int)(dall.Tables["Book"].Rows[j].ItemArray[0]), dall.Tables["Book"].Rows[j].ItemArray[1].ToString(), float.Parse(dall.Tables["Book"].Rows[j].ItemArray[2].ToString()), dall.Tables["Book"].Rows[j].ItemArray[3].ToString(), dall.Tables["Book"].Rows[j].ItemArray[4].ToString(), int.Parse(dall.Tables["Book"].Rows[j].ItemArray[5].ToString()));
prd.Image = dall.Tables["Book"].Rows[j].ItemArray[7].ToString();
}
}
}
else if (ptype[i].ToString() == "M")
{
for (int k = 0; k < dall.Tables["Magazine"].Rows.Count; k++)
{
if (dall.Tables["Magazine"].Rows[k].ItemArray[0].ToString() == products[i])
{
prd = new Magazine((int)(dall.Tables["Magazine"].Rows[k].ItemArray[0]), dall.Tables["Magazine"].Rows[k].ItemArray[1].ToString(), float.Parse(dall.Tables["Magazine"].Rows[k].ItemArray[2].ToString()), int.Parse(dall.Tables["Magazine"].Rows[k].ItemArray[3].ToString()), dall.Tables["Magazine"].Rows[k].ItemArray[4].ToString());
prd.Image = dall.Tables["Magazine"].Rows[k].ItemArray[5].ToString();
}
}
}
else if (ptype[i].ToString() == "C")
{
for (int l = 0; l < dall.Tables["MusicCD"].Rows.Count; l++)
{
if (dall.Tables["MusicCD"].Rows[l].ItemArray[0].ToString() == products[i])
{
prd = new MusicCD((int)(dall.Tables["MusicCD"].Rows[l].ItemArray[0]), dall.Tables["MusicCD"].Rows[l].ItemArray[1].ToString(), float.Parse(dall.Tables["MusicCD"].Rows[l].ItemArray[2].ToString()), dall.Tables["MusicCD"].Rows[l].ItemArray[3].ToString(), dall.Tables["MusicCD"].Rows[l].ItemArray[4].ToString());
prd.Image = dall.Tables["MusicCD"].Rows[l].ItemArray[5].ToString();
}
}
}
ItemToPurchase item = new ItemToPurchase(prd, int.Parse(quantities[i]));
login.Cart.addProduct(item);
}
con.Close();
}
}
}
catch (Exception a)
{
MessageBox.Show(a.Message);
}
}
else
{
MessageBox.Show("Lütfen kullanıcı bilgilerinizi giriniz!", "Hata",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}