public void GetIncidentsTest()
{
CarRepairDAO dao = new CarRepairDAO(ConnectionString);
dao.DeleteAllIncidents();
User user = CreateFirstTestUser();
int userId = dao.AddUser(user);
Vehicle vehicle = CreateTestVehicle(userId);
int vehicleId = dao.AddVehicleItems(vehicle);
Incident incident1 = CreateFirstTestIncident(vehicleId);
int newIncidentID = dao.AddIncident(incident1);
Incident incident2 = CreateSecondTestIncident(vehicleId);
int newIncidentID2 = dao.AddIncident(incident2);
List <Incident> incidentList = new List <Incident>();
incidentList = dao.GetIncidents();
Assert.AreEqual(incidentList.Count, 2, "2 users were not returned");
Assert.AreEqual(incidentList[0].Id, newIncidentID, "First user's ID does not match first user in list");
Assert.AreEqual(incidentList[1].Id, newIncidentID2, "Second user's ID does not match second user in list");
}
public void AddIncidentTest()
{
CarRepairDAO dao = new CarRepairDAO(ConnectionString);
//add user
User user = CreateFirstTestUser();
int userId = dao.AddUser(user);
//add vehicle and set incident to that id
Vehicle vehicle = CreateTestVehicle(userId);
int vehicleId = dao.AddVehicleItems(vehicle);
Incident incident = CreateFirstTestIncident(vehicleId);
int newId = dao.AddIncident(incident);
var newUser = dao.GetIncidentById(newId);
Assert.AreEqual(newId, newUser.Id, "ID does not match, check GetIncidentById Method");
Assert.AreEqual(incident.VehicleId, newUser.VehicleId, "Vehicle ID does not match");
Assert.AreEqual(incident.Description, newUser.Description, "Description does not match");
Assert.AreEqual(incident.SubmittedDate, newUser.SubmittedDate, "SubmittedDate does not match");
Assert.AreEqual(incident.Paid, newUser.Paid, "Paid bool does not match");
}
public void GetUserItemsTest()
{
CarRepairDAO dao = new CarRepairDAO(ConnectionString);
//delete entire table
dao.DeleteAllVehicles();
dao.DeleteAllUsers();
//create new users
User user = CreateFirstTestUser();
int newUserID = dao.AddUser(user);
User user2 = CreateSecondTestUser();
int newUser2ID = dao.AddUser(user2);
List <User> userList = new List <User>();
userList = dao.GetUserItems();
Assert.AreEqual(userList.Count, 2, "2 users were not returned");
Assert.AreEqual(userList[0].Id, newUserID, "First user's ID does not match first user in list");
Assert.AreEqual(userList[1].Id, newUser2ID, "Second user's ID does not match second user in list");
}
/// <summary>
/// 执行所有任务
/// </summary>
void ExecuteAllTask()
{
CarRepairDAO carRepairDAO = CarRepairDAO.GetInstance();
taskSimpleScheduler.StartNewTask("车辆报修监测", () =>
{
if (isExeFinish)
{
isExeFinish = false;
carRepairDAO.SaveToCarRepair(this.rTxtOutputer.Output);
isExeFinish = true;
}
}, 30 * 1000, OutputError);
}
public void GetRolesTest()
{
CarRepairDAO dao = new CarRepairDAO(ConnectionString);
List <Role> RolesList = new List <Role>();
RolesList = dao.GetRoles();
Assert.AreEqual(RolesList[0].Id, 1, "Administrator ID does not equal 1");
Assert.AreEqual(RolesList[0].Name, "Administrator", "ID 1 is not named Administrator");
Assert.AreEqual(RolesList[1].Id, 2, "Employee ID does not equal 2");
Assert.AreEqual(RolesList[1].Name, "Employee", "ID 2 is not named Employee");
Assert.AreEqual(RolesList[2].Id, 3, "Customer ID does not equal 3");
Assert.AreEqual(RolesList[2].Name, "Customer", "ID 1 is not named Customer");
}
private Vehicle CreateTestVehicle(int newUserID)
{
CarRepairDAO dao = new CarRepairDAO(ConnectionString);
Vehicle vehicle = new Vehicle();
vehicle.Vin = "VinTest";
vehicle.UserId = newUserID;
vehicle.Make = "MakeTest";
vehicle.Model = "Model Test";
vehicle.Year = 1990;
vehicle.Color = "ColorTest";
return(vehicle);
}
private User CreateSecondTestUser()
{
CarRepairDAO dao = new CarRepairDAO(ConnectionString);
User user2 = new User();
user2.RoleId = 3;
user2.Username = "******";
user2.FirstName = "Kevin";
user2.LastName = "Schott";
user2.Email = "*****@*****.**";
user2.PhoneNumber = "1-513-555-6666";
user2.Hash = "hash";
user2.Salt = "salt";
return(user2);
}
private User CreateFirstTestUser()
{
CarRepairDAO dao = new CarRepairDAO(ConnectionString);
User user = new User();
user.RoleId = 3;
user.Username = "******";
user.FirstName = "Kevin";
user.LastName = "Schott";
user.Email = "*****@*****.**";
user.PhoneNumber = "1-513-555-6666";
user.Hash = "hash";
user.Salt = "salt";
return(user);
}
public void GetIncidentsByUserTest()
{
CarRepairDAO dao = new CarRepairDAO(ConnectionString);
List <Incident> incidentsList = new List <Incident>();
//delete all vehicles
dao.DeleteAllVehicles();
//delete users
dao.DeleteAllUsers();
//delete incidents
dao.DeleteAllIncidents();
//delete all vehicles
dao.DeleteAllVehicles();
//add user and return id
User user = CreateFirstTestUser();
int newUserID = dao.AddUser(user);
//add vehicle
Vehicle vehicle = CreateTestVehicle(newUserID);
int vehicleId = dao.AddVehicleItems(vehicle);
//add incidents with new user id
Incident incident1 = CreateFirstTestIncident(vehicleId);
int newIncidentID = dao.AddIncident(incident1);
Incident incident2 = CreateSecondTestIncident(vehicleId);
int newIncidentID2 = dao.AddIncident(incident2);
//call get method and add to incidents list
incidentsList = dao.GetIncidentsByUser(newUserID);
Assert.AreEqual(incidentsList.Count, 2, "2 incidents were not returned");
Assert.AreEqual(incidentsList[0].VehicleId, vehicleId, "First incidents vehicle ID does not match");
Assert.AreEqual(incidentsList[1].VehicleId, vehicleId, "Second incidents vehicle ID does not match");
}
public void AddUserTest()
{
//// Arrange
CarRepairDAO dao = new CarRepairDAO(ConnectionString);
User user = CreateFirstTestUser();
int newId = dao.AddUser(user);
var newUser = dao.GetUserById(newId);
Assert.AreEqual(newId, newUser.Id, "ID does not match, check GetUserItemByIdMethod");
Assert.AreEqual(user.RoleId, newUser.RoleId, "Role ID does not match");
Assert.AreEqual(user.Username, newUser.Username, "UserName does not match");
Assert.AreEqual(user.FirstName, newUser.FirstName, "FirstName does not match");
Assert.AreEqual(user.LastName, newUser.LastName, "LastName does not match");
Assert.AreEqual(user.Email, newUser.Email, "Email does not match");
Assert.AreEqual(user.PhoneNumber, newUser.PhoneNumber, "PhoneNumber does not match");
Assert.AreEqual(user.Hash, newUser.Hash, "Hash does not match");
Assert.AreEqual(user.Salt, newUser.Salt, "Salt does not match");
}
