Exemple #1
0
        public ActionResult _getdistA360(int ID)
        {
            var list = opb.UHSWEBUSRCONDbs.Where(s => s.A360CSTNM != null && s.divid == ID && s.distid != 0).Select(s => new { distid = s.distid, district = s.district }).Distinct();
            List <UHSWEBUSRCONDb> distA360 = new List <UHSWEBUSRCONDb>();

            foreach (var item in list)
            {
                UHSWEBUSRCONDb set1 = new UHSWEBUSRCONDb();
                set1.divid    = item.distid;
                set1.division = item.district;
                distA360.Add(set1);
            }
            return(PartialView("_getdistA360", distA360.ToList()));
        }
Exemple #2
0
        public ActionResult userstruct1(int projectID, int taskOrderID, int Int1)
        {
            //System.Diagnostics.Debug.WriteLine(item2);
            string CurrentLoginID = User.Identity.GetUserId().ToString();

            var userIDselectVar = from s in db.agentsDbs where s.userID == CurrentLoginID select s.ID;
            int userIDselectInt = userIDselectVar.Single();

            List <int> returnProjectIDlist = db.agentsTaskOrdersDbs.Where(s => s.agentID == userIDselectInt)
                                             .Select(s => s.projectID)
                                             .ToList();

            List <int> returnTaskOrdersIDlist = db.agentsTaskOrdersDbs.Where(s => s.agentID == userIDselectInt)
                                                .Select(s => s.taskOrderID)
                                                .ToList();

            var userTypeSelect = from s in db.agentsDbs where s.userID == CurrentLoginID select s.userType;
            int userTypeInt    = userTypeSelect.First();

            if (userTypeInt == 2 && CurrentLoginID == User.Identity.GetUserId().ToString() && returnProjectIDlist.Contains(6) && returnTaskOrdersIDlist.Contains(63))
            {
                var list = opb.UHSWEBUSRCONDbs.Where(s => s.A360CSTNM != null && s.distid != 0).Select(s => new { regid = s.regid, region = s.region }).Distinct();
                List <UHSWEBUSRCONDb> dataA360 = new List <UHSWEBUSRCONDb>();
                foreach (var item in list)
                {
                    UHSWEBUSRCONDb set1 = new UHSWEBUSRCONDb();
                    set1.regid  = item.regid;
                    set1.region = item.region;
                    dataA360.Add(set1);
                }
                ViewBag.dataA360 = dataA360;

                return(View());
            }
            else
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
        }