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