public JsonResult Orders(int electionId, int partyId, int regionId) { m_internetDc = new EOSInternetDataContext(Globals.InternetConnectionString); string result = ""; ESSMerkezDataContext merkezDc = new ESSMerkezDataContext(Globals.MerkezConnectionString); if (partyId != 0 && electionId != 0 && regionId != 0) { if (m_internetDc.Parties.Any(p => p.PartyId == partyId) && merkezDc.Elections.Any(e => e.ElectionId == electionId) && merkezDc.Regions.Any(r => r.RegionId == regionId) ) { int count = merkezDc.Regions.First(r => r.RegionId == regionId).CandidateCount.Value; var candidates = m_internetDc.Candidates.Where(c => c.PartyId == partyId && c.RegionId == regionId && c.ElectionId == electionId).ToList(); List <int> exist = new List <int>(); List <int> usable = new List <int>(); foreach (var candidate in candidates) { exist.Add(candidate.OrderNo.Value); } for (int i = 1; i <= count; i++) { if (!exist.Contains(i)) { usable.Add(i); result += "<option value='" + i + "'>" + i + " . Sıra</option>\n"; } } return(Json(result, JsonRequestBehavior.AllowGet)); } } return(Json(result, JsonRequestBehavior.AllowGet)); }