public IEnumerable <SelectListItem> DistrictAuth(string cRegion, string selectedValue)
        {
            System.Web.Security.FormsIdentity identity = (System.Web.Security.FormsIdentity)HttpContext.User.Identity;
            string[] roles = identity.Ticket.UserData.Split('|');

            if (roles.Length > 4)
            {
                IMsDistrictAuthorizationQuery      msDistrictAuthorizationQuery = new MsDistrictAuthorizationListQuery();
                IList <MsDistrictAuthorizationDto> listDistrictAuth             = msDistrictAuthorizationQuery
                                                                                  .GetMsDistrictAuthorizationQRY(2, 0, 0
                                                                                                                 , "cStatus = 1 AND nPernr = " + roles[5] + " AND cRegionCode = '" + cRegion + "'"
                                                                                                                 , "cDistrictName");

                IEnumerable <SelectListItem> query = (from da in listDistrictAuth
                                                      select new SelectListItem
                {
                    Value = da.cDistrictCode,
                    Text = da.cDistrictName,
                    Selected = da.cDistrictCode.Equals(selectedValue) ? true : false
                });

                return(query);
            }

            return(null);
        }
        public IEnumerable <SelectListItem> ProvinceAuth(string selValue)
        {
            System.Web.Security.FormsIdentity identity = (System.Web.Security.FormsIdentity)HttpContext.User.Identity;
            string[] roles = identity.Ticket.UserData.Split('|');

            selValue = string.IsNullOrEmpty(selValue) ? string.Empty : selValue;
            if (roles.Length > 4)
            {
                IMsDistrictAuthorizationQuery      msDistrictAuthorizationQuery = new MsDistrictAuthorizationListQuery();
                IList <MsDistrictAuthorizationDto> listDistrictAuth             = msDistrictAuthorizationQuery
                                                                                  .GetMsDistrictAuthorizationQRY(2, 0, 0, "cStatus = 1 AND nPernr = " + roles[5], "cProvince");

                IEnumerable <SelectListItem> query = (from da in listDistrictAuth
                                                      group da by new { da.cProvince } into g
                                                      select new SelectListItem
                {
                    Value = g.FirstOrDefault().cProvince,
                    Text = g.FirstOrDefault().cProvince,
                    Selected = selValue.Equals(g.FirstOrDefault().cProvince)
                });

                return(query);
            }

            return(null);
        }
        public String GetRegionSelected()
        {
            string ddlRegion = Request["ddlRegion"];

            if (!string.IsNullOrEmpty(ddlRegion))
            {
                Session["ddlRegion"] = ddlRegion;
            }
            else
            {
                // Set default region
                string regionSelected = string.Empty;
                IMsDistrictAuthorizationQuery      msDistrictAuthorizationQuery = new MsDistrictAuthorizationListQuery();
                IList <MsDistrictAuthorizationDto> listDistrictAuth             = msDistrictAuthorizationQuery
                                                                                  .GetMsDistrictAuthorizationQRY(2, 0, 0
                                                                                                                 , "cStatus = 1 AND nPernr = " + HttpContext.User.Identity.Name, string.Empty);

                if (listDistrictAuth.Count > 0)
                {
                    regionSelected = listDistrictAuth[0].cRegionCode;
                }

                ddlRegion = Session["ddlRegion"] == null ? regionSelected :
                            Session["ddlRegion"].ToString();
            }
            return(ddlRegion);
        }
        public IEnumerable <MsDistrictAuthorizationDto> RegionAuth(int pernr)
        {
            IMsDistrictAuthorizationQuery      msDistrictAuthorizationQuery = new MsDistrictAuthorizationListQuery();
            IList <MsDistrictAuthorizationDto> listDistrictAuth             = msDistrictAuthorizationQuery
                                                                              .GetMsDistrictAuthorizationQRY(2, 0, 0, "cStatus = 1 AND nPernr = " + pernr, "cRegionName");

            IEnumerable <MsDistrictAuthorizationDto> query = (from da in listDistrictAuth
                                                              group da by new { da.cRegionCode, da.cRegionName } into g
                                                              select new MsDistrictAuthorizationDto
            {
                cRegionCode = g.FirstOrDefault().cRegionCode,
                cRegionName = g.FirstOrDefault().cRegionName,
            });

            return(query);
        }