public List <Cliente> GetClientes()
{
List <Cliente> result = new List <Cliente>();
try
{
this.cnn = new Conexion();
using (DataTable dt = cnn.GetTable("SELECT * FROM clientes WITH(NOLOCK) WHERE id_cliente > 0 AND estatus = 1"))
{
if (dt != null && dt.Rows.Count > 0)
{
result.AddRange(dt.AsEnumerable().Select(x => new Cliente(x)));
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(result);
}
public List <Contacto> GetContactos(int id_cliente)
{
List <Contacto> result = new List <Contacto>();
try
{
this.cnn = new Conexion();
using (DataTable dt = cnn.GetTable(string.Format("SELECT * FROM contactos WITH(NOLOCK) WHERE id_contacto > 0 AND id_cliente = {0} AND estatus = 1", id_cliente)))
{
if (dt != null && dt.Rows.Count > 0)
{
result.AddRange(dt.AsEnumerable().Select(x => new Contacto(x)));
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(result);
}
