public SongApplication_ReturnType RemoveSongInfo(string albumId, string songId, string songName) { SongApplication_ReturnType resultRC = new SongApplication_ReturnType(); string excMsg = string.Empty; try { if (string.IsNullOrEmpty(songId.Trim())) { excMsg = @"Missing SongId value."; } else if (string.IsNullOrEmpty(albumId.Trim())) { excMsg = @"Missing albumId vlaue."; } if (!string.IsNullOrEmpty(excMsg)) { throw new Exception(excMsg); } SongApplicationDataAccess.DeleteXMLSongInfo(albumId, songId, songName); resultRC.Status = 0; resultRC.StatusDescription = @""; } catch (Exception e) { resultRC.Status = -1; resultRC.StatusDescription = @"Excetion::" + e.TargetSite + " - " + e.Message; } return(resultRC); }
public SongApplication_ReturnType UpdateSongInfo(string songId, string albumId, string songName, string albumName, string songLength, string trackNumber, string genre) { SongApplication_ReturnType resultRC = new SongApplication_ReturnType(); string excMsg = string.Empty; try { if (string.IsNullOrEmpty(songId.Trim())) { excMsg = @"Missing SongId value."; } else if (string.IsNullOrEmpty(albumId.Trim())) { excMsg = @"Missing albumId vlaue."; } if (!string.IsNullOrEmpty(excMsg)) { throw new Exception(excMsg); } resultRC = manageSongRecord(albumName, songName, songLength, trackNumber, genre, @"song", @"update", ref songId, albumId); } catch (Exception e) { resultRC.Status = -1; resultRC.StatusDescription = @"Excetion::" + e.TargetSite + " - " + e.Message; } return(resultRC); }
public static string UpdateSongData(string albumId, string songId, string albumName, string songName, string length, string trackNumber, string genre) { SongServiceClient song = new SongServiceClient(); SongApplication_ReturnType songRC = new SongApplication_ReturnType(); songRC = song.UpdateSongInfo(songId, albumId, songName, albumName, length, trackNumber, genre); return songRC.Status.ToString(); }
public static string UpdateSongData(string albumId, string songId, string albumName, string songName, string length, string trackNumber, string genre) { SongServiceClient song = new SongServiceClient(); SongApplication_ReturnType songRC = new SongApplication_ReturnType(); songRC = song.UpdateSongInfo(songId, albumId, songName, albumName, length, trackNumber, genre); return(songRC.Status.ToString()); }
public static List<string> AddSongRecord(string albumId, string albumName, string songName, string length, string trackNumber, string genre) { SongServiceClient song = new SongServiceClient(); SongApplication_ReturnType songRC = new SongApplication_ReturnType(); List<string> id = new List<string>(); string songId = string.Empty; songRC = song.AddSongToAlbum(albumName, albumId, songName, length, trackNumber, genre, ref songId); id.Add(songId); return id; }
public static List <string> AddSongRecord(string albumId, string albumName, string songName, string length, string trackNumber, string genre) { SongServiceClient song = new SongServiceClient(); SongApplication_ReturnType songRC = new SongApplication_ReturnType(); List <string> id = new List <string>(); string songId = string.Empty; songRC = song.AddSongToAlbum(albumName, albumId, songName, length, trackNumber, genre, ref songId); id.Add(songId); return(id); }
public SongApplication_ReturnType AddSongToAlbum(string albumName, string albumId, string songName, string songLength, string trackNumber, string genre, ref string songId) { SongApplication_ReturnType resultRC = new SongApplication_ReturnType(); string tagName = @"song"; string excMsg = string.Empty; try { if (!string.IsNullOrEmpty(albumName)) { albumName = albumName.Trim(); } if (!string.IsNullOrEmpty(songName)) { songName = songName.Trim(); } if (!string.IsNullOrEmpty(genre)) { genre = genre.Trim(); } if (string.IsNullOrEmpty(albumName)) { excMsg = @"Missing Album Name value."; } else if (string.IsNullOrEmpty(songName)) { excMsg = @"Missing Song's Title value."; } else if (string.IsNullOrEmpty(genre)) { excMsg = @"Missing Genre value."; } if (!string.IsNullOrEmpty(excMsg)) { throw new Exception(excMsg); } resultRC = manageSongRecord(albumName, songName, songLength, trackNumber, genre, tagName, @"insert", ref songId, albumId); } catch (Exception e) { resultRC.Status = -1; resultRC.StatusDescription = @"Excetion::" + e.TargetSite + " - " + e.Message; } return(resultRC); }
private static SongApplication_ReturnType manageSongRecord(string albumName, string songName, string songLength, string trackNumber, string genre, string tagName, string action, ref string songId, string albumId) { SongApplication_ReturnType dataRC = new SongApplication_ReturnType(); List <AlbumInfo_ReturnType> updateData = new List <AlbumInfo_ReturnType>(); AlbumInfo_ReturnType record = new AlbumInfo_ReturnType(); DataSet dataSet = new DataSet(); string connectDB = string.Empty; Random rand = new Random(); //0 = SQL, 1 = XML try { if (ConfigurationManager.AppSettings[@"connectionString"] != null) { connectDB = Convert.ToString(ConfigurationManager.AppSettings[@"connectionString"]); } ObjectCache updateCache = MemoryCache.Default; if (action.Equals(@"update")) { if (rand.Next(2) == 0) { //sql dataSet = SongApplicationDataAccess.GetDataSet(2, connectDB, albumId, songId, songName, songLength, trackNumber, genre); dataRC.StatusDescription = "Update Song was successful."; dataRC.Status = 0; } else { //xml SongApplicationDataAccess.UpdateXMLSongInfo(songId, albumId, songName, songLength, trackNumber, genre, tagName); dataRC.Status = 0; dataRC.StatusDescription = "Update request was successful"; } if (updateCache.Contains(albumName)) { updateData = (List <AlbumInfo_ReturnType>)updateCache.Get(albumName); if (updateData != null && updateData.Count > 0) { for (int i = 0; i < updateData.Count; i++) { if (updateData[i].SongId.ToString().Equals(songId) && updateData[i].AlbumId.ToString().Equals(albumId)) { updateData[i].SongName = songName; updateData[i].Length = songLength; updateData[i].TrackNumber = trackNumber; updateData[i].Genre = genre; } } } CacheItemPolicy cachePolicy = new CacheItemPolicy(); cachePolicy.AbsoluteExpiration = DateTime.Now.AddHours(1); updateCache.Set(albumName, updateData, cachePolicy); } } else if (action.Equals(@"insert")) { if (rand.Next(2) == 0) { //sql dataSet = SongApplicationDataAccess.GetDataSet(1, connectDB, albumId, albumName, songName, songLength, trackNumber, genre); if (dataSet != null && dataSet.Tables != null && dataSet.Tables.Count > 0 && dataSet.Tables[0].Rows != null && dataSet.Tables[0].Rows.Count > 0) { if (Convert.IsDBNull(dataSet.Tables[0].Rows[0][@"SongId"]) != null) { songId = Convert.IsDBNull(dataSet.Tables[0].Rows[0][@"SongId"]).ToString(); } } } else { //xml SongApplicationDataAccess.insertXMLSongInfo(albumName, albumId, songName, songLength, trackNumber, genre, tagName, ref songId); if (string.IsNullOrEmpty(songId)) { dataRC.StatusDescription = "Failed to insert record in XML Data source. This can be due to albumn record does not exsits."; dataRC.Status = -1; } } if (string.IsNullOrEmpty(songId)) { dataRC.StatusDescription = "Failed to insert song."; dataRC.Status = -1; } else { dataRC.StatusDescription = "Tnsert song request was succesful."; dataRC.Status = 0; if (updateCache.Contains(albumName)) { updateData = (List <AlbumInfo_ReturnType>)updateCache.Get(albumName); if (updateCache != null) { record.AlbumId = Convert.ToInt32(albumId); record.AlbumName = albumName; record.SongId = Convert.ToInt32(songId); record.SongName = songName; record.Length = songLength; record.TrackNumber = trackNumber; record.Genre = genre; updateData.Add(record); } CacheItemPolicy cachePolicy = new CacheItemPolicy(); cachePolicy.AbsoluteExpiration = DateTime.Now.AddHours(1); updateCache.Set(albumName, updateData, cachePolicy); } } } } catch (Exception e) { dataRC.Status = -1; dataRC.StatusDescription = @"Excetion::" + e.TargetSite + " - " + e.Message; } return(dataRC); }