public virtual IEnumerable <ICameraModel> GetCameras()
{
var output = "Get all cameras";
Console.WriteLine(output);
var cameras = new List <ICameraModel>();
try
{
Conn.Open();
using (var reader = PS.GetAllCameras.ExecuteReader())
{
while (reader.Read())
{
cameras.Add(DTOParser.ParseCameraModel(RecordToDictionary(reader)));
}
}
Conn.Close();
return(cameras);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw new Exception(output, e);
}
finally
{
Conn.Close();
}
}
public virtual ICameraModel GetCamera(int ID)
{
var output = $"Get Camera with ID: {ID}";
Console.WriteLine(output);
try
{
Conn.Open();
PS.GetOneCameraId.Parameters["@ID"].Value = ID;
CameraModel camera;
using (var reader = PS.GetOneCameraId.ExecuteReader())
{
reader.Read();
camera = DTOParser.ParseCameraModel(RecordToDictionary(reader));
}
Conn.Close();
return(camera);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw new Exception(output, e);
}
finally
{
Conn.Close();
}
}
