private void GuardarButton_Click(object sender, RoutedEventArgs e)
{
bool paso = false;
if (!Validar())
{
return;
}
Limpiar();
if (cobro.CobroId == 0)
{
paso = CobrosBLL.Guardar(cobro);
}
else
{
if (!existeEnLaBaseDeDatos())
{
paso = CobrosBLL.Modificar(cobro);
MessageBox.Show(" modifico ", "Existo", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
if (paso)
{
Limpiar();
}
else
{
MessageBox.Show("No fue posible guardar!!", "Fallo", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
public ActionResult Delete(CobroAlquilerModel collection)
{
try
{
var bCobro = false;
var cobbll = new CobrosBLL();
collection.Pago = cobbll.GetById(collection.Pago.PagoId.ToString());
bCobro = cobbll.Delete(collection.Pago);
if (bCobro)
{
ViewBag.TipoMsj = "Success";
ViewBag.Message = "La anulación de cobro se realizó con exito. !!!";
return(View());
}
else
{
ViewBag.TipoMsj = "Info";
ViewBag.Message = "No pudo realizar la anulación";
return(View(collection));
}
}
catch (Exception ex)
{
ViewBag.TipoMsj = "Error";
ViewBag.Message = ex.Message;
return(View(collection));
}
}
public void ExisteTest()
{
bool paso = false;
paso = CobrosBLL.Existe(1);
Assert.AreEqual(paso, true);
}
public void EliminarTest()
{
bool paso = false;
paso = CobrosBLL.Eliminar(1);
Assert.AreEqual(paso, true);
}
/* private void DetalleDataGridcobro_AutoGeneratedColumns(object sender, EventArgs e)
* {
* foreach (DataGridColumn item in DataGridCobroConsultas.Columns)
* {
* chk = new CheckBox();
* checkBoxList.Add(chk);
* wrapColumns.Children.Add(chk);
* chk.Width = 100;
* chk.Height = 22;
* chk.Content = item.Header;
* chk.IsChecked = true;
* chk.Checked += new RoutedEventHandler(chk_Checked);
* chk.Unchecked += new RoutedEventHandler(chk_Unchecked);
* }
* }
* void chk_Unchecked(object sender, RoutedEventArgs e) /// metodo para ocultar las columnas
* {
* List<string> chkUnchekList = new List<string>();
* chkUnchekList.Clear();
*
* foreach (CheckBox item in checkBoxList)
* {
* if (item.IsChecked == false)
* {
* chkUnchekList.Add(item.Content.ToString());
* }
* }
*
* foreach (DataGridColumn item in DataGridCobroConsultas.Columns)
* {
* if (chkUnchekList.Contains(item.Header.ToString()))
* {
* DataGridCobroConsultas.Columns.Remove(item);
* break;
* }
* }
* }
*
* void chk_Checked(object sender, RoutedEventArgs e) // metodo para mostrar las columnas
* {
* DataGridCobroConsultas.AutoGeneratedColumns -= new EventHandler(DetalleDataGridcobro_AutoGeneratedColumns);
*
* List<string> chkCheckList = new List<string>();
* chkCheckList.Clear();
*
* foreach (CheckBox item in checkBoxList)
* {
* if (item.IsChecked == false)
* {
* chkCheckList.Add(item.Content.ToString());
* }
* }
*
* DataGridCobroConsultas.ItemsSource = null;
* DataGridCobroConsultas.ItemsSource = ocultardetalle;
*
* foreach (string item in chkCheckList)
* {
* foreach (DataGridColumn column in DataGridCobroConsultas.Columns)
* {
* if (column.Header.ToString() == item)
* {
* DataGridCobroConsultas.Columns.Remove(column);
* break;
* }
* }
* }
* }*/
private void ConsultarButton_Click(object sender, RoutedEventArgs e)
{
var listado = new List <Cobros>();
if (CriterioTextBox.Text.Trim().Length > 0)
{
switch (FiltroComboBox.SelectedIndex)
{
case 0: //Todo
listado = CobrosBLL.GetList(o => true);
break;
case 1: //Cobro Id
int id;
id = int.Parse(CriterioTextBox.Text);
listado = CobrosBLL.GetList(o => o.CobroId == id);
break;
case 2: // Cliente Id
int clienteId;
clienteId = int.Parse(CriterioTextBox.Text);
listado = CobrosBLL.GetList(o => o.ClienteId == clienteId);
break;
case 3: //Cantidad
int cant;
cant = int.Parse(CriterioTextBox.Text);
listado = CobrosBLL.GetList(o => o.Cantidad == cant);
break;
case 4: //Precio
int Prec;
Prec = int.Parse(CriterioTextBox.Text);
listado = CobrosBLL.GetList(o => o.Precio == Prec);
break;
case 5: //monto
float monto;
monto = float.Parse(CriterioTextBox.Text);
listado = CobrosBLL.GetList(o => o.Monto == monto);
break;
}
}
else if (FiltroComboBox.SelectedIndex == 6)
{
listado = CobrosBLL.GetList(c => c.Fecha.Date >= DesdeDatePicker.SelectedDate && c.Fecha.Date <= HastaDatePicker.SelectedDate);
}
else
{
listado = CobrosBLL.GetList(p => true);
}
DataGridCobroConsultas.ItemsSource = null;
DataGridCobroConsultas.ItemsSource = listado;
}
private void GuardarButton_Click(object sender, EventArgs e)
{
Cobros cobro;
bool paso = false;
RepositorioBase <Cobros> repositorio = new RepositorioBase <Cobros>();
CobrosBLL cobrosBLL = new CobrosBLL();
if (!Validar())
{
return;
}
cobro = LlenarClase();
if (CobroIdnumericUpDown.Value == 0)
{
paso = cobrosBLL.Guardar(cobro);
}
else
{
if (!ExisteEnLaBaseDeDatos())
{
MessageBox.Show("No se puede modificar un registro que no existe");
return;
}
paso = repositorio.Modificar(cobro);
}
if (paso)
{
MessageBox.Show("Guardado!!", "Exito", MessageBoxButtons.OK, MessageBoxIcon.Information);
///
/// Imprimir reporte
///
BLL.RepositorioBase <Cobros> repositorioBase = new RepositorioBase <Cobros>();
ListaCobros = repositorioBase.GetList(p => p.CobroId == cobro.CobroId);
if (ListaCobros.Count == 0)
{
MessageBox.Show("No hay datos para imprimir");
return;
}
ReciboCobroReportViewer reciboCobroReportViewer = new ReciboCobroReportViewer(ListaCobros);
reciboCobroReportViewer.ShowDialog();
///
Limpiar();
}
else
{
MessageBox.Show("No fue posible guardar!!", "Fallo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void GetListTest()
{
bool paso = false;
List <Cobros> lista = CobrosBLL.GetList(l => true);
if (lista != null)
{
paso = true;
}
Assert.AreEqual(paso, true);
}
public void GuardarTest()
{
Cobros ve = new Cobros()
{
VentaId = 1,
ClienteId = 1,
UsuarioId = 3,
MontoPagado = 9,
Fecha = DateTime.Now
};
Assert.IsTrue(CobrosBLL.Guardar(ve));
}
public void BuscarTest()
{
bool paso = false;
Cobros cobros;
cobros = CobrosBLL.Buscar(3);
if (cobros != null)
{
paso = true;
}
Assert.AreEqual(paso, false);
}
public void BuscarTest()
{
Cobros cobro = new Cobros();
bool paso = false;
cobro = CobrosBLL.Buscar(1);
if (cobro != null)
{
paso = true;
}
Assert.AreEqual(paso, true);
}
private void BuscarButton_Click(object sender, RoutedEventArgs e)
{
Cobros cobroAnterior = CobrosBLL.Buscar(CobrosIdTextBox.Text.ToInt());
if (cobroAnterior != null)
{
cobro = cobroAnterior;
reCargar();
}
else
{
MessageBox.Show(" No Encontrado !!!", "Informacion", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
public void ModificarTest()
{
Cobros ve = new Cobros()
{
CobroId = 1,
VentaId = 2,
ClienteId = 1,
UsuarioId = 1,
MontoPagado = 200,
Fecha = DateTime.Now
};
Assert.IsTrue(CobrosBLL.Modificar(ve));
}
private void ClienteIdComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (DetalleDataGridCobro != null)
{
if (ClienteIdComboBox.Text == "0")
{
cobro = new Cobros();
reCargar();
}
else
{
cobro = CobrosBLL.Buscar(Convert.ToInt32(ClienteIdComboBox.Text));
reCargar();
}
}
}
public void ModificarTest()
{
Cobros cobro = new Cobros();
bool paso = false;
cobro.CobroId = 1;
cobro.ClienteId = 1;
cobro.Balance = 0;
cobro.Monto = 500;
cobro.Fecha = DateTime.Now;
cobro.UsuarioId = 1;
paso = CobrosBLL.Modificar(cobro);
Assert.AreEqual(paso, true);
}
public void GuardarTest()
{
bool paso;
CobrosBLL cobrosBLL = new CobrosBLL();
Cobros cobros = new Cobros();
cobros.CobroId = 0;
cobros.ProcedimientoId = 1;
cobros.Fecha = DateTime.Now;
cobros.Abono = 500;
cobros.UsuarioId = 1;
paso = cobrosBLL.Guardar(cobros);
Assert.AreEqual(paso, true);
}
public void GuardarTest()
{
Cobros cobros = new Cobros();
CobroDetalles cobroDetalles = new CobroDetalles();
bool paso = false;
cobros.CobroId = 0;
cobros.Fecha = DateTime.Now;
cobros.PacienteId = 1;
cobros.ProcedimientoId = 1;
cobros.Monto = 500;
cobroDetalles.CobroId = 1;
cobroDetalles.Descripcion = "Breve descripcion";
cobroDetalles.Abono = 250;
cobros.CobroDetalles.Add(cobroDetalles);
paso = CobrosBLL.Guardar(cobros);
}
public JsonResult GetPago(string idCobro, string idContrato)
{
var newPago = new object();
try
{
var pagobll = new CobrosBLL();
var pago = pagobll.GetById(idCobro);
newPago = new
{
MontoTotal = pago.MontoTotal,
FechaPago = pago.FechaPago.Value.ToShortDateString()
};
}
catch (Exception ex)
{
ViewBag.TipoMsj = "Error";
ViewBag.Message = ex.Message;
return(Json(ex.Message, JsonRequestBehavior.AllowGet));
}
return(Json(newPago, JsonRequestBehavior.AllowGet));
}
public ActionResult GetImprimir(CobroAlquilerModel collection)
{
try
{
var a = "";
var pagobll = new CobrosBLL();
var pago = pagobll.GetById(collection.Pago.PagoId.ToString());
var admAlqui = new AdministradoraAlquileres();
byte[] bytes = admAlqui.GenerarRecibo(pago);
Server.MapPath("");
var streamDownload = new MemoryStream(bytes);
streamDownload.Flush();
streamDownload.Position = 0;
return(File(streamDownload, "application/pdf", "Comprobante" + DateTime.Now.ToShortDateString() + "_" + collection.Pago.PagoId.ToString() + ".xlsx"));
}
catch (Exception ex)
{
ViewBag.TipoMsj = "Error";
ViewBag.Message = ex.Message;
return(View("Delete", collection));
}
}
private void EliminarButton_Click(object sender, RoutedEventArgs e)
{
int id;
int.TryParse(CobrosIdTextBox.Text, out id);
try
{
if (CobrosBLL.Eliminar(id))
{
Limpiar();
MessageBox.Show("Eliminado", "Exito", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
MessageBox.Show(CobrosIdTextBox.Text, "No se puede eliminar no existe");
}
}
catch
{
}
}
private string AlquileresImpagos()
{
try
{
var PagoPendie = new CobrosBLL().GetPagosPendientes();
string AlquileresImpagos = "";
if (PagoPendie == null || PagoPendie.Count() == 0)
{
AlquileresImpagos = "<tr><td></td><td></td><td></td><td></td><td></td></tr>";
}
else
{
foreach (var item in PagoPendie)
{
AlquileresImpagos += "<tr><td>" + item.Nombre + "</td><td>" + item.Fecha + "</td><td>" + item.Telefono + "</td><td>[email protected]</td><td>$ 6.000</td></tr>";
}
}
return(AlquileresImpagos);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public ActionResult Create(CobroAlquilerModel collection)
{
try
{
//if (ModelState.IsValid)
//{
var pagoentity = new PagoAlquiler();
pagoentity.ContratoId = int.Parse(collection.Contrato.sIdContrato);
pagoentity.FechaPago = DateTime.Now;
pagoentity.InquilinoId = int.Parse(collection.Contrato.sInquilinoId);
pagoentity.PropiedadId = int.Parse(collection.Contrato.sPropiedadId);
pagoentity.Observaciones = collection.Pago.Observaciones;
pagoentity.Periodo = DateTime.Parse(collection.sPeriodo.Substring(6, 2) + "/" + collection.sPeriodo.Substring(4, 2) + "/" + collection.sPeriodo.Substring(0, 4));
pagoentity.Observaciones = collection.Pago.Observaciones;
var detallePago = new PagoAlquiler_Detalle();
detallePago.Monto = collection.Pago.MontoTotal.Value;
detallePago.TipoId = 6;
detallePago.PeriodoPago = pagoentity.Periodo.Value;
pagoentity.DetallePago = new List <PagoAlquiler_Detalle>();
pagoentity.DetallePago.Add(detallePago);
foreach (var item in collection.OtrosPagos)
{
if (!string.IsNullOrEmpty(item.Monto))
{
pagoentity.DetallePago.Add(new PagoAlquiler_Detalle()
{
TipoId = item.Codigo, Monto = decimal.Parse(item.Monto), PeriodoPago = pagoentity.Periodo.Value
});
collection.Pago.MontoTotal += decimal.Parse(item.Monto);
}
}
pagoentity.MontoTotal = collection.Pago.MontoTotal;
var pagoBll = new CobrosBLL();
int cod = pagoBll.Add(pagoentity);
collection.Pago = pagoentity;
collection.Pago.PagoId = cod;
string impu = collection.ImpuestosPresentados;
ViewBag.Imprimir = true;
ViewBag.TipoMsj = "Success";
ViewBag.Message = "El cobro se registro con Exito!!!";
return(View(collection));
//}
//else
//{
// ViewBag.TipoMsj = "Info";
// ViewBag.Message = string.Join("; ", ModelState.Values
// .SelectMany(x => x.Errors)
// .Select(x => x.ErrorMessage));
// return View(collection);
//}
}
catch (Exception ex)
{
ViewBag.TipoMsj = "Error";
ViewBag.Message = ex.Message;
return(View());
}
}
public void EliminarTest()
{
Assert.IsTrue(CobrosBLL.Eliminar(1));
}
private bool existeEnLaBaseDeDatos()
{
Cobros cobroAnterior = CobrosBLL.Buscar((int)CobrosIdTextBox.Text.ToInt());
return(cobroAnterior != null);
}
