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