/// <summary> /// Removes an item from the list of media items. /// </summary> /// <param name="oldMedia">An item form the list of media items you want to delete.</param> public void RemoveMedia(DataModel.Media oldMedia) { if (Mapper.DeleteMedia(oldMedia)) { List.Remove(oldMedia); } }
public DataModel.Media AddMedia(DataModel.Media newMedia) { string addQuery; if (newMedia.File == null) { addQuery = "INSERT INTO Song (Title, Singer) VALUES ('" + newMedia.Title + "', '" + ((Song)newMedia).Singer + "');" + " SELECT CAST(scope_identity() AS int);"; } else { addQuery = "INSERT INTO Song (Title, Singer, File) VALUES ('" + newMedia.Title + "', '" + ((Song)newMedia).Singer + "', '" + "0x" + BitConverter.ToString(newMedia.File).Replace("-", "") + "');" + " SELECT CAST(scope_identity() AS int);"; } try { using (SqlConnection cn = MediaDB.GetConnection()) { using (SqlCommand cmd = new SqlCommand(addQuery, cn)) { cn.Open(); newMedia.Id = (int)cmd.ExecuteScalar(); } } } catch (SqlException) { throw new SaveMediaFailedException(); } return(newMedia); }
public bool UpdateMedia(DataModel.Media updateMedia) { int updateCount = 0; string updateQuery; if (updateMedia.File == null) { updateQuery = "UPDATE Song SET Title = '" + updateMedia.Title + "', Singer = '" + ((Song)updateMedia).Singer + "' WHERE Id = " + updateMedia.Id; } else { updateQuery = "UPDATE Song SET Title = '" + updateMedia.Title + "', Singer = '" + ((Song)updateMedia).Singer + "', File = '" + "0x" + BitConverter.ToString(updateMedia.File).Replace("-", "") + "' WHERE Id = " + updateMedia.Id; } try { using (SqlConnection cn = MediaDB.GetConnection()) { using (SqlCommand cmd = new SqlCommand(updateQuery, cn)) { cn.Open(); updateCount = cmd.ExecuteNonQuery(); } } } catch (SqlException) { throw new UpdateMediaFailedException(); } return(updateCount > 0); }
/// <summary> /// Sets the property Selected to an item from the list of media items. /// </summary> /// <param name="newSelected">An item from the list of media items you want to set as selected.</param> public void ChangeSelected(DataModel.Media newSelected) { if (Mapper.UpdateMedia(newSelected)) { Selected = newSelected; } }
/// <summary> /// Removes an item from the list of media items. /// </summary> /// <param name="oldMedia">An item from the list of media items you want to delete.</param> public void RemoveMedia(DataModel.Media oldMedia) { ClearSelected(); //List.Remove(oldMedia); _mediaMapper.DeleteMedia(oldMedia); this.InitializeData(); }
/// <summary> /// Adds an item to the list of media items. /// </summary> /// <param name="newMedia">A new media item that you want to add to the list of media items.</param> public void AddMedia(DataModel.Media newMedia) { ClearSelected(); //List.Add(newMedia); _mediaMapper.AddMedia(newMedia); this.InitializeData(); }
/// <summary> /// Sets the property Selected to an item from the list of media items. /// </summary> /// <param name="newSelected">An item from the list of media items you want to set as selected.</param> public void ChangeSelected(DataModel.Media newSelected) { if (List.Contains(newSelected)) { Selected = newSelected; } }
public bool DeleteMedia(DataModel.Media oldMedia) { int deleteCount = 0; string deleteQuery = "DELETE FROM Song WHERE Id = " + oldMedia.Id; try { using (SqlConnection cn = MediaDB.GetConnection()) { using (SqlCommand cmd = new SqlCommand(deleteQuery, cn)) { cn.Open(); deleteCount = cmd.ExecuteNonQuery(); } } } catch (SqlException) { throw new RemoveMediaFailedException(); } return(deleteCount > 0); }
/// <summary> /// Adds an item to the list of media items. /// </summary> /// <param name="newMedia">A new media item that you want to add to the list of media items.</param> public void AddMedia(DataModel.Media newMedia) { List.Add(Mapper.AddMedia(newMedia)); }
/// <summary> /// Sets the property Selected to default (null). /// </summary> public void ClearSelected() { Selected = null; }
public void RemoveMedia(DataModel.Media oldMedia) { playlist.Remove(oldMedia); }
public void AddMedia(DataModel.Media newMedia) { playlist.Add(newMedia); }
/// <summary> /// Updates an item in the list of media items. /// </summary> /// <param name="updateMedia">An item from the list of media items you want to update.</param> public void UpdateMedia(DataModel.Media updateMedia) { ClearSelected(); _mediaMapper.UpdateMedia(updateMedia); this.InitializeData(); }
/// <summary> /// Removes an item from the list of media items. /// </summary> /// <param name="oldMedia">An item form the list of media items you want to delete.</param> public void RemoveMedia(DataModel.Media oldMedia) { ClearSelected(); List.Remove(oldMedia); }
/// <summary> /// Adds an item to the list of media items. /// </summary> /// <param name="newMedia">A new media item that you want to add to the list of media items.</param> public void AddMedia(DataModel.Media newMedia) { ClearSelected(); List.Add(newMedia); }