protected void Button2_click(object sender, EventArgs e)
{
DateTime d1 = new DateTime();
// d1 = Convert.ToDateTime(TextBox1.Text);
if (!DateTime.TryParseExact(TextBox1.Text, "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out d1))
{
}
Label2.Text = d1.ToString("dd/MM/yyyy");
TransitionLogic ol = new TransitionLogic();
DataTable dt1 = ol.SelectOrderStatus("Order Created",d1);
DataTable dt2 = ol.SelectOrderStatus("Performa invoice generated", d1);
DataTable dt3 = ol.SelectOrderStatus("Performa invoice approved", d1);
DataTable dt4 = ol.SelectOrderStatus("Cylinder requested", d1);
DataTable dt5 = ol.SelectOrderStatus("Cylinder received", d1);
DataTable dt6 = ol.SelectOrderStatus("Print pending", d1);
DataTable dt7 = ol.SelectOrderStatus("Converting", d1);
DataTable dt8 = ol.SelectOrderStatus("Ready", d1);
DataTable dt9 = ol.SelectOrderStatus("Dispached", d1);
DataTable dt10 = ol.SelectOrderStatus("Closed", d1);
int max = findMax(dt1.Rows.Count, dt2.Rows.Count, dt3.Rows.Count, dt4.Rows.Count, dt5.Rows.Count, dt6.Rows.Count, dt7.Rows.Count, dt8.Rows.Count,dt9.Rows.Count, dt10.Rows.Count);
if (dt1.Rows.Count < max)
{
for (int i = dt1.Rows.Count; i < max; i++)
{
dt1.Rows.Add("-");
}
}
if (dt2.Rows.Count < max)
{
for (int i = dt2.Rows.Count; i < max; i++)
{
dt2.Rows.Add("-");
}
}
if (dt3.Rows.Count < max)
{
for (int i = dt3.Rows.Count; i < max; i++)
{
dt3.Rows.Add("-");
}
}
if (dt4.Rows.Count < max)
{
for (int i = dt4.Rows.Count; i < max; i++)
{
dt4.Rows.Add("-");
}
}
if (dt5.Rows.Count < max)
{
for (int i = dt5.Rows.Count; i < max; i++)
{
dt5.Rows.Add("-");
}
}
if (dt6.Rows.Count < max)
{
for (int i = dt6.Rows.Count; i < max; i++)
{
dt6.Rows.Add("-");
}
}
if (dt7.Rows.Count < max)
{
for (int i = dt7.Rows.Count; i < max; i++)
{
dt7.Rows.Add("-");
}
}
if (dt8.Rows.Count < max)
{
for (int i = dt8.Rows.Count; i < max; i++)
{
dt8.Rows.Add("-");
}
}
if (dt9.Rows.Count < max)
{
for (int i = dt9.Rows.Count; i < max; i++)
{
dt9.Rows.Add("-");
}
}
if (dt10.Rows.Count < max)
{
for (int i = dt10.Rows.Count; i < max; i++)
{
dt10.Rows.Add("-");
}
}
Repeater1.DataSource = dt1;
Repeater2.DataSource = dt2;
Repeater3.DataSource = dt3;
Repeater4.DataSource = dt4;
Repeater5.DataSource = dt5;
Repeater6.DataSource = dt6;
Repeater7.DataSource = dt7;
Repeater8.DataSource = dt8;
Repeater9.DataSource = dt9;
Repeater10.DataSource = dt10;
Repeater1.DataBind();
Repeater2.DataBind();
Repeater3.DataBind();
Repeater4.DataBind();
Repeater5.DataBind();
Repeater6.DataBind();
Repeater7.DataBind();
Repeater8.DataBind();
Repeater9.DataBind();
Repeater10.DataBind();
}
protected void Button2_click(object sender, EventArgs e)
{
DateTime d1 = new DateTime();
// d1 = Convert.ToDateTime(TextBox1.Text);
if (!DateTime.TryParseExact(TextBox1.Text, "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out d1))
{
}
Label2.Text = d1.ToString("dd/MM/yyyy");
TransitionLogic ol = new TransitionLogic();
DataTable dt1 = ol.SelectOrderStatus("Order Created", d1);
DataTable dt2 = ol.SelectOrderStatus("Performa invoice generated", d1);
DataTable dt3 = ol.SelectOrderStatus("Performa invoice approved", d1);
DataTable dt4 = ol.SelectOrderStatus("Cylinder requested", d1);
DataTable dt5 = ol.SelectOrderStatus("Cylinder received", d1);
DataTable dt6 = ol.SelectOrderStatus("Print pending", d1);
DataTable dt7 = ol.SelectOrderStatus("Converting", d1);
DataTable dt8 = ol.SelectOrderStatus("Ready", d1);
DataTable dt9 = ol.SelectOrderStatus("Dispached", d1);
DataTable dt10 = ol.SelectOrderStatus("Closed", d1);
int max = findMax(dt1.Rows.Count, dt2.Rows.Count, dt3.Rows.Count, dt4.Rows.Count, dt5.Rows.Count, dt6.Rows.Count, dt7.Rows.Count, dt8.Rows.Count, dt9.Rows.Count, dt10.Rows.Count);
if (dt1.Rows.Count < max)
{
for (int i = dt1.Rows.Count; i < max; i++)
{
dt1.Rows.Add("-");
}
}
if (dt2.Rows.Count < max)
{
for (int i = dt2.Rows.Count; i < max; i++)
{
dt2.Rows.Add("-");
}
}
if (dt3.Rows.Count < max)
{
for (int i = dt3.Rows.Count; i < max; i++)
{
dt3.Rows.Add("-");
}
}
if (dt4.Rows.Count < max)
{
for (int i = dt4.Rows.Count; i < max; i++)
{
dt4.Rows.Add("-");
}
}
if (dt5.Rows.Count < max)
{
for (int i = dt5.Rows.Count; i < max; i++)
{
dt5.Rows.Add("-");
}
}
if (dt6.Rows.Count < max)
{
for (int i = dt6.Rows.Count; i < max; i++)
{
dt6.Rows.Add("-");
}
}
if (dt7.Rows.Count < max)
{
for (int i = dt7.Rows.Count; i < max; i++)
{
dt7.Rows.Add("-");
}
}
if (dt8.Rows.Count < max)
{
for (int i = dt8.Rows.Count; i < max; i++)
{
dt8.Rows.Add("-");
}
}
if (dt9.Rows.Count < max)
{
for (int i = dt9.Rows.Count; i < max; i++)
{
dt9.Rows.Add("-");
}
}
if (dt10.Rows.Count < max)
{
for (int i = dt10.Rows.Count; i < max; i++)
{
dt10.Rows.Add("-");
}
}
Repeater1.DataSource = dt1;
Repeater2.DataSource = dt2;
Repeater3.DataSource = dt3;
Repeater4.DataSource = dt4;
Repeater5.DataSource = dt5;
Repeater6.DataSource = dt6;
Repeater7.DataSource = dt7;
Repeater8.DataSource = dt8;
Repeater9.DataSource = dt9;
Repeater10.DataSource = dt10;
Repeater1.DataBind();
Repeater2.DataBind();
Repeater3.DataBind();
Repeater4.DataBind();
Repeater5.DataBind();
Repeater6.DataBind();
Repeater7.DataBind();
Repeater8.DataBind();
Repeater9.DataBind();
Repeater10.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
Label2.Text = DateTime.Today.ToString("dd/MM/yyyy");
TransitionLogic ol = new TransitionLogic();
DataTable dt1 = ol.SelectOrderStatus("Order Created",DateTime.Today);
DataTable dt2 = ol.SelectOrderStatus("Performa invoice generated", DateTime.Today);
DataTable dt3 = ol.SelectOrderStatus("Performa invoice approved", DateTime.Today);
DataTable dt4 = ol.SelectOrderStatus("Cylinder requested", DateTime.Today);
DataTable dt5 = ol.SelectOrderStatus("Cylinder received", DateTime.Today);
DataTable dt6 = ol.SelectOrderStatus("Print pending", DateTime.Today);
DataTable dt7 = ol.SelectOrderStatus("Converting", DateTime.Today);
DataTable dt8 = ol.SelectOrderStatus("Ready", DateTime.Today);
DataTable dt9 = ol.SelectOrderStatus("Dispached", DateTime.Today);
DataTable dt10 = ol.SelectOrderStatusClosed("Closed", DateTime.Today);
int max = findMax(dt1.Rows.Count, dt2.Rows.Count, dt3.Rows.Count, dt4.Rows.Count, dt5.Rows.Count, dt6.Rows.Count, dt7.Rows.Count, dt8.Rows.Count, dt9.Rows.Count, dt10.Rows.Count);
if (dt1.Rows.Count < max)
{
for (int i = dt1.Rows.Count; i < max; i++)
{
dt1.Rows.Add("-");
}
}
if (dt2.Rows.Count < max)
{
for (int i = dt2.Rows.Count; i < max; i++)
{
dt2.Rows.Add("-");
}
}
if (dt3.Rows.Count < max)
{
for (int i = dt3.Rows.Count; i < max; i++)
{
dt3.Rows.Add("-");
}
}
if (dt4.Rows.Count < max)
{
for (int i = dt4.Rows.Count; i < max; i++)
{
dt4.Rows.Add("-");
}
}
if (dt5.Rows.Count < max)
{
for (int i = dt5.Rows.Count; i < max; i++)
{
dt5.Rows.Add("-");
}
}
if (dt6.Rows.Count < max)
{
for (int i = dt6.Rows.Count; i < max; i++)
{
dt6.Rows.Add("-");
}
}
if (dt7.Rows.Count < max)
{
for (int i = dt7.Rows.Count; i < max; i++)
{
dt7.Rows.Add("-");
}
}
if (dt8.Rows.Count < max)
{
for (int i = dt8.Rows.Count; i < max; i++)
{
dt8.Rows.Add("-");
}
}
if (dt9.Rows.Count < max)
{
for (int i = dt9.Rows.Count; i < max; i++)
{
dt9.Rows.Add("-");
}
}
if (dt10.Rows.Count < max)
{
for (int i = dt10.Rows.Count; i < max; i++)
{
dt10.Rows.Add("-");
}
}
Repeater1.DataSource = dt1;
Repeater2.DataSource = dt2;
Repeater3.DataSource = dt3;
Repeater4.DataSource = dt4;
Repeater5.DataSource = dt5;
Repeater6.DataSource = dt6;
Repeater7.DataSource = dt7;
Repeater8.DataSource = dt8;
Repeater9.DataSource = dt9;
Repeater10.DataSource = dt10;
Repeater1.DataBind();
Repeater2.DataBind();
Repeater3.DataBind();
Repeater4.DataBind();
Repeater5.DataBind();
Repeater6.DataBind();
Repeater7.DataBind();
Repeater8.DataBind();
Repeater9.DataBind();
Repeater10.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
Label2.Text = DateTime.Today.ToString("dd/MM/yyyy");
TransitionLogic ol = new TransitionLogic();
DataTable dt1 = ol.SelectOrderStatus("Order Created", DateTime.Today);
DataTable dt2 = ol.SelectOrderStatus("Performa invoice generated", DateTime.Today);
DataTable dt3 = ol.SelectOrderStatus("Performa invoice approved", DateTime.Today);
DataTable dt4 = ol.SelectOrderStatus("Cylinder requested", DateTime.Today);
DataTable dt5 = ol.SelectOrderStatus("Cylinder received", DateTime.Today);
DataTable dt6 = ol.SelectOrderStatus("Print pending", DateTime.Today);
DataTable dt7 = ol.SelectOrderStatus("Converting", DateTime.Today);
DataTable dt8 = ol.SelectOrderStatus("Ready", DateTime.Today);
DataTable dt9 = ol.SelectOrderStatus("Dispached", DateTime.Today);
DataTable dt10 = ol.SelectOrderStatusClosed("Closed", DateTime.Today);
int max = findMax(dt1.Rows.Count, dt2.Rows.Count, dt3.Rows.Count, dt4.Rows.Count, dt5.Rows.Count, dt6.Rows.Count, dt7.Rows.Count, dt8.Rows.Count, dt9.Rows.Count, dt10.Rows.Count);
if (dt1.Rows.Count < max)
{
for (int i = dt1.Rows.Count; i < max; i++)
{
dt1.Rows.Add("-");
}
}
if (dt2.Rows.Count < max)
{
for (int i = dt2.Rows.Count; i < max; i++)
{
dt2.Rows.Add("-");
}
}
if (dt3.Rows.Count < max)
{
for (int i = dt3.Rows.Count; i < max; i++)
{
dt3.Rows.Add("-");
}
}
if (dt4.Rows.Count < max)
{
for (int i = dt4.Rows.Count; i < max; i++)
{
dt4.Rows.Add("-");
}
}
if (dt5.Rows.Count < max)
{
for (int i = dt5.Rows.Count; i < max; i++)
{
dt5.Rows.Add("-");
}
}
if (dt6.Rows.Count < max)
{
for (int i = dt6.Rows.Count; i < max; i++)
{
dt6.Rows.Add("-");
}
}
if (dt7.Rows.Count < max)
{
for (int i = dt7.Rows.Count; i < max; i++)
{
dt7.Rows.Add("-");
}
}
if (dt8.Rows.Count < max)
{
for (int i = dt8.Rows.Count; i < max; i++)
{
dt8.Rows.Add("-");
}
}
if (dt9.Rows.Count < max)
{
for (int i = dt9.Rows.Count; i < max; i++)
{
dt9.Rows.Add("-");
}
}
if (dt10.Rows.Count < max)
{
for (int i = dt10.Rows.Count; i < max; i++)
{
dt10.Rows.Add("-");
}
}
Repeater1.DataSource = dt1;
Repeater2.DataSource = dt2;
Repeater3.DataSource = dt3;
Repeater4.DataSource = dt4;
Repeater5.DataSource = dt5;
Repeater6.DataSource = dt6;
Repeater7.DataSource = dt7;
Repeater8.DataSource = dt8;
Repeater9.DataSource = dt9;
Repeater10.DataSource = dt10;
Repeater1.DataBind();
Repeater2.DataBind();
Repeater3.DataBind();
Repeater4.DataBind();
Repeater5.DataBind();
Repeater6.DataBind();
Repeater7.DataBind();
Repeater8.DataBind();
Repeater9.DataBind();
Repeater10.DataBind();
}