//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;
}
}
