protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { DivGridSection.Visible = false; DivGridCrew.Visible = false; DivGridDept.Visible = false; DivGridEmp.Visible = false; DivShiftGrid.Visible = false; DivLocGrid.Visible = false; DivTypeGrid.Visible = false; ReportViewer1.Visible = true; DivGridComapny.Visible = false; SelectedComps.Clear(); ReportViewer1.Width = 1050; ReportViewer1.Height = 700; SelectedTypes.Clear(); SelectedCrews.Clear(); SelectedDepts.Clear(); SelectedEmps.Clear(); SelectedLocs.Clear(); SelectedSections.Clear(); SelectedShifts.Clear(); LoadGridViews(); RefreshLabels(); DateTime date = DateTime.Today.Date; if (GlobalVariables.DeploymentType == false) { PathString = "/Reports/RDLC/DREarlyOut.rdlc"; } else { PathString = "/WMS/Reports/RDLC/DREarlyOut.rdlc"; } User LoggedInUser = HttpContext.Current.Session["LoggedUser"] as User; QueryBuilder qb = new QueryBuilder(); string query = qb.MakeCustomizeQuery(LoggedInUser); DataTable dt = qb.GetValuesfromDB("select * from ViewEarlyOut " + query + " and AttDate = '" + date.Date.Year.ToString() + "-" + date.Date.Month.ToString() + "-" + date.Date.Day.ToString() + "'" + " and StatusEO=1 "); List <ViewEarlyOut> _View = dt.ToList <ViewEarlyOut>(); LoadReport(PathString, _View); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { DivGridSection.Visible = false; DivGridCrew.Visible = false; DivGridDept.Visible = false; DivGridEmp.Visible = false; DivShiftGrid.Visible = false; DivLocGrid.Visible = false; DivTypeGrid.Visible = false; ReportViewer1.Visible = true; DivGridComapny.Visible = false; SelectedComps.Clear(); ReportViewer1.Width = 1050; ReportViewer1.Height = 700; SelectedTypes.Clear(); SelectedCrews.Clear(); SelectedDepts.Clear(); SelectedEmps.Clear(); SelectedLocs.Clear(); SelectedSections.Clear(); SelectedShifts.Clear(); RefreshLabels(); LoadGridViews(); DateTime date = DateTime.Today.Date.AddDays(-1); if (GlobalVariables.DeploymentType == false) { PathString = "/Reports/RDLC/DRMultipleInOut.rdlc"; } else { PathString = "/WMS/Reports/RDLC/DRMultipleInOut.rdlc"; } User LoggedInUser = HttpContext.Current.Session["LoggedUser"] as User; QueryBuilder qb = new QueryBuilder(); string query = qb.MakeCustomizeQuery(LoggedInUser); DataTable datatable = qb.GetValuesfromDB("select * from ViewDetailAttData " + query + " and (AttDate = " + "'" + date.ToString("yyyy-MM-dd") + "')" + " and (Tin1 is not null or TOut1 is not null)"); List <ViewDetailAttData> _View = datatable.ToList <ViewDetailAttData>(); LoadReport(PathString, _View); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { DivGridSection.Visible = false; DivGridCrew.Visible = false; DivGridDept.Visible = false; DivGridEmp.Visible = false; DivShiftGrid.Visible = false; DivLocGrid.Visible = false; DivTypeGrid.Visible = false; ReportViewer1.Visible = true; DivGridComapny.Visible = false; SelectedComps.Clear(); ReportViewer1.Width = 1050; ReportViewer1.Height = 700; SelectedTypes.Clear(); SelectedCrews.Clear(); SelectedDepts.Clear(); SelectedEmps.Clear(); SelectedLocs.Clear(); SelectedSections.Clear(); SelectedShifts.Clear(); RefreshLabels(); LoadGridViews(); if (GlobalVariables.DeploymentType == false) { PathString = "/Reports/RDLC/EmployeeDetail.rdlc"; } else { PathString = "/WMS/Reports/RDLC/EmployeeDetail.rdlc"; } User LoggedInUser = HttpContext.Current.Session["LoggedUser"] as User; QueryBuilder qb = new QueryBuilder(); string query = qb.MakeCustomizeQuery(LoggedInUser); DataTable dt = qb.GetValuesfromDB("select * from EmpView " + query); List <EmpView> _View = dt.ToList <EmpView>(); LoadReport(PathString, _View); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { DivGridSection.Visible = false; DivGridCrew.Visible = false; DivGridDept.Visible = false; DivGridEmp.Visible = false; DivShiftGrid.Visible = false; DivLocGrid.Visible = false; DivTypeGrid.Visible = false; ReportViewer1.Visible = true; DivGridComapny.Visible = false; SelectedComps.Clear(); ReportViewer1.Width = 1050; ReportViewer1.Height = 700; SelectedTypes.Clear(); SelectedCrews.Clear(); SelectedDepts.Clear(); SelectedEmps.Clear(); SelectedLocs.Clear(); SelectedSections.Clear(); SelectedShifts.Clear(); RefreshLabels(); LoadGridViews(); DateTime dateTo = DateTime.Today.Date.AddDays(-1); DateTime dateFrom = DateTime.Today.Date.AddDays(-20); if (GlobalVariables.DeploymentType == false) { PathString = "/Reports/RDLC/EmpAttSummary.rdlc"; } else { PathString = "/WMS/Reports/RDLC/EmpAttSummary.rdlc"; } LoadReport(PathString, context.ViewPresentEmps.Where(aa => aa.AttDate >= dateFrom && aa.AttDate <= dateTo && aa.EmpID == 1).ToList()); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { DivGridSection.Visible = false; DivGridCrew.Visible = false; DivGridDept.Visible = false; DivGridEmp.Visible = false; DivShiftGrid.Visible = false; DivLocGrid.Visible = false; DivTypeGrid.Visible = false; ReportViewer1.Visible = true; ReportViewer1.Width = 1050; ReportViewer1.Height = 700; SelectedTypes.Clear(); SelectedCrews.Clear(); SelectedDepts.Clear(); SelectedEmps.Clear(); SelectedLocs.Clear(); SelectedSections.Clear(); SelectedShifts.Clear(); DivGridComapny.Visible = false; SelectedComps.Clear(); LoadGridViews(); RefreshLabels(); string _period = DateTime.Now.Month.ToString() + DateTime.Now.Year.ToString(); if (GlobalVariables.DeploymentType == false) { PathString = "/Reports/RDLC/MRSheetC.rdlc"; } else { PathString = "/WMS/Reports/RDLC/MRSheetC.rdlc"; } LoadReport(PathString, context.ViewMonthlyDatas.Where(aa => aa.Period == _period).ToList()); } }