| Revisão | 57 (tree) |
|---|---|
| Hora | 2022-02-07 03:35:21 |
| Autor | hemaxvi_soft |
Cambios Aplicados
-Boton pago capital activado
-Campos Balance pendiente y pagado agregado.
softloans/.vs/SoftLoans/v16/Server/sqlite3/storage.ide (diff) softloans/.vs/SoftLoans/v16/.suo (diff)
softloans/bin/SoftLoteria.dll (diff) softloans/bin/SoftLoteria.pdb (diff) softloans/obj/Debug/SoftLoteria.dll (diff) softloans/obj/Debug/SoftLoteria.pdb (diff) softloans/DetallePrestamosWF.aspx (diff) softloans/DetallePrestamosWF.aspx.cs (diff) softloans/DetallePrestamosWF.aspx.designer.cs (diff)| @@ -397,11 +397,20 @@ | ||
| 397 | 397 | decimal quantityDelay = 0; |
| 398 | 398 | TimeSpan difFechas; |
| 399 | 399 | decimal delayAmount = 0; |
| 400 | + | |
| 401 | + decimal totalDueAmount = 0; | |
| 402 | + decimal totalPay = 0; | |
| 403 | + | |
| 400 | 404 | if (Session["ParametroDetalle"] != null) |
| 401 | 405 | { |
| 402 | 406 | LoandetailsDAL loandetailsDAL = new LoandetailsDAL(); |
| 403 | 407 | LoandetailsEntity loandetailsEntity = new LoandetailsEntity(); |
| 404 | 408 | List<LoandetailsEntity> loandetailsEntityList = new List<LoandetailsEntity>(); |
| 409 | + List<LoandetailsEntity> loandetailsEntityListAll = new List<LoandetailsEntity>(); | |
| 410 | + PaysDAL paysDAL = new PaysDAL(); | |
| 411 | + PaysEntity paysEntity = new PaysEntity(); | |
| 412 | + List<PaysEntity> paysEntityList = new List<PaysEntity>(); | |
| 413 | + | |
| 405 | 414 | loandetailsDAL.dbm.DataSource = loginDAL.DataSource; |
| 406 | 415 | loandetailsDAL.dbm.User = loginDAL.UserName; |
| 407 | 416 | loandetailsDAL.dbm.Password = loginDAL.UserPassword; |
| @@ -412,6 +421,7 @@ | ||
| 412 | 421 | |
| 413 | 422 | loandetailsEntity = (LoandetailsEntity)Session["ParametroDetalle"]; |
| 414 | 423 | loandetailsEntityList = loandetailsDAL.SearchActive(loandetailsEntity, loginDAL); |
| 424 | + loandetailsEntityListAll = loandetailsDAL.Search(loandetailsEntity, loginDAL); | |
| 415 | 425 | |
| 416 | 426 | |
| 417 | 427 | foreach (var item in loandetailsEntityList) |
| @@ -471,10 +481,28 @@ | ||
| 471 | 481 | } |
| 472 | 482 | } |
| 473 | 483 | } |
| 474 | - | |
| 484 | + | |
| 485 | + totalDueAmount = totalDueAmount + Convert.ToDecimal(item.TotalDueAmount.ToString()); | |
| 486 | + | |
| 487 | + // totalPay = totalPay + ((item.Interest + item.Capital + item.DelayAmount) - (item.InterestBalance + item.CapitalBalance + item.DelayBalance + delayAmount)); | |
| 488 | + | |
| 489 | + | |
| 475 | 490 | } |
| 476 | 491 | |
| 477 | - loandetailsEntityList = loandetailsDAL.SearchActive(loandetailsEntity, loginDAL); | |
| 492 | + foreach (var item in loandetailsEntityListAll) | |
| 493 | + { | |
| 494 | + paysEntity.TimeStart = item.LastDateDelayAmount; | |
| 495 | + paysEntity.TimeEnd = DateTime.Now; | |
| 496 | + paysEntityList = paysDAL.Search(paysEntity, loginDAL); | |
| 497 | + | |
| 498 | + foreach (var item1 in paysEntityList) | |
| 499 | + { | |
| 500 | + if (item.ID == item1.LoanDetailsID) | |
| 501 | + totalPay = totalPay + item1.Amount; | |
| 502 | + | |
| 503 | + } | |
| 504 | + } | |
| 505 | + | |
| 478 | 506 | TbIDPrestamo.InnerText = loandetailsEntity.LoandID.ToString(); |
| 479 | 507 | TbCustomerName.InnerText = loandetailsEntity.CustomerName.ToString(); |
| 480 | 508 | GvDetallePrestamos.Controls.Clear(); |
| @@ -485,7 +513,10 @@ | ||
| 485 | 513 | GvDetallePrestamos.DataBind(); |
| 486 | 514 | //Session["Parametro"] = null; |
| 487 | 515 | |
| 516 | + LbBalancePendiente.InnerText = totalDueAmount.ToString("N2"); | |
| 517 | + LbBalancePagado.InnerText = totalPay.ToString("N2"); | |
| 488 | 518 | |
| 519 | + | |
| 489 | 520 | } |
| 490 | 521 | catch (Exception ex) |
| 491 | 522 | { |
| @@ -790,7 +821,7 @@ | ||
| 790 | 821 | paysEntity.LoanDetailsID = lastDetailID; |
| 791 | 822 | paysEntity.Date = DateTime.Now; |
| 792 | 823 | paysEntity.NcfNumber = ""; |
| 793 | - payDAL.InsertCapital(paysEntity,loginDAL); | |
| 824 | + payDAL.Insert(paysEntity,loginDAL); | |
| 794 | 825 | |
| 795 | 826 | payDAL = null; |
| 796 | 827 | paysEntity = null; |
| @@ -321,6 +321,24 @@ | ||
| 321 | 321 | protected global::System.Web.UI.HtmlControls.HtmlGenericControl TbCustomerName; |
| 322 | 322 | |
| 323 | 323 | /// <summary> |
| 324 | + /// Control LbBalancePendiente. | |
| 325 | + /// </summary> | |
| 326 | + /// <remarks> | |
| 327 | + /// Campo generado automáticamente. | |
| 328 | + /// Para modificarlo, mueva la declaración del campo del archivo del diseñador al archivo de código subyacente. | |
| 329 | + /// </remarks> | |
| 330 | + protected global::System.Web.UI.HtmlControls.HtmlGenericControl LbBalancePendiente; | |
| 331 | + | |
| 332 | + /// <summary> | |
| 333 | + /// Control LbBalancePagado. | |
| 334 | + /// </summary> | |
| 335 | + /// <remarks> | |
| 336 | + /// Campo generado automáticamente. | |
| 337 | + /// Para modificarlo, mueva la declaración del campo del archivo del diseñador al archivo de código subyacente. | |
| 338 | + /// </remarks> | |
| 339 | + protected global::System.Web.UI.HtmlControls.HtmlGenericControl LbBalancePagado; | |
| 340 | + | |
| 341 | + /// <summary> | |
| 324 | 342 | /// Control TextActo. |
| 325 | 343 | /// </summary> |
| 326 | 344 | /// <remarks> |
