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; DivGridComapny.Visible = false; ReportViewer1.Visible = true; LoadGridViews(); ReportViewer1.Width = 1080; ReportViewer1.Height = 700; SelectedTypes.Clear(); SelectedCrews.Clear(); SelectedDepts.Clear(); SelectedEmps.Clear(); SelectedLocs.Clear(); SelectedComps.Clear(); SelectedSections.Clear(); SelectedShifts.Clear(); RefreshLabels(); LoadGridViews(); DateTime date = DateTime.Today.Date.AddDays(-1); if (GlobalVariables.DeploymentType == false) { PathString = "/Reports/RDLC/DRDetailed.rdlc"; } else { PathString = "/WMS/Reports/RDLC/DRDetailed.rdlc"; } //List<ViewAttData> _View = new List<ViewAttData>(); User LoggedInUser = HttpContext.Current.Session["LoggedUser"] as User; QueryBuilder qb = new QueryBuilder(); string query = qb.MakeCustomizeQuery(LoggedInUser); DataTable dt = qb.GetValuesfromDB("select * from ViewAttData " + query + " and AttDate = '" + date.Date.Year.ToString() + "-" + date.Date.Month.ToString() + "-" + date.Date.Day.ToString() + "'"); List <ViewAttData> _View = dt.ToList <ViewAttData>(); LoadReport(PathString, _View); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { CreateDatatable(); 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(); RefreshLabels(); LoadGridViews(); string _period = DateTime.Now.Month.ToString() + DateTime.Now.Year.ToString(); if (GlobalVariables.DeploymentType == false) { PathString = "/Reports/RDLC/MLvApplication.rdlc"; } else { PathString = "/WMS/Reports/RDLC/MLvApplication.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); DataTable dt = qb.GetValuesfromDB("select * from EmpView "); List <EmpView> _emp = dt.ToList <EmpView>(); LoadReport(PathString, GetLV(_emp, DateTime.Now.Month)); } }
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(); RefreshLabels(); LoadGridViews(); string _period = DateTime.Now.Month.ToString() + DateTime.Now.Year.ToString(); if (GlobalVariables.DeploymentType == false) { PathString = "/Reports/RDLC/MRDetailExcelP.rdlc"; } else { PathString = "/WMS/Reports/RDLC/MRDetailExcelP.rdlc"; } List <ViewMonthlyDataPer> _ViewList = new List <ViewMonthlyDataPer>(); User LoggedInUser = HttpContext.Current.Session["LoggedUser"] as User; QueryBuilder qb = new QueryBuilder(); string query = qb.MakeCustomizeQuery(LoggedInUser); DataTable dt = qb.GetValuesfromDB("select * from ViewMonthlyDataPer " + query + " and Period='" + _period + "'"); _ViewList = dt.ToList <ViewMonthlyDataPer>(); LoadReport(PathString, _ViewList); } }
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()); } }