public ActionResult Pagar([Bind(Include = "Fecha")] PagoPrestamo pago, int id)
{
PrestamoOperations po = new PrestamoOperations();
ViewBag.Valores = po.Pagar(pago, id);
return(View("Ticket"));
}
public PagoPrestamo CargarPago(int?id, DateTime fecha)
{
PagoPrestamo pago = new PagoPrestamo();
Prestamo prestamo = db.Prestamo.Find(id);
Double Cuota = ClacularCuota(prestamo);
double Mora = CalcularMora(fecha, prestamo.ProximoPago, Convert.ToDouble(prestamo.TasaMora), Cuota);
pago.Mora = (Mora != 0) ? Convert.ToDecimal(Mora.ToString("#.##")) : 0;
pago.Cuota = Convert.ToDecimal(Cuota.ToString("#.##"));
pago.Prestamo = prestamo;
return(pago);
}
public ActionResult Pagar(int?id)
{
PrestamoOperations po = new PrestamoOperations();
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PagoPrestamo pago = po.CargarPago(id, DateTime.Now);
return(View(pago));
}
public IActionResult Refinanciar(IFormCollection form)
{
var idPrestamo = Convert.ToInt16(form["idPrestamo"]);
var cantidad = Convert.ToInt16(form["cantidad"]);
var periodo = Convert.ToInt16(form["periodo"]);
var pdi = new PrestamoDaoImplements();
var cdi = new ClienteDaoImplements();
var pp = new PagoPrestamo();
ViewBag.Prestamo = pdi.getPrestamoId(idPrestamo);
ViewBag.Cliente = cdi.GetClienteId(ViewBag.prestamo.idCliente);
ViewBag.ListaFechas = pp.listarFechasIntermedias(DateTime.Now, ViewBag.Prestamo.fechaFocal, cantidad, periodo);
return(View(ViewBag));
}
public string[] Pagar(PagoPrestamo pago, int?id)
{
DateTime fecha = pago.Fecha;
pago = CargarPago(id, fecha);
pago.Fecha = fecha;
Prestamo prestamo = pago.Prestamo;
double Interes = Convert.ToDouble((prestamo.TasaInteres / 12 / 100) * prestamo.Deuda);
double Amortizado = Convert.ToDouble(pago.Cuota) - Interes;
double Deuda = Convert.ToDouble(prestamo.Deuda) - Amortizado;
prestamo.Deuda = Convert.ToDecimal(Deuda.ToString("#.##"));
prestamo.ProximoPago = prestamo.ProximoPago.AddMonths(1);
pago.Periodo = db.Pago.Where(p => p.PrestamoID == prestamo.PrestamoID).Count();
pago.Periodo++;
if (prestamo.Plazo == db.Pago.Where(p => p.PrestamoID == prestamo.PrestamoID).Count())
{
prestamo.Estado = Estado.Pagado;
prestamo.Deuda = 0;
}
db.Pago.Add(pago);
db.Entry(prestamo).State = EntityState.Modified;
db.SaveChanges();
string[] valores = new string[11]
{
prestamo.Cliente.Nombre + " " + prestamo.Cliente.Apellido,
prestamo.Monto.ToString("#.##") + " $",
prestamo.TasaInteres.ToString() + " %",
prestamo.Plazo.ToString() + " Meses",
prestamo.TasaInteres.ToString() + " %",
"Cuota",
pago.Fecha.ToShortDateString(),
pago.Cuota.ToString("#.##") + " $",
pago.Mora.ToString("#.##") + " $",
(pago.Mora + pago.Cuota).ToString("#.##") + " $",
prestamo.ProximoPago.ToShortDateString()
};
return(valores);
}
public IActionResult RealizarPrestamo(IFormCollection form)
{
var pp = new PagoPrestamo();
var pdi = new PrestamoDaoImplements();
var cdi = new CuentaDaoImplements();
NumberFormatInfo nfi = new CultureInfo("en-US", false).NumberFormat;
nfi.NumberDecimalSeparator = ".";
// Variables del formulario
var cuenta = Convert.ToInt16(form["id-cuenta"]);
var cliente = Convert.ToInt16(form["id-cliente"]);
var efectivoSolicitado = Convert.ToDouble(form["efectivo-solicitado"], NumberFormatInfo.InvariantInfo);
var tasaInteres = Convert.ToDouble(form["tasa-interes"], nfi);
var limiteAño = Convert.ToInt16(form["limite-año"]);
var limiteMes = Convert.ToInt16(form["limite-mes"]);
var periodoPagos = Convert.ToInt16(form["periodo-pagos"]);
var totalDeuda = Convert.ToDouble(form["total-deuda"], NumberFormatInfo.InvariantInfo);
// Fin variables del formulario
var cantidadMeses = pp.YearToMonth(limiteAño) + limiteMes;
var cuotas = cantidadMeses / periodoPagos;
if (cuotas < 1)
{
ViewBag.mensaje = "No se pudo realizar la transaccion, el plazo limite es menor que el periodo de cuotas";
ViewBag.path = "/Cliente/Prestamo";
return(View("ErrorUser", ViewBag));
}
else
{
var mensualidad = totalDeuda / cuotas;
var prestamo = new Prestamo(cliente, efectivoSolicitado, tasaInteres, cantidadMeses, periodoPagos, totalDeuda, false, cuotas, 0, DateTime.Now.AddMonths(cantidadMeses));
var id = pdi.ingresarPrestamo(prestamo);
if (id > 0)
{
List <PagoPrestamo> lpp = new List <PagoPrestamo>();
for (int i = periodoPagos; i <= cantidadMeses; i += periodoPagos)
{
pp = new PagoPrestamo(id, DateTime.Now.AddMonths(i).Month, pp.NumberToMonth(DateTime.Now.AddMonths(i).Month), mensualidad, false, DateTime.Now.AddMonths(i));
lpp.Add(pp);
}
var verif = pdi.ingresarPagos(lpp);
if (verif)
{
ViewBag.mensaje = "* El prestamo y la transaccion se realizaron de forma correcta";
ViewBag.mensaje += "- * Registro de pagos correcto";
Registro registro = new Registro("ABONO-PRESTAMO", efectivoSolicitado, efectivoSolicitado, cuenta);
rdi.ingresarRegistros(registro);
cdi.SumarEfectivoCuenta(cuenta, prestamo.efectivoSolicitado);
}
if (!verif)
{
ViewBag.mensaje += "- * Registro de pagos INCORRECTO";
}
}
if (id < 1)
{
ViewBag.mensaje += "- * Registro de prestamo INCORRECTO";
}
}
return(View("Correcto", ViewBag));
}
#pragma warning disable 1998
public async override global::System.Threading.Tasks.Task ExecuteAsync()
{
#line 1 "/home/giothcode/Escritorio/MatematicaFinanciera/MatematicaFinanciera/Views/Cliente/Refinanciar.cshtml"
Layout = "_Layout";
Cliente cliente = ViewBag.Cliente;
Prestamo prestamo = ViewBag.Prestamo;
var pp = new PagoPrestamo();
List <DateTime> lista = ViewBag.ListaFechas;
#line default
#line hidden
BeginContext(191, 612, true);
WriteLiteral(@"<nav aria-label=""breadcrumb"">
<ol class=""breadcrumb"">
<li class=""breadcrumb-item""><a href=""/Home/Index"">Inicio</a></li>
<li class=""breadcrumb-item active"" aria-current=""page"">Refinanciamiento</li>
</ol>
</nav>
<div class=""display-4 text-center"">Refinanciamiento</div>
<hr>
<div class=""row justify-content-left mt-3"">
<div class=""col-6"">
<div class=""card"">
<div class=""card-body"">
<div class=""card-title h2"">Informacion del prestamo</div>
<div class=""row"">
<div class=""col"">
<small><strong>I.D PRESTAMO</strong><br>");
EndContext();
BeginContext(804, 11, false);
#line 23 "/home/giothcode/Escritorio/MatematicaFinanciera/MatematicaFinanciera/Views/Cliente/Refinanciar.cshtml"
Write(prestamo.id);
#line default
#line hidden
EndContext();
BeginContext(815, 221, true);
WriteLiteral("</small><br>\n </div>\n </div>\n <hr>\n <div class=\"row\">\n <div class=\"col\">\n <small><strong>Efectivo solicitado</strong><br>$ ");
EndContext();
BeginContext(1037, 27, false);
#line 29 "/home/giothcode/Escritorio/MatematicaFinanciera/MatematicaFinanciera/Views/Cliente/Refinanciar.cshtml"
Write(prestamo.efectivoSolicitado);
#line default
#line hidden
EndContext();
BeginContext(1064, 118, true);
WriteLiteral("</small>\n </div>\n <div class=\"col\">\n <small><strong>Interes al ");
EndContext();
BeginContext(1183, 20, false);
#line 32 "/home/giothcode/Escritorio/MatematicaFinanciera/MatematicaFinanciera/Views/Cliente/Refinanciar.cshtml"
Write(prestamo.tasaInteres);
#line default
#line hidden
EndContext();
BeginContext(1203, 17, true);
WriteLiteral(" %</strong><br>$ ");
EndContext();
BeginContext(1221, 21, false);
#line 32 "/home/giothcode/Escritorio/MatematicaFinanciera/MatematicaFinanciera/Views/Cliente/Refinanciar.cshtml"
Write(prestamo.montoInteres);
#line default
#line hidden
EndContext();
BeginContext(1242, 127, true);
WriteLiteral("</small>\n </div>\n <div class=\"col\">\n <small><strong>Total</strong><br>$ ");
EndContext();
BeginContext(1370, 19, false);
#line 35 "/home/giothcode/Escritorio/MatematicaFinanciera/MatematicaFinanciera/Views/Cliente/Refinanciar.cshtml"
Write(prestamo.saldoDeuda);
#line default
#line hidden
EndContext();
BeginContext(1389, 203, true);
WriteLiteral("</small>\n </div>\n </div>\n <hr>\n <div class=\"row\">\n <div class=\"col\">\n <small><strong>Cliente</strong><br>");
EndContext();
BeginContext(1593, 14, false);
#line 41 "/home/giothcode/Escritorio/MatematicaFinanciera/MatematicaFinanciera/Views/Cliente/Refinanciar.cshtml"
Write(cliente.nombre);
#line default
#line hidden
EndContext();
BeginContext(1607, 1, true);
WriteLiteral(" ");
EndContext();
BeginContext(1609, 16, false);
#line 41 "/home/giothcode/Escritorio/MatematicaFinanciera/MatematicaFinanciera/Views/Cliente/Refinanciar.cshtml"
Write(cliente.apellido);
#line default
#line hidden
EndContext();
BeginContext(1625, 130, true);
WriteLiteral("</small><br>\n </div>\n <div class=\"col\">\n <small><strong>Cedula</strong><br>");
EndContext();
BeginContext(1756, 14, false);
#line 44 "/home/giothcode/Escritorio/MatematicaFinanciera/MatematicaFinanciera/Views/Cliente/Refinanciar.cshtml"
Write(cliente.cedula);
#line default
#line hidden
EndContext();
BeginContext(1770, 193, true);
WriteLiteral("</small><br>\n </div>\n </div>\n <div class=\"row\">\n <div class=\"col\">\n <small><strong>Fecha solicitado</strong><br>");
EndContext();
BeginContext(1964, 47, false);
#line 49 "/home/giothcode/Escritorio/MatematicaFinanciera/MatematicaFinanciera/Views/Cliente/Refinanciar.cshtml"
Write(prestamo.fechaSolicitado.ToString("MM/dd/yyyy"));
#line default
#line hidden
EndContext();
BeginContext(2011, 131, true);
WriteLiteral("</small>\n </div>\n <div class=\"col\">\n <small><strong>Fecha focal</strong><br>");
EndContext();
BeginContext(2143, 42, false);
#line 52 "/home/giothcode/Escritorio/MatematicaFinanciera/MatematicaFinanciera/Views/Cliente/Refinanciar.cshtml"
Write(prestamo.fechaFocal.ToString("MM/dd/yyyy"));
#line default
#line hidden
EndContext();
BeginContext(2185, 161, true);
WriteLiteral("</small>\n </div>\n </div>\n </div>\n </div>\n </div>\n <div class=\"col-6\">\n <strong>Lista de pagos anterior</strong>\n");
EndContext();
#line 60 "/home/giothcode/Escritorio/MatematicaFinanciera/MatematicaFinanciera/Views/Cliente/Refinanciar.cshtml"
foreach (var pago in @prestamo.pagos)
{
#line default
#line hidden
BeginContext(2395, 126, true);
WriteLiteral(" <div class=\"row\">\n <div class=\"col-6\">\n <small><strong>Fecha limite: </strong></small>\n <small>");
EndContext();
BeginContext(2522, 39, false);
#line 65 "/home/giothcode/Escritorio/MatematicaFinanciera/MatematicaFinanciera/Views/Cliente/Refinanciar.cshtml"
Write(pago.fechaLimite.ToString("MM/dd/yyyy"));
#line default
#line hidden
EndContext();
BeginContext(2561, 121, true);
WriteLiteral("</small>\n </div>\n <div class=\"col-6\">\n <small><strong>Monto: $ </strong></small>\n <small>");
EndContext();
BeginContext(2683, 15, false);
#line 69 "/home/giothcode/Escritorio/MatematicaFinanciera/MatematicaFinanciera/Views/Cliente/Refinanciar.cshtml"
Write(pago.montoPagar);
#line default
#line hidden
EndContext();
BeginContext(2698, 37, true);
WriteLiteral("</small>\n </div>\n </div>\n");
EndContext();
#line 72 "/home/giothcode/Escritorio/MatematicaFinanciera/MatematicaFinanciera/Views/Cliente/Refinanciar.cshtml"
}
#line default
#line hidden
BeginContext(2741, 17, true);
WriteLiteral(" </div>\n</div>\n\n");
EndContext();
BeginContext(2758, 2025, false);
__tagHelperExecutionContext = __tagHelperScopeManager.Begin("form", global::Microsoft.AspNetCore.Razor.TagHelpers.TagMode.StartTagAndEndTag, "e7d3c0c66546b3a85b9393a45ed1e2b2c35e677313097", async() => {
BeginContext(2778, 41, true);
WriteLiteral("\n <input type=\"hidden\" name=\"prestamoId\"");
EndContext();
BeginWriteAttribute("value", " value=\"", 2819, "\"", 2839, 1);
#line 77 "/home/giothcode/Escritorio/MatematicaFinanciera/MatematicaFinanciera/Views/Cliente/Refinanciar.cshtml"
WriteAttributeValue("", 2827, prestamo.id, 2827, 12, false);
#line default
#line hidden
EndWriteAttribute();
BeginContext(2840, 42, true);
WriteLiteral(">\n <input type=\"hidden\" name=\"fechaFocal\"");
EndContext();
BeginWriteAttribute("value", " value=\"", 2882, "\"", 2931, 1);
#line 78 "/home/giothcode/Escritorio/MatematicaFinanciera/MatematicaFinanciera/Views/Cliente/Refinanciar.cshtml"
WriteAttributeValue("", 2890, prestamo.fechaFocal.ToString("dd/MM/yy"), 2890, 41, false);
#line default
#line hidden
EndWriteAttribute();
BeginContext(2932, 37, true);
WriteLiteral(">\n <input type=\"hidden\" name=\"monto\"");
EndContext();
BeginWriteAttribute("value", " value=\"", 2969, "\"", 2997, 1);
#line 79 "/home/giothcode/Escritorio/MatematicaFinanciera/MatematicaFinanciera/Views/Cliente/Refinanciar.cshtml"
WriteAttributeValue("", 2977, prestamo.saldoDeuda, 2977, 20, false);
#line default
#line hidden
EndWriteAttribute();
BeginContext(2998, 734, true);
WriteLiteral(@">
<div class=""row p-2 mt-3 justify-content-center"">
<div class=""col- 4"">
<div class=""form-group alert alert-info"">
<input type=""checkbox"" id=""checkInteres"" name=""checkInteres"">
<label class=""m-0"">Mantener interes fijo a todos los meses.</label>
<input class=""form-control text-right"" type=""text"" id=""interesFijo"" name=""interesFijo"" placeholder=""Ingrese el interes 0.0%"">
</div>
</div>
</div>
<div class=""row justify-content-center"">
<div class=""col-8"">
<table class=""w-100"">
<thead>
<th class=""text-center"" >Mes</th>
<th class=""text-center"" >Fecha</th>
<th class=""text-center"" >Tasa de interes</th>
</thead>
<tbody>
");
EndContext();
#line 100 "/home/giothcode/Escritorio/MatematicaFinanciera/MatematicaFinanciera/Views/Cliente/Refinanciar.cshtml"
foreach (var fecha in lista)
{
#line default
#line hidden
BeginContext(3784, 85, true);
WriteLiteral(" <tr>\n <td class=\"p-2 border border-dark m-auto text-center\">");
EndContext();
BeginContext(3870, 30, false);
#line 103 "/home/giothcode/Escritorio/MatematicaFinanciera/MatematicaFinanciera/Views/Cliente/Refinanciar.cshtml"
Write(pp.NumberToMonth(@fecha.Month));
#line default
#line hidden
EndContext();
BeginContext(3900, 74, true);
WriteLiteral("</td>\n <td class=\"p-2 border border-dark m-auto text-center\">");
EndContext();
BeginContext(3975, 26, false);
#line 104 "/home/giothcode/Escritorio/MatematicaFinanciera/MatematicaFinanciera/Views/Cliente/Refinanciar.cshtml"
Write(fecha.ToString("dd/MM/yy"));
#line default
#line hidden
EndContext();
BeginContext(4001, 56, true);
WriteLiteral("</td>\n <input type=\"hidden\" name=\"fechas[]\"");
EndContext();
BeginWriteAttribute("value", " value=\"", 4057, "\"", 4092, 1);
#line 105 "/home/giothcode/Escritorio/MatematicaFinanciera/MatematicaFinanciera/Views/Cliente/Refinanciar.cshtml"
WriteAttributeValue("", 4065, fecha.ToString("dd/MM/yy"), 4065, 27, false);
#line default
#line hidden
EndWriteAttribute();
BeginContext(4093, 170, true);
WriteLiteral(" >\n <td class=\"border border-dark m-auto text-center\"><input class=\"form-control\" type=\"text\" name=\"interesMes[]\" placeholder=\"0.0%\"></td>\n </tr>\n");
EndContext();
#line 108 "/home/giothcode/Escritorio/MatematicaFinanciera/MatematicaFinanciera/Views/Cliente/Refinanciar.cshtml"
}
#line default
#line hidden
BeginContext(4275, 348, true);
WriteLiteral(@" </tbody>
</table>
</div>
</div>
<div class=""row justify-content-center m-1 mt-3"">
<div class=""col-6"">
<small class=""text-danger""> * Asegurese de revisar detenidamente la informacion</small><br>
<small class=""text-danger""> * Llene todos los campos solicitados</small><br>
<div class=""form-group"">
");
EndContext();
BeginContext(4623, 119, false);
__tagHelperExecutionContext = __tagHelperScopeManager.Begin("input", global::Microsoft.AspNetCore.Razor.TagHelpers.TagMode.StartTagOnly, "e7d3c0c66546b3a85b9393a45ed1e2b2c35e677318346", async() => {
}
);
__Microsoft_AspNetCore_Mvc_TagHelpers_FormActionTagHelper = CreateTagHelper <global::Microsoft.AspNetCore.Mvc.TagHelpers.FormActionTagHelper>();
__tagHelperExecutionContext.Add(__Microsoft_AspNetCore_Mvc_TagHelpers_FormActionTagHelper);
__tagHelperExecutionContext.AddHtmlAttribute(__tagHelperAttribute_0);
__Microsoft_AspNetCore_Mvc_TagHelpers_FormActionTagHelper.Route = (string)__tagHelperAttribute_1.Value;
__tagHelperExecutionContext.AddTagHelperAttribute(__tagHelperAttribute_1);
__tagHelperExecutionContext.AddHtmlAttribute(__tagHelperAttribute_2);
__tagHelperExecutionContext.AddHtmlAttribute(__tagHelperAttribute_3);
await __tagHelperRunner.RunAsync(__tagHelperExecutionContext);
if (!__tagHelperExecutionContext.Output.IsContentModified)
{
await __tagHelperExecutionContext.SetOutputContentAsync();
}
Write(__tagHelperExecutionContext.Output);
__tagHelperExecutionContext = __tagHelperScopeManager.End();
EndContext();
BeginContext(4742, 34, true);
WriteLiteral("\n </div>\n </div>\n </div>\n");
EndContext();
}
);
__Microsoft_AspNetCore_Mvc_TagHelpers_FormTagHelper = CreateTagHelper <global::Microsoft.AspNetCore.Mvc.TagHelpers.FormTagHelper>();
__tagHelperExecutionContext.Add(__Microsoft_AspNetCore_Mvc_TagHelpers_FormTagHelper);
__Microsoft_AspNetCore_Mvc_TagHelpers_RenderAtEndOfFormTagHelper = CreateTagHelper <global::Microsoft.AspNetCore.Mvc.TagHelpers.RenderAtEndOfFormTagHelper>();
__tagHelperExecutionContext.Add(__Microsoft_AspNetCore_Mvc_TagHelpers_RenderAtEndOfFormTagHelper);
__Microsoft_AspNetCore_Mvc_TagHelpers_FormTagHelper.Method = (string)__tagHelperAttribute_4.Value;
__tagHelperExecutionContext.AddTagHelperAttribute(__tagHelperAttribute_4);
await __tagHelperRunner.RunAsync(__tagHelperExecutionContext);
if (!__tagHelperExecutionContext.Output.IsContentModified)
{
await __tagHelperExecutionContext.SetOutputContentAsync();
}
Write(__tagHelperExecutionContext.Output);
__tagHelperExecutionContext = __tagHelperScopeManager.End();
EndContext();
BeginContext(4783, 614, true);
WriteLiteral(@"
<script>
var check = document.getElementById('checkInteres')
var interesFijo = document.getElementById('interesFijo')
var interesMes = document.getElementsByName('interesMes[]')
if(!check.checked){
interesFijo.style.display = 'none'
}
check.addEventListener('click',function(){
if(!check.checked){
interesFijo.style.display = 'none'
interesMes.forEach(input => {
input.disabled = false
})
}else if(check.checked){
interesFijo.style.display = 'inherit'
interesMes.forEach(input => {
input.disabled = true
})
}
})
</script>");
EndContext();
}
public List <Prestamo> getPrestamo(int idCliente)
{
List <Prestamo> prestamos = new List <Prestamo>();
var cn = dbc.getConnection();
try
{
cn.Open();
var sql = "SELECT * FROM prestamo WHERE idCliente = " + idCliente;
var cmd = new SqlCommand(sql, cn);
var dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
prestamo = new Prestamo(
dr.GetInt32(0),
dr.GetInt32(1),
dr.GetDouble(2),
Convert.ToDouble(dr.GetDecimal(3)),
dr.GetInt32(4),
dr.GetInt32(5),
dr.GetDouble(6),
dr.GetBoolean(7),
dr.GetInt32(8),
dr.GetInt32(9),
dr.GetDateTime(10),
dr.GetDateTime(11));
prestamos.Add(prestamo);
}
}
dr.Close();
foreach (var prestamo in prestamos)
{
List <PagoPrestamo> pagos = new List <PagoPrestamo>();
sql = "SELECT * FROM pagos_prestamo p WHERE p.idPrestamo = " + prestamo.id;
var cmd2 = new SqlCommand(sql, cn);
var dr2 = cmd2.ExecuteReader();
if (dr2.HasRows)
{
while (dr2.Read())
{
var pago = new PagoPrestamo(dr2.GetInt32(1), dr2.GetInt32(2), dr2.GetString(3), dr2.GetDouble(4), dr2.GetBoolean(5), dr2.GetDateTime(6));
pagos.Add(pago);
}
prestamo.pagos = pagos;
}
dr2.Close();
}
Debug.WriteLine("===================QUERY==================");
Debug.WriteLine(sql);
Debug.WriteLine("===================QUERY==================");
}
catch (System.Exception e)
{
Debug.WriteLine("===================GET PAGO PRESTAMO==================");
Debug.WriteLine("DEBUGGER::" + e.Message);
Debug.WriteLine("DEBUGGER::" + e.StackTrace);
Debug.WriteLine("DEBUGGER::" + e);
Debug.WriteLine("=========================================================");
}finally
{
cn.Close();
}
return(prestamos);
}
