public DataTable GetReportFromDS(int reportType) { DataSet1.ReportsDataTable dt = new DataSet1.ReportsDataTable(); switch (reportType) { case 1: // aging < 30 listReport = OrderLAO.GetOrderByDate(1); break; case 2: //outstanding listReport = OrderLAO.GetOutStandingReport(1); break; case 3: //top customers listReport = OrderLAO.GetTopCustomers(10); break; case 4: // aging > 30 < 60 listReport = OrderLAO.GetOrderByDate(2); break; case 5: // aging > 90 listReport = OrderLAO.GetOrderByDate(3); break; default: break; } dt = (DataSet1.ReportsDataTable)SetReprots(listReport); return(dt); }
private void InitializeAllData() { listOrder = OrderLAO.GetAllOrders(); dataGridView1.DataSource = null; dataGridView1.DataSource = listOrder; but_GetCustomer.Enabled = false; cb_cusId.Visible = false; cb_cusId.Enabled = false; btn_add.Enabled = false; btn_delete.Enabled = false; e_custName.Enabled = false; e_custName.ReadOnly = true; o_number.Enabled = false; listProduct = ProductsLAO.GetAllProducts(); }
/// <summary> /// add order /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnAdd_Click(object sender, EventArgs e) { showProdut.Clear(); currentStatus = FormStatus.adding; CleanAllComponets(); but_GetCustomer.Enabled = true; cb_cusId.Enabled = true; cb_cusId.Visible = true; btn_add.Enabled = true; btn_delete.Enabled = true; e_custName.Enabled = true; comb_prod.Items.Clear(); comb_prod.Text = string.Empty; e_custName.Enabled = true; e_custName.ReadOnly = false; extenstions.ClearControls(Controls); o_number.Enabled = false; o_number.Text = OrderLAO.getOrderNextValue().ToString(); if (listProduct.Count > 0) { this.comb_prod.Items.Clear(); string[] productNameString = new string[listProduct.Count]; for (int i = 0; i < listProduct.Count; i++) { productNameString[i] = listProduct[i].ProductName; } this.comb_prod.Items.AddRange(productNameString); this.comb_prod.SelectedIndex = 0; } listcostomer = CustomerLAO.GetAllCustomers(); if (listcostomer.Count > 0) { string[] customerIdlist = new string[listcostomer.Count]; for (int i = 0; i < listcostomer.Count; i++) { customerIdlist[i] = ((Customer)(listcostomer[i])).CustomerId.ToString(); } this.cb_cusId.Items.AddRange(customerIdlist); this.cb_cusId.SelectedIndex = 0; Customer aCusotomer = new Customer(); aCusotomer = listcostomer[0]; SetCustomerInformation(aCusotomer); } setAddressEnable(true); }
private void button1_Click(object sender, EventArgs e) { listReports.Clear(); if (cbx_id.Text == string.Empty) { listReports = OrderLAO.GetAllOrderWithInfo(0, chk_Pending.Checked); } else { Order o = new Order(); listReports = OrderLAO.GetAllOrderWithInfo(Int32.Parse(cbx_id.Text), chk_Pending.Checked); } dataGridView1.DataSource = null; dataGridView1.DataSource = listReports; }
public frmOrderQuery() { InitializeComponent(); listOrder = OrderLAO.GetAllOrders(); if (listOrder.Count > 0) { string[] orderIdList = new string[listOrder.Count]; for (int i = 0; i < listOrder.Count; i++) { orderIdList[i] = ((Order)listOrder[i]).OrderId.ToString(); } this.cbx_id.Items.AddRange(orderIdList); } }
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (currentStatus == FormStatus.editing || currentStatus == FormStatus.nonstatus) { int selectIndex = dataGridView1.CurrentRow.Index; Order aOrder = new Order(); aOrder = listOrder[selectIndex]; SetOrderInformation(aOrder); Customer cusotmerInformation = new Customer(); cusotmerInformation = CustomerLAO.getCustoemerById(aOrder.customerId); SetCustomerInformation(cusotmerInformation); orderLine = new List <OrderLines>(); orderLine = OrderLAO.GetLinesByOrderId(aOrder.OrderId); SetAllProductInformation(); currentStatus = FormStatus.editing; UpdateBottomInformation(); } if (currentStatus == FormStatus.adding) { selectIndexOfProduct = dataGridView1.CurrentRow.Index; } }
/// <summary> /// Save an order /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSave_Click(object sender, EventArgs e) { if (prod_qnt.Text == string.Empty) { MessageBox.Show("Empty quantity", "OK", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (o_emp.Text == string.Empty) { MessageBox.Show("Empty Employee id", "OK", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { if (currentStatus == FormStatus.adding) { currentStatus = FormStatus.nonstatus; cb_cusId.Enabled = false; cb_cusId.Visible = false; btn_add.Enabled = false; btn_delete.Enabled = false; e_custName.Enabled = false; e_custName.ReadOnly = true; o_number.Enabled = false; OrderLAO.CreateNewOrder(GenerateOrder(), GenerateOrderLine()); e_custName.Text = string.Empty; e_cust.Text = string.Empty; cb_cusId.Text = string.Empty; setAddressEnable(false); listOrder = OrderLAO.GetAllOrders(); } if (currentStatus == FormStatus.editing) { OrderLAO.UpdateOrderStatus(o_status.SelectedIndex, Int32.Parse(o_number.Text)); listOrder = OrderLAO.GetAllOrders(); } dataGridView1.DataSource = null; dataGridView1.DataSource = listOrder; listcostomer.Clear(); } }