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));
}
