//Create List to store your CSV data public List<Models.Holidayhome> parseHolidayhomes() { CsvReader csv = new CsvReader(reader, true); int fieldCount = csv.FieldCount; List<Holidayhome> holidaylist = new List<Holidayhome>(); String[] headers = csv.GetFieldHeaders(); while (csv.ReadNextRecord()) { Holidayhome exObj = new Holidayhome(); for (int i = 0; i < fieldCount; i++) { if (headers[i].Equals("holidayhomeno")) {exObj.holidayhomeno = csv[i];} else if (headers[i].Equals("address1")) { exObj.address1 = csv[i]; } else if (headers[i].Equals("address2")) { exObj.address2 = csv[i]; } else if (headers[i].Equals("country")) { exObj.country = csv[i]; } else if (headers[i].Equals("email")) { exObj.email = csv[i]; } else if (headers[i].Equals("contactno")){ exObj.contactno = csv[i];} else if (headers[i].Equals("amenities")){ exObj.amenities = csv[i];} else if (headers[i].Equals("price")) { exObj.price = csv[i]; } } holidaylist.Add(exObj); } return holidaylist; }
public bool updateHolidayhomeDb(Holidayhome hse) { db.Entry(hse).State = EntityState.Modified; db.SaveChanges(); return true; }
//Create List to store your CSV data List<Models.Holidayhome> IDataParser.parseHolidayhomes() { CsvReader csv = new CsvReader(reader, true); int fieldCount = csv.FieldCount; List<Holidayhome> holidayhomes = new List<Holidayhome>(); String[] headers = csv.GetFieldHeaders(); Holidayhome exObj = new Holidayhome(); while (csv.ReadNextRecord()) { for (int i = 0; i < fieldCount; i++) { if (headers[i].Equals("location")) {exObj.location = csv[i];} else if (headers[i].Equals("address1")) { exObj.address1 = csv[i]; } else if (headers[i].Equals("address2")) { exObj.address2 = csv[i]; } else if (headers[i].Equals("country")) { exObj.country = csv[i]; } else if (headers[i].Equals("email")) { exObj.email = csv[i]; } else if (headers[i].Equals("contactno")){ exObj.contactno = csv[i];} else if (headers[i].Equals("amenities")){ exObj.amenities = csv[i];} } holidayhomes.Add(exObj); } return holidayhomes; }
public ActionResult Edit(Holidayhome holidayhome) { if (ModelState.IsValid) { db.Entry(holidayhome).State = EntityState.Modified; db.SaveChanges(); return RedirectToAction("Index"); } return View(holidayhome); }
public ActionResult Create(Holidayhome holidayhome) { if (ModelState.IsValid) { db.Holidayhomes.Add(holidayhome); db.SaveChanges(); return RedirectToAction("Index"); } return View(holidayhome); }
public bool addHolidayhomeDb(Holidayhome hse) { Holidayhome home = new Holidayhome(); home = db.Holidayhomes.Add(hse); if (home is Holidayhome) { db.SaveChanges(); return true; } return false; }
public bool updateHolidayhomeDb(Holidayhome hse) { db.Entry(hse).State = EntityState.Modified; try { db.SaveChanges(); return true; } catch (Exception exp) { // do something return false; } }
public ActionResult Create(Holidayhome Holidayhome) { try { if (ModelState.IsValid) { HolidayhomeRepository.InsertHolidayhome(Holidayhome); HolidayhomeRepository.Save(); return RedirectToAction("Index"); } } catch (DataException) { //Log the error (add a variable name after DataException) ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists see your system administrator."); } return View(Holidayhome); }
public bool addHolidayhomeDb(Holidayhome hse) { Holidayhome home = new Holidayhome(); try { home = db.Holidayhomes.Add(hse); } catch (Exception exp) { Exception j = exp; return false; //do something } if (home is Holidayhome) { db.SaveChanges(); return true; } return false; }
public void parseHolidayhomesTest1() { StreamReader reader = new StreamReader("d:\\nci\\holidayhomes.csv"); CSVParser target = new CSVParser(); target.setStreamSource(reader); Holidayhome hse = new Holidayhome(); hse.holidayhomeno="Spain"; hse.address1="San Costa"; hse.address2="Valencia"; hse.country = "Spain"; hse.email="*****@*****.**"; hse.contactno="+353 18767352"; hse.amenities="Swimming Pool| Gym | Sauna"; hse.price="445"; List<Holidayhome> expected = new List<Holidayhome>(); expected.Add(hse); List<Holidayhome> actual = target.parseHolidayhomes(); Assert.AreEqual(expected[0].address1, actual[0].address1); Assert.AreEqual(expected[0].country, actual[0].country); Assert.AreEqual(expected[0].contactno, actual[0].contactno); }
public void UpdateHolidayhome(Holidayhome Holidayhome) { context.Entry(Holidayhome).State = EntityState.Modified; }
public void InsertHolidayhome(Holidayhome Holidayhome) { context.Holidayhomes.Add(Holidayhome); }