public PictureModel(string fileName) { _fileName = fileName; _iptc = new IPTCModel(); _exif = new EXIFModel(); _camera = new CameraModel("", ""); }
public ICameraModel GetCamera(int ID) { // TO DO - Select where Camera = ID and return this Camera CameraModel newCamera = new CameraModel("", ""); newCamera.ID = ID; cameraTable.Add(newCamera); return(newCamera); }
/// <summary> /// Save camera in the db /// </summary> /// <param name="camera"></param> public void SaveCamera(CameraModel camera) { var query = "INSERT INTO dbo.CameraModel(Producer, Make, BoughtOn, Notes, ISOLimitAcceptable, ISOLimitGood)" + "VALUES(@producer, @make, @boughtOn, @notes, @isoAcc, @isoGood);"; // Create and prepare an SQL statement. var producerParam = new SqlParameter("@producer", SqlDbType.Text, 255) { Value = camera.Producer }; var makeParam = new SqlParameter("@make", SqlDbType.Text, 255) { Value = camera.Make }; var boughtOnParam = new SqlParameter("@boughtOn", SqlDbType.DateTime) { Value = camera.BoughtOn }; var notesParam = new SqlParameter("@notes", SqlDbType.Text, 255) { Value = camera.Notes }; var isoAccLimit = new SqlParameter("@isoAcc", SqlDbType.Decimal) { Value = camera.ISOLimitAcceptable, Precision = 18, Scale = 0 }; var isoGood = new SqlParameter("@isoGood", SqlDbType.Decimal) { Value = camera.ISOLimitGood, Precision = 18, Scale = 0 }; using (var connection = new SqlConnection(ConnectionString)) { connection.Open(); var command = new SqlCommand(null, connection) { CommandText = query }; command.Parameters.Add(producerParam); command.Parameters.Add(makeParam); command.Parameters.Add(boughtOnParam); command.Parameters.Add(notesParam); command.Parameters.Add(isoAccLimit); command.Parameters.Add(isoGood); // Call Prepare after setting the Commandtext and Parameters. command.Prepare(); // Change parameter values and call ExecuteNonQuery. command.ExecuteScalar(); connection.Close(); } }
public CameraViewModel(CameraModel core) { _make = core.Make; _producer = core.Producer; _id = core.ID; _ISOLimitAcceptable = core.ISOLimitAcceptable; _ISOLimitGood = core.ISOLimitGood; _boughton = core.BoughtOn; }
public MockDataAccessLayer() { CameraModel cm = new CameraModel(); CameraList.Add(1234, cm); PhotographerModel pm = new PhotographerModel(); pm.ID = 1234; PhotographerList.Add(pm.ID, pm); }
public void Add(CameraModel p) { if (p == null) { return; } CameraViewModel pvm = new CameraViewModel(p); _List.Add(pvm); CurrentIndex = Count - 1; OnPropertyChanged("List"); OnPropertyChanged("Count"); }
/// <summary> /// Returns ONE Camera /// </summary> /// <param name="ID"></param> /// <returns></returns> public ICameraModel GetCamera(int ID) { var queryString = $"Select ID, Producer, Make, BoughtOn, Notes, ISOLimitGood, ISOLimitAcceptable from CameraModel" + " WHERE ID = @id;"; SqlParameter idparam = new SqlParameter("@id", SqlDbType.Int) { Value = ID }; var model = new CameraModel(); using (var connection = new SqlConnection(ConnectionString)) using (var command = connection.CreateCommand()) { command.CommandText = queryString; command.Parameters.Add(idparam); connection.Open(); using (var reader = command.ExecuteReader()) { reader.Read(); int.TryParse(reader["ID"].ToString(), out var tempInt); model.ID = tempInt; model.Producer = reader["Producer"]?.ToString(); model.Make = reader["Make"]?.ToString(); if (reader["BoughtOn"] != DBNull.Value) { model.BoughtOn = DateTime.Parse(reader["BoughtOn"].ToString()); } if (reader["Notes"] != DBNull.Value) { model.Notes = reader["Notes"]?.ToString(); } if (reader["ISOLimitGood"] != DBNull.Value) { model.ISOLimitGood = Decimal.Parse(reader["ISOLimitGood"].ToString()); } if (reader["ISOLimitAcceptable"] != DBNull.Value) { model.ISOLimitAcceptable = Decimal.Parse(reader["ISOLimitAcceptable"].ToString()); } } } return(model); }
public MockDataAccessLayer() { IPictureModel p = new PictureModel("Blume.jpg"); p.ID = 1234; Save(p); IPhotographerModel ph = new PhotographerModel(); ph.ID = 1234; Save(ph); ICameraModel c = new CameraModel(); c.ID = 1234; Save(c); }
/// <summary> /// Returns a list of ALL Cameras. /// </summary> /// <returns></returns> public IEnumerable <ICameraModel> GetCameras() { var queryString = $"Select ID, Producer, Make, BoughtOn, Notes, ISOLimitGood, ISOLimitAcceptable from CameraModel;"; var liste = new List <ICameraModel>(); using (var connection = new SqlConnection(ConnectionString)) using (var command = connection.CreateCommand()) { command.CommandText = queryString; connection.Open(); using (var reader = command.ExecuteReader()) { while (reader.Read()) { var model = new CameraModel(); int.TryParse(reader["ID"].ToString(), out var tempInt); model.ID = tempInt; model.Producer = reader["Producer"].ToString(); model.Make = reader["Make"].ToString(); if (reader["BoughtOn"] != DBNull.Value) { model.BoughtOn = DateTime.Parse(reader["BoughtOn"].ToString()); } if (reader["Notes"] != DBNull.Value) { model.Notes = reader["Notes"]?.ToString(); } if (reader["ISOLimitGood"] != DBNull.Value) { model.ISOLimitGood = Decimal.Parse(reader["ISOLimitGood"].ToString()); } if (reader["ISOLimitAcceptable"] != DBNull.Value) { model.ISOLimitAcceptable = Decimal.Parse(reader["ISOLimitAcceptable"].ToString()); } liste.Add(model); } } } return(liste); }
public void Save(CameraModel newCamera) { _dal.Save(newCamera); }
/// <summary> /// creates new camera view model for given ICameraModel /// </summary> /// <param name="c"></param> public CameraViewModel(ICameraModel c) { _Camera = (CameraModel)c; _Camera.PropertyChanged += SubPropertyChanged; }
/// <summary> /// Save a camera in the database /// </summary> /// <param name="camera"></param> public void SaveCamera(CameraModel camera) { var dal = (DataAccessLayer)_dataAccessLayer; dal.SaveCamera(camera); }
/// <summary> /// returns camera with given ID /// </summary> /// <param name="ID"></param> /// <returns></returns> public ICameraModel GetCamera(int ID) { if (_Cameras.ContainsKey(ID)) { return(_Cameras[ID]); } else { ICameraModel cm = new CameraModel(); SqlCommand c = new SqlCommand(null, dbc); c.CommandText = "SELECT ID, Producer, Make, BoughtOn, Notes, ISOLimitGood, ISOLimitAcceptable FROM Cameras WHERE ID = @id"; SqlParameter id = new SqlParameter("@id", SqlDbType.Int, 0); id.Value = ID; c.Parameters.Add(id); c.Prepare(); SqlDataReader dr = c.ExecuteReader(); if (dr.Read()) { cm.ID = dr.GetInt32(0); try { cm.Producer = dr.GetString(1); } catch (SqlNullValueException) { } try { cm.Make = dr.GetString(2); } catch (SqlNullValueException) { } try { cm.BoughtOn = dr.GetDateTime(3); } catch (SqlNullValueException) { } try { cm.Notes = dr.GetString(4); } catch (SqlNullValueException) { } try { cm.ISOLimitGood = dr.GetDecimal(5); } catch (SqlNullValueException) { } try { cm.ISOLimitAcceptable = dr.GetDecimal(6); } catch (SqlNullValueException) { } dr.Close(); _Cameras.Add(cm.ID, (CameraModel)cm); return(cm); } else { dr.Close(); throw new ElementWithIdDoesNotExistException(); } } }