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); } }