public static ConstituencyViewModel ConstituencyToConstituencyViewModel(Constituency constituency) { var latestMember = constituency.ConstituencyMembers.Count > 0 ? constituency.ConstituencyMembers.Last().Member : null; var latestParty = latestMember != null?latestMember.Parties.Last().Party : null; return(new ConstituencyViewModel { Id = constituency.Id, Name = constituency.Name, ConstituencyTypeId = constituency.ConstituencyTypeId, ConstituencyTypeName = (constituency.ConstituencyTypeId.HasValue) ? constituency.ConstituencyType.Name : "Other", OldDodsId = constituency.OldDodsId, OldDisId = constituency.OldDisId, ClerksConstituencyId = constituency.ClerksConstituencyId, GisId = constituency.GisId, PcaCode = constituency.PcaCode, PconName = constituency.PconName, OsName = constituency.OsName, StartDate = constituency.StartDate, EndDate = constituency.EndDate, OnsCode = constituency.OnsCode, SchoolSubsidyBand = constituency.SchoolsSubsidyBand, Areas = String.Join(", ", constituency.ConstituencyAreas .OrderByDescending(ca => ca.Area.AreaTypeId) .Select(ca => ca.Area.Name)), CurrentMemberId = latestMember != null ? latestMember.Id : -1, CurrentMemberName = latestMember != null ? latestMember.Forename + " " + latestMember.Surname : string.Empty, CurrentPartyId = latestParty != null ? latestParty.Id : -1, CurrentPartyName = latestParty != null ? latestParty.Name : string.Empty }); }
public async Task <Constituency> Add(Constituency constituency) { _context.Set <Constituency>().Add(constituency); await _context.SaveChangesAsync(); return(constituency); }
public IHttpActionResult PutConstituency(int id, Constituency constituency) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != constituency.Id) { return(BadRequest()); } db.Entry(constituency).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!ConstituencyExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public async Task <IActionResult> PutConstituency(long id, Constituency constituency) { if (id != constituency.ConstituencyId) { return(BadRequest()); } _context.Entry(constituency).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ConstituencyExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public Constituency AddConstituency(ConstituencyRequest constituencyRequest, int adminId) { try { var constituencyData = this.dBContext.constituencies.FirstOrDefault(linq => linq.ConstituencyName == constituencyRequest.ConstituencyName); if (constituencyData == null) { Constituency constituency = new Constituency() { ConstituencyName = constituencyRequest.ConstituencyName, City = constituencyRequest.City, State = constituencyRequest.State, Created = DateTime.Now, Modified = DateTime.Now, IsDeleted = false, AdminId = adminId }; this.dBContext.constituencies.Add(constituency); this.dBContext.SaveChanges(); return(constituency); } return(null); } catch (Exception e) { throw new Exception(e.Message); } }
public bool DeleteMantri(int mantriId) { try { Mantri mantri = _context.Mantri.Find(mantriId); List <Workdone> workdone = _context.Workdone.Where(p => p.MantriId == mantri.MantriId).ToList(); Constituency constituency = _context.Constituency.Where(p => p.ConstituencyName == mantri.Constituency).FirstOrDefault(); constituency.Status = "not registered"; List <Complaint> complaints = _context.Complaint.Where(p => p.Constituency == mantri.Constituency).ToList(); List <Feedback> feedbacks = new List <Feedback>(); foreach (var item in complaints) { Feedback feedbackitem = _context.Feedback.Where(p => p.ComplaintId == item.ComplaintId).FirstOrDefault(); feedbacks.Add(feedbackitem); } UserCredentials userCredentials = _context.UserCredentials.Find(mantriId); _context.Feedback.RemoveRange(feedbacks); _context.Complaint.RemoveRange(complaints); _context.Workdone.RemoveRange(workdone); _context.Mantri.Remove(mantri); _context.UserCredentials.Remove(userCredentials); _context.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public static void InsertWard() { using (SchoolContext dbcontext = new SchoolContext()) { string path = HttpContext.Current.Server.MapPath(@"~/Models/Initialisation/Wards.txt"); string[] Wards = File.ReadAllLines(path); foreach (string WardLine in Wards) { string wardName = WardLine.Split('=')[0]; string constituencyName = WardLine.Split('=')[1]; var ConstituencyId = dbcontext.Constituency.Where(n => n.Name == constituencyName).Select(c => c.Id).FirstOrDefault(); Constituency Constituency = dbcontext.Constituency.Find(ConstituencyId); Ward Ward = new Ward() { Name = wardName, Constituency = Constituency }; dbcontext.Ward.Add(Ward); } dbcontext.SaveChanges(); } }
public Constituency UpdateConstituency(int constituencyId, ConstituencyDataRequest constituencyDataRequest, int adminId) { Constituency constituency = this.dBContext.constituencies.FirstOrDefault(linq => linq.ConstituencyId == constituencyId && linq.IsDeleted == false); if (constituency != null) { constituency.AdminId = constituency.AdminId; constituency.City = constituencyDataRequest.City; constituency.ConstituencyName = constituencyDataRequest.ConstituencyName; constituency.State = constituencyDataRequest.State; constituency.Modified = DateTime.Now; var constituencyData = this.dBContext.constituencies.Attach(constituency); constituencyData.State = Microsoft.EntityFrameworkCore.EntityState.Modified; this.dBContext.SaveChanges(); if (constituencyData.State != 0) { var data = new AdminConstituency { ConstituencyId = constituencyId, AdminId = adminId }; this.dBContext.adminConstituencies.Add(data); this.dBContext.SaveChanges(); constituency.AdminResponses = Adminresponse(constituencyId); } return(constituency); } return(null); }
public ActionResult Edit(Constituency constituency) { if (ModelState.IsValid) { db.Entry(constituency).State = EntityState.Modified; db.SaveChanges(); Utils.ShowUserMessage("Confirmation", "Your record has been edited successfully."); return(RedirectToAction("Index")); } Constituency constituencyToLoad = db.Constituency.Find(constituency.Id); ConstituencyViewModel model = new ConstituencyViewModel() { Constituency = constituencyToLoad, Constituencies = db.Constituency.OrderBy(n => n.Name).ToList(), Counties = db.County.OrderBy(n => n.CountyName).ToList() }; if (constituency == null) { return(HttpNotFound()); } Utils.ShowUserMessage("warning", "An error occured while saving your record. Report this to the system administrator."); return(View(model)); }
public async Task <ActionResult <Constituency> > PostConstituency(Constituency constituency) { _context.Constituencies.Add(constituency); await _context.SaveChangesAsync(); return(CreatedAtAction("GetConstituency", new { id = constituency.ConstituencyId }, constituency)); }
public static void InsertConstituency() { using (SchoolContext dbcontext = new SchoolContext()) { string path = HttpContext.Current.Server.MapPath(@"~/Models/Initialisation/Constituencies.txt"); string[] Constituencies = File.ReadAllLines(path); foreach (string ConstituencyLine in Constituencies) { string constituencyName = ConstituencyLine.Split('=')[0]; string countyName = ConstituencyLine.Split('=')[1]; var CountyId = dbcontext.County.Where(n => n.CountyName == countyName).Select(f => f.Id).FirstOrDefault(); County County = dbcontext.County.Find(CountyId); Constituency Constituency = new Constituency() { Name = constituencyName, County = County }; dbcontext.Constituency.Add(Constituency); } dbcontext.SaveChanges(); } }
public async Task <Constituency> Update(Constituency constituency) { _context.Entry(constituency).State = EntityState.Modified; _context.Set <Constituency>().Update(constituency); await _context.SaveChangesAsync(); return(constituency); }
public ActionResult DeleteConfirmed(int id) { Constituency constituency = db.Constituency.Find(id); db.Constituency.Remove(constituency); db.SaveChanges(); return(RedirectToAction("Index")); }
// GET: Pollings public ActionResult Index(String Polling) { Constituency constituency = db.Constituencies.Where(o => o.ConstituencyName.Equals(Polling)).FirstOrDefault(); ViewBag.Constituency = constituency.ConstituencyName; var vm = PollingTable(Polling); return(View(vm)); }
public async Task <ActionResult> DeleteConfirmed(int id) { Constituency constituency = await db.Constituencys.FindAsync(id); db.Constituencys.Remove(constituency); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
public async Task <ActionResult> Edit([Bind(Include = "ConstituencyID,Name,Abbreviation,Geom")] Constituency constituency) { if (ModelState.IsValid) { db.Entry(constituency).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(constituency)); }
public void Constituency_withValid_validations_shouldPass() { //arrange var u = new Fixture(); Constituency constituency = u.Create <Constituency>(); //act ValidationResultInfo r = constituency.Validate(); //assert Assert.That(r.IsValid, Is.True, "Validation should pass"); }
public IHttpActionResult PostConstituency(Constituency constituency) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } _constituencyRepository.Create(constituency); _constituencyRepository.Save(); return(CreatedAtRoute("DefaultApi", new { id = constituency.Id }, constituency)); }
private static CandidateDTO CandidateToDto(Candidate candidate, Constituency constituency) => new CandidateDTO { CandidateId = candidate.CandidateId, ConstituencyId = candidate.ConstituencyId, FirstName = candidate.FirstName, LastName = candidate.LastName, Affiliation = candidate.Affiliation, Photo = candidate.Photo, Parish = constituency.Parish, ConstituencyName = constituency.Name };
public async Task <ActionResult> Create([Bind(Include = "ConstituencyID,Name,Abbreviation,Geom")] Constituency constituency) { if (ModelState.IsValid) { db.Constituencys.Add(constituency); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(constituency)); }
public ActionResult Create(Constituency constituency) { if (ModelState.IsValid) { db.Constituency.Add(constituency); db.SaveChanges(); Utils.ShowUserMessage("Confirmation", "Record has been saved successfully."); return(RedirectToAction("Index")); } ViewBag.CountyId = new SelectList(db.County, "Id", "CountyName", constituency.CountyId); return(View(constituency)); }
// GET: Constituencies/Details/5 public async Task <ActionResult> Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Constituency constituency = await db.Constituencys.FindAsync(id); if (constituency == null) { return(HttpNotFound()); } return(View(constituency)); }
// GET: Constituencies/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Constituency constituency = db.Constituency.Find(id); if (constituency == null) { return(HttpNotFound()); } return(View(constituency)); }
public IActionResult Index(string postcode) { ConstituencyQuery query = new ConstituencyQuery(); ConstituencyResult constituencyResult = query.GetConstitutencyByPostCode(postcode); Constituency constituency = this.constituencyRepository.FindByName(constituencyResult.Name); ConstituencyViewModel vm = new ConstituencyViewModel() { Constituency = constituency, ConstituencyResult = constituencyResult, }; return(View(vm)); }
protected Constituency CreateConstituency(CountyRef county) { var constituencyEntity = new Constituency(Guid.NewGuid()) { Name = "default".RandStr(), County = county, TotalRegisteredVoters = 40000, PopulationOver18 = 80000, Area = 54786, NumberOfWards = 100, NumberOfPollingStations = 200, Status = EntityStatus.Active }; return(constituencyEntity); }
// GET: Constituencies/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Constituency constituency = db.Constituency.Find(id); ConstituencyViewModel model = new ConstituencyViewModel() { Constituency = constituency, Constituencies = db.Constituency.OrderBy(n => n.Name).ToList(), Counties = db.County.OrderBy(n => n.CountyName).ToList() }; if (constituency == null) { return(HttpNotFound()); } return(View(model)); }
public Constituency GetConstituency(int idnt) { Constituency constitiency = new Constituency(idnt); SqlServerConnection conn = new SqlServerConnection(); SqlDataReader dr = conn.SqlServerConnect("SELECT cn_code, cn_name, cn_geojson, cn_center, cn_zoom, ct_idnt, ct_name FROM Constituency INNER JOIN County ON cn_county=ct_idnt WHERE cn_idnt=" + idnt); if (dr.Read()) { constitiency.Code = Convert.ToInt16(dr[0]); constitiency.Name = dr[1].ToString(); constitiency.Json = dr[2].ToString(); constitiency.Center = dr[3].ToString(); constitiency.Zoom = Convert.ToDouble(dr[4]); constitiency.County.Id = Convert.ToInt16(dr[5]); constitiency.County.Name = dr[6].ToString(); } return(constitiency); }
public JObject GetMarkers(Constituency Constituency) { string markers = "{}"; SqlServerConnection conn = new SqlServerConnection(); SqlDataReader dr = conn.SqlServerConnect("SELECT wd_center, wd_idnt, wd_name FROM Wards WHERE wd_constituency=" + Constituency.Id); if (dr.HasRows) { markers = "{type: 'FeatureCollection',features:["; while (dr.Read()) { markers += "{type:'Feature',geometry:{type:'Point',coordinates:" + dr[0].ToString() + "},properties:{id:" + Convert.ToInt16(dr[1]) + ",title: 'Ward',description:'" + dr[2].ToString() + "'}},"; } markers += "]}"; } return(JObject.Parse(markers)); }
public void GenerateVotersForConstituency(Constituency constituency, int numberOfVoters) { if (votersGenerated) { throw new InvalidOperationException("Voters already generated for this Voter Manager"); } votersGenerated = true; location = constituency.Name; this.constituency = constituency; GenerateBlankVotersInRegion(constituency.Region, numberOfVoters); ApplyGender(LoadNationalGenderMalePercentage()); ApplyAgeGroups(constituency.Ages); ApplySocialGroups(constituency.SocialGrades[SocialGrade.ABC1]); ApplyEURef(constituency.ReferendumResults[ReferendumResult.Leave]); ApplyPreviousVote(constituency.PreviousVote); }
public int ValidateMantri(string mantriId, string constituency) { int status = -1; try { Constituency _constituency = _context.Constituency.Find(constituency); if (_constituency.MantriUid == mantriId) { if (_constituency.Status == "registered") { return(2); } _constituency.Status = "registered"; _context.SaveChanges(); status = 1; } } catch (Exception ex) { status = -1; } return(status); }