public List <ArtistEE> ListarArtists() { DataSet DS = new DataSet(); List <ArtistEE> ListaArtist = new List <ArtistEE>(); DS = this.oDatos.Leer("sp_Artists_Listar", null); if (DS.Tables[0].Rows.Count > 0) { foreach (DataRow Item in DS.Tables[0].Rows) { ArtistEE oCli = new ArtistEE { Id = int.Parse(Item["Id"].ToString()), FirstName = Item["FirstName"].ToString(), LastName = Item["LastName"].ToString(), LifeSpan = Item["LifeSpan"].ToString(), Country = Item["Country"].ToString(), Description = Item["Description"].ToString() }; ListaArtist.Add(oCli); } return(ListaArtist); } else { return(null); } }
public bool Operacion(ArtistEE oArtistEE, int op) { var hdatos = new Hashtable(); string consulta; switch (op) { case 1: consulta = "sp_Artist_Insert"; break; case 2: consulta = "sp_Artist_Update"; break; case 3: consulta = "sp_Artist_Delete"; break; default: consulta = null; break; } if (op != 1) { if (oArtistEE.Id.HasValue) { hdatos.Add("@Id", oArtistEE.Id); } } if (op != 3) { hdatos.Add("@FirstName", oArtistEE.FirstName); hdatos.Add("@LastName", oArtistEE.LastName); hdatos.Add("@LifeSpan", oArtistEE.LifeSpan); hdatos.Add("@Country", oArtistEE.Country); hdatos.Add("@Description", oArtistEE.Description); } return(this.oDatos.Escribir(consulta, hdatos)); }
public bool Operacion(ArtistEE oArtistEE, int op) { ArtistMPP oArtMPP = new ArtistMPP(); return(oArtMPP.Operacion(oArtistEE, op)); }