public void parseMuseumsTest() { //** Actual Museum Object **// string fnameMuseums = "C:\\Louise\\Semester3\\EnterpriseFrameworks\\GroupProj\\MupadoodleAPI-Complete\\Museums_ParserTest.csv"; StreamReader myReader = new StreamReader(fnameMuseums); CSVParser target = new CSVParser(); target.setStreamSource(myReader); //**Test Museum Oject **// string cityStr = "New York"; double lat = 40.7, lng = -74.01; string theName = "Alexander Hamilton U.S. Custom House", theUrl = "http://www.oldnycustomhouse.gov/", add1 = "1 Bowling Grn", add2 = null, theZip = "10004", phone = " 514-3700"; Museum mTest = new Museum(lat, lng, theName, phone, theUrl, add1, add2, theZip, cityStr); //** Expected **// List<Museum> expected = new List<Museum>(); expected.Add(mTest); //** Actual **// List<Museum> actual; actual = target.parseMuseums(); //** First Test **// Assert.AreEqual(expected.Count, actual.Count); //** Second Test **// Museum museumCity = actual.Find(item => item.cityStr == "New York"); Assert.IsNotNull(museumCity); //** Third Test - Test parseShape **// Museum museumLat = actual.Find(item => item.latitude == 40.7); Assert.IsNotNull(museumLat); }
// POST api/Admin public HttpResponseMessage PostMuseum(Museum museum) { if (ModelState.IsValid) { db.museums.Add(museum); db.SaveChanges(); HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, museum); response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = museum.LocationID })); return response; } else { return Request.CreateResponse(HttpStatusCode.BadRequest); } }
public void addMuseumToDbTest() { MuseumDAL target = new MuseumDAL(); double lat = 40.7669569450; double lng = -73.937655144; string theName = "Test Museum",theUrl = "www.testmuseum.com", add1 = "Bronx", add2 = null, theZip = "008", phone = "007007"; string cityStr = "New York"; Museum mTest = new Museum(lat, lng, theName, phone, theUrl, add1, add2, theZip, cityStr); bool expected = true; bool actual; actual = target.addMuseumToDb(mTest); // ** Check it was added **/ Assert.AreEqual(expected, actual); }
// PUT api/Admin/5 public HttpResponseMessage PutMuseum(int id, Museum museum) { if (ModelState.IsValid && id == museum.LocationID) { db.Entry(museum).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { return Request.CreateResponse(HttpStatusCode.NotFound); } return Request.CreateResponse(HttpStatusCode.OK, museum); } else { return Request.CreateResponse(HttpStatusCode.BadRequest); } }
public bool addMuseumToDb(Museum m) { Museum inm = new Museum(); try { inm = db.museums.Add(m); } catch (Exception e) { Exception j = e; return false; //do something } if (inm is Museum) { db.SaveChanges(); return true; } return false; }
public List<Models.Museum> parseMuseums() { CsvReader csv = new CsvReader(reader, true); int fieldCount = csv.FieldCount; List<Museum> exList = new List<Museum>(); Museum exObj = null; String[] headers = csv.GetFieldHeaders(); while (csv.ReadNextRecord()) { string cityStr = null; double lat = 0, lng = 0; string theName = null, theUrl = null, add1 = null, add2 = null, theZip = null, phone = null; for (int i = 0; i < fieldCount; i++) { // this is where you actually create your dB object if (headers[i].Equals("Shape")) { parseShape(csv[i], ref lat, ref lng); } else if (headers[i].Equals("NAME")) { theName = csv[i]; } else if (headers[i].Equals("TEL")) { phone = csv[i]; } else if (headers[i].Equals("URL")) { theUrl = csv[i]; } else if (headers[i].Equals("ADRESS1")) // intentionally misspelt { add1 = csv[i]; } else if (headers[i].Equals("ADDRESS2")) { add2 = csv[i]; } else if (headers[i].Equals("ZIP")) { theZip = csv[i]; } else if (headers[i].Equals("CITY")) { cityStr = csv[i]; } } exObj = new Museum(lat, lng, theName, phone, theUrl, add1, add2, theZip, cityStr); exList.Add(exObj); } return exList; //throw new NotImplementedException(); }
public bool updateMuseumInDb(Museum m) { db.Entry(m).State = EntityState.Modified; try { db.SaveChanges(); return true; } catch (Exception e) { // do something return false; } }