private void limpiarDatosFil()
{
datosForm = new pojoDVD(-1, -1, "", "", new DateTime(1900, 01, 01), "", "", "", "", -1, -1);
tbCopSegFil.Text = "";
tbEditadorPorFil.Text = "";
tbEstuchesFil.Text = "";
dtpFechaFil.Value = DateTime.Today;
tbIdDvdFil.Text = "";
tbPartesFil.Text = "";
tbSeriesFilDvd.Text =
tbSubtituloFil.Text = "";
tbTituloDvdFil.Text = "";
limpiarMenu();
limpiarRbBR();
}
private void limpiarDatosEd()
{
datosForm = new pojoDVD(-1, -1, "", "", new DateTime(1900, 01, 01), "", "", "", "", -1, -1);
tbCopSegEd.Text = "";
tbEditadoPorEd.Text = "";
tbEstuchesEd.Text = "";
dtpFechaED.Value = DateTime.Today;
tbIdDvdEd.Text = "";
tbPartesEd.Text = "";
tbSeriesEd.Text = "";
tbSubtituloEd.Text = "";
tbTituloEd.Text = "";
rbCopiaBRFEd.Checked = false;
rbCopiaBRVEd.Checked = false;
rbMenuFEd.Checked = false;
rbMenuVEd.Checked = false;
lblMensajesEd.Text = "";
}
private Boolean esta(pojoDVD dvd)
{
Boolean es = false;
DataTable x = null;
OleDbCommand command = null;
OleDbDataAdapter adapter = null;
if (dvd.idDvd > 0)
{
selectCustomSql = selectCustomSql + " AND id_Dvd=" + dvd.idDvd;
}
if (!dvd.titulo.Equals(""))
{
selectCustomSql = selectCustomSql + " AND titulo = '" + dvd.titulo + "'";
}
if (!dvd.subtitulo.Equals(""))
{
selectCustomSql = selectCustomSql + " AND subtitulo = '" + dvd.subtitulo + "'";
}
if (dvd.copiaBR == 0)
{
selectCustomSql = selectCustomSql + " AND copia_BluRay=" + "false";
}
else
{
if (dvd.copiaBR == 1)
{
selectCustomSql = selectCustomSql + " AND copia_BluRay=" + "true";
}
}
if (dvd.partes > -1)
{
selectCustomSql = selectCustomSql + " AND partes=" + dvd.partes;
}
if (!dvd.series.Equals(""))
{
selectCustomSql = selectCustomSql + " AND series = '" + dvd.series + "'";
}
if (!dvd.copiaSeg.Equals(""))
{
selectCustomSql = selectCustomSql + " AND copia_seg = '" + dvd.copiaSeg + "'";
}
if (dvd.menuHecho == 0)
{
selectCustomSql = selectCustomSql + " AND Menu_Hecho=" + "false";
}
else
{
if (dvd.menuHecho == 1)
{
selectCustomSql = selectCustomSql + " AND Menu_Hecho=" + "true";
}
}
if (!dvd.editadoPor.Equals(""))
{
selectCustomSql = selectCustomSql + " AND Editado_Por = '" + dvd.editadoPor + "'";
}
if (!dvd.estuches.Equals(""))
{
selectCustomSql = selectCustomSql + " AND estuches = '" + dvd.estuches + "'";
}
command = new OleDbCommand(selectCustomSql, conn);
adapter = new OleDbDataAdapter(command);
x = new DataTable();
adapter.Fill(x);
if (x.Rows.Count > 0)
{
es = true;
}
return(es);
}
private void inicializarDatosForm()
{
datosForm = new pojoDVD(-1, -1, "", "", new DateTime(1900, 01, 01), "", "", "", "", -1, -1);
}
