public List<ClientModel> GetClientList(ClientModel client) { try { using (FacturandoEntities context = new FacturandoEntities()) { return context.Client .Where(x => x.IdIdentificationType == client.IdIdentificationType && x.IdentificationNumber.Equals(client.IdentificationNumber)) .Select(x => new ClientModel { Id = x.Id, IdentificationNumber = x.IdentificationNumber, IdIdentificationType = x.IdIdentificationType.Value, Adress = x.Address, DiscountPercent = x.DisccountPercent, Email = x.Email, Name = x.Name, Phone = x.Phone, DateEvent = x.DateEvent != null ? x.DateEvent.Value : DateTime.MinValue }).ToList(); } } catch (Exception) { throw; } }
private void btnBuscarCliente_Click(object sender, EventArgs e) { if (cmbTipoIdentificacion.Items.Count > 0) { _client = _billData.GetClient(new ClientModel { IdIdentificationType = (Guid)cmbTipoIdentificacion.SelectedValue, IdentificationNumber = txtIdentificacionCliente.Text, Name = txtNombreCliente.Text }); if (_client != null) { _remission.IdClient = _client.Id; txtNombreCliente.Text = _client.Name; txtDireccion.Text = _client.Adress; txtEmail.Text = _client.Email; txtDescuentoCliente.Text = _client.DiscountPercent.ToString(); txtTelefono.Text = _client.Phone; txtIdentificacionCliente.Text = _client.IdentificationNumber; cmbTipoIdentificacion.SelectedValue = _client.IdIdentificationType; } else { MessageBox.Show("No encontramos un cliente con los datos de búsqueda, verique que esten correctos o diligencie los datos para crear un nuevo cliente"); } } else { MessageBox.Show("Error - Revise la configuración del sistema"); } }
public ClientModel GetClient(ClientModel client) { try { ClientModel result = new ClientModel(); using (FacturandoEntities context = new FacturandoEntities()) { if (!string.IsNullOrEmpty(client.Name)) { result = context.Client .Where(x => x.Name.ToLower().Contains(client.Name.ToLower())) .Select(x => new ClientModel { Id = x.Id, IdentificationNumber = x.IdentificationNumber, IdIdentificationType = x.IdIdentificationType.Value, Adress = x.Address, DiscountPercent = x.DisccountPercent, Email = x.Email, Name = x.Name, Phone = x.Phone, DateEvent = x.DateEvent != null ? x.DateEvent.Value : DateTime.MinValue }).ToList().FirstOrDefault(); } else { result = context.Client .Where(x => x.IdIdentificationType == client.IdIdentificationType && x.IdentificationNumber.Equals(client.IdentificationNumber)) .Select(x => new ClientModel { Id = x.Id, IdentificationNumber = x.IdentificationNumber, IdIdentificationType = x.IdIdentificationType.Value, Adress = x.Address, DiscountPercent = x.DisccountPercent, Email = x.Email, Name = x.Name, Phone = x.Phone, DateEvent = x.DateEvent != null ? x.DateEvent.Value : DateTime.MinValue }).ToList().FirstOrDefault(); } return result; } } catch (Exception) { throw; } }
public bool ClientExists(ClientModel client) { try { using (FacturandoEntities context = new FacturandoEntities()) { return context.Client.Any(x => x.IdentificationNumber.Equals(client.IdentificationNumber)); } } catch (Exception) { throw; } }
private void ClearControls() { _billData = new BillData(); _inventoryData = new InventoryData(); _client = null; _remissionDetail = new List<RemissionDetailModel>(); _remissionSaveModel = new RemissionSaveModel(); _remission = new RemissionModel { Id = Guid.NewGuid(), RemissionNumber = _remissionData.GetRemissionNumber(), DateEvent = DateTime.Now }; lblNumeroRemision.Text = _remission.RemissionNumber.ToString().PadLeft(8, '0'); lblGranTotal.Text = "$0,00"; txtSubTotal.Text = string.Format("{0:0.00}", 0.00); txtDescuentoFinal.Text = string.Format("{0:0.00}", 0.00); txtDescuentoCliente.Text = string.Format("{0:0.00}", 0.00); dtgDetalleRemision.DataSource = new List<RemissionDetailModel>(); txtIdentificacionCliente.Text = string.Empty; txtNombreCliente.Text = string.Empty; txtDireccion.Text = string.Empty; txtTelefono.Text = string.Empty; txtEmail.Text = string.Empty; txtCodigoBarras.Text = string.Empty; txtNombreProducto.Text = string.Empty; lstProducto.DataSource = new List<InventoryModel>(); btnRemitir.Enabled = false; }
private void clientEntityGet() { if (!string.IsNullOrEmpty(txtIdentificacionCliente.Text) && !string.IsNullOrEmpty(txtNombreCliente.Text)) { _client = new ClientModel { Id = Guid.NewGuid(), Adress = txtDireccion.Text, DiscountPercent = decimal.Parse(txtDescuentoCliente.Text), Email = txtEmail.Text, IdentificationNumber = txtIdentificacionCliente.Text, IdIdentificationType = (Guid)cmbTipoIdentificacion.SelectedValue, Name = txtNombreCliente.Text, Phone = txtTelefono.Text, IsNew = true }; } else { if (cmbTipoIdentificacion.Items.Count > 0) { _client = new ClientModel { Adress = txtDireccion.Text, DiscountPercent = decimal.Parse(txtDescuentoCliente.Text), Email = txtEmail.Text, IdentificationNumber = txtIdentificacionCliente.Text, IdIdentificationType = (Guid)cmbTipoIdentificacion.SelectedValue, Name = txtNombreCliente.Text, Phone = txtTelefono.Text, }; } else { MessageBox.Show("Error - revise la configuración del sistema"); } } }
private void ClearControls() { _billData = new BillData(); _inventoryData = new InventoryData(); _client = null; _billDetail = new List<BillDetailModel>(); _bill = new BillModel(); _billTaxes = new List<BillTaxesModel>(); _billSaveModel = new BillSaveModel(); _bill = new BillModel { Id = Guid.NewGuid(), BillNumber = _billData.GetBillNumber(), DateEvent = DateTime.Now }; lblNumeroFactura.Text = _bill.BillNumber.ToString().PadLeft(8, '0'); _billTaxes = _billData.GetBillTaxes(); _billTaxes.ForEach(x => x.IdBill = _bill.Id); dtgImpuestos.DataSource = _billTaxes; lblGranTotal.Text = "$0,00"; txtSubTotal.Text = string.Format("{0:0.00}", 0.00); txtDescuentoFinal.Text = string.Format("{0:0.00}", 0.00); txtDescuentoCliente.Text = string.Format("{0:0.00}", 0.00); dtgDetalleFactura.DataSource = new List<BillDetailModel>(); txtIdentificacionCliente.Text = string.Empty; txtNombreCliente.Text = string.Empty; txtDireccion.Text = string.Empty; txtTelefono.Text = string.Empty; txtEmail.Text = string.Empty; txtCodigoBarras.Text = string.Empty; txtNombreProducto.Text = string.Empty; lstProducto.DataSource = new List<InventoryModel>(); btnBuscarProducto.Enabled = false; btnFacturar.Enabled = false; }
private bool clientEntityGet() { bool result = false; if (txtIdentificacionCliente.Text.Equals(string.Empty) || txtNombreCliente.Text.Equals(string.Empty)) { MessageBox.Show("Faltan los datos del cliente para crear la factura, identificación y nombre"); } else { result = true; _client = new ClientModel { Id = Guid.NewGuid(), Adress = txtDireccion.Text, DiscountPercent = decimal.Parse(txtDescuentoCliente.Text), Email = txtEmail.Text, IdentificationNumber = txtIdentificacionCliente.Text, IdIdentificationType = (Guid)cmbTipoIdentificacion.SelectedValue, Name = txtNombreCliente.Text, Phone = txtTelefono.Text, IsNew = true }; _bill.IdClient = _client.Id; } return result; }