public static tblClientes SelectById(int Cliente_ID)
{
tblClientesDSTableAdapters.Tbl_ClienteTableAdapter clienteAdapter = new tblClientesDSTableAdapters.Tbl_ClienteTableAdapter();
tblClientesDS.Tbl_ClienteDataTable tablaCliente = clienteAdapter.SelectById(Cliente_ID);
if (tablaCliente.Rows.Count == 0)
{
return null;
}
return rowToDto(tablaCliente[0]);
}
public static List<tblClientes> SelectAll()
{
List<tblClientes> listaCliente = new List<tblClientes>();
tblClientesDSTableAdapters.Tbl_ClienteTableAdapter clienteAdapter = new tblClientesDSTableAdapters.Tbl_ClienteTableAdapter();
tblClientesDS.Tbl_ClienteDataTable tablaCliente = clienteAdapter.SelectAll();
foreach (tblClientesDS.Tbl_ClienteRow row in tablaCliente)
{
listaCliente.Add(rowToDto(row));
}
return listaCliente;
}
public static void Update(string Nombre, string Apellido, string Direccion, string Telefono, string Documento, string Pais, int ClienteID)
{
tblClientesDSTableAdapters.Tbl_ClienteTableAdapter clienteAdapter = new tblClientesDSTableAdapters.Tbl_ClienteTableAdapter();
clienteAdapter.Update(Nombre, Apellido, Direccion, Telefono, Documento, Pais, ClienteID);
}
public static void Insert(string Nombre, string Apellido, string Direccion, string Telefono, string Documento, string Pais)
{
tblClientesDSTableAdapters.Tbl_ClienteTableAdapter clienteAdapter = new tblClientesDSTableAdapters.Tbl_ClienteTableAdapter();
clienteAdapter.Insert(Nombre, Apellido, Direccion, Telefono, Documento, Pais);
}
public static void Delete(int ClienteID)
{
tblClientesDSTableAdapters.Tbl_ClienteTableAdapter clienteAdapter = new tblClientesDSTableAdapters.Tbl_ClienteTableAdapter();
clienteAdapter.Delete(ClienteID);
}