private void ShowWorkOrders()
{
try
{
lblCurrentDate.Text = dtCurrentDate.ToLongDateString();
order = new clsWorkOrders();
order.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false);
switch(dtCurrentDate.DayOfWeek)
{
case DayOfWeek.Monday:
l_iWeekDay = 0;
break;
case DayOfWeek.Tuesday:
l_iWeekDay = 1;
break;
case DayOfWeek.Wednesday:
l_iWeekDay = 2;
break;
case DayOfWeek.Thursday:
l_iWeekDay = 3;
break;
case DayOfWeek.Friday:
l_iWeekDay = 4;
break;
case DayOfWeek.Saturday:
l_iWeekDay = 5;
break;
case DayOfWeek.Sunday:
l_iWeekDay = 6;
break;
}
lblMondayDate.Text = "Monday " + dtCurrentDate.AddDays(-(l_iWeekDay)).ToShortDateString();
lblTuesdayDate.Text = "Tuesday " + dtCurrentDate.AddDays(1-l_iWeekDay).ToShortDateString();
lblWednesdayDate.Text = "Wednesday " + dtCurrentDate.AddDays(2-l_iWeekDay).ToShortDateString();
lblThursdayDate.Text = "Thursday " + dtCurrentDate.AddDays(3-l_iWeekDay).ToShortDateString();
lblFridayDate.Text = "Friday " + dtCurrentDate.AddDays(4-l_iWeekDay).ToShortDateString();
lblWeekendDate.Text = "Saturday/Sunday " + dtCurrentDate.AddDays(5-l_iWeekDay).ToShortDateString() + " - " + dtCurrentDate.AddDays(6-l_iWeekDay).ToShortDateString();
order.daMaxDate = dtCurrentDate.AddDays(7-l_iWeekDay);
order.daMinDate = dtCurrentDate.AddDays(-(l_iWeekDay));
dtWorkOrders = order.GetWOListForDate();
// Monday
dwOrderMonday = new DataView(dtWorkOrders);
dwOrderMonday.RowFilter = "[WeekDay] = 2";
dgWorkOrdersMonday.DataSource = dwOrderMonday;
dgWorkOrdersMonday.DataBind();
// Tuesday
dwOrderTuesday = new DataView(dtWorkOrders);
dwOrderTuesday.RowFilter = "[WeekDay] = 3";
dgWorkOrdersTuesday.DataSource = dwOrderTuesday;
dgWorkOrdersTuesday.DataBind();
// Wednesday
dwOrderWednesday = new DataView(dtWorkOrders);
dwOrderWednesday.RowFilter = "[WeekDay] = 4";
dgWorkOrdersWednesday.DataSource = dwOrderWednesday;
dgWorkOrdersWednesday.DataBind();
// Thursday
dwOrderThursday = new DataView(dtWorkOrders);
dwOrderThursday.RowFilter = "[WeekDay] = 5";
dgWorkOrdersThursday.DataSource = dwOrderThursday;
dgWorkOrdersThursday.DataBind();
// Friday
dwOrderFriday = new DataView(dtWorkOrders);
dwOrderFriday.RowFilter = "[WeekDay] = 6";
dgWorkOrdersFriday.DataSource = dwOrderFriday;
dgWorkOrdersFriday.DataBind();
// Weekend
dwOrderWeekend = new DataView(dtWorkOrders);
dwOrderWeekend.RowFilter = "[WeekDay] in (1,7)";
dgWorkOrdersWeekend.DataSource = dwOrderWeekend;
dgWorkOrdersWeekend.DataBind();
Session["CurrentDay"] = dtCurrentDate;
}
catch(Exception ex)
{
throw new Exception(ex.Message, ex);
}
finally
{
if(order != null)
order.Dispose();
}
}
/// <summary>
/// Procedure is showing all work orders for current date
/// </summary>
private void ShowWorkOrders()
{
try
{
lblCurrentDate.Text = dtCurrentDate.ToLongDateString();
order = new clsWorkOrders();
order.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false);
order.daMaxDate = dtCurrentDate.AddDays(1);
order.daMinDate = dtCurrentDate;
dgWorkOrders.DataSource = new DataView(order.GetWOListForDate());
dgWorkOrders.DataBind();
Session["CurrentDay"] = dtCurrentDate;
}
catch(Exception ex)
{
throw new Exception(ex.Message, ex);
}
finally
{
if(order != null)
order.Dispose();
}
}
private void t_calOrders_PreRender(object sender, System.EventArgs e)
{
try
{
// Procedure is showing all work orders for current date
lblCurrentDate.Text = t_calOrders.TodaysDate.ToString("y");
order = new clsWorkOrders();
order.iOrgId = _functions.GetUserOrgId(HttpContext.Current.User.Identity.Name, false);
order.daMinDate = ((Acme.CalendarDayCell)t_calOrders.Controls[0].Controls[1].Controls[0]).Date.Date;
order.daMaxDate = ((Acme.CalendarDayCell)t_calOrders.Controls[0].Controls[t_calOrders.Controls[0].Controls.Count-1].Controls[6]).Date.Date.AddDays(1);
dwWorkOrders = new DataView(order.GetWOListForDate());
for(int i = 1; i < t_calOrders.Controls[0].Controls.Count; i++)
{
for(int j = 0; j < 7; j++)
{
dwWorkOrders.RowFilter = "[Date] = '" + ((Acme.CalendarDayCell)t_calOrders.Controls[0].Controls[i].Controls[j]).Date.ToString() + "'";
((Repeater)t_calOrders.Controls[0].Controls[i].Controls[j].FindControl("repOrders")).DataSource = dwWorkOrders;
((Repeater)t_calOrders.Controls[0].Controls[i].Controls[j].FindControl("repOrders")).DataBind();
}
}
}
catch(Exception ex)
{
_functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName);
Session["lastpage"] = "main.aspx";
Session["error"] = ex.Message;
Session["error_report"] = ex.ToString();
Response.Redirect("error.aspx", false);
}
finally
{
if(order != null)
order.Dispose();
}
}
