//——————————————————————————————————————————————————————————————[ Guardar ]———————————————————————————————————————————————————————————————
private void GuardarButton_Click(object sender, RoutedEventArgs e)
{
{
if (!Validar())
{
return;
}
//———————————————————————————————————————————————————————[ VALIDAR SI ESTA VACIO ]———————————————————————————————————————————————————————
//—————————————————————————————————[ Nomina Id ]—————————————————————————————————
if (NominaIdTextBox.Text.Trim() == string.Empty)
{
MessageBox.Show("El Campo (Contacto Id) está vacío.\n\nPorfavor, Asigne un Id al Contacto.", "Advertencia", MessageBoxButton.OK, MessageBoxImage.Warning);
NominaIdTextBox.Text = "0";
NominaIdTextBox.Focus();
NominaIdTextBox.SelectAll();
return;
}
//———————————————————————————————————————————————————————[ VALIDAR SI ESTA VACIO - FIN ]———————————————————————————————————————————————————————
var paso = NominasBLL.Guardar(nominas);
if (paso)
{
Limpiar();
MessageBox.Show("El Registro se pudo guardar satisfactoriamente.", "Éxito", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
MessageBox.Show("El Registro no se pudo guardar :(", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
//——————————————————————————————————————————————————————————————[ Eliminar ]———————————————————————————————————————————————————————————————
private void EliminarButton_Click(object sender, RoutedEventArgs e)
{
{
if (NominasBLL.Eliminar(Utilidades.ToInt(NominaIdTextBox.Text)))
{
Limpiar();
MessageBox.Show("Registro Eliminado", "Éxito", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
MessageBox.Show("No se pudo eliminar el registro", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
//——————————————————————————————————————————————————————————————[ Buscar ]———————————————————————————————————————————————————————————————
private void BuscarButton_Click(object sender, RoutedEventArgs e)
{
Nominas encontrado = NominasBLL.Buscar(Utilidades.ToInt(NominaIdTextBox.Text));
if (encontrado != null)
{
this.nominas = encontrado;
Cargar();
}
else
{
this.nominas = new Nominas();
this.DataContext = this.nominas;
MessageBox.Show($"Este Contacto no fue encontrado.\n\nAsegúrese que existe o cree uno nuevo.", "Advertencia", MessageBoxButton.OK, MessageBoxImage.Warning);
Limpiar();
NominaIdTextBox.SelectAll();
NominaIdTextBox.Focus();
}
}
private void BtnCrear_Click(object sender, RoutedEventArgs e)
{
Directory.CreateDirectory("C:\\Nominas");
Nominas aux = new NominasBLL().CreateNomina();
List <Vehiculos> listado = new VehiculosBLL().GetVehiculosNomina(aux);
Microsoft.Office.Interop.Excel.Application excel;
Microsoft.Office.Interop.Excel.Workbook worKbooK;
Microsoft.Office.Interop.Excel.Worksheet worksheet;
Microsoft.Office.Interop.Excel.Range celLrangE;
excel = new Microsoft.Office.Interop.Excel.Application();
worKbooK = excel.Workbooks.Add(Type.Missing);
Microsoft.Office.Interop.Excel.Worksheet worKsheeT = (Microsoft.Office.Interop.Excel.Worksheet)worKbooK.ActiveSheet;
worKsheeT.Name = "Nomina de pago " + aux.IdNomina;
worKsheeT.Cells[1, 1] = "Rut";
worKsheeT.Cells[1, 2] = "Patente";
worKsheeT.Cells[1, 3] = "Fecha_vencimiento";
worKsheeT.Cells[1, 4] = "Nro_serie_documento";
worKsheeT.Cells[1, 5] = "Fecha_factura";
worKsheeT.Cells[1, 6] = "Fecha_emision_homologacion";
worKsheeT.Cells[1, 7] = "Valor_neto_factura";
worKsheeT.Cells[1, 8] = "Digito_verificador_patente";
worKsheeT.Cells[1, 9] = "Codigo_sii";
worKsheeT.Cells[1, 10] = "Ano";
worKsheeT.Cells[1, 11] = "Tasacion";
worKsheeT.Cells[1, 12] = "Motor";
worKsheeT.Cells[1, 13] = "Chasis";
worKsheeT.Cells[1, 14] = "Color";
worKsheeT.Cells[1, 15] = "Nro_asientos";
worKsheeT.Cells[1, 16] = "Tara";
worKsheeT.Cells[1, 17] = "Nombre_propietario";
worKsheeT.Cells[1, 18] = "Domicilio_propietario";
worKsheeT.Cells[1, 19] = "Comuna_propietario";
worKsheeT.Cells[1, 20] = "Telefono_propietario";
worKsheeT.Cells[1, 21] = "Sello_verde";
worKsheeT.Cells[1, 22] = "Fecha_plazo_homologacion";
worKsheeT.Cells[1, 23] = "Modelo";
worKsheeT.Cells[1, 24] = "Marca";
worKsheeT.Cells[1, 25] = "Tipo_vehiculo";
worKsheeT.Cells[1, 26] = "Cilindrada";
worKsheeT.Cells[1, 27] = "Combustible";
worKsheeT.Cells[1, 28] = "Transmision";
worKsheeT.Cells[1, 29] = "Equipamiento";
worKsheeT.Cells[1, 30] = "Nro_puertas";
worKsheeT.Cells[1, 31] = "Zona_franca";
worKsheeT.Cells[1, 32] = "Tonelaje";
int i = 2;
foreach (Vehiculos item in listado)
{
worKsheeT.Cells[i, 1] = item.Rut;
worKsheeT.Cells[i, 2] = item.Patente;
worKsheeT.Cells[i, 3] = item.FechaVencimiento.Value.ToString("dd/MM/yyyy");
worKsheeT.Cells[i, 4] = "";
if (item.FechaFactura.HasValue)
{
worKsheeT.Cells[i, 5] = item.FechaFactura.Value.ToString("dd/MM/yyyy");
}
if (item.FechaEmisionHomologacion.HasValue)
{
worKsheeT.Cells[i, 6] = item.FechaEmisionHomologacion.Value.ToString("dd/MM/yyyy");
}
if (item.ValorNetoFactura.HasValue)
{
worKsheeT.Cells[i, 7] = item.ValorNetoFactura;
}
worKsheeT.Cells[i, 8] = item.DigitoVerificador;
worKsheeT.Cells[i, 9] = item.CodigoSII;
worKsheeT.Cells[i, 10] = item.Anno;
worKsheeT.Cells[i, 11] = item.Tasacion;
worKsheeT.Cells[i, 12] = item.NroMotor;
worKsheeT.Cells[i, 13] = item.NroChasis;
worKsheeT.Cells[i, 14] = item.Color;
worKsheeT.Cells[i, 15] = item.NroAsientos;
worKsheeT.Cells[i, 16] = "0";
worKsheeT.Cells[i, 17] = item.NombrePropietario;
worKsheeT.Cells[i, 18] = item.DomicilioPropietario;
worKsheeT.Cells[i, 19] = item.ComunaPropietario;
worKsheeT.Cells[i, 20] = item.TelefonoPropietario;
worKsheeT.Cells[i, 21] = "Si";
if (item.FechaPlazoHomologacion.HasValue)
{
worKsheeT.Cells[i, 22] = item.FechaPlazoHomologacion.Value.ToString("dd/MM/yyyy");
}
worKsheeT.Cells[i, 23] = item.Modelo;
worKsheeT.Cells[i, 24] = item.Marca;
worKsheeT.Cells[i, 25] = item.TipoVehiculo;
worKsheeT.Cells[i, 26] = item.Cilindrada;
worKsheeT.Cells[i, 27] = item.Combustible;
worKsheeT.Cells[i, 28] = item.Transmision;
worKsheeT.Cells[i, 29] = item.Equipamiento;
worKsheeT.Cells[i, 30] = item.NroPuertas;
worKsheeT.Cells[i, 31] = "";
worKsheeT.Cells[i, 32] = "";
i++;
}
string file = "C:\\Nominas\\nomina" + aux.IdNomina + ".xlsx";
if (File.Exists(file))
{
File.Delete(file);
worKbooK.SaveAs(file);
}
else
{
worKbooK.SaveAs(file);
}
worKbooK.Close();
excel.Quit();
Process.Start(file);
DgVehiculosNominas.ItemsSource = new VehiculosBLL().GetVehiculosOff();
DgNominasCreadas.ItemsSource = new NominasBLL().GetNominas();
}
