private void Form_orders_Load(object sender, EventArgs e)
{
textBox3.Text = User_name.Name;
DataTable table = new DataTable();
List <Products_DATA> list = Products_DAL.Select_ALL_Product();
table.Columns.Add("");
table.Columns.Add("");
table.Columns.Add("");
table.Columns.Add("");
table.Columns.Add("");
table.Columns.Add("");
table.Columns.Add("");
dataGridView1.DataSource = table;
dataGridView1.RowHeadersWidth = 77;
dataGridView1.Columns[0].Width = 75;
dataGridView1.Columns[1].Width = 75;
dataGridView1.Columns[2].Width = 75;
dataGridView1.Columns[3].Width = 75;
dataGridView1.Columns[4].Width = 75;
dataGridView1.Columns[5].Width = 75;
dataGridView1.Columns[6].Width = 143;
dataGridView1.ColumnHeadersVisible = false;
}
private void button2_Click(object sender, EventArgs e)
{
DataGridViewRow x = dataGridView1.SelectedRows[0];
Products_DATA product = new Products_DATA();
product.Id = Convert.ToInt16(x.Cells[0].Value);
BLL.Products_BLL.Delete_Product(product);
DataTable table = new DataTable();
List <Products_DATA> list = Products_DAL.Select_ALL_Product();
table.Columns.Add("Id");
table.Columns.Add("اسم المنتج");
table.Columns.Add("سعر المنتج");
table.Columns.Add("كمية المنتج");
table.Columns.Add("نوع المنتج");
table.Columns.Add("Category_ID");
foreach (var item in list)
{
table.Rows.Add(item.Id, item.Label_product, item.Price, item.Qte_in_product, item.Category.Description, item.Category.Id);
}
dataGridView1.DataSource = table;
dataGridView1.Columns[0].Visible = false;
//dataGridView1.Columns[5].Visible = false;
}
private void Form_product_report_Load(object sender, EventArgs e)
{
CrystalReport2 s = new CrystalReport2();
DataTable table = new DataTable();
List <Products_DATA> list = Products_DAL.Select_ALL_Product();
table.Columns.Add("Id");
table.Columns.Add("label_product");
table.Columns.Add("qte_in_product");
table.Columns.Add("price");
table.Columns.Add("image", typeof(byte[]));
table.Columns.Add("category_FK");
table.Columns.Add("description");
foreach (var item in list)
{
//table.Rows.Add(item.Id, item.Label_product, item.Price, item.Qte_in_product, item.Category.Description, item.Category.Id, item.Image);
table.Rows.Add(item.Id, item.Label_product, item.Qte_in_product, item.Price, item.Image, item.Category.Id, item.Category.Description);
}
s.SetDataSource(table);
crystalReportViewer1.ReportSource = s;
}
private void button2_Click(object sender, EventArgs e)
{
Products_DATA Product = new Products_DATA();
Product.Label_product = description.Text;
Product.Qte_in_product = quantity.Text;
Product.Price = price.Text;
MemoryStream memory = new MemoryStream();
pictureBox1.Image.Save(memory, pictureBox1.Image.RawFormat);
byte[] byte_image = memory.ToArray();
Product.Image = byte_image;
Product.Id = Id;
int x = Convert.ToInt16(comboBox1.SelectedValue);
Categories_DATA c = new Categories_DATA();
c.Id = x;
Product.Category = c;
Products_BLL.Update_Product(Product);
DataTable table = new DataTable();
List <Products_DATA> list = Products_DAL.Select_ALL_Product();
table.Columns.Add("Id");
table.Columns.Add("اسم المنتج");
table.Columns.Add("سعر المنتج");
table.Columns.Add("كمية المنتج");
table.Columns.Add("نوع المنتج");
table.Columns.Add("Category_ID");
table.Columns.Add("image", typeof(byte[]));
foreach (var item in list)
{
table.Rows.Add(item.Id, item.Label_product, item.Price, item.Qte_in_product, item.Category.Description, item.Category.Id, item.Image);
}
form_product.DataGridView1.DataSource = table;
form_product.DataGridView1.Columns[0].Visible = false;
form_product.DataGridView1.Columns[5].Visible = false;
form_product.DataGridView1.Columns[6].Visible = false;
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
DataTable table = new DataTable();
List <Products_DATA> list;
if (max_price.Text != "" && min_price.Text != "")
{
list = Products_DAL.Select_ALL_Product().Where
(x =>
(x.Label_product.Contains(textBox1.Text) || textBox1.Text == "")
&&
Convert.ToInt16(min_price.Text) <= Convert.ToInt16(x.Price)
&&
Convert.ToInt16(x.Price) <= Convert.ToInt16(max_price.Text)
).ToList();
}
else
{
list = Products_DAL.Select_ALL_Product().Where(
x => x.Label_product.Contains(textBox1.Text) || textBox1.Text == ""
).ToList();
}
table.Columns.Add("اسم المنتج");
table.Columns.Add("سعر المنتج");
table.Columns.Add("كمية المنتج");
table.Columns.Add("نوع المنتج");
foreach (var item in list)
{
table.Rows.Add(item.Label_product, item.Price, item.Qte_in_product, item.Category.Description);
}
dataGridView1.DataSource = table;
}
private void Form_Select_products_Load(object sender, EventArgs e)
{
DataTable table = new DataTable();
List <Products_DATA> list = Products_DAL.Select_ALL_Product();
table.Columns.Add("Id");
table.Columns.Add("اسم المنتج");
table.Columns.Add("سعر المنتج");
table.Columns.Add("كمية المنتج");
table.Columns.Add("نوع المنتج");
table.Columns.Add("Category_ID");
table.Columns.Add("image", typeof(byte[]));
foreach (var item in list)
{
table.Rows.Add(item.Id, item.Label_product, item.Price, item.Qte_in_product, item.Category.Description, item.Category.Id, item.Image);
}
dataGridView1.DataSource = table;
dataGridView1.Columns[0].Visible = false;
dataGridView1.Columns[5].Visible = false;
dataGridView1.Columns[6].Visible = false;
}
public static void Delete_Product(Products_DATA Products)
{
Products_DAL.Delete_Product(Products);
}
public static void Update_Product(Products_DATA Products)
{
Products_DAL.Update_Product(Products);
}
public static void Insert_Product(Products_DATA Products)
{
Products_DAL.Insert_Product(Products);
}
public static Products_DATA Select_Item_Product(Products_DATA Products)
{
return(Products_DAL.Select_Item_Product(Products.Id));
}
public static List <Products_DATA> Select_ALL_Product()
{
return(Products_DAL.Select_ALL_Product());
}
