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();
}
}
