bool IsAlreadyExistsInDB(string value) { bool yes = false; try { using (var modelContext = new MusicPlayEntities3()) { yes = modelContext.MusicAlbums.Where(r => r.AlbumName.ToUpper() == value.ToUpper()).Count() > 0; } if (!yes) { using (var modelContext = new MusicPlayEntities3()) { yes = modelContext.MusicArtists.Where(r => r.ArtistName.ToUpper() == value.ToUpper()).Count() > 0; } } if (!yes) { using (var modelContext = new MusicPlayEntities3()) { yes = modelContext.MusicBands.Where(r => r.BandName.ToUpper() == value.ToUpper()).Count() > 0; } } } catch (Exception errMsg) { throw errMsg; } return(yes); }
public bool HasBandInDB(string bandName) { bool yes = false; using (var modelContext = new MusicPlayEntities3()) { yes = modelContext.MusicBands.Where(r => r.BandName.ToUpper() == bandName.ToUpper()).Count() > 0; } return(yes); }
public bool HasArtistInExistsInDB(string artistName) { bool yes = false; using (var modelContext = new MusicPlayEntities3()) { try { yes = modelContext.MusicArtists.Where(r => r.ArtistName.ToUpper() == artistName.ToUpper()).Count() > 0; } catch (Exception errMsg) { throw errMsg; } } return(yes); }
private void btnGo_Click(object sender, EventArgs e) { DistilTitle distilTitle = new DistilTitle(); TitleExtract titleExtract = new TitleExtract(); GlobalUserConfig config = new GlobalUserConfig(); GlobalUserConfig.ParentFolderPath = txtPath.Text.Trim(); DirectoryProcess dProcess = new DirectoryProcess(); List <DirectoryInfo> dirList = dProcess.GetDirectories(); FileInfo[] musicFiles = null; TagLib.File tagMusicFile = null; Simile.Algorithm.AlgorithmFactory algFactory = new Algorithm.AlgorithmFactory(); //string newTitle = ""; // string artistOrBandName = ""; // Simile.SimileEnums.GroupCategory grpCategory = SimileEnums.GroupCategory.Unknown; Simile.DBProcess.MusicBand musicBand = new Simile.DBProcess.MusicBand(); Simile.DBProcess.MusicArtist musicArtist = new Simile.DBProcess.MusicArtist(); List <MusicFileViewModel> listMusicFileViewModel = new List <MusicFileViewModel>(); MusicFileViewModel musicFileViewModel = null; List <clsErrorRpt> errorRpts = new List <clsErrorRpt>(); clsErrorRpt errR = null; foreach (DirectoryInfo dir in dirList) { musicFiles = dir.GetFiles(GlobalUserConfig.FileType); foreach (FileInfo finfo in musicFiles) { try { FileInfo musicFile = finfo; // errR = new clsErrorRpt(); errR.FileName = musicFile.Name; errR.Path = musicFile.FullName; // tagMusicFile = TagLib.File.Create(musicFile.FullName); //if tag is null then avoid the file and get next file. if (tagMusicFile.Tag == null) { continue; } musicFileViewModel = new MusicFileViewModel(); musicFileViewModel.Title = tagMusicFile.Tag.Title.Trim(); // newTitle.Trim(); musicFileViewModel.FileName = musicFile.Name.Trim(); musicFileViewModel.Path = musicFile.DirectoryName.Trim(); var artistName = ""; var bandName = ""; //---------------------------- if (tagMusicFile.Tag.AlbumArtists != null && tagMusicFile.Tag.AlbumArtists.Count() > 0) { string tmpAlbArtists = ""; var test = tagMusicFile.Tag.AlbumArtists; foreach (var val in test) { tmpAlbArtists += val.Trim(); } if (!string.IsNullOrEmpty(tmpAlbArtists)) { using (var modelContext = new MusicPlayEntities3()) { Simile.MusicArtist tmpArtist = modelContext.MusicArtists.Where(r => r.ArtistName.ToUpper() == tmpAlbArtists.ToUpper()).FirstOrDefault(); if (tmpArtist != null) { musicFileViewModel.Artist = tmpArtist.ArtistName.Trim(); musicFileViewModel.ArtistId = tmpArtist.Id; } } using (var modelContext = new MusicPlayEntities3()) { Simile.MusicBand tmpBand = modelContext.MusicBands.Where(r => r.BandName.ToUpper() == tmpAlbArtists.ToUpper()).FirstOrDefault(); if (tmpBand != null) { musicFileViewModel.Band = tmpBand.BandName.Trim(); musicFileViewModel.BandId = tmpBand.Id; } } } } //----------------------------- ////////////////// if (musicFileViewModel.BandId == 0) { var tmpBandName = musicFile.Directory.Name.Trim(); using (var modelContext = new MusicPlayEntities3()) { Simile.MusicBand tmpBand = modelContext.MusicBands.Where(r => r.BandName.ToUpper() == tmpBandName.ToUpper()).FirstOrDefault(); if (tmpBand != null) { musicFileViewModel.Band = tmpBand.BandName.Trim(); musicFileViewModel.BandId = tmpBand.Id; } } } if (musicFileViewModel.ArtistId == 0) { var tmpArtistName = musicFile.Directory.Name.Trim(); using (var modelContext = new MusicPlayEntities3()) { Simile.MusicArtist tmpArtist = modelContext.MusicArtists.Where(r => r.ArtistName.ToUpper() == tmpArtistName.ToUpper()).FirstOrDefault(); if (tmpArtist != null) { musicFileViewModel.Artist = tmpArtist.ArtistName.Trim(); musicFileViewModel.ArtistId = tmpArtist.Id; } } } //////////////////// if (!string.IsNullOrEmpty(tagMusicFile.Tag.Comment)) { var splitComments = tagMusicFile.Tag.Comment.Split(';'); foreach (var val in splitComments) { var childSplit = val.ToString().Split('='); if (childSplit.Length == 2) { if (childSplit[0].Trim() == "Artist") { artistName = childSplit[1].Trim(); } if (childSplit[0].Trim() == "Band") { bandName = childSplit[1].Trim(); } } } } if (musicFileViewModel.BandId == 0 && !string.IsNullOrEmpty(bandName)) { using (var modelContext = new MusicPlayEntities3()) { Simile.MusicBand tmpBand = modelContext.MusicBands.Where(r => r.BandName.ToUpper() == bandName.ToUpper()).FirstOrDefault(); musicFileViewModel.Band = tmpBand.BandName.Trim(); musicFileViewModel.BandId = tmpBand.Id; } } if (musicFileViewModel.ArtistId == 0 && !string.IsNullOrEmpty(artistName)) { using (var modelContext = new MusicPlayEntities3()) { Simile.MusicArtist tmpArtist = modelContext.MusicArtists.Where(r => r.ArtistName.ToUpper() == artistName.ToUpper()).FirstOrDefault(); musicFileViewModel.Artist = tmpArtist.ArtistName.Trim(); musicFileViewModel.ArtistId = tmpArtist.Id; } } listMusicFileViewModel.Add(musicFileViewModel); } catch (Exception errMsg) { errR.Error = errMsg.Message; errorRpts.Add(errR); MessageBox.Show(errMsg.Message); } } // end of for loop } //end of dir for loop dgvMusicFiles.DataSource = listMusicFileViewModel; }
bool IsFun(string value) { char[] splitIncomingValue = new char[value.Length]; string[] strSplitValue = new string[value.Length]; //Convert incoming values into character array. splitIncomingValue = value.ToUpper().ToCharArray(); char[] obsoleteCharacter = new char[6]; obsoleteCharacter[0] = '('; obsoleteCharacter[1] = ')'; obsoleteCharacter[2] = '*'; obsoleteCharacter[3] = ';'; obsoleteCharacter[4] = '.'; obsoleteCharacter[5] = ' '; //strSplitValue[0] = "New Artist"; // ArrayList valueToCompare = new ArrayList(); List <string> valueToCompare = new List <string>(); foreach (char charValue in splitIncomingValue) { if (obsoleteCharacter.Where(r => r == charValue).Count() == 0) //value.Contains(charValue)) { valueToCompare.Add(charValue.ToString().ToUpper()); // = charValue.ToString(); } } //// // ArrayList dbvalueToCompare = new ArrayList(); List <string> dbvalueToCompare = new List <string>(); var albums = this.artistsTagValue.Select(r => r.ToUpper()); foreach (var albumName in albums) { char[] splitAlbumNames = new char[albumName.Length]; splitAlbumNames = albumName.ToUpper().ToCharArray(); foreach (char charValue in splitAlbumNames) { if (obsoleteCharacter.Where(r => r == charValue).Count() == 0) { dbvalueToCompare.Add(charValue.ToString().ToUpper()); // = charValue.ToString(); } } } bool isLocalSame = valueToCompare.Except(dbvalueToCompare).ToList().Count() == 0; List <string> dbvalueToCompare1 = new List <string>(); using (var modelContext = new MusicPlayEntities3()) { var albums1 = modelContext.MusicAlbums.Select(r => r.AlbumName.ToUpper()); foreach (var albumName in albums1) { char[] splitAlbumNames = new char[albumName.Length]; foreach (char charValue in splitAlbumNames) { if (obsoleteCharacter.Where(r => r == charValue).Count() == 0) { dbvalueToCompare1.Add(charValue.ToString().ToUpper()); // = charValue.ToString(); } } } } bool isDbSame = valueToCompare.Except(dbvalueToCompare1).ToList().Count() == 0; //valueToCompare.ToArray().Where( r => r.ToString() == dbvalueToCompare.ToArray()) //.Contains(dbvalueToCompare); bool isSame = false; isSame = (isLocalSame || isDbSame); return(isSame); }