//for sections protected void chkCtrlSection_CheckedChanged(object sender, EventArgs e) { foreach (GridViewRow row in grid_Section.Rows) { CheckBox ck = ((CheckBox)row.FindControl("chkCtrlSection")); Section _sec = new Section(); _sec.SectionID = Convert.ToInt16(row.Cells[1].Text); _sec.SectionName = row.Cells[2].Text; if (ck.Checked) { if (SelectedSections.Where(sec => sec.SectionID == _sec.SectionID).Count() == 0) { SelectedSections.Add(_sec); } } else { if (SelectedSections.Where(sec => sec.SectionID == _sec.SectionID).Count() > 0) { var _section = SelectedSections.Where(sec => sec.SectionID == _sec.SectionID).First(); SelectedSections.Remove(_section); } } } }
public LineList_Output_ParamDef(string inName, FeRestraint inDefaultRestraint = null, List <string> inDefaultSelectedSectionNames = null) : base(inName) { if (inDefaultSelectedSectionNames == null || inDefaultSelectedSectionNames.Count == 0) { // Adds ALL sections SelectedSections.AddItems(FeSectionPipe.GetAllSections()); } else { SelectedSections.AddItems((from a in FeSectionPipe.GetAllSections() where inDefaultSelectedSectionNames.Contains(a.Name) select a).ToList()); } SelectedSections.CollectionChanged += SelectedSections_CollectionChanged; if (inDefaultRestraint == null) { Restraint = new FeRestraint(); // All False } else { Restraint = inDefaultRestraint; } }
protected void Page_Load(object sender, EventArgs e) { User _loggedUser = HttpContext.Current.Session["LoggedUser"] as User; 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; LoadGridViews(); ReportViewer1.Width = 1150; ReportViewer1.Height = 700; SelectedTypes.Clear(); SelectedCrews.Clear(); SelectedDepts.Clear(); SelectedEmps.Clear(); SelectedLocs.Clear(); SelectedSections.Clear(); SelectedShifts.Clear(); RefreshLabels(); LoadGridViews(); DateTime dt = DateTime.Today.Date.AddDays(-1); if (GlobalVariables.DeploymentType == false) { PathString = "/Reports/RDLC/DRDetailed.rdlc"; } else { PathString = "/WMS/Reports/RDLC/.rdlc"; } List <ViewMultipleInOut> _View = new List <ViewMultipleInOut>(); if (_loggedUser.ViewContractual == false && _loggedUser.ViewPermanentMgm == true && _loggedUser.ViewPermanentStaff == false) { _View = context.ViewMultipleInOuts.Where(aa => aa.CompanyID == _loggedUser.CompanyID && (aa.TypeID == 7 || aa.TypeID == 27 || aa.TypeID == 28)).ToList(); } else if (_loggedUser.ViewContractual == false && _loggedUser.ViewPermanentMgm == false && _loggedUser.ViewPermanentStaff == true) { _View = context.ViewMultipleInOuts.Where(aa => aa.CompanyID == _loggedUser.CompanyID && (aa.TypeID == 2 || aa.TypeID == 3 || aa.TypeID == 9)).ToList(); } else if (_loggedUser.ViewContractual == true && _loggedUser.ViewPermanentMgm == false && _loggedUser.ViewPermanentStaff == false) { _View = context.ViewMultipleInOuts.Where(aa => aa.CatID != 2).ToList(); } else { _View = context.ViewMultipleInOuts.Where(aa => aa.CompanyID == _loggedUser.CompanyID).ToList(); } LoadReport(PathString, _View); } }
private void OnNotSelectedSectionDoubleClickCommand() { var section = SelectedNotSelectedSection; if (section == null) { return; } NotSelectedSections.Remove(section); SelectedSections.Add(section); RaisePropertyChanged(() => SelectedSections); RaisePropertyChanged(() => NotSelectedSections); }
/// <summary> /// sets the returnparameter before closing /// </summary> /// <param name="window"></param> private void OnApplyCommand(Window window) { ReturnParameter = Parameter; ReturnParameter.Buildings = SelectedBuildings.ToList(); ReturnParameter.Departments = SelectedDepartments.ToList(); ReturnParameter.ItemStates = SelectedItemStates.ToList(); ReturnParameter.ItemNatures = SelectedItemNatures.ToList(); ReturnParameter.ItemTypes = SelectedItemTypes.ToList(); ReturnParameter.Locations = SelectedLocations.ToList(); ReturnParameter.Sections = SelectedSections.ToList(); ReturnParameter.Floors = SelectedFloors.ToList(); window.DialogResult = true; window.Close(); }
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(); RefreshLabels(); LoadGridViews(); if (GlobalVariables.DeploymentType == false) { PathString = "/Reports/RDLC/YLvConsumed.rdlc"; } else { PathString = "/WMS/Reports/RDLC/YLvConsumed.rdlc"; } User LoggedInUser = HttpContext.Current.Session["LoggedUser"] as User; QueryBuilder qb = new QueryBuilder(); string query = qb.MakeCustomizeQuery(LoggedInUser); DataTable dt = qb.GetValuesfromDB("select * from ViewLvConsumed " + query); List <ViewLvConsumed> _ViewList = dt.ToList <ViewLvConsumed>(); 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; 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()); } }
/// <summary> /// Initialization /// </summary> /// <returns></returns> protected override async Task InitializeAsync() { try { IsLoading = true; if (Parameter != null) { SelectedBuildings = new ObservableCollection <BuildingDto>(Parameter.Buildings); SelectedDepartments = new ObservableCollection <DepartmentDto>(Parameter.Departments); SelectedFloors = new ObservableCollection <FloorDto>(Parameter.Floors); SelectedItemNatures = new ObservableCollection <ItemNatureDto>(Parameter.ItemNatures); SelectedItemStates = new ObservableCollection <ItemStateDto>(Parameter.ItemStates); SelectedItemTypes = new ObservableCollection <ItemTypeDto>(Parameter.ItemTypes); SelectedLocations = new ObservableCollection <LocationDto>(Parameter.Locations); SelectedSections = new ObservableCollection <SectionDto>(Parameter.Sections); } else { SelectedBuildings = new ObservableCollection <BuildingDto>(); SelectedDepartments = new ObservableCollection <DepartmentDto>(); SelectedFloors = new ObservableCollection <FloorDto>(); SelectedItemNatures = new ObservableCollection <ItemNatureDto>(); SelectedItemStates = new ObservableCollection <ItemStateDto>(); SelectedItemTypes = new ObservableCollection <ItemTypeDto>(); SelectedLocations = new ObservableCollection <LocationDto>(); SelectedSections = new ObservableCollection <SectionDto>(); } var buildingList = await _buildingApiService.GetAll(); var departmentList = await _departmentApiService.GetAll(); var floorList = await _floorApiService.GetAll(); var itemNatureList = await _itemNatureApiService.GetAll(); var itemStateList = await _itemStateApiService.GetAll(); var itemTypeList = await _itemTypeApiService.GetAll(); var locationList = await _locationApiService.GetAll(); var sectionList = await _sectionApiService.GetAll(); if (buildingList != null) { var buildings = buildingList.Where(building => SelectedBuildings.FirstOrDefault(building2 => building.Id == building2.Id) == null).ToList(); NotSelectedBuildings = new ObservableCollection <BuildingDto>(buildings); } if (departmentList != null) { var departments = departmentList.Where(department => SelectedDepartments.FirstOrDefault(department2 => department.Id == department2.Id) == null).ToList(); NotSelectedDepartments = new ObservableCollection <DepartmentDto>(departments); } if (floorList != null) { var floors = floorList.Where(floor => !SelectedFloors.Contains(floor)).ToList(); NotSelectedFloors = new ObservableCollection <FloorDto>(floors); } if (itemNatureList != null) { var itemNatures = itemNatureList.Where(itemNature => SelectedItemNatures.FirstOrDefault(itemNature2 => itemNature.Id == itemNature2.Id) == null).ToList(); NotSelectedItemNatures = new ObservableCollection <ItemNatureDto>(itemNatures); } if (itemStateList != null) { var itemStates = itemStateList.Where(itemState => SelectedItemStates.FirstOrDefault(itemState2 => itemState.Id == itemState2.Id) == null).ToList(); NotSelectedItemStates = new ObservableCollection <ItemStateDto>(itemStates); } if (itemTypeList != null) { var itemTypes = itemTypeList.Where(itemType => SelectedItemTypes.FirstOrDefault(itemType2 => itemType.Id == itemType2.Id) == null).ToList(); NotSelectedItemTypes = new ObservableCollection <ItemTypeDto>(itemTypes); } if (locationList != null) { var locations = locationList.Where(location => SelectedLocations.FirstOrDefault(location2 => location.Id == location2.Id) == null).ToList(); NotSelectedLocations = new ObservableCollection <LocationDto>(locations); } if (sectionList != null) { var sections = sectionList.Where(section => SelectedSections.FirstOrDefault(section2 => section.Id == section2.Id) == null).ToList(); NotSelectedSections = new ObservableCollection <SectionDto>(sections); } } catch (Exception e) { _loggingService.LogFatal("Error during Initalization!", e); _dialogService.ShowError(e.Message); } finally { IsLoading = false; } }