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