public static void Delete_Order_Details(Order_Details_DATA Order_Details)
{
Order_Details_DAL.Delete_Order_Details(Order_Details);
}
private void button2_Click(object sender, EventArgs e)
{
DataTable table = new DataTable();
table.Columns.Add("رقم الفاتورة");
table.Columns.Add("التاريخ");
table.Columns.Add("Id_customer");
table.Columns.Add("الاسم الاول");
table.Columns.Add("الاسم الثاني");
table.Columns.Add("ID_User");
table.Columns.Add("قيمة الفاتورة");
List <Orders_DATA> list_order = new List <Orders_DATA>();
list_order = Orders_BLL.Select_ALL_Orders();
foreach (var item in list_order)
{
item.Customer = Customer_BLL.Select_Item_Customers(item.Customer);
}
list_order = list_order.Where(x =>
(x.Customer.First_Name.Contains(search.Text) || search.Text == "") ||
(x.Customer.Last_Name.Contains(search.Text) || search.Text == "") ||
(x.Id.ToString().Contains(search.Text) || search.Text == "")
|| (search.Text.Contains(x.Customer.First_Name + " " + x.Customer.Last_Name))
).ToList();
list_order = list_order.Where(x =>
(x.Order_date.ToString().Contains(dateTimePicker1.Value.Date.ToString()))).ToList();
foreach (var item in list_order)
{
List <Order_Details_DATA> Order_Detail = new List <Order_Details_DATA>();
item.Customer = Customer_BLL.Select_Item_Customers(item.Customer);
Order_Detail = Order_Details_DAL.Select_ALL_Order_Details_By_Products_Id(item.Id);
table.Rows.Add(item.Id,
item.Order_date,
item.Customer.ID,
item.Customer.First_Name,
item.Customer.Last_Name,
item.User_id,
item.Total_paied);
}
dataGridView1.DataSource = table;
dataGridView1.Columns[2].Visible = false;
dataGridView1.Columns[5].Visible = false;
//foreach (var item in list)
//{
// table.Rows.Add(item.ID, item.First_Name, item.Last_Name, item.Tel, item.Email, item.Image);
// count_ALL_items++;
//}
}
public static void Upaate_Order_Details(Order_Details_DATA Order_Details)
{
Order_Details_DAL.Upaate_Order_Details(Order_Details);
}
public static void Insert_Order_Details(Order_Details_DATA Order_Details)
{
Order_Details_DAL.Insert_Order_Details(Order_Details);
}
public static Order_Details_DATA Select_Item_Order_Details(Order_Details_DATA Order_Details)
{
return(Order_Details_DAL.Select_Item_Order_Details(Order_Details.Id));
}
public static List <Order_Details_DATA> Select_ALL_Order_Details()
{
return(Order_Details_DAL.Select_ALL_Order_Details());
}
private void bill_2_Load(object sender, EventArgs e)
{
DataTable table = new DataTable();
table.Columns.Add("Id");
table.Columns.Add("first_Name");
table.Columns.Add("last_Name");
table.Columns.Add("tel");
table.Columns.Add("email");
table.Columns.Add("order_date");
table.Columns.Add("user_name");
List <Order_Details_DATA> Order_Detail = new List <Order_Details_DATA>();
Order.Customer = Customer_BLL.Select_Item_Customers(Order.Customer);
Order_Detail = Order_Details_DAL.Select_ALL_Order_Details_By_Order_Id(Order.Id);
class_bills bill = new class_bills();
Users user = new Users();
List <Users> user_list = new List <Users>();
DataTable tables = DBL.get_DATA("Select_Users");
foreach (DataRow item in tables.Rows)
{
user_list.Add(new Users(item["Name"].ToString(), item["Password"].ToString(), Convert.ToInt16(item["ID_User"])));
}
user.Id = Order.User_id;
user = user_list.Single(x => x.Id == user.Id);
bill.Id = Order.Id;
bill.First_Name = Order.Customer.First_Name;
bill.Last_Name = Order.Customer.Last_Name;
bill.Tel = Order.Customer.Tel;
bill.Email = Order.Customer.Email;
bill.Order_date = Order.Order_date;
bill.User_name = user.Name;
table.Rows.Add(
bill.Id,
bill.First_Name,
bill.Last_Name,
bill.Tel,
bill.Email,
bill.Order_date,
user.Name
);
DataTable details_table = new DataTable();
details_table.Columns.Add("quantity");
details_table.Columns.Add("total_price");
details_table.Columns.Add("discount");
details_table.Columns.Add("total_price_after_discount");
details_table.Columns.Add("label_product");
details_table.Columns.Add("price");
List <Order_Details_DATA> list_order_details = new List <Order_Details_DATA>();
list_order_details = Order_Details_BLL.Select_ALL_Order_Details();
list_order_details = Order_Details_BLL.Select_ALL_Order_Details().Where(x => x.Order.Id == bill.Id).ToList();
foreach (var item in list_order_details)
{
details_table.Rows.Add(
item.Quantity,
item.Total_price,
item.Discount,
item.Total_price_after_discount,
item.Product.Label_product,
item.Product.Price
);
}
CrystalReport_bill s = new CrystalReport_bill();
s.Subreports[0].SetDataSource(details_table);
s.SetDataSource(table);
crystalReportViewer1.ReportSource = s;
}
