/// <summary>
/// Constuctor sin parametros
/// </summary>
public Especial()
{
Data.dsFacturaTableAdapters.FacturasHeaderTableAdapter Adapter1 = new Data.dsFacturaTableAdapters.FacturasHeaderTableAdapter();
this.FacturasCount = (int) Adapter1.CountFacturas();
Data.dsClienteTableAdapters.ClienteTableAdapter Adapter2 =
new Data.dsClienteTableAdapters.ClienteTableAdapter();
this.ClientesCount = (int)Adapter2.CountClientes();
Data.dsEmpleadoTableAdapters.EmpleadoTableAdapter Adapter3 =
new Data.dsEmpleadoTableAdapters.EmpleadoTableAdapter();
this.EmpleadosSuma = (int) Adapter3.SumEmpleados();
Data.dsProductoTableAdapters.ProductosTableAdapter Adapter4 = new Data.dsProductoTableAdapters.ProductosTableAdapter();
this.ProductosSum = (int) Adapter4.SumProductosInv();
}
/// <summary>
/// Constructor con parametros
/// </summary>
/// <param name="idCliente"></param>
public Cliente(int idCliente)
{
Data.dsClienteTableAdapters.ClienteTableAdapter Adapter = new Data.dsClienteTableAdapters.ClienteTableAdapter();
//Data.dsProductoTableAdapters.ProductosTableAdapter Adapter = new Data.dsProductoTableAdapters.ProductosTableAdapter();
Data.dsCliente.ClienteDataTable dt = Adapter.SelectCliente(idCliente);
if (dt.Rows.Count > 0)
{
Data.dsCliente.ClienteRow dr = dt[0];
this.idCliente = dr.idCliente;
if (!dr.IscRepresentanteNull())
this.cRepresentante = dr.cRepresentante;
if (!dr.IscEmpresaNull())
this.cEmpresa = dr.cEmpresa;
if (!dr.IscEmailNull())
this.cEmail = dr.cEmail;
if (!dr.IscTelefonoNull())
this.cTelefono = dr.cTelefono;
if (!dr.IsnDescuentoNull())
this.nDescuento = dr.nDescuento;
if (!dr.IscRNCNull())
this.cRNC = dr.cRNC;
}
}
/// <summary>
/// Actualiza el cliente a la DB
/// </summary>
public void UpdateCliente()
{
Data.dsClienteTableAdapters.ClienteTableAdapter Adapter = new Data.dsClienteTableAdapters.ClienteTableAdapter();
Adapter.UpdateCliente(this.idCliente, this.cRepresentante, this.cEmpresa, this.cEmail, this.cTelefono, this.nDescuento, this.cRNC);
}
/// <summary>
/// Genera la lista de productos de la DB
/// </summary>
/// <returns></returns>
public static List<Cliente> GetListaClientes()
{
List<Cliente> listaClientes = new List<Cliente>();
Data.dsClienteTableAdapters.ClienteTableAdapter Adapter = new Data.dsClienteTableAdapters.ClienteTableAdapter();
Data.dsCliente.ClienteDataTable dt = Adapter.SelectListaClientes();
foreach (var dr in dt)
{
Cliente item = new Cliente();
item.idCliente = dr.idCliente;
if (!dr.IscRepresentanteNull())
item.cRepresentante = dr.cRepresentante;
if (!dr.IscEmpresaNull())
item.cEmpresa = dr.cEmpresa;
if (!dr.IscEmailNull())
item.cEmail = dr.cEmail;
if (!dr.IscTelefonoNull())
item.cTelefono = dr.cTelefono;
if (!dr.IsnDescuentoNull())
item.nDescuento = dr.nDescuento;
if (!dr.IscRNCNull())
item.cRNC = dr.cRNC;
listaClientes.Add(item);
}
return listaClientes;
}
/// <summary>
/// Elimina el cliente de la DB
/// </summary>
/// <param name="idCliente"></param>
public static void DeleteCliente(int idCliente)
{
Data.dsClienteTableAdapters.ClienteTableAdapter Adapter = new Data.dsClienteTableAdapters.ClienteTableAdapter();
Adapter.DeleteCliente(idCliente);
}
/// <summary>
/// Genera la lista de productos de la DB
/// </summary>
/// <returns></returns>
public static List<SelectListItem> GetListaClientes()
{
List<SelectListItem> listaClientes = new List<SelectListItem>();
Data.dsClienteTableAdapters.ClienteTableAdapter Adapter = new Data.dsClienteTableAdapters.ClienteTableAdapter();
Data.dsCliente.ClienteDataTable dt = Adapter.SelectListaClientes();
foreach (var dr in dt)
{
SelectListItem item = new SelectListItem();
item.Value = dr.idCliente.ToString().Trim();
if (!dr.IscEmpresaNull())
item.Text = "[" + item.Value + "] " + dr.cEmpresa;
listaClientes.Add(item);
}
return listaClientes;
}
