public static List <Order_Details_DATA> Select_ALL_Order_Details_By_Order_Id(int Order_Id)
{
List <Order_Details_DATA> Order_Details = new List <Order_Details_DATA>();
Order_Details_DATA Order_Detail = new Order_Details_DATA();
DataTable table = DBL.get_DATA("ORDERS_DETAIAS_select_All");
foreach (DataRow item in table.Rows)
{
Order_Detail.Id = Convert.ToInt16(item["ID_ORDERS_DETAIAS"]);
Order_Detail.Quantity = Convert.ToInt16(item["QUANTITY"]);
Orders_DATA Order = new Orders_DATA();
Order.Id = Convert.ToInt16(item["ID_ORDER"]);
Products_DATA Product = new Products_DATA();
Product.Id = Convert.ToInt16(item["ID_PRODUCT"]);
Order_Detail.Order = Order;
Order_Detail.Product = Product;
Order_Details.Add(Order_Detail);
}
Order_Details = Order_Details.Where(x => x.Order.Id == Order_Id).ToList();
return(Order_Details);
}
public static List <Order_Details_DATA> Select_ALL_Order_Details()
{
List <Order_Details_DATA> Order_Details = new List <Order_Details_DATA>();
DataTable table = DBL.get_DATA("ORDERS_DETAIAS_select_All");
foreach (DataRow item in table.Rows)
{
Order_Details_DATA Order_Detail = new Order_Details_DATA();
Order_Detail.Id = Convert.ToInt16(item["ID_ORDERS_DETAIAS"]);
Order_Detail.Quantity = Convert.ToInt16(item["QUANTITY"]);
Order_Detail.Total_price = Convert.ToDouble(item["TOTAL_PRICE"]);
Order_Detail.Total_price_after_discount = Convert.ToDouble(item["TOTAL_PRICE_with_discount"]);
Order_Detail.Discount = Convert.ToDouble(item["DISCOUNT"]);
Orders_DATA order = new Orders_DATA();
Products_DATA product = new Products_DATA();
Order_Detail.Order = order;
Order_Detail.Product = product;
order.Id = Convert.ToInt16(item["ID_ORDER"]);
order = Orders_DAL.Select_Item_Orders(order.Id);
Order_Detail.Order = order;
product.Id = Convert.ToInt16(item["ID_PRODUCT"]);
Order_Detail.Product.Id = product.Id;
Order_Details.Add(Order_Detail);
}
return(Order_Details);
}
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;
}
public static void Delete_Product(Products_DATA Products)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@ID_PRODUCT", Products.Id));
DBL.execute_query("PRODUCT_delete", parameters);
}
private void button4_Click(object sender, EventArgs e)
{
DataGridViewRow x = dataGridView1.SelectedRows[0];
Products_DATA product = new Products_DATA();
Form_Image form = new Form_Image();
product.Image = (byte[])x.Cells[6].Value;
form.Product = product;
form.ShowDialog();
}
public static void Insert_Product(Products_DATA Products)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("IMAGE_PRODUCT", Products.Image));
parameters.Add(new SqlParameter("LABEL_PRODUCT", Products.Label_product));
parameters.Add(new SqlParameter("QTE_IN_PRODUCT", Products.Price));
parameters.Add(new SqlParameter("PRICE", Products.Qte_in_product));
parameters.Add(new SqlParameter("ID_CATEGORIES", Products.Category.Id));
DBL.execute_query("PRODUCT_insert", parameters);
}
private void button3_Click(object sender, EventArgs e)
{
Orders_DATA order = new Orders_DATA();
order.User_id = user_name.Id;
order.Order_date = Convert.ToDateTime(dateTimePicker1.Text);
Customer_DATA customer = new Customer_DATA();
customer.ID = Convert.ToInt16(id.Text);
order.Customer = customer;
order.Total_paied = Convert.ToDouble(total_value.Text);
Orders_BLL.Insert_Orders(order);
foreach (DataGridViewRow row in dataGridView1.Rows)
{
Products_DATA product = new Products_DATA();
product.Id = Convert.ToInt16(row.Cells[0].Value);
Orders_DATA orders = new Orders_DATA();
orders = Orders_BLL.Select_ALL_Orders().Last();
Order_Details_DATA order_details = new Order_Details_DATA();
order_details.Quantity = Convert.ToInt16(row.Cells[3].Value);
order_details.Total_price = Convert.ToDouble(row.Cells[4].Value);
order_details.Discount = Convert.ToDouble(row.Cells[5].Value);
order_details.Total_price_after_discount = Convert.ToDouble(row.Cells[6].Value);
order_details.Order = orders;
order_details.Product = product;
Order_Details_BLL.Insert_Order_Details(order_details);
}
id.Text = "";
name.Text = "";
lastname.Text = "";
phone.Text = "";
email.Text = "";
textBox2.Text = "";
product_id.Text = "";
product_name.Text = "";
product_price.Text = "";
product_quantety.Text = "";
product_total_price.Text = "";
product_discount.Text = "";
product_total.Text = "";
total_value.Text = "";
pictureBox1.Image = null;
button2.Enabled = true;
button3.Enabled = false;
table.Clear();
dataGridView1.DataSource = table;
}
public static Products_DATA Select_Item_Product(int Id)
{
Products_DATA Products = new Products_DATA();
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("ID_PRODUCT", Id));
Products.Id = (int)DBL.get_DATA_row("PRODUCT_select", parameters)[0];
Products.Label_product = DBL.get_DATA_row("PRODUCT_select", parameters)[1].ToString();
Products.Price = DBL.get_DATA_row("PRODUCT_select", parameters)[2].ToString();
Products.Qte_in_product = DBL.get_DATA_row("PRODUCT_select", parameters)[3].ToString();
return(Products);
}
private void dataGridView1_DoubleClick(object sender, EventArgs e)
{
DataGridViewRow row = dataGridView1.SelectedRows[0];
Products_DATA pro = new Products_DATA();
pro.Id = Convert.ToInt16(row.Cells[0].Value);
pro.Label_product = row.Cells[1].Value.ToString();
pro.Qte_in_product = row.Cells[3].Value.ToString();
pro.Price = row.Cells[2].Value.ToString();
Categories_DATA ctegory = new Categories_DATA();
ctegory.Description = row.Cells[4].Value.ToString();
ctegory.Id = Convert.ToInt16(row.Cells[5].Value);
pro.Category = ctegory;
orders_form.Product = pro;
this.Close();
}
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 button3_Click(object sender, EventArgs e)
{
DataGridViewRow x = dataGridView1.SelectedRows[0];
Products_DATA product = new Products_DATA();
product.Id = Convert.ToInt16(x.Cells[0].Value);
product.Label_product = x.Cells[1].Value.ToString();
product.Price = x.Cells[3].Value.ToString();
product.Qte_in_product = x.Cells[2].Value.ToString();
Categories_DATA c = new Categories_DATA();
c.Id = Convert.ToInt16(x.Cells[5].Value);
product.Category = c;
form_UPDATE_PRODUCT form = new form_UPDATE_PRODUCT(this);
product.Image = (byte[])x.Cells[6].Value;
form.Product = product;
form.ShowDialog();
}
public static List <Products_DATA> Select_ALL_Product()
{
List <Products_DATA> Products = new List <Products_DATA>();
DataTable table = DBL.get_DATA("PRODUCT_select_All");
foreach (DataRow item in table.Rows)
{
Products_DATA Product = new Products_DATA();
Product.Id = Convert.ToInt16(item["ID_PRODUCT"]);
Product.Image = (byte[])item["IMAGE_PRODUCT"];
Product.Label_product = item["LABEL_PRODUCT"].ToString();
Product.Price = item["QTE_IN_PRODUCT"].ToString();
Product.Qte_in_product = item["PRICE"].ToString();
Categories_DATA c = new Categories_DATA();
c.Id = Convert.ToInt16(item["ID_CATEGORIES"]);
Product.Category = c;
Products.Add(Product);
}
return(Products);
}
private void button5_Click(object sender, EventArgs e)
{
DataGridViewRow x = dataGridView1.SelectedRows[0];
Products_DATA product = new Products_DATA();
product.Id = Convert.ToInt16(x.Cells[0].Value);
product.Label_product = x.Cells[1].Value.ToString();
product.Price = x.Cells[3].Value.ToString();
product.Qte_in_product = x.Cells[2].Value.ToString();
Categories_DATA c = new Categories_DATA();
c.Id = Convert.ToInt16(x.Cells[5].Value);
product.Category = c;
Form_item_product report = new Form_item_product();
product.Image = (byte[])x.Cells[6].Value;
report.Product = product;
this.Hide();
report.ShowDialog();
this.Show();
}
public static Products_DATA Select_Item_Product(Products_DATA Products)
{
return(Products_DAL.Select_Item_Product(Products.Id));
}
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);
}
