Ejemplo n.º 1
0
        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));
        }