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