public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { CrystalReport_bill rpt = new CrystalReport_bill(); rpt.Site = this.Site; return(rpt); }
private void bills_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"); 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"); Order_Details_DATA order_details = new Order_Details_DATA(); order_details.Order = new Orders_DATA(); order_details.Order.Customer = new Customer_DATA(); order_details = Order_Details_BLL.Select_ALL_Order_Details().Last(); Customer_DATA customer = new Customer_DATA(); List <Orders_DATA> order = new List <Orders_DATA>(); order = Orders_BLL.Select_ALL_Orders(); foreach (var item in order) { if (order_details.Order.Id == item.Id) { order_details.Order.Customer = Customer_BLL.Select_Item_Customers(item.Customer); } } 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 == order_details.Order.Id).ToList(); 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_details.Order.User_id; user = user_list.Single(x => x.Id == user.Id); table.Rows.Add( order_details.Order.Id, order_details.Order.Customer.First_Name, order_details.Order.Customer.Last_Name, order_details.Order.Customer.Tel, order_details.Order.Customer.Email, order_details.Order.Order_date, user.Name ); 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.Subreports[0].AfterFormatPage += Bills_AfterFormatPage; s.SetDataSource(table); crystalReportViewer1.ReportSource = s; }