protected override void RefreshMainData()
{
PgMng.Grow(string.Empty, "Prestamo");
long oid = ActiveOID;
switch (DataType)
{
case EntityMngFormTypeData.Default:
if (moleQule.Common.ModulePrincipal.GetUseActiveYear())
{
List = LoanList.GetList(_loan_type, moleQule.Common.ModulePrincipal.GetActiveYear().Year, false);
}
else
{
List = LoanList.GetList(_loan_type, false);
}
break;
case EntityMngFormTypeData.ByParameter:
_sorted_list = List.GetSortedList();
break;
}
PgMng.Grow(string.Empty, "Lista de Prestamos");
}
/// <summary>
/// To Get Loan
/// </summary>
/// <param name="EncumbrancepurposeName"></param>
/// <returns></returns>
public LoanList GetLoan(string EncumbrancepurposeName)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_GET_ENCUMBRANCEPURPOSE";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
if (EncumbrancepurposeName.ToString() == "")
{
cmd.Parameters.Add("@EncumbrancepurposeNameIN", DBNull.Value);
}
else
{
cmd.Parameters.Add("@EncumbrancepurposeNameIN", EncumbrancepurposeName.ToString());
}
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
LoanBO objLoan = null;
LoanList Loan = new LoanList();
while (dr.Read())
{
objLoan = new LoanBO();
objLoan.EncumbranceId = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("ENCUMBRANCEID")));
objLoan.Encumbrancepurpose = dr.GetString(dr.GetOrdinal("ENCUMBRANCEPURPOSE"));
objLoan.IsDeleted = dr.GetString(dr.GetOrdinal("isdeleted"));
Loan.Add(objLoan);
}
dr.Close();
return(Loan);
}
protected override void GetFormSourceData(object[] parameters)
{
_loan = (Loan)parameters[1];
_entity = (Payment)parameters[2];
_loans = LoanList.NewList(_loan);
PaymentList pagos = PaymentList.GetListByPrestamo(_loans[0], false);
TransactionPayment pf = _entity.Operations.GetItemByFactura(_loans[0].Oid);
if (pf != null)
{
_loans[0].Asignado = pf.Cantidad;
_loans[0].TotalPagado = 0;
foreach (PaymentInfo pago in pagos)
{
if (pago.EEstado == moleQule.Base.EEstado.Anulado)
{
continue;
}
_loans[0].TotalPagado += pago.Importe;
}
}
_loans[0].Pendiente = _loans[0].Importe - _loans[0].TotalPagado + _loans[0].Asignado;
_loans[0].PendienteAsignar = _loans[0].Pendiente - _loans[0].Asignado;
}
protected override void GetFormSourceData(long oid, object[] parameters)
{
try
{
ETipoPago tipo = ETipoPago.Prestamo;
if (parameters[1] != null)
{
_loan = (Loan)parameters[1];
}
if (parameters.Length >= 3)
{
_entity = (Payment)parameters[2];
}
else
{
_entity = Payment.Get(oid, tipo, true);
_entity.BeginEdit();
}
_loans = _loan != null?
LoanList.NewList(_loan)
: LoanList.GetByPagoAndPendientesList(_entity.GetInfo(false));
if (_loans.Count > 0)
{
PaymentList pagos = PaymentList.GetListByPrestamo(_loans[0], false);
TransactionPayment pf = _entity.Operations.GetItemByFactura(_loans[0].Oid);
if (pf != null)
{
_loans[0].Asignado = pf.Cantidad;
_loans[0].TotalPagado = 0;
foreach (PaymentInfo pago in pagos)
{
if (pago.EEstado == moleQule.Base.EEstado.Anulado)
{
continue;
}
_loans[0].TotalPagado += pago.Importe;
}
}
_loans[0].Pendiente = _loans[0].Importe - _loans[0].TotalPagado + _loans[0].Asignado;
_loans[0].PendienteAsignar = _loans[0].Pendiente - _loans[0].Asignado;
}
}
catch (Exception ex)
{
if (_entity != null)
{
_entity.CloseSession();
}
throw ex;
}
}
public static LoanList GetList(int applicantId)
{
LoanList loans = new LoanList();
using(OracleConnection oraDbConn =
new OracleConnection(
ConnStringFactory.getConnString(
ConnStringFactory.ConnStringType.Oracle))){
oraDbConn.Open();
using(OracleCommand getLoansByAppIdCommand = new OracleCommand()){
getLoansByAppIdCommand.CommandType = CommandType.StoredProcedure;
getLoansByAppIdCommand.CommandText = "LoansPKG.getLoansByAppId";
getLoansByAppIdCommand.Connection = oraDbConn;
getLoansByAppIdCommand.Parameters.AddWithValue("AppId", applicantId);
OracleParameter outputCursor = new OracleParameter("IO_CURSOR", OracleType.Cursor);
outputCursor.Direction = ParameterDirection.Output;
getLoansByAppIdCommand.Parameters.Add(outputCursor);
using (OracleDataReader loanListReader =
getLoansByAppIdCommand.ExecuteReader()) {
while(loanListReader.Read()){
loans.Add(FillDataRecord(loanListReader));
}
}
}
}
return loans;
}
public async Task <IActionResult> Edit(int id, LoanList loanList)
{
if (id != loanList.loatypeID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(loanList);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!LoanListExists(loanList.loatypeID))
{
return(NotFound());
}
throw;
}
return(RedirectToAction("Index"));
}
return(View(loanList));
}
public LoanSelectForm(Form parent, LoanList list)
: base(true, parent, list, ELoanType.All)
{
InitializeComponent();
SetView(molView.Select);
DialogResult = DialogResult.Cancel;
}
public void DeleteLoanFromList(LoanEntity newEntity)
{
LoanEntity oldEntity = LoanList.FirstOrDefault <LoanEntity>(p => p.LoanId == newEntity.LoanId);
if (oldEntity != null)
{
LoanList.Remove(oldEntity);
}
LoanList = new List <LoanEntity>(_loanList);
}
public override void UpdateList()
{
switch (_current_action)
{
case molAction.Add:
case molAction.Copy:
if (_entity == null)
{
return;
}
List.AddItem(_entity.GetInfo());
if (FilterType == IFilterType.Filter)
{
LoanList listA = LoanList.GetList(_filter_results);
listA.AddItem(_entity.GetInfo());
_filter_results = listA.GetSortedList();
}
break;
case molAction.Edit:
case molAction.Lock:
case molAction.Unlock:
case molAction.ChangeStateAnulado:
if (_entity == null)
{
return;
}
ActiveItem.CopyFrom(_entity);
break;
case molAction.Delete:
if (ActiveItem == null)
{
return;
}
List.RemoveItem(ActiveOID);
if (FilterType == IFilterType.Filter)
{
LoanList listD = LoanList.GetList(_filter_results);
listD.RemoveItem(ActiveOID);
_filter_results = listD.GetSortedList();
}
break;
}
RefreshSources();
if (_entity != null)
{
Select(_entity.Oid);
}
_entity = null;
}
public async Task <IActionResult> Create(LoanList lists)
{
if (ModelState.IsValid)
{
_context.loanlist.Add(lists);
await _context.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(lists));
}
protected override void RefreshMainData()
{
Datos.DataSource = _entity;
SetParametrosPagoComercioExteriorAction();
PgMng.Grow();
Datos_Lineas.DataSource = LoanList.GetSortedList(_loans, "FechaFirma", ListSortDirection.Ascending);
PgMng.Grow();
Fecha_DTP.Value = _entity.Fecha;
Vencimiento_DTP.Value = _entity.Vencimiento;
base.RefreshMainData();
}
/// <summary>
/// To save details to database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void SetGridSource(bool showRecentRecords)
{
string EncumbrancepurposeName;
EncumbrancepurposeName = txtSearch.Text.Trim();
LoanBLL objLoanBLL = new LoanBLL();
LoanList objLoanList = new LoanList();
objLoanList = objLoanBLL.GetLoan(EncumbrancepurposeName);
if (objLoanList.Count > 0)
{
GrdPurposeofencumbrance.DataSource = objLoanList;
GrdPurposeofencumbrance.DataBind();
}
}
public LoanMngForm(bool isModal, Form parent, LoanList list, ELoanType loanType)
: base(isModal, parent, list)
{
InitializeComponent();
SetView(molView.Normal);
// Parche para poder abrir el formulario en modo diseño y no perder la configuracion de columnas
DatosLocal_BS = Datos;
Tabla.DataSource = DatosLocal_BS;
SetMainDataGridView(Tabla);
Datos.DataSource = LoanList.NewList().GetSortedList();
SortProperty = FechaVencimiento.DataPropertyName;
SortDirection = ListSortDirection.Descending;
_loan_type = loanType;
}
protected override void GetFormSourceData(object[] parameters)
{
if (parameters[0] == null)
{
_loan = (Loan)parameters[2];
_entity = Payment.New(_loan.GetInfo(false));
_entity.BeginEdit();
_entity.Oid = -1;
_loans = LoanList.NewList(_loan);
PaymentList pagos = PaymentList.GetListByPrestamo(_loans[0], false);
_loans[0].TotalPagado = 0;
_loans[0].Asignado = 0;
foreach (PaymentInfo pago in pagos)
{
if (pago.EEstado == moleQule.Base.EEstado.Anulado)
{
continue;
}
_loans[0].TotalPagado += pago.Importe;
}
_loans[0].Pendiente = _loans[0].Importe - _loans[0].TotalPagado;
_loans[0].PendienteAsignar = _loans[0].Pendiente;
}
else
{
_entity = (Payment)parameters[0];
_entity.BeginEdit();
_entity.Oid = -1;
_loans = LoanList.GetPendientesList(_entity.GetInfo(false));
}
//Asociamos los gastos previamente vinculados
foreach (TransactionPayment item in _entity.Operations)
{
LoanInfo prestamo = _loans.GetItem(item.OidOperation);
prestamo.Vincula();
}
}
protected override void GetFormSourceData(long oid, object[] parameters)
{
ETipoPago tipo = ETipoPago.Prestamo;
if (parameters[1] != null)
{
_loan = (LoanInfo)parameters[1];
}
_entity = PaymentInfo.Get(oid, tipo, true);
_mf_type = ManagerFormType.MFView;
_loans = _loan != null?
LoanList.NewList(_loan)
: LoanList.GetByPagoAndPendientesList(_entity);
//if (_prestamo != null)
{
PaymentList pagos = PaymentList.GetListByPrestamo(_loans[0], false);
TransactionPaymentInfo pf = _entity.Operations != null?_entity.Operations.GetItemByFactura(_loans[0].Oid) : null;
if (pf != null)
{
_loans[0].Asignado = pf.Cantidad;
_loans[0].TotalPagado = 0;
foreach (PaymentInfo pago in pagos)
{
if (pago.EEstado == moleQule.Base.EEstado.Anulado)
{
continue;
}
_loans[0].TotalPagado += pago.Importe;
}
}
_loans[0].Pendiente = _loans[0].Importe - _loans[0].TotalPagado + _loans[0].Asignado;
_loans[0].PendienteAsignar = _loans[0].Pendiente - _loans[0].Asignado;
}
}
protected void UpdateAmount()
{
decimal _asignado = 0;
LoanList loans = Datos_Lineas.DataSource as LoanList;
foreach (LoanInfo item in loans)
{
_asignado += item.Asignado;
}
if (_entity.Importe >= 0)
{
_entity.Importe = (_entity.Importe) > _asignado ? _entity.Importe : _asignado;
}
else
{
_entity.Importe = (_entity.Importe) < _asignado ? _entity.Importe : _asignado;
}
}
public void AddOrUpdateLoanToList(LoanEntity newEntity)
{
if (LoanList == null)
{
LoanList = new List <LoanEntity>();
}
LoanEntity oldEntity = LoanList.FirstOrDefault <LoanEntity>(p => p.LoanId == newEntity.LoanId);
if (oldEntity == null)
{
LoanList.Insert(0, newEntity);
}
else
{
int index = LoanList.IndexOf(oldEntity);
LoanList.Remove(oldEntity);
LoanList.Insert(index, newEntity);
}
LoanList = new List <LoanEntity>(_loanList);
}
private void BindDataGrid()
{
ApplicantList applicants = new ApplicantList();
applicants = ApplicantManager.GetList();
LoanList loans = new LoanList();
foreach (Applicant applicant in applicants) {
loans.AddRange(applicant.Loans);
}
if (applicants.Count > 0) {
var LoanApp = from loan in loans
join app in applicants on loan.ApplicantId equals app.Id
select new {
app.Name,
app.Gender,
app.SSN,
loan.Amount,
loan.Type
};
grdLoanApp.DataSource = LoanApp.ToList();
StyleDataGrid();
}
}
public MerchantLoanMngForm(bool isModal, Form parent, LoanList list)
: base(isModal, parent, list, ELoanType.Merchant)
{
Text = Resources.Labels.PRESTAMOS_COMERCIO_EXTERIOR;
}
public BankLoanMngForm(bool isModal, Form parent, LoanList list)
: base(isModal, parent, list, ELoanType.Bank)
{
}
