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 addAlbum(List<string> aList)
{
foreach (var onpath in aList)
{
var _item = new PIAlbum();
_item.Album = onpath;
_item.Musik_Catagory_idCatagory = 2;
using (var pimusik = new PiindexEntities())
{
pimusik.PIAlbums.Add(_item);
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 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();
}
}
}
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;
}
private void Addmusikdata(List<musicdata> aList)
{
foreach (var onpath in aList)
{
var _item = new PIMusikData();
_item.UUIDMusikData = onpath.UUIDMusikData;
_item.Title = onpath.Title;
_item.NrLenth = onpath.NrLenth;
_item.FileName = onpath.FileName;
_item.Artist_Artist = onpath.Artist_Artist;
_item.Album_Album = onpath.Album_Album;
_item.Genre_Genre = onpath.Genre_Genre;
_item.FilePath_UUIDPath = onpath.FilePath_UUIDPath;
using (var pimusik = new PiindexEntities())
{
pimusik.PIMusikDatas.Add(_item);
pimusik.SaveChanges();
}
}
}
private void addGenre(List<string> aList )
{
foreach (var onpath in aList)
{
var _item = new PIGenre();
_item.Genre = onpath;
_item.Musik_Catagory_idCatagory = 3;
using (var pimusik = new PiindexEntities())
{
pimusik.PIGenres.Add(_item);
pimusik.SaveChanges();
}
}
}
