public List <Data.T_Archivo> Execute(int CodigoSolCredito)
{
using (_Entities = new ValentineEntities())
{
var Result = _Entities.T_Archivo.Where(A => A.codigoSolCredito == CodigoSolCredito).ToList();
return(Result);
}
}
public List <Data.T_Parametro> Execute(int PadreID)
{
using (_Entities = new ValentineEntities())
{
var Result = _Entities.T_Parametro.Where(s => s.Padre == PadreID).ToList();
return(Result);
}
}
public Data.T_Archivo Execute(Data.T_Archivo Model)
{
using (_Entities = new ValentineEntities())
{
_Entities.T_Archivo.Add(Model);
_Entities.SaveChanges();
return(Model);
}
}
public Data.T_SolicitudCredito Execute(int ID)
{
using (_Entities = new ValentineEntities())
{
var Result = _Entities.T_SolicitudCredito.Where(s => s.codigoSolCredito == ID).FirstOrDefault();
//var Result = Mapper.Map<GetSolicitudCreditoQueryModel>(ResultQuery);
return(Result);
}
}
public Data.T_Prestatario Execute(int TipoDocumento, string NumeroDocumento)
{
using (_Entities = new ValentineEntities())
{
var Result = _Entities.T_Prestatario.Where(s => s.tipoDocumento == TipoDocumento && s.numeroDocumento == NumeroDocumento).FirstOrDefault();
//var Result = Mapper.Map<GetSolicitudCreditoQueryModel>(ResultQuery);
return(Result);
}
}
public RegisterFirstStepCommandModel Execute(RegisterFirstStepCommandModel Model)
{
using (_Entities = new ValentineEntities())
{
var _T_SolicitudCredito = Mapper.Map <Data.T_SolicitudCredito>(Model);
_Entities.T_SolicitudCredito.Add(_T_SolicitudCredito);
_Entities.SaveChanges();
var Result = Mapper.Map <RegisterFirstStepCommandModel>(_T_SolicitudCredito);
return(Result);
}
}
public List <Data.T_Ubigeo> Execute(int PadreID)
{
using (_Entities = new ValentineEntities())
{
if (PadreID == 0)
{
var Result = _Entities.T_Ubigeo.Where(s => s.Ubigeo_Padre == null).ToList();
return(Result);
}
else
{
var Result = _Entities.T_Ubigeo.Where(s => s.Ubigeo_Padre == PadreID).ToList();
return(Result);
}
}
}
public RegisterSecondStepCommandModel Execute(int ID, RegisterSecondStepCommandModel Model)
{
using (_Entities = new ValentineEntities())
{
var _T_SolicitudCredito = _Entities.T_SolicitudCredito.Where(s => s.codigoSolCredito == ID).FirstOrDefault();
Mapper.Map(Model, _T_SolicitudCredito);
_Entities.T_SolicitudCredito.Attach(_T_SolicitudCredito);
_Entities.Entry(_T_SolicitudCredito).State = EntityState.Modified;
_Entities.SaveChanges();
var client = new SmtpClient("smtp.gmail.com", 587)
{
Credentials = new NetworkCredential("*****@*****.**", "valentinepassword"),
EnableSsl = true
};
client.Send("*****@*****.**", _T_SolicitudCredito.correoElectronico, "test", "testbody");
return(Model);
}
}
