static void Main(string[] args) { // Get the connection string from the appsettings.json file IConfigurationBuilder builder = new ConfigurationBuilder() .SetBasePath(Directory.GetCurrentDirectory()) .AddJsonFile("appsettings.json", optional: true, reloadOnChange: true); IConfigurationRoot configuration = builder.Build(); string connectionString = configuration.GetConnectionString("npcampground"); /******************************************************************** * // If you do not want to use CLIMenu, you can remove the following *********************************************************************/ // Create any DAOs needed here, and then pass them into main menu... ICampgroundDAO campgroundDAO = new CampgroundDAO(connectionString); ICampsiteDAO campsiteDAO = new CampsiteDAO(connectionString); IParkDAO parkDAO = new ParkDAO(connectionString); IReservationDAO reservationDAO = new ReservationDAO(connectionString); MainMenu mainMenu = new MainMenu(campgroundDAO, campsiteDAO, parkDAO, reservationDAO); // You'll probably be adding daos to the constructor // Run the menu. mainMenu.Run(); }
public void GetAvailableSitesOnCampgroundTest() { string Camp = "Camp Blue"; DateTime StartDate = new DateTime(2020, 1, 2); DateTime EndDate = new DateTime(2020, 1, 3); CampsiteDAO campsiteDAO = new CampsiteDAO(connectionString); IList <Site> sites = campsiteDAO.GetAvailableSitesOnCampground(Camp, StartDate, EndDate); Assert.AreEqual(1, sites.Count); }
public void makeReservationTest() { string Camp = "Camp Blue"; DateTime StartDate = new DateTime(2020, 1, 2); DateTime EndDate = new DateTime(2020, 1, 3); CampsiteDAO campsiteDAO = new CampsiteDAO(connectionString); IList <Site> sites = campsiteDAO.GetAvailableSitesOnCampground(Camp, StartDate, EndDate); ReservationDAO reservationDAO = new ReservationDAO(connectionString); int confirmationNo = reservationDAO.makeReservation(sites[0], "John Brown", StartDate, EndDate); Assert.IsTrue(confirmationNo > newreservation_id); }
public void GetPriceOfStayTest() { CampsiteDAO campsiteDAO = new CampsiteDAO(connectionString); string Camp = "Camp Red"; DateTime StartDate = new DateTime(2020, 3, 2); DateTime EndDate = new DateTime(2020, 3, 4); IList <Site> sites = campsiteDAO.GetAvailableSitesOnCampground(Camp, StartDate, EndDate); Site s = sites[0]; decimal price = campsiteDAO.GetPriceOfStay(s, StartDate, EndDate); Assert.AreEqual(price, 200M); }
//POST : api/Campsite public void Post([FromBody] JObject value) { int numero = (int)value.GetValue("campsite_numero"); string zone = value.GetValue("campsite_zone").ToString(); string category = value.GetValue("campsite_category").ToString(); int nbPers = (int)value.GetValue("campsite_nbPersonne"); Decimal prize = (Decimal)value.GetValue("campsite_prize"); bool isReserved = (bool)value.GetValue("campsite_isReserved"); bool isUnavailable = (bool)value.GetValue("campsite_isUnavailable"); CampsiteDAO.add(new Campsite(numero, zone, category, nbPers, prize, isReserved, isUnavailable)); }
//PUT : api/Campsite/5 public void Put(int id, [FromBody] JObject value) { int numero = (int)value.GetValue("Numero"); string zone = value.GetValue("Zone").ToString(); string category = value.GetValue("Category").ToString(); int nbPers = (int)value.GetValue("NbPersonne"); Decimal prize = (Decimal)value.GetValue("Prize"); bool isReserved = (bool)value.GetValue("IsReserved"); bool isUnavailable = (bool)value.GetValue("IsUnavailable"); CampsiteDAO.update(id, new Campsite(numero, zone, category, nbPers, prize, isReserved, isUnavailable)); }
public void GetTop5CampsitesTest() { CampsiteDAO campsiteDAO = new CampsiteDAO(connectionString); string Camp = "Camp Red"; DateTime StartDate = new DateTime(2020, 3, 2); DateTime EndDate = new DateTime(2020, 3, 3); IList <Site> sites = campsiteDAO.GetAvailableSitesOnCampground(Camp, StartDate, EndDate); List <string> top5 = campsiteDAO.GetTop5Campsites(sites, StartDate, EndDate); //string s = "Site number: " + "2" + " MaxOccupancy: " + "6" + " Is Accessible: " + "Yes" + " Max RV: " + "25" + " Utilities: " + "Yes" + " Total Price: " + "$100.00"; string siteNumber = "2"; string maxOccupancy = "6"; string isAccessible = "Yes"; string maxRV = "25"; string utilities = "Yes"; string totalPrice = "$100.00"; string s = $"{siteNumber,-15}{maxOccupancy,-15}{isAccessible,-15}{maxRV,-15}{utilities,-15}{totalPrice,-15}"; Assert.AreEqual(s, top5[0]); }
//DELETE : api/Campsite/5 public void Delete(int id) { CampsiteDAO.delete(id); }
//GET : api/Campsite/5 public Campsite Get(int id) { return(CampsiteDAO.get(id)); }
//GET: api/Campsite public IEnumerable <Campsite> Get() { return(CampsiteDAO.getAll()); }