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