private void ReportDetailsForm_Load(object sender, EventArgs e) { btnClose.Text = "\u00d7"; PsscDBContext psscDBContext = new PsscDBContext(); OrderDetailFormModel odfm = new OrderDetailFormModel(); try { List<Order> listOrderTemp = new List<Order>() { psscDBContext.Orders.Where(x => x.OrderId == this.orderId).FirstOrDefault() }; this.reportViewer1.LocalReport.DataSources.Clear(); this.reportViewer1.LocalReport.ReportEmbeddedResource = "PSSC.App.ReportOrderDetails.rdlc"; ReportDataSource OrderDetailDS = new ReportDataSource("OrderDetailDS", odfm.GetOrderDetailsByOrderId(this.orderId)); ReportDataSource OrderDS = new ReportDataSource("OrderDS", listOrderTemp); this.reportViewer1.LocalReport.DataSources.Add(OrderDetailDS); this.reportViewer1.LocalReport.DataSources.Add(OrderDS); this.reportViewer1.LocalReport.Refresh(); this.reportViewer1.RefreshReport(); } catch {} }
public List<OrderDetailFormModel> GetOrderDetailsByOrderId(int orderId) { List<OrderDetailFormModel> list = new List<OrderDetailFormModel>(); int count = 0; PsscDBContext psscDBContext = new PsscDBContext(); List<OrderDetail> listOrderDetail = psscDBContext.OrderDetails.Include("Marble").Where(x => x.OrderId == orderId).ToList(); foreach(var item in listOrderDetail) { list.Add(new OrderDetailFormModel() { Id = count++, MarbleColor = item.Marble.MarbleColor, Quantity = item.Quantity, UnitPrice = (double)item.Marble.Price, TotalPerMarbles = item.Quantity * (double)item.Marble.Price }); } return list; }
private void frmUIMain_Load(object sender, EventArgs e) { btnMinimize.Text = "\u2013"; btnClose.Text = "\u00d7"; PsscDBContext psscDBContext = new PsscDBContext(); List<Marble> list = psscDBContext.Marbles.ToList(); //Auto config port PortConfig.AutoConfig(PortConfig._INPUT_PORT, PortConfig._INPUT_PORT_NAME); PortConfig.AutoConfig(PortConfig._OUTPUT_PORT, PortConfig._OUTPUT_PORT_NAME); PortConfig._INPUT_PORT.DataReceived += _INPUT_PORT_DataReceived; PortConfig._OUTPUT_PORT.DataReceived +=_OUTPUT_PORT_DataReceived; //Initialize Forms this.InitializeForms(); //Check Connection every 10s this.CallThread_CheckConnection(); //Open Default Form this.SetFormShow(frmMablesManagement); }