public void BookResTest() { int resID = 0; CampDAL test = new CampDAL(connectionString); DateTime start = new DateTime(2017, 04, 05); DateTime end = new DateTime(2017, 04, 10); int id = test.BookRes(5, "Test Fam", start, end); try { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM reservation WHERE name = 'Test Fam'", conn); SqlDataReader r = cmd.ExecuteReader(); while (r.Read()) { resID = Convert.ToInt32(r["reservation_id"]); } } } catch { throw; } Assert.AreNotEqual(0, resID); }
public void GetCampCostTest() { int campID = 0; try { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand("INSERT INTO campground(park_id, name, open_from_mm, open_to_mm, daily_fee) VALUES(1, 'reginald', 11, 03, 500)", conn); int rowsAffected = cmd.ExecuteNonQuery(); cmd = new SqlCommand("SELECT campground_id FROM campground WHERE name = 'reginald'", conn); SqlDataReader r = cmd.ExecuteReader(); while (r.Read()) { campID = Convert.ToInt32(r["campground_id"]); } } } catch (SqlException ex) { throw; } CampDAL test = new CampDAL(connectionString); DateTime start = new DateTime(2017, 10, 05); DateTime end = new DateTime(2017, 10, 10); int result = Convert.ToInt32(test.GetCampCost(campID, start, end)); Assert.AreEqual(2500, result); }
public void FindResTest() { CampDAL test = new CampDAL(connectionString); Reservation res = test.FindRes(1); Assert.IsNotNull(res); }
static void Main(string[] args) { string dbConnection = ConfigurationManager.ConnectionStrings["CapstoneDatabase"].ConnectionString; CampDAL dbAccess = new CampDAL(dbConnection); DisplayMethods display = new DisplayMethods(); CLI myMenu = new CLI(dbAccess, display); myMenu.Running(); }
public void SitesAvailableTest() { CampDAL test = new CampDAL(connectionString); DateTime start = new DateTime(2017, 03, 05); DateTime end = new DateTime(2017, 03, 10); List <Site> list = test.SiteAvailable(1, start, end); Assert.AreEqual(12, list.Count); }
public CLI(CampDAL access, DisplayMethods display) { DB = access; Display = display; }
public void GetCampsTest() { CampDAL test = new CampDAL(connectionString); Assert.IsNotNull(test.GetCamps(1)); }