예제 #1
0
    public static List <Cliente> GetListaClientesVendedores()
    {
        List <Cliente> theList = new List <Cliente>();
        Cliente        theData = null;

        try
        {
            ClienteDSTableAdapters.ClienteTableAdapter localAdapter = new ClienteDSTableAdapters.ClienteTableAdapter();
            ClienteDS.ClienteDataTable table = localAdapter.GetListaClientes();

            if (table != null && table.Rows.Count > 0)
            {
                foreach (var row in table)
                {
                    theData = FillReccord(row);
                    if (theData.EsVendedor)
                    {
                        theList.Add(theData);
                    }
                }
            }
        }
        catch (Exception q)
        {
            throw new ArgumentException(q.Message, q);
        }

        return(theList);
    }
예제 #2
0
        public static Cliente GetCLienteByNit(int clienteId)
        {
            if (clienteId <= 0)
            {
                throw new ArgumentException("El Nit del contacto no puede ser menor o igual que cero");
            }

            CapaDatos.ClienteDSTableAdapters.ClienteTableAdapter adapter = new CapaDatos.ClienteDSTableAdapters.ClienteTableAdapter();
            ClienteDS.ClienteDataTable table = adapter.GetClienteById(clienteId);
            Cliente obj = getCLienteFromRow(table[0]);

            return(obj);
        }
예제 #3
0
        public static List <Cliente> GetCliente( )
        {
            CapaDatos.ClienteDSTableAdapters.ClienteTableAdapter adapter = new CapaDatos.ClienteDSTableAdapters.ClienteTableAdapter();
            ClienteDS.ClienteDataTable table = adapter.GetCliente();

            List <Cliente> list = new List <Cliente>();

            foreach (var row in table)
            {
                Cliente obj = getCLienteFromRow(row);
                list.Add(obj);
            }
            return(list);
        }
예제 #4
0
    public static Cliente GetClienteById(int ClienteId)
    {
        Cliente theData = null;

        try
        {
            ClienteDSTableAdapters.ClienteTableAdapter localAdapter = new ClienteDSTableAdapters.ClienteTableAdapter();
            ClienteDS.ClienteDataTable table = localAdapter.GetClienteById(ClienteId);

            if (table != null && table.Rows.Count > 0)
            {
                ClienteDS.ClienteRow row = table[0];
                theData = FillReccord(row);
            }
        }
        catch (Exception q)
        {
            throw new ArgumentException(q.Message, q);
        }

        return(theData);
    }