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