public override bool Insertar() { bool retorno = false; StringBuilder comando = new StringBuilder(); retorno = conexion.Ejecutar(string.Format("Insert into Peliculas(Titulo,Descripcion,Ano,Calificacion,IMDB,CategoriaId,Imagen,Video,Estudio) values('{0}','{1}',{2},{3},{4},{5},'{6}','{7}','{8}') ", this.Titulo, this.Descripcion, this.Ano, this.Calificacion, this.IMDB, this.CategoriaId, this.Imagen, this.Video, this.Estudio)); if (retorno) { this.PeliculaId = (int)conexion.ObtenerDatos("Select Max(PeliculaId) as PeliculaId from Peliculas").Rows[0]["PeliculaId"]; foreach (var actor in this.Actor) { comando.AppendLine(string.Format("Insert into PeliculasActores(PeliculaId,ActorId) values({0},{1})", this.PeliculaId, actor.ActorId)); } foreach (var genero in this.Genero) { comando.AppendLine(string.Format("Insert into PeliculasGeneros(PeliculaId,GeneroId) values({0},{1})", this.PeliculaId, genero.GeneroId)); } retorno = conexion.Ejecutar(comando.ToString()); } return(retorno); }
public override bool Editar() { bool retorno = false; StringBuilder comando = new StringBuilder(); Conexion conexion = new Conexion(); retorno = conexion.Ejecutar(string.Format("update Peliculas set Titulo = '{0}',Descripcion = '{1}',Ano = '{2}', Calificacion = '{3}',IMDB = '{4}' where PeliculaId = '{5}'", Titulo, Descripcion, Ano, Calificacion, IMDB, this.PeliculaId)); if (retorno) { conexion.Ejecutar("Delete from PeliculasActores where PeliculaId =" + this.PeliculaId); conexion.Ejecutar("Delete from PeliculasGeneros where PeliculaId =" + this.PeliculaId); foreach (var actor in this.Actor) { comando.AppendLine(string.Format("Insert into PeliculasActores(PeliculaId,ActorId) values({0},{1});", this.PeliculaId, actor.ActorId)); } foreach (var genero in this.Genero) { comando.AppendLine(string.Format("Insert into PeliculasGeneros(PeliculaId,GeneroId) values({0},{1});", this.PeliculaId, genero.GeneroId)); } retorno = conexion.Ejecutar(comando.ToString()); } return(retorno); }
public override bool Insertar() { bool retorno = false; try { retorno = conexion.Ejecutar(String.Format("Insert into DestinosExportes(Pais, CodigoDestino, NombreDestino, Direccion, CodigoPostal) Values('{0}', '{1}', '{2}', '{3}', {4})", this.Pais, this.CodigoDestino, this.NombreDestino, this.Direccion, this.CodigoPostal)); } catch (Exception ex) { throw ex; } return(retorno); }
public override bool Eliminar() { bool retorno = false; try { retorno = conexion.Ejecutar(String.Format("Delete from Certificaciones where CertificacionId={0}", this.CertificacionID)); } catch (Exception ex) { throw ex; } return(retorno); }
public override bool Insertar() { bool retorno = false; try { retorno = conexion.Ejecutar(String.Format("insert into Recepcionnes(socioId, CodigoLote, LoteId, CertificacionId, TipoCacaoId, Fecha, CantidadesPesada, Observacion, RecibidoPor) values({0}, '{1}',{2}, {3}, {4}, '{5}', {6}, '{7}','{8}')", this.SocioId, this.CodigoLote, this.LoteId, this.CertificacionId, this.TipoCacaoId, this.Fecha, this.CantidadPesada, this.Observacion, this.RecibidoPor)); } catch (Exception ex) { throw ex; } return(retorno); }
public override bool Borrar() { bool retorno = false; try { retorno = conexion.Ejecutar(String.Format("Delete from Inspecciones where InspeccionesId={0}", this.InspeccionId)); } catch (Exception ex) { throw ex; } return(retorno); }
public override bool Insertar() { bool retorno = false; try { retorno = con.Ejecutar(String.Format("Insert Into RegistroUsuarios(Nombre, Apellido, Direccion, Cedula, sexo, Clave) values('{0}', '{1}', '{2}', '{3}', {4}, '{5}')", this.Nombre, this.Apellido, this.Direccion, this.Cedula, this.sexo, this.Clave)); } catch (Exception ex) { throw ex; } return(retorno); }
public bool Insertar() { bool retorno = false; try { retorno = conexion.Ejecutar(String.Format("Insert Into Cuentas(Balance, Descripcion) Values({0},'{1}')", this.Balance, this.Descripcion)); } catch (Exception ex) { throw ex; } return(retorno); }
public override bool Insertar() { bool retorno = false; try { retorno = conexion.Ejecutar(String.Format("Insert Into Inspecciones(InspeccionId, SocioId, Fecha, Fertilizantes, MaterialSiembra, CrianzaAnimales, ControlPlagas, ResumenInspeccion) Values({0}, {1}, '{2}', {3}, '{4}', {5}, '{6}', '{7}')", this.SocioId, this.Fecha, this.Fertilizantes, this.MaterialSiembra, this.CrianzaAnimales, this.ControlPlagas, this.ResumenInspeccion)); } catch (Exception ex) { throw ex; } return(retorno); }
public override bool Insertar() { bool retorno = false; try { retorno = conexion.Ejecutar(String.Format("Insert Into Usuarios(Nombres, Apellidos, Direccion, NombreUsuario, Contrasena, Contrasena1) Values('{0}', '{1}', '{2}', '{3}', '{4}', '{5}')", this.Nombre, this.Apellido, this.Direccion, this.NombreUsuario, this.Contrasena, this.Contrasena1)); } catch (Exception ex) { throw ex; } return(retorno); }
public override bool Insertar() { bool retorno = false; try { retorno = conexion.Ejecutar(String.Format("Insert Into TiposCacao(Descripcion) Values('{0}')", this.Descripcion)); } catch (Exception ex) { throw ex; } return(retorno); }
public override bool Insertar() { bool retorno = false; try { retorno = conexion.Ejecutar(String.Format("Insert Into Socios(Nombre, Apellido, Direccion, Cedula, CertificacionId, CantidadTerreno, Fertilizantes) Values('{0}', '{1}', '{2}', {3}, {4}, {5}, {6})", this.Nombre, this.Apellido, this.Direccion, this.Cedula, this.CertificacionId, this.CantidadTerreno, this.Fertilizantes)); } catch (Exception ex) { throw ex; } return(retorno); }
public override bool Insertar() { StringBuilder comando = new StringBuilder(); bool retorno = false; try { retorno = conexion.Ejecutar(String.Format("Insert Into Lotes(CodigoLote, Total, CertificacionId, Fecha) values('{0}', {1}, {2}, '{3}')", this.CodigoLote, this.Total, this.CertificacionId, this.Fecha)); } catch (Exception ex) { throw ex; } return(retorno); }
public override bool Eliminar() { bool retorno = false; Conexion conexion = new Conexion(); retorno = conexion.Ejecutar("delete from Peliculas where PeliculaId =" + this.PeliculaId + "; " + "Delete from PeliculasActores where PeliculaId=" + this.PeliculaId + "; " + "Delete from PeliculasGeneros where PeliculaId=" + this.PeliculaId); return(retorno); }
public override bool Insert() { bool retorno = false; StringBuilder Comando = new StringBuilder(); try { retorno = con.Ejecutar(String.Format("Insert Into Registro(titulo, Descripcion, Ano, calificacion, IMDB, CategoriaId, Estudio) Values('{0}','{1}', {2}, {3}, {4}, {5}, '{6}')", this.Titulo, this.Descripcion, this.Ano, this.Calificacion, this.IMDB, this.CategoriapId, this.Estudio)); if (retorno) { this.PeliculaId = (int)con.getDatos("Select Max(PeliculaId) as PeliculaId from Registro").Rows[0]["PeliculaId"]; foreach (var autor in this.Actores) { Comando.AppendLine(String.Format("insert into PeliculasActores(PeliculaId,ActorId) Values({0},{1});", this.PeliculaId, autor.ActorId)); } retorno = con.Ejecutar(Comando.ToString()); } return(retorno); } catch (Exception) { return(false); } }
public override bool Insertar() { bool retorno = false; StringBuilder Comando = new StringBuilder(); try { retorno = conexion.Ejecutar(String.Format("Insert into Exportaciones(DestinoId, Monto, Fecha, Resumen) values({0}, {1}, '{2}', '{3}')", this.DestinoId, this.Monto, this.Fecha, this.Resumen)); if (retorno) { this.ExportacionId = (int)conexion.getDatos("Select Max(ExportacionId) as ExportacionId from Exportaciones").Rows[0]["ExportacionId"]; foreach (var lote in this.Lotes) { Comando.AppendLine(String.Format("Insert Into LotesExportes(LoteId, CodigoLote, ExportacionId) Values({0},'{1}', {2})", lote.LoteId, lote.CodigoLote, this.ExportacionId)); } retorno = conexion.Ejecutar(Comando.ToString()); } } catch (Exception ex) { throw ex; } return(retorno); }
public override bool Insertar() { bool retorno = false; DataTable dt = new DataTable(); try { retorno = conexion.Ejecutar(String.Format("insert into Recepciones(SocioId, LoteId, TipoCacaoId, Fecha, CantidadPesada, Monto, Observacion, RecibidoPor) values({0}, {1}, {2}, '{3}', {4}, {5}, '{6}', '{7}')", this.SocioId, this.LoteId, this.TipoCacaoId, this.Fecha, this.CantidadPesada, this.Monto, this.Observacion, this.RecibidoPor)); conexion.Ejecutar(String.Format("update Lotes set Total=Total + " + this.CantidadPesada + " where LoteId=" + this.LoteId)); } catch (Exception ex) { throw ex; } return(retorno); }
public override bool Insertar() { bool retorno = false; StringBuilder Comando = new StringBuilder(); retorno = conexion.Ejecutar(String.Format("insert into Personas(Nombres,Apellidos,EstadoCivil) value('" + Nombres + "', " + Apellidos + "', '" + EstadoCivil + "')")); if (retorno) { this.PersonaId = (int)conexion.ObtenerValor("Select Max(PersonaId) from Personas"); foreach (var tel in this.Telefonos) { Comando.AppendLine(String.Format("insert into PersonasTelefonos(PersonaId,Numero) Values('" + this.PersonaId + "', '" + tel.Numero + "');")); } retorno = conexion.Ejecutar(Comando.ToString()); } return(retorno); }
public override bool Eliminar() { Conexion conexion = new Conexion(); return(conexion.Ejecutar(string.Format("Delete from Actores where ActorId = {0}", this.ActorId))); }
public override bool Insert() { return(con.Ejecutar(String.Format("Insert Into Estudios (Nombre) values('{0}')", this.Nombre))); }
public override bool Editar() { Conexion conexion = new Conexion(); return(conexion.Ejecutar(string.Format("Update Estudios set Nombre = '{0}' where EstudioId = '{1}'", this.Nombre, this.EstudioId))); }
public override bool Insert() { return(con.Ejecutar(String.Format("Insert Into Generos (Descripcion) Values('{0}')", this.Descripcion))); }
public override bool Insertar() { Conexion conexion = new Conexion(); return(conexion.Ejecutar(string.Format("Insert into Generos (Descripcion) values('{0}')", this.Descripcion))); }
public override bool Editar() { Conexion conexion = new Conexion(); return(conexion.Ejecutar(string.Format("Update Generos set Descripcion = '{0}' where GeneroId = {1}", this.Descripcion, this.GeneroId))); }
public override bool Eliminar() { Conexion conexion = new Conexion(); return(conexion.Ejecutar("Delete from Generos where GeneroId = " + this.GeneroId)); }
public override bool Insertar() { Conexion conexion = new Conexion(); return(conexion.Ejecutar(string.Format("Insert into Estudios(Nombre) values('{0}')", this.Nombre))); }
public override bool Eliminar() { Conexion conexion = new Conexion(); return(conexion.Ejecutar(string.Format("Delete from Estudios where EstudioId = {0}", this.EstudioId))); }
public override bool Insert() { return(con.Ejecutar(String.Format("insert into Actores (Nombre) Values('{0}')", this.Nombre))); }