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