public MainShop()
{
InitializeComponent();
prd = new Proudects();
dth = new DataHelpers();
ord = new Orders();
conn = new SqlConnection("Data Source=DESKTOP-AJ8DB4G;" + "Initial Catalog=ShopCart;" + "Integrated Security=SSPI;");
Lists();
}
private void DisplayOrderData()
{
ordList.Clear();
Order_list.Items.Clear();
Order_list.ClearSelected();
//Order_list.Refresh();
try
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("Select * from [Orders] where Users_id = '" + user.Id + "'", conn))
{
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
long len = reader.GetBytes(3, 0, null, 0, 0);
Byte[] buffer = new Byte[len];
reader.GetBytes(3, 0, buffer, 0, (int)len);
Proudects prd = new Proudects()
{
Name = reader.GetString(1).ToString(),
Price = reader.GetDouble(2),
Image = dth.byteArrayToImage(buffer),
Description = reader.GetString(9).ToString()
};
ordList.Add(prd);
}
}
}
foreach (var item in ordList)
{
Order_list.Items.Add(new exListBoxItem(idd, item.Name, item.Description, item.Price.ToString() + "$", item.Image));
idd++;
}
timer1.Start();
Console.WriteLine(ordList.Count);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
timer1.Stop();
}
}
private void DisplayHousewareData()
{
prdList.Clear();
try
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("Select * from [Proudects] where classes_id = '" + 3 + "'", conn))
{
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
long len = reader.GetBytes(3, 0, null, 0, 0);
Byte[] buffer = new Byte[len];
reader.GetBytes(3, 0, buffer, 0, (int)len);
Proudects prd = new Proudects()
{
Name = reader.GetString(1).ToString(),
Price = reader.GetDouble(2),
Image = dth.byteArrayToImage(buffer),
Description = reader.GetString(4).ToString()
};
prdList.Add(prd);
}
}
}
foreach (var item in prdList)
{
hose_list.Items.Add(new exListBoxItem(idd, item.Name, item.Description, item.Price.ToString() + "$", item.Image));
idd++;
}
Console.WriteLine(prdList.Count);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
}
