//databind to total orders by eta and company id
protected void bind_chart(Int32 companyid)
{
try
{
ordertablecustomcontroller _orders = new ordertablecustomcontroller();
IDataReader _dr = _orders.GetOrderCountByEtaWeek(companyid);
DataTable _dt = new DataTable();
_dt.Load(_dr);
//DevExpress.XtraCharts.Series _s = this.dxchartEta.Series[0];
//
Series _s = this.dxchartEta.Series[0];
XYDiagram _xy = (XYDiagram)this.dxchartEta.Diagram;
this.dxchartEta.Legend.Visible = false;
//stagger x axis lables
_xy.AxisX.Label.Staggered = false;
//rotate them.
_xy.AxisX.Label.Angle = -30;
_xy.AxisX.Label.Antialiasing = true;
_s.Label.TextOrientation = TextOrientation.Horizontal;
_s.DataSource = _dt;
//columns
_s.ArgumentScaleType = ScaleType.DateTime;
_s.ArgumentDataMember = "GroupByOfETA";
//rows
_s.ValueScaleType = ScaleType.Numerical;
_s.ValueDataMembers.AddRange(new string[] { "SumOrderId" });
this.dxchartEta.DataBind();
}
catch (Exception ex)
{
this.dxlblerr3.Text = ex.Message.ToString();
this.dxlblerr3.Visible = true;
}
}
// overloads
protected void bind_order_data(Int32 orderno, string houseBL)
{
try
{
if (Session["orderlist"] != null)
{
IList<Int32> _ol = (IList<Int32>)Session["orderlist"];
//DataTable _ol = (DataTable)Session["orderlist"];
this.dlorder.DataSource = _ol;
this.dlorder.DataBind();
}
else
{
//IList<Int32> _ol = build_order_table();
//_ol.Add(orderno);
//160112 find any other order numbers covered by house b/l and ad to ilist
IList<Int32> _ol = new ordertablecustomcontroller().get_orders_by_houseBL(houseBL);
if (_ol.Count == 0)
{
_ol.Add(orderno);
}
//DataTable _ol = build_order_table();
//_ol.Rows.Add(orderno);
Session["orderlist"] = _ol;
this.dlorder.DataSource = _ol;
this.dlorder.DataBind();
}
}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
}