public Dictionary <int, Vehicle> GetVehicleCustom(ref string errMessage, string str)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
Dictionary <int, Vehicle> list = new Dictionary <int, Vehicle>();
try
{
DataSet ds = VehicleDataAccess.GetVehicleCustom(db, str);
Vehicle vehicle;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
vehicle = new Vehicle(ds.Tables[0].Rows[i]);
vehicle.CapturePicture = CapturePictureBusiness.Instance.GetCapturePicture(ref errMessage, vehicle.PictureID);
vehicle.CameraInfo = CameraBusiness.Instance.GetCameraInfoByCameraId(ref errMessage,
vehicle.CapturePicture.CameraID);
vehicle.VideoInfo = VideoBusiness.Instance.GetVideoInfoById(ref errMessage, vehicle.VedioId);
list.Add(vehicle.VehicleID, vehicle);
}
return(list);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(null);
}
}
internal static void VehiclesInRaceSimulation(int id)
{
var vehicles = VehicleDataAccess.GetVehiclesByRaceId(id);
foreach (var vehicle in vehicles)
{
var vehicleStatistics = GetStatisticForVehicle(vehicle);
VehicleStatisticDataAccess.AddStatisticForVehicle(vehicleStatistics);
}
}
public int Insert(ref string errMessage, Vehicle ovehicle)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
try
{
return(VehicleDataAccess.Insert(db, ovehicle));
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(-1);
}
}
public int GetVehicleQuantity(ref string errMessage, string str)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
int ret = 0;
try
{
return(VehicleDataAccess.GetVehicleCustomQuantity(db, str));
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(0);
}
}
public Vehicle GetVehicle(ref string errMessage, int cameraId, DateTime captureDataTime)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
Vehicle vehicle = null;
try
{
DataSet ds = VehicleDataAccess.GetVehicleCustom(db, string.Format(" and CapturePicture.CameraId={0} and CapturePicture.DateTime='{1}'", cameraId, captureDataTime));
vehicle = new Vehicle(ds.Tables[0].Rows[0]);
vehicle.CapturePicture = CapturePictureBusiness.Instance.GetCapturePicture(ref errMessage, vehicle.PictureID);
vehicle.CameraInfo = CameraBusiness.Instance.GetCameraInfoByCameraId(ref errMessage,
vehicle.CapturePicture.CameraID);
vehicle.VideoInfo = VideoBusiness.Instance.GetVideoInfoById(ref errMessage, vehicle.VedioId);
return(vehicle);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(null);
}
}
public void RemoveVehicleFromTheRace(int id)
{
VehicleDataAccess.RemoveVehicleFromTheRace(id);
}
public IEnumerable <Vehicle> GetVehiclesByMultipleParameters(string team, string model, DateTime manufacturingDate, VehicleStatus status, int distance)
{
return(VehicleDataAccess.GetVehiclesByMultipleParameters(team, model, manufacturingDate, status, distance));
}
public IEnumerable <Vehicle> GetVehiclesLeaderboardByType(string type)
{
return(VehicleDataAccess.GetVehiclesLeaderboardByType(type));
}
public IEnumerable <Vehicle> GetVehiclesLeaderboard()
{
return(VehicleDataAccess.GetVehiclesLeaderboard());
}
public void UpdateVehicleInfo(int id, Vehicle vehicle)
{
VehicleDataAccess.UpdateVehicleInfo(id, vehicle);
}
public void AddVehicleToRace(Vehicle vehicle)
{
VehicleDataAccess.AddVehicleToRace(vehicle);
}
public VehicleRepository(long userid)
{
this.UserId = userid;
this.instance = new VehicleDataAccess();
}
