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)));
}
