//for Company
protected void chkCtrlCompany_CheckedChanged(object sender, EventArgs e)
{
foreach (GridViewRow row in grid_Company.Rows)
{
CheckBox ck = ((CheckBox)row.FindControl("chkCtrlCompany"));
Company _comp = new Company();
_comp.CompID = Convert.ToInt16(row.Cells[1].Text);
_comp.CompName = row.Cells[2].Text;
if (ck.Checked)
{
if (SelectedLocs.Where(aa => aa.LocID == _comp.CompID).Count() == 0)
{
SelectedComps.Add(_comp);
}
}
else
{
if (SelectedComps.Where(aa => aa.CompID == _comp.CompID).Count() > 0)
{
var comp = SelectedComps.Where(aa => aa.CompID == _comp.CompID).First();
SelectedComps.Remove(comp);
}
}
}
}
public void SetTargetedTile(GlobalTargetInfo t)
{
CameraJumper.TryHideWorld();
var compList = SelectedComps.ToList();
for (int i = 0; i < compList.Count; i++)
{
var comp = compList[i];
NonPublicMethods.Building_TurretGun_ResetForcedTarget(comp.Turret);
NonPublicMethods.Building_TurretGun_ResetCurrentTarget(comp.Turret);
comp.targetedTile = t;
SoundDefOf.TurretAcquireTarget.PlayOneShot(new TargetInfo(comp.parent.Position, comp.parent.Map, false));
comp.ResetWarmupTicks();
}
}
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());
}
}
