private void BindGridViewSection(string search)
        {
            FiltersModel       fm        = Session["FiltersModel"] as FiltersModel;
            List <ViewSection> _View     = new List <ViewSection>();
            List <ViewSection> _TempView = new List <ViewSection>();
            User         LoggedInUser    = HttpContext.Current.Session["LoggedUser"] as User;
            QueryBuilder qb    = new QueryBuilder();
            string       query = qb.QueryForSectionRptFilters(LoggedInUser);
            DataTable    dt    = qb.GetValuesfromDB("select * from ViewSection " + query);

            _View = dt.ToList <ViewSection>().AsQueryable().SortBy("DeptName").ToList();

            if (fm.DepartmentFilter.Count > 0)
            {
                _TempView.Clear();
                foreach (var Sec in fm.DepartmentFilter)
                {
                    short _SecID = Convert.ToInt16(Sec.ID);
                    _TempView.AddRange(_View.Where(aa => aa.SectionID == _SecID).ToList());
                }
                _View = _TempView.ToList();
            }
            GridViewSection.DataSource = _View.Where(aa => aa.SectionName.ToUpper().Contains(search.ToUpper()) || aa.DeptName.ToUpper().Contains(search.ToUpper())).ToList();
            GridViewSection.DataBind();
        }
        private void BindGridViewSection(string search)
        {
            using (var db = new HRMEntities())
            {
                FiltersModel         fm           = Session["FiltersModel"] as FiltersModel;
                List <ViewHRSection> _View        = new List <ViewHRSection>();
                List <ViewHRSection> _TempView    = new List <ViewHRSection>();
                ViewUserEmp          LoggedInUser = HttpContext.Current.Session["LoggedUser"] as ViewUserEmp;
                List <ViewHRSection> secList      = new List <ViewHRSection>();
                secList = db.ViewHRSections.Where(aa => aa.Status == true).ToList();
                if (LoggedInUser.UserType == "A" || LoggedInUser.UserType == "H" || LoggedInUser.UserType == "E" || LoggedInUser.HRModule == true)
                {
                    _View = secList.ToList();
                }
                else
                {
                    List <EmpView> emps = new List <EmpView>();
                    emps = OTHelperManager.GetEmployees(db.EmpViews.Where(aa => aa.Status == "Active").ToList(), LoggedInUser);
                    List <short?>        secids   = emps.Select(aa => aa.SectionID).Distinct().ToList();
                    List <ViewHRSection> tempSecs = new List <ViewHRSection>();
                    foreach (var secid in secids)
                    {
                        tempSecs.AddRange(secList.Where(aa => aa.SecID == secid).ToList());
                    }
                    _View = tempSecs.ToList();
                }

                if (fm.DepartmentFilter.Count > 0)
                {
                    _TempView.Clear();
                    foreach (var dept in fm.DepartmentFilter)
                    {
                        short _deptID = Convert.ToInt16(dept.ID);
                        _TempView.AddRange(_View.Where(aa => aa.DeptID == _deptID).ToList());
                    }
                    _View = _TempView.ToList();
                }
                if (fm.LocationFilter.Count > 0)
                {
                    _TempView.Clear();
                    foreach (var dept in fm.LocationFilter)
                    {
                        short _deptID = Convert.ToInt16(dept.ID);
                        _TempView.AddRange(_View.Where(aa => aa.LocID == _deptID).ToList());
                    }
                    _View = _TempView.ToList();
                }
                GridViewSection.DataSource = _View.Where(aa => aa.SectionName.ToUpper().Contains(search.ToUpper())).OrderBy(aa => aa.SectionName).ToList();
                GridViewSection.DataBind();
            }
        }
示例#3
0
        private void BindGridViewSection(string search)
        {
            FiltersModel       fm        = Session["FiltersModel"] as FiltersModel;
            List <ViewSection> _View     = new List <ViewSection>();
            List <ViewSection> _TempView = new List <ViewSection>();
            User         LoggedInUser    = HttpContext.Current.Session["LoggedUser"] as User;
            QueryBuilder qb = new QueryBuilder();
            // string query = qb.QueryForCompanyFilters(LoggedInUser);
            DataTable dt = qb.GetValuesfromDB("select * from ViewSection" + " order by SectionName asc");

            _View = dt.ToList <ViewSection>();
            //if (fm.CompanyFilter.Count > 0)
            //{
            //    foreach (var comp in fm.CompanyFilter)
            //    {
            //        short _compID = Convert.ToInt16(comp.ID);

            //        _TempView.AddRange(_View.Where(aa => aa.CompanyID == _compID).ToList());
            //    }
            //    _View = _TempView.ToList();
            //}
            //if (fm.DivisionFilter.Count > 0)
            //{
            //    _TempView.Clear();
            //    foreach (var comp in fm.DivisionFilter)
            //    {
            //        short _compID = Convert.ToInt16(comp.ID);
            //        _TempView.AddRange(_View.Where(aa => aa.DivID == _compID).ToList());
            //    }
            //    _View = _TempView.ToList();
            //}
            if (fm.DepartmentFilter.Count > 0)
            {
                _TempView.Clear();
                foreach (var comp in fm.DepartmentFilter)
                {
                    short _compID = Convert.ToInt16(comp.ID);
                    _TempView.AddRange(_View.Where(aa => aa.DeptID == _compID).ToList());
                }
                _View = _TempView.ToList();
            }
            GridViewSection.DataSource = _View.Where(aa => aa.SectionName.ToUpper().Contains(search.ToUpper())).ToList();
            GridViewSection.DataBind();
        }
示例#4
0
        private void BindGridViewSection(string search)
        {
            FiltersModel       fm           = Session["FiltersModel"] as FiltersModel;
            List <ViewSection> _View        = new List <ViewSection>();
            List <ViewSection> _TempView    = new List <ViewSection>();
            User               LoggedInUser = Session["LoggedUser"] as User;
            TAS2013Entities    db           = new TAS2013Entities();
            QueryBuilder       qb           = new QueryBuilder();
            string             query        = qb.QueryForSectionRptFilters(LoggedInUser);
            DataTable          dt           = qb.GetValuesfromDB("select * from ViewSection " + query);
            List <ViewSection> _Viewsec     = new List <ViewSection>();
            List <ViewSection> _TempViewsec = new List <ViewSection>();

            _View = dt.ToList <ViewSection>().AsQueryable().SortBy("SectionName").ToList();
            foreach (var item in db.UserSections.Where(aa => aa.UserID == LoggedInUser.UserID && aa.LocationOrSection == "Section").ToList())
            {
                _TempView.AddRange(_View.Where(aa => aa.SectionID == item.SectionID).ToList());
            }
            GridViewSection.DataSource = _TempView.Where(aa => aa.SectionName.ToUpper().Contains(search.ToUpper())).ToList();
            GridViewSection.DataBind();
        }