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())); }
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)); } }