public void CreateNewContribution(Contributions ContributionToCreate)
{
if (ExceptionToThrow != null)
throw ExceptionToThrow;
_db.Add(ContributionToCreate);
// return ContributionToCreate;
}
public ActionResult Create(Contributions contributions)
{
if (ModelState.IsValid)
{
db.ElectionContributions.Add(contributions);
db.SaveChanges();
return RedirectToAction("Index");
}
return View(contributions);
}
//public List<Contribution> Items { get; set; }
public void SaveChanges(Contributions ContributionToUpdate)
{
foreach (Contributions Contribution in _db)
{
if (Contribution.id == ContributionToUpdate.id)
{
_db.Remove(Contribution);
_db.Add(ContributionToUpdate);
break;
}
}
}
public void parsecsvTest()
{
StreamReader reader = new StreamReader("C:\\Users\\DB\\Documents\\GitHub\\EF-Group-Project\\datasets\\test_files\\testContributions.csv", true);
AllDataParser target = new DataParse();
target.setStreamSource(reader);
Contributions r = new Contributions();
r.ElectionType = "Council";
r.ElectionYear = 2006;
r.ContributorLastName = "Aloi";
r.ContributorFirstName = "77";
r.ContributorAddress = "asdhfbkaef";
r.ContributorPostCode = "efeae";
r.WardNum = 3;
r.Amount = 200;
r.ContributionTypeDesc = "Cash";
r.ContributorTypeDesc = "individ";
r.CandidateFirstName = "joe";
r.CandidateLastName = "walsh";
List<Contributions> expected = new List<Contributions>();
expected.Add(r);
expected.Add(r);
expected.Add(r);
expected.Add(r);
List<Contributions> actual;
actual = target.parseContributions();
Assert.AreEqual(expected.Count, actual.Count);
Contributions ElectionType = actual.Find(item => item.ElectionType == "Council");
Assert.IsNotNull(ElectionType);
// As an exercise for the reader, make sure that the rate object is correctly populated
}
public void CreateNewContribution(Contributions ContributionsToCreate)
{
db.ElectionContributions.Add(ContributionsToCreate);
db.SaveChanges();
// return ContributionToCreate;
}
public ActionResult Edit(Contributions contributions)
{
if (ModelState.IsValid)
{
db.Entry(contributions).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
return View(contributions);
}
// bring in contributions data
List<Contributions> AllDataParser.parseContributions()
{
List<Contributions> lst = new List<Contributions>();
CsvReader csv = new CsvReader(reader, true);
int fieldCount = csv.FieldCount;
String[] headers = csv.GetFieldHeaders();
while (csv.ReadNextRecord())
{
Contributions exObj = new Contributions();
for (int i = 0; i < fieldCount; i++)
{
if (headers[i].Equals("id"))
{
}
else if (headers[i].Equals("ELECTIONTYPE"))
{
exObj.ElectionType = csv[i];
}
else if (headers[i].Equals("ELECTIONYEAR"))
{
exObj.ElectionYear = Convert.ToInt32(csv[i]);
}
else if (headers[i].Equals("CONTRIBUTORLASTNAME"))
{
exObj.ContributorLastName = csv[i];
}
else if (headers[i].Equals("CONTRIBUTORFIRSTNAME"))
{
exObj.ContributorFirstName = csv[i];
}
else if (headers[i].Equals("CONTRIBUTORADDRESS"))
{
exObj.ContributorAddress = csv[i];
}
else if (headers[i].Equals("CONTRIBUTORPOSTCODE"))
{
exObj.ContributorPostCode = csv[i];
}
else if (headers[i].Equals("WARDNUM"))
{
exObj.WardNum = Convert.ToInt32(csv[i]);
}
else if (headers[i].Equals("AMOUNT"))
{
exObj.Amount = Convert.ToSingle(csv[i]);
}
else if (headers[i].Equals("CONTRIBUTIONTYPEDESC"))
{
exObj.ContributionTypeDesc = csv[i];
}
else if (headers[i].Equals("CONTRIBUTORTYPEDESC"))
{
exObj.ContributorTypeDesc = csv[i];
}
else if (headers[i].Equals("CANDIDATEFIRSTNAME"))
{
exObj.CandidateFirstName = csv[i];
}
else if (headers[i].Equals("CANDIDATELASTNAME"))
{
exObj.CandidateLastName = csv[i];
}
}
lst.Add(exObj);
}
return lst;
}
public void Add(Contributions ContributionToAdd)
{
_db.Add(ContributionToAdd);
}
