public DataSet BusquedaActividades(object obj)
{
string cadenaWhere = "";
bool edo = false;
AgendaBO data = (AgendaBO)obj;
cmd = new SQLiteCommand();
dsContactos = new DataSet();
da = new SQLiteDataAdapter();
con = new ConexionAgenda();
cmd.Connection = con.establecerConexion();
con.abrirConexion();
if (data.IdContacto > 0)
{
cadenaWhere = cadenaWhere + " idContacto=" + data.IdContacto + " and";
edo = true;
}
if (edo == true)
{
cadenaWhere = " WHERE " + cadenaWhere.Remove(cadenaWhere.Length - 3, 3);
}
sql = " SELECT * FROM RegistroActividades " + cadenaWhere;
cmd.CommandText = sql;
DataSet ds = new DataSet();
da.SelectCommand = cmd;
da.Fill(dsContactos);
con.cerrarConexion();
return(dsContactos);
}
public DataSet BusquedaContactos(object obj)
{
string cadenaWhere = "";
bool edo = false;
AgendaBO data = (AgendaBO)obj;
cmd = new SQLiteCommand();
dsContactos = new DataSet();
da = new SQLiteDataAdapter();
con = new ConexionAgenda();
cmd.Connection = con.establecerConexion();
con.abrirConexion();
if (data.IDagenda > 0)
{
cadenaWhere = cadenaWhere + " IDagenda=" + data.IDagenda + " and";
edo = true;
}
if (data.Nombre != null)
{
cadenaWhere = cadenaWhere + " Nombre=" + data.Nombre + " and";
edo = true;
}
if (data.Apellidos != null)
{
cadenaWhere = cadenaWhere + " Apellidos='" + data.Apellidos.Trim() + "' and";
edo = true;
}
if (data.Edad != null)
{
cadenaWhere = cadenaWhere + " Edad='" + data.Edad.Trim() + "' and";
edo = true;
}
if (data.Telefono != null)
{
cadenaWhere = cadenaWhere + " Telefono='" + data.Telefono.Trim() + "' and";
edo = true;
}
if (data.CorreoElectronico != null)
{
cadenaWhere = cadenaWhere + " CorreoElectronico='" + data.CorreoElectronico.Trim() + "' and";
edo = true;
}
if (edo == true)
{
cadenaWhere = " WHERE " + cadenaWhere.Remove(cadenaWhere.Length - 3, 3);
}
sql = " SELECT * FROM Agenda1 " + cadenaWhere;
cmd.CommandText = sql;
DataSet ds = new DataSet();
da.SelectCommand = cmd;
da.Fill(dsContactos);
con.cerrarConexion();
return(dsContactos);
}