protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Account re = (Account)Session["account"]; this.drRegion.DataSource = RegionDAO.getAllRegion(); this.drRegion.DataTextField = "name"; Area r = re.Areax; this.drRegion.DataValueField = "id"; this.drRegion.SelectedValue = r.ID.ToString(); this.drRegion.DataBind(); this.drSite.DataSource = SiteDAO.getAllSite(); this.drSite.DataTextField = "name"; this.drSite.DataValueField = "id"; Model.Theart th = re.Thearts; this.drSite.SelectedValue = th.ID.ToString(); this.drSite.DataBind(); this.txtName.Text = re.Name; this.txtPhone.Text = re.Phone; this.txtEmail.Text = re.Gmail; this.txtUsername.Text = re.UserName; this.txtPass.Text = re.PassWord; this.txtNgaySinh.Text = re.DOB.ToString(); if (re.Gender) { this.rdMale.Checked = true; } else { this.rdFemale.Checked = true; } } }
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("Project"); /******************************************************************** * // 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... IParkDAO parkDAO = new ParkDAO(connectionString); ICampgroundDAO campgroundDAO = new CampgroundDAO(connectionString); IReservationDAO reservationDAO = new ReservationDAO(connectionString); ISiteDAO siteDAO = new SiteDAO(connectionString); MainMenu mainMenu = new MainMenu(parkDAO, campgroundDAO, reservationDAO, siteDAO); // You'll probably be adding daos to the constructor // Run the menu. mainMenu.Run(); }
public void GetSitesTests() { SiteDAO dao = new SiteDAO(connectionString); //arrange IList <Site> sites = dao.GetSites(); //act Assert.AreEqual(4, sites.Count); //assert }
public void SearchReservationTest_StartsBeforeEndsAfter_ReturnsNone() { //Arrange var arriveDate = new DateTime(2020, 02, 20); var departDate = new DateTime(2020, 02, 25); SiteDAO dao = new SiteDAO(ConnectionString); //Act IList <Site> sites = dao.SearchReservation(CampGroundId, arriveDate, departDate); //Assert Assert.AreEqual(0, sites.Count); }
public void SearchReservationTest_DatesAlreadyUsed_ReturnsNone() { //Arrange var arriveDate = new DateTime(2015, 02, 21); var departDate = new DateTime(2015, 02, 24); SiteDAO dao = new SiteDAO(ConnectionString); //Act IList <Site> sites = dao.SearchReservation(CampGroundId, arriveDate, departDate); //Assert Assert.AreEqual(0, sites.Count); }
public void SearchReservationTest_ReturnsListOfSites() { //Arrange var arriveDate = new DateTime(2020, 08, 20); var departDate = new DateTime(2020, 08, 24); SiteDAO dao = new SiteDAO(ConnectionString); //Act IList <Site> sites = dao.SearchReservation(CampGroundId, arriveDate, departDate); //Assert Assert.AreEqual(1, sites.Count); }
public void HasAvailableSitesTests() { SiteDAO dao = new SiteDAO(connectionString); //arrange //Site is available bool isAvailable = dao.HasAvailableSites(newCampgroundId, Convert.ToDateTime("2021/01/01"), Convert.ToDateTime("2021/05/01")); //act Assert.IsTrue(isAvailable); //No sites available isAvailable = dao.HasAvailableSites(newCampgroundId, DateTime.Now, DateTime.Now); //act Assert.IsTrue(isAvailable); }
public void GetTop5AvailableSitesTests() { SiteDAO dao = new SiteDAO(connectionString); //arrange //Date conflict with 1 of 4 sites IList <Site> sites = dao.GetTop5AvailableSites(newCampgroundId, DateTime.Now, DateTime.Now); //act Assert.AreEqual(3, sites.Count); //assert //Fully available date sites = dao.GetTop5AvailableSites(newCampgroundId, Convert.ToDateTime("2021/01/01"), Convert.ToDateTime("2021/05/01")); //act Assert.AreEqual(4, sites.Count); //assert }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { this.drRegion.DataSource = RegionDAO.getAllRegion(); this.drRegion.DataTextField = "name"; this.drRegion.DataValueField = "id"; this.drRegion.SelectedIndex = 0; this.drRegion.DataBind(); this.drSite.DataSource = SiteDAO.getAllSite(); this.drSite.DataTextField = "name"; this.drSite.DataValueField = "id"; this.drSite.SelectedIndex = 0; this.drSite.DataBind(); } }
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("Project"); IParkDAO parkDAO = new ParkDAO(connectionString); ICampgroundDAO campgroundDAO = new CampgroundDAO(connectionString); ISiteDAO siteDAO = new SiteDAO(connectionString); IReservationDAO reservationDAO = new ReservationDAO(connectionString); MainMenuCLI menu = new MainMenuCLI(parkDAO, campgroundDAO, siteDAO, reservationDAO); menu.Run(); }
private int GetAvailableSites(int campgroundId, string arrivalDate, string departureDate, int park_id, int totalStay) { IList<Site> sites = SiteDAO.ReturnAvailableSites(campgroundId, arrivalDate, departureDate); IList<Campground> campgrounds = CampgroundDAO.GetCampgroundByParkId(park_id); decimal totalCost = 0; foreach (Campground campground in campgrounds) { totalCost = (decimal)(totalStay) * campground.Daily_Fee; } int sitesCount = sites.Count; if (sitesCount == 0) { return sitesCount; } Console.WriteLine(Site.GetHeader()); foreach (Site site in sites) { Console.WriteLine($"{site}{totalCost:C}"); } return sitesCount; }
private void SearchForReservationInterface(Campground selectedCamp) { bool exit = false; while (!exit) { Console.WriteLine("What is the arrival date? "); DateTime arrivalDate = CLIHelper.GetDateTime("Enter in year-month-day format."); Console.WriteLine("What is the departure date?"); DateTime depatureDate = CLIHelper.GetDateTime("Enter in year-month-day format."); SiteDAO dao = new SiteDAO(_connectionString); try { IList <Site> sites = dao.GetTop5Sites(selectedCamp, arrivalDate, depatureDate); if (sites.Count > 0) { Console.Clear(); Console.WriteLine($"Results Matching Your Search Criteria"); Console.WriteLine("Site No.".PadRight(15) + "Max Occup.".PadRight(15) + "Accessible?".PadRight(15) + "Max RV Length".PadRight(15) + "Utility".PadRight(15) + "Cost"); Dictionary <int, Site> siteDict = new Dictionary <int, Site>(); int siteCount = 0; foreach (Site s in sites) { Console.WriteLine($"{++siteCount}) " + $"{s.SiteNumber.ToString().PadRight(15)}" + $"{s.MaxOccupancy.ToString().PadRight(15)}" + $"{s.AccessibleString.PadRight(15)}" + $"{s.MaxRVString.PadRight(15)}" + $"{s.UtilitiesString.PadRight(15)}" + $"{selectedCamp.DailyFee.ToString("C")}"); siteDict.Add(siteCount, s); } Console.WriteLine(); int selection = CLIHelper.GetSingleInteger("Which site should be reserved(enter 0 to cancel) ", 0, sites.Count); Console.WriteLine(); if (selection == 0) { exit = true; } else { //ReservationDAO = new ReservationDAO(_connectionString); string name = CLIHelper.GetString("What name should the reservation be made under? "); MakeReservationInterface(siteDict[selection], name, arrivalDate, depatureDate); exit = true; } } else { Console.Clear(); Console.WriteLine("****** NO RESULTS ******"); Console.WriteLine(""); Console.ReadKey(); exit = true; } } catch { Console.Clear(); Console.WriteLine("Something went wrong with the Dates you entered... try again."); } } }
private void SearchForReservationInterface(Campground selectedCamp) { bool exit = false; SiteDAO dao = new SiteDAO(_connectionString); DateTime arrivalDate; DateTime depatureDate; while (!exit) { try { Console.WriteLine("What is the arrival date? yyyy-mm-dd "); arrivalDate = Convert.ToDateTime(Console.ReadLine()); Console.WriteLine("What is the departure date? yyyy-mm-dd"); depatureDate = Convert.ToDateTime(Console.ReadLine()); if (depatureDate > arrivalDate && (depatureDate - arrivalDate).TotalDays > 0 && arrivalDate > DateTime.Today) { IList <Site> sites = dao.GetTop5Sites(selectedCamp.CampgroundId, arrivalDate, depatureDate); Console.Clear(); Console.WriteLine($"Results Matching Your Search Criteria"); Console.WriteLine("Site No.".PadRight(15) + "Max Occup.".PadRight(15) + "Accessible?".PadRight(15) + "Max RV Length".PadRight(15) + "Utility".PadRight(15) + "Cost"); Dictionary <int, Site> siteDict = new Dictionary <int, Site>(); int siteCount = 0; foreach (Site s in sites) { Console.WriteLine($"{++siteCount}) " + $"{s.SiteNumber.ToString().PadRight(15)}" + $"{s.MaxOccupancy.ToString().PadRight(15)}" + $"{s.AccessibleString.PadRight(15)}" + $"{s.MaxRVString.PadRight(15)}" + $"{s.UtilitiesString.PadRight(15)}" + $"{(selectedCamp.DailyFee * (decimal)(depatureDate - arrivalDate).TotalDays).ToString("C")}"); siteDict.Add(siteCount, s); } Console.WriteLine(); int selection = CLIHelper.GetSingleInteger("Which site should be reserved(enter 0 to cancel) ", 0, sites.Count); Console.WriteLine(); if (selection != 0) { //ReservationDAO = new ReservationDAO(_connectionString); string name = CLIHelper.GetString("What name should the reservation be made under? "); MakeReservationInterface(siteDict[selection], name, arrivalDate, depatureDate); } exit = true; } else { NoResults(exit); } } catch { Console.WriteLine("Something went wrong with the Dates or Name you entered... try again."); } } }
public AccessRightsManagementService(string context) { _cooperatorDAO = new CooperatorDAO(context); _siteDAO = new SiteDAO(context); }