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