public PackEN ReadOIDDefault(int idPack) { PackEN packEN = null; try { SesssionInitializeTransaction(); packEN = (PackEN)session.Load(typeof(PackEN), idPack ); SessionCommit(); } catch (Exception ex) { SessionRollBack(); if (ex is ModelException) { throw ex; } throw new DataLayerException("Error in PackCAD.", ex); } finally { SessionClose(); } return(packEN); }
public int Crear(PackEN pack) { try { SesssionInitializeTransaction(); session.Save(pack); SessionCommit(); } catch (Exception ex) { SessionRollBack(); if (ex is ModelException) { throw ex; } throw new DataLayerException("Error in PackCAD.", ex); } finally { SessionClose(); } return(pack.IdPack); }
public void Eliminar(int idPack) { try { SesssionInitializeTransaction(); PackEN packEN = (PackEN)session.Load(typeof(PackEN), idPack ); session.Delete(packEN); SessionCommit(); } catch (Exception ex) { SessionRollBack(); if (ex is ModelException) { throw ex; } throw new DataLayerException("Error in PackCAD.", ex); } finally { SessionClose(); } }
public PackEN DamePorID(int idPack) { PackEN packEN = null; packEN = _IPackCAD.DamePorID( idPack ); return(packEN); }
public void Modificar(int p_Pack_OID, String p_nombre, String p_familia, String p_descripción, String p_color, String p_codigo) { PackEN packEN = null; //Initialized PackEN packEN = new PackEN(); packEN.IdPack = p_Pack_OID; packEN.Nombre = p_nombre; packEN.Familia = p_familia; packEN.Descripción = p_descripción; packEN.Color = p_color; packEN.Codigo = p_codigo; //Call to PackCAD _IPackCAD.Modificar(packEN); }
public static PackEN Convert(PackDTO dto) { PackEN newinstance = null; try { if (dto != null) { newinstance = new PackEN(); newinstance.IdPack = dto.IdPack; newinstance.Nombre = dto.Nombre; newinstance.Familia = dto.Familia; newinstance.Descripción = dto.Descripción; newinstance.Color = dto.Color; newinstance.Codigo = dto.Codigo; if (dto.Variable_oid != null) { PersonalHomeGenNHibernate.CAD.PersonalHome.IVariableCAD variableCAD = new PersonalHomeGenNHibernate.CAD.PersonalHome.VariableCAD(); newinstance.Variable = new System.Collections.Generic.List <PersonalHomeGenNHibernate.EN.PersonalHome.VariableEN>(); foreach (int entry in dto.Variable_oid) { newinstance.Variable.Add(variableCAD.ReadOIDDefault(entry)); } } if (dto.FamiliaPack_oid != null) { PersonalHomeGenNHibernate.CAD.PersonalHome.IFamiliaPackCAD familiaPackCAD = new PersonalHomeGenNHibernate.CAD.PersonalHome.FamiliaPackCAD(); newinstance.FamiliaPack = new System.Collections.Generic.List <PersonalHomeGenNHibernate.EN.PersonalHome.FamiliaPackEN>(); foreach (int entry in dto.FamiliaPack_oid) { newinstance.FamiliaPack.Add(familiaPackCAD.ReadOIDDefault(entry)); } } } } catch (Exception ex) { throw ex; } return(newinstance); }
public int Crear(String p_nombre, String p_familia, String p_descripción, String p_color, String p_codigo) { PackEN packEN = null; int oid; //Initialized PackEN packEN = new PackEN(); packEN.Nombre = p_nombre; packEN.Familia = p_familia; packEN.Descripción = p_descripción; packEN.Color = p_color; packEN.Codigo = p_codigo; //Call to PackCAD oid = _IPackCAD.Crear(packEN); return(oid); }
public void Modificar(PackEN pack) { try { SesssionInitializeTransaction(); PackEN packEN = (PackEN)session.Load(typeof(PackEN), pack.IdPack); packEN.Nombre = pack.Nombre; packEN.Familia = pack.Familia; packEN.Descripción = pack.Descripción; packEN.Color = pack.Color; packEN.Codigo = pack.Codigo; session.Update(packEN); SessionCommit(); } catch (Exception ex) { SessionRollBack(); if (ex is ModelException) { throw ex; } throw new DataLayerException("Error in PackCAD.", ex); } finally { SessionClose(); } }
public static PackDTO Convert(PackEN en) { PackDTO newinstance = null; if (en != null) { newinstance = new PackDTO(); newinstance.IdPack = en.IdPack; newinstance.Nombre = en.Nombre; newinstance.Familia = en.Familia; newinstance.Descripción = en.Descripción; newinstance.Color = en.Color; newinstance.Codigo = en.Codigo; if (en.Variable != null) { newinstance.Variable_oid = new System.Collections.Generic.List <Int32>(); foreach (PersonalHomeGenNHibernate.EN.PersonalHome.VariableEN entry in en.Variable) { newinstance.Variable_oid.Add(entry.IdVariable); } } if (en.FamiliaPack != null) { newinstance.FamiliaPack_oid = new System.Collections.Generic.List <Int32>(); foreach (PersonalHomeGenNHibernate.EN.PersonalHome.FamiliaPackEN entry in en.FamiliaPack) { newinstance.FamiliaPack_oid.Add(entry.IdFamPack); } } } return(newinstance); }
public static void InitializeData() { /*PROTECTED REGION ID(initializeDataMethod) ENABLED START*/ try { VariableEN variable = new VariableEN(); IVariableCAD _IVarCAD = new VariableCAD(); VariableCEN varCEN = new VariableCEN(_IVarCAD); PackEN pack = new PackEN(); IPackCAD _IPackCAD = new PackCAD(); PackCEN packCEN = new PackCEN(_IPackCAD); int idVAR1 = varCEN.Crear("Tarima laminada", "Muy bonita", 120.23, "imagen", 10, "miniatura"); int idVAR2 = varCEN.Crear("Tarima flotante", "Muy fea", 100.10, "imagen", 10, "miniatura"); int idPack1 = packCEN.Crear("Pack A", "Familia A", "Descripci?n Pack A", "rojo", "PAA"); int idPack2 = packCEN.Crear("Pack B", "Familia A", "Descripci?n Pack B", "azul", "PAB"); IList <int> variables = new List <int>(); variables.Add(idVAR1); variables.Add(idVAR2); //packCEN.AsignarVariable(idPack1, variables); //packCEN.AsignarVariable(idPack2, variables); IList <int> packs = new List <int>(); packs.Add(idPack1); packs.Add(idPack2); varCEN.AsignarPack(idVAR1, packs); varCEN.AsignarPack(idVAR2, packs); IAdminCAD _IAdminCAD = new AdminCAD(); AdminCEN adminCEN = new AdminCEN(_IAdminCAD); adminCEN.CrearAdmin("*****@*****.**", "12345", "Tigran"); /*List<PersonalHomeGenNHibernate.EN.Mediaplayer.MusicTrackEN> musicTracks = new List<PersonalHomeGenNHibernate.EN.Mediaplayer.MusicTrackEN>(); * PersonalHomeGenNHibernate.EN.Mediaplayer.UserEN userEN = new PersonalHomeGenNHibernate.EN.Mediaplayer.UserEN(); * PersonalHomeGenNHibernate.EN.Mediaplayer.ArtistEN artistEN = new PersonalHomeGenNHibernate.EN.Mediaplayer.ArtistEN(); * PersonalHomeGenNHibernate.EN.Mediaplayer.MusicTrackEN musicTrackEN = new PersonalHomeGenNHibernate.EN.Mediaplayer.MusicTrackEN(); * PersonalHomeGenNHibernate.CEN.Mediaplayer.ArtistCEN artistCEN = new PersonalHomeGenNHibernate.CEN.Mediaplayer.ArtistCEN(); * PersonalHomeGenNHibernate.CEN.Mediaplayer.UserCEN userCEN = new PersonalHomeGenNHibernate.CEN.Mediaplayer.UserCEN(); * PersonalHomeGenNHibernate.CEN.Mediaplayer.MusicTrackCEN musicTrackCEN = new PersonalHomeGenNHibernate.CEN.Mediaplayer.MusicTrackCEN(); * PersonalHomeGenNHibernate.CEN.Mediaplayer.PlayListCEN playListCEN = new PersonalHomeGenNHibernate.CEN.Mediaplayer.PlayListCEN(); * * //Add Users * userEN.Email = "*****@*****.**"; * userEN.Name = "user"; * userEN.Surname = "userSurname"; * userEN.Password = "******"; * userCEN.New_(userEN.Name, userEN.Surname, userEN.Email, userEN.Password); * * //Add Music Track1 * musicTrackEN.Id = "http://www2.b3ta.com/mp3/Beer Beer Beer (YOB mix).mp3"; * musicTrackEN.Format = "mp3"; * musicTrackEN.Lyrics = "Beer Beer Beer Beer Beer Beer .."; * musicTrackEN.Name = "Beer Beer Beer"; * musicTrackEN.Company = "Company"; * musicTrackEN.Cover = "http://www.tomasabraham.com.ar/cajadig/2007/images/nro18-2/beer1.jpg"; * musicTrackEN.Price = 20; * musicTrackEN.Rating = 5; * musicTrackEN.CommunityRating = 5; * musicTrackEN.Duration = 200; * musicTrackCEN.New_(musicTrackEN.Id, musicTrackEN.Format, musicTrackEN.Lyrics, musicTrackEN.Name, * musicTrackEN.Company, musicTrackEN.Cover, musicTrackEN.CommunityRating, musicTrackEN.Rating, * musicTrackEN.Price, musicTrackEN.Duration); * musicTracks.Add(musicTrackEN); * musicTrackCEN.AsignUser(musicTrackEN.Id,userEN.Email); * * //Add Music Track2 * musicTrackEN = new PersonalHomeGenNHibernate.EN.Mediaplayer.MusicTrackEN(); * musicTrackEN.Id = "http://www.goear.com/files/sst2/mp3files/01122006/681dabd7c2c03aad5f10a13abaa61f95.mp3"; * musicTrackEN.Format = "mp3"; * musicTrackEN.Lyrics = ""; * musicTrackEN.Name = "Chariots of Fire"; * musicTrackEN.Company = "Company 2"; * musicTrackEN.Cover = "http://www.tupelicula.es/imagenes/pelisonline/628.jpg"; * musicTrackEN.Price = 10; * musicTrackEN.Rating = 3; * musicTrackEN.CommunityRating = 2; * musicTrackEN.Duration = 220; * musicTrackCEN.New_(musicTrackEN.Id, musicTrackEN.Format, musicTrackEN.Lyrics, musicTrackEN.Name, * musicTrackEN.Company, musicTrackEN.Cover, musicTrackEN.CommunityRating, musicTrackEN.Rating, * musicTrackEN.Price, musicTrackEN.Duration); * musicTracks.Add(musicTrackEN); * musicTrackCEN.AsignUser(musicTrackEN.Id,userEN.Email); * * //Add Music Track3 * musicTrackEN = new PersonalHomeGenNHibernate.EN.Mediaplayer.MusicTrackEN(); * musicTrackEN.Id = "http://www.goear.com/files/sst5/mp3files/12062009/833734cbbb8d43bb5393c18793783e6d.mp3"; * musicTrackEN.Format = "mp3"; * musicTrackEN.Lyrics = ""; * musicTrackEN.Name = "I Gotta Feeling"; * musicTrackEN.Company = "Company 3"; * musicTrackEN.Cover = "http://www.nuncamas.org/images_post/0981248470.jpg"; * musicTrackEN.Price = 14; * musicTrackEN.Rating = 4; * musicTrackEN.CommunityRating = 5; * musicTrackEN.Duration = 180; * musicTrackCEN.New_(musicTrackEN.Id, musicTrackEN.Format, musicTrackEN.Lyrics, musicTrackEN.Name, * musicTrackEN.Company, musicTrackEN.Cover, musicTrackEN.CommunityRating, musicTrackEN.Rating, * musicTrackEN.Price, musicTrackEN.Duration); * musicTracks.Add(musicTrackEN); * musicTrackCEN.AsignUser(musicTrackEN.Id,userEN.Email); * * //Add Music Track4 * musicTrackEN = new PersonalHomeGenNHibernate.EN.Mediaplayer.MusicTrackEN(); * musicTrackEN.Id = "http://www.goear.com/files/sst5/mp3files/31052010/50c15dc1018ea9dcec455d7b78e7889c.mp3"; * musicTrackEN.Format = "mp3"; * musicTrackEN.Lyrics = ""; * musicTrackEN.Name = "Waka Waka World Cup 2010"; * musicTrackEN.Company = "Company 4"; * musicTrackEN.Cover = "http://carris.files.wordpress.com/2010/03/logosudafrica2010.jpg"; * musicTrackEN.Price = 22; * musicTrackEN.Rating = 5; * musicTrackEN.CommunityRating = 5; * musicTrackEN.Duration = 189; * musicTrackCEN.New_(musicTrackEN.Id, musicTrackEN.Format, musicTrackEN.Lyrics, musicTrackEN.Name, * musicTrackEN.Company, musicTrackEN.Cover, musicTrackEN.CommunityRating, musicTrackEN.Rating, * musicTrackEN.Price, musicTrackEN.Duration); * musicTracks.Add(musicTrackEN); * musicTrackCEN.AsignUser(musicTrackEN.Id,userEN.Email); * * //Add PlayList 1 * int idPlayList = playListCEN.New_("List1", "This is my playList 1", "Rock", userEN); * //Define tracks to Add to PlayList 1 * List<String> tracks = new List<string>(); * tracks.Add("http://www2.b3ta.com/mp3/Beer Beer Beer (YOB mix).mp3"); * tracks.Add("http://www.goear.com/files/sst5/mp3files/12062009/833734cbbb8d43bb5393c18793783e6d.mp3"); * tracks.Add("http://www.goear.com/files/sst5/mp3files/31052010/50c15dc1018ea9dcec455d7b78e7889c.mp3"); * //Add Songs to PlayList 1 * playListCEN.AddMusicTrack(idPlayList, tracks); * * //Add PlayList 2 * idPlayList = playListCEN.New_("List2", "This is my playList 2", "Pop", userEN); * //Define tracks to Add to PlayList 2 * tracks = new List<string>(); * tracks.Add("http://www.goear.com/files/sst2/mp3files/01122006/681dabd7c2c03aad5f10a13abaa61f95.mp3"); * tracks.Add("http://www.goear.com/files/sst5/mp3files/12062009/833734cbbb8d43bb5393c18793783e6d.mp3"); * tracks.Add("http://www.goear.com/files/sst5/mp3files/31052010/50c15dc1018ea9dcec455d7b78e7889c.mp3"); * //Add Songs to PlayList 2 * playListCEN.AddMusicTrack(idPlayList, tracks); * * //Add PlayList 2 * idPlayList = playListCEN.New_("List2", "This is my playList 2", "Pop", userEN); * //Define tracks to Add to PlayList 2 * tracks = new List<string>(); * tracks.Add("http://www.goear.com/files/sst2/mp3files/01122006/681dabd7c2c03aad5f10a13abaa61f95.mp3"); * tracks.Add("http://www.goear.com/files/sst5/mp3files/12062009/833734cbbb8d43bb5393c18793783e6d.mp3"); * tracks.Add("http://www.goear.com/files/sst5/mp3files/31052010/50c15dc1018ea9dcec455d7b78e7889c.mp3"); * //Add Songs to PlayList 2 * playListCEN.AddMusicTrack(idPlayList, tracks); * * //Add PlayList 3 * idPlayList = playListCEN.New_("List3", "This is my playList 3", "Pop", userEN); * //Define tracks to Add to PlayList 3 * tracks = new List<string>(); * tracks.Add("http://www.goear.com/files/sst2/mp3files/01122006/681dabd7c2c03aad5f10a13abaa61f95.mp3"); * tracks.Add("http://www2.b3ta.com/mp3/Beer Beer Beer (YOB mix).mp3"); * tracks.Add("http://www.goear.com/files/sst5/mp3files/31052010/50c15dc1018ea9dcec455d7b78e7889c.mp3"); * //Add Songs to PlayList 3 * playListCEN.AddMusicTrack(idPlayList, tracks); * * * //Define Artist 1 * List<PersonalHomeGenNHibernate.EN.Mediaplayer.ArtistEN> artists = new List<PersonalHomeGenNHibernate.EN.Mediaplayer.ArtistEN>(); * artistEN.Id = 1; * artistEN.Name = "Youth of Britain"; * artists.Add(artistEN); * artistCEN.New_(artistEN.Id, artistEN.Name); * tracks = new List<string>(); * tracks.Add("http://www2.b3ta.com/mp3/Beer Beer Beer (YOB mix).mp3"); * artistCEN.AsignTrack(artistEN.Id, tracks); * //Define Artist 2 * artistEN = new PersonalHomeGenNHibernate.EN.Mediaplayer.ArtistEN(); * artistEN.Id = 2; * artistEN.Name = "Vangelis"; * artists.Add(artistEN); * artistCEN.New_(artistEN.Id, artistEN.Name); * tracks = new List<string>(); * tracks.Add("http://www.goear.com/files/sst2/mp3files/01122006/681dabd7c2c03aad5f10a13abaa61f95.mp3"); * artistCEN.AsignTrack(artistEN.Id, tracks); * //Define Artist 3 * artistEN = new PersonalHomeGenNHibernate.EN.Mediaplayer.ArtistEN(); * artistEN.Id = 3; * artistEN.Name = "Black Eyed Peas"; * artists.Add(artistEN); * artistCEN.New_(artistEN.Id, artistEN.Name); * tracks = new List<string>(); * tracks.Add("http://www.goear.com/files/sst5/mp3files/12062009/833734cbbb8d43bb5393c18793783e6d.mp3"); * artistCEN.AsignTrack(artistEN.Id, tracks); * //Define Artist 4 * artistEN = new PersonalHomeGenNHibernate.EN.Mediaplayer.ArtistEN(); * artistEN.Id = 4; * artistEN.Name = "Shakira"; * artists.Add(artistEN); * artistCEN.New_(artistEN.Id, artistEN.Name); * tracks = new List<string>(); * tracks.Add("http://www.goear.com/files/sst5/mp3files/31052010/50c15dc1018ea9dcec455d7b78e7889c.mp3"); * artistCEN.AsignTrack(artistEN.Id, tracks); * * //Define Album * //PersonalHomeGenNHibernate.CEN.Mediaplayer.AlbumCEN albumCEN = new PersonalHomeGenNHibernate.CEN.Mediaplayer.AlbumCEN(); * //albumCEN.New_("Album 1", "This is a Album 1", artists, musicTracks);*/ /*PROTECTED REGION END*/ } catch (Exception ex) { throw ex; } }