public void FillIp(string myip) { if (!makeguuidifnodevice()) { var mydevice = new device(); mydevice.UUIDDevice = Guid.NewGuid().ToString(); _GUIDDevice = mydevice.UUIDDevice; mydevice.IP = myip+":8554"; mydevice.Protocol = "rtsp://"; mydevice.PCOwner = Environment.UserName; using (var musik = new pcindexEntities()) { musik.devices.Add(mydevice); musik.SaveChanges(); } } else { using (var musik = new pcindexEntities()) { var olddevice = (from p in musik.devices select p).ToList(); if (myip != olddevice[0].IP) { olddevice[0].IP = myip+":8554"; musik.SaveChanges(); } } } }
public void Markasonline() { { if (!CheckIfDeviceExists()) { List<device> pcdevices; using (var musik = new pcindexEntities()) { pcdevices = (from p in musik.devices select p).ToList(); } var nyed = pcdevices.ElementAt(0); var pid = new PIDevice(); pid.UUIDDevice = nyed.UUIDDevice; pid.IP = nyed.IP; pid.PCOwner = nyed.PCOwner; pid.Protocol = nyed.Protocol; pid.Catagory_idCatagory = 1; pid.Online = true; using (var pimusik = new PiindexEntities()) { pimusik.PIDevices.Add(pid); pimusik.SaveChanges(); } } else { CheckPIandFixIp(); } } }
private void FillPiPath() { List<filepath> pathtopi; List<PIFilePath> pifilepaths; using (var musik = new pcindexEntities()) { pathtopi = (from p in musik.filepaths select p).ToList(); } using (var pimusik = new PiindexEntities()) { pifilepaths = (from p in pimusik.PIFilePaths select p).ToList(); } pathtopi = listcompair(pathtopi, pifilepaths); foreach (var ele in pathtopi) { var fil = new PIFilePath(); fil.Device_UUIDDevice = ele.Device_UUIDDevice; fil.FilePath = ele.FilePath1; fil.UUIDPath = ele.UUIDPath; using (var pimusik = new PiindexEntities()) { pimusik.PIFilePaths.Add(fil); pimusik.SaveChanges(); } } }
// Takes all music from Pc an adds to the Pi what it doesn't have private void FillMusikData() { List<musicdata> musicdatas; using (var musik = new pcindexEntities()) { musicdatas = (from p in musik.musicdatas select p).ToList(); } using (var pimusik = new PiindexEntities()) { musicdatas = listcompair(musicdatas, (from p in pimusik.PIMusikDatas select p).ToList()); } if(musicdatas.Count >0) Addmusikdata(musicdatas); }
private void FillAAG() { List<string> Artist; List<string> Album; List<string> Genre; using (var musik = new pcindexEntities()) { Artist = (from p in musik.artists select p.Artist1).ToList(); Album = (from p in musik.albums select p.Album1).ToList(); Genre = (from p in musik.genres select p.Genre1).ToList(); } using (var pimusik = new PiindexEntities()) { Artist = listcompair(Artist,(from p in pimusik.PIArtists select p.Artist).ToList()); Album = listcompair(Album ,(from p in pimusik.PIAlbums select p.Album).ToList()); Genre = listcompair(Genre ,(from p in pimusik.PIGenres select p.Genre).ToList()); } if (Artist.Count > 0) addArtist(Artist); if (Album.Count > 0) addAlbum(Album); if (Genre.Count > 0) addGenre(Genre); }
private void CheckPIandFixIp() { List<device> PCdevices; using (var musik = new pcindexEntities()) { PCdevices = (from p in musik.devices select p).ToList(); } var my = PCdevices[0]; using (var pimusik = new PiindexEntities()) { var change = (from p in pimusik.PIDevices where p.UUIDDevice == my.UUIDDevice select p).ToList(); change[0].IP = my.IP; pimusik.SaveChanges(); } }
private bool CheckIfDeviceExists() { List<string> pcdevices; using (var musik = new pcindexEntities()) { pcdevices = (from p in musik.devices select p.UUIDDevice).ToList(); } using (var pimusik = new PiindexEntities()) { pcdevices = listcompair(pcdevices, (from p in pimusik.PIDevices select p.UUIDDevice).ToList()); } return pcdevices.Count == 0; }
public void FillMusicAndPath(List<string> PathOndevice) { using (var musik = new pcindexEntities()) { var pathlist = (from p in musik.filepaths select p.FilePath1 ).ToList(); PathOndevice = listcompair(PathOndevice, pathlist); if (PathOndevice.Count >= 1) { foreach (var onpath in PathOndevice) { var path = new filepath(); path.Device_UUIDDevice = _GUIDDevice; path.UUIDPath = Guid.NewGuid().ToString(); path.FilePath1 = onpath; musik.filepaths.Add(path); musik.SaveChanges(); IFileIndexer indexer = new FolderAndFileReader(); indexer.SetIndexPath(onpath); List<IMetadataReader> mdata = indexer.GetMetaData(); FillAAG(mdata); fillMusicdata(mdata,path.UUIDPath); } } } //see if pathes is allready is assigned to ip // if not add pathes }
private bool makeguuidifnodevice() { using (var musik = new pcindexEntities()) { var GUIDDevice = (from p in musik.devices select p).ToList(); if (GUIDDevice.Count == 0) return false; _GUIDDevice = GUIDDevice[0].UUIDDevice; return true; } }
private void Addgenre( List<string> liste) { //se if Genre exists if not add genre using (var musik = new pcindexEntities()) { List<string> list2 = (from p in musik.genres select p.Genre1 ).ToList(); liste = listcompair(liste, list2); if (liste.Count >= 1) { foreach (var onpath in liste) { var _genre = new genre(); _genre.Genre1 = onpath; musik.genres.Add(_genre); musik.SaveChanges(); } } } }
private void addArtist(List<string> liste) { // make artist list // remove duplets using (var musik = new pcindexEntities()) { List<string> list2 = (from p in musik.artists select p.Artist1 ).ToList(); liste = listcompair(liste, list2); if (liste.Count >= 1) { foreach (var onpath in liste) { var entity = new artist(); entity.Artist1 = onpath; musik.artists.Add(entity); musik.SaveChanges(); } } } }
private void addAlbum(List<string> liste) { using (var musik = new pcindexEntities()) { List<string> list2 = (from p in musik.albums select p.Album1 ).ToList(); liste = listcompair(liste, list2); if (liste.Count >= 1) { foreach (var onpath in liste) { var entity = new album(); entity.Album1 = onpath; musik.albums.Add(entity); musik.SaveChanges(); } } } }
public void fillMusicdata(List<IMetadataReader> datalist,string uuid) { using (var musik = new pcindexEntities()) { foreach (var metadata in datalist) { var nummer = new musicdata(); nummer.Title = metadata.Title; nummer.Artist_Artist = metadata.Artist; nummer.Album_Album = metadata.Album; nummer.Genre_Genre = metadata.Genre; nummer.NrLenth = metadata.LengthS; nummer.FileName = metadata.ItemName; nummer.FilePath_UUIDPath = uuid; nummer.UUIDMusikData = Guid.NewGuid().ToString(); musik.musicdatas.Add(nummer); musik.SaveChanges(); } } }