public void TestOpenConnectionInValid() { var mySqlProvider = new MySqlDatabaseProvider { ConnectionString = "SERVER=localhost;DATABASE=scduvss;UID=root;PASSWORD=123;" }; Assert.False(mySqlProvider.Open(), "Test MySql Connection Failed"); }
public void TestOpenConnectionValid() { var mySqlProvider = new MySqlDatabaseProvider { ConnectionString = ValidConnectionString }; Assert.IsTrue(mySqlProvider.Open(), "Test MySql Connection Failed"); }
public void TestAddBlackListItem() { var mySqlProvider = new MySqlDatabaseProvider { ConnectionString = ValidConnectionString }; Assert.IsTrue(mySqlProvider.AddBlackListItem(new BlackListItem("TN 01 1235"))); }
public void TestGetBlackListItem() { var mySqlProvider = new MySqlDatabaseProvider { ConnectionString = ValidConnectionString }; var blackListItems = mySqlProvider.GetAllBlackListItem(); Assert.IsTrue(blackListItems.Count > 2); }
public void TestAddVehicleEntryBasicInfo() { var mySqlProvider = new MySqlDatabaseProvider { ConnectionString = ValidConnectionString }; var vehicleBasicInfoModel = new VehicleBasicInfoModel { UniqueEntryId = Guid.NewGuid().ToString(), Number = "TN 07 1234", DateTime = DateTime.Now }; Assert.IsTrue(mySqlProvider.AddVehicleEntryBasicInfo(vehicleBasicInfoModel)); }
public void TestAddVehicleEntryImges() { var executiongDir = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location); var fileName = Path.Combine(executiongDir, "Resources", "split_1.jpg"); var mySqlProvider = new MySqlDatabaseProvider { ConnectionString = ValidConnectionString }; var vehicleImages = new VehicleImagesModel("a8e21388-a12e-4cb3-a920-35301ab593cf") { ChaisisImage = File.ReadAllBytes(fileName), DriverImage = File.ReadAllBytes(fileName), VehicleOverallImage = File.ReadAllBytes(fileName) }; Assert.IsTrue(mySqlProvider.AddVehicleEntryImges(vehicleImages)); }
public void TestCloseConnection() { var mySqlProvider = new MySqlDatabaseProvider(); Assert.IsFalse(mySqlProvider.Close()); }
public void TestGetImageResult() { var id = "a8e21388-a12e-4cb3-a920-35301ab593cf"; var mySqlProvider = new MySqlDatabaseProvider { ConnectionString = ValidConnectionString }; var resutlt = mySqlProvider.GetImageResult(id); Assert.IsTrue(resutlt.ChasisImage != null); }
public void TestSearchVehicleData() { /* SELECT * FROM scduvss.vehicle_entry_info WHERE number = "TN 07 1234" AND entrytime >= '2015-10-01' AND entrytime < '2015-11-01' AND DATE_FORMAT(entrytime, '%H:%i:s') >= '10:00:00' AND DATE_FORMAT(entrytime, '%H:%i:s') > '22:00:00' */ var dbSearchRequestModel = new DbSearchRequestModel { StaDateTime = new DateTime(2015, 10, 01, 10, 00, 00), EnDateTime = new DateTime(2015, 11, 01, 22, 00, 00), VehicleNumber = "TN 07 1234" }; var mySqlProvider = new MySqlDatabaseProvider { ConnectionString = ValidConnectionString }; var searchResult = mySqlProvider.Search(dbSearchRequestModel); Assert.IsTrue(searchResult.Any()); }