public TOTransaction <CtRevPrSalida> sendMailPropo(string mailTo)
{
DAORevPr daoRevPr = new DAORevPr();
DAOGnInsta daoInsta = new DAOGnInsta();
mailHandler mailHandler = new mailHandler();
try
{
string subject = ConfigurationManager.AppSettings["asuntoCreacion"].ToString();
string body = ConfigurationManager.AppSettings["cuerpoCreacion"].ToString();
body = string.Format("{0}{1}{2}", "<p style = 'text-align: justify; '>", body, "</p>");
Mail mail = mailHandler.generateMailCtPropo(mailTo, subject, body);
GnInsta insta = daoInsta.GetGnInsta();
mailHandler.sendMail(mail, insta);
return(new TOTransaction <CtRevPrSalida>()
{
objTransaction = new CtRevPrSalida()
{
msg = "El correo ha sido enviado de manera exitosa"
}, retorno = 0, txtRetorno = ""
});
}
catch (Exception ex)
{
return(new TOTransaction <CtRevPrSalida>()
{
objTransaction = null, retorno = 1, txtRetorno = ex.Message
});
}
}
public TOTransaction <CtRevPrSalida> PostPropo(CtPropo propo)
{
DAORevPr daoRevPr = new DAORevPr();
DAOGnInsta daoInsta = new DAOGnInsta();
mailHandler mailHandler = new mailHandler();
try
{
propo.rev_cont = daoRevPr.GetCont("CT_REVPR", "REV_CONT", propo.emp_codi);
daoRevPr.InseCTREVPR(propo);
return(new TOTransaction <CtRevPrSalida>()
{
objTransaction = new CtRevPrSalida()
{
rev_cont = propo.rev_cont, msg = "La transacción ha sido enviada de manera satisfactoria"
}, retorno = 0, txtRetorno = ""
});
}
catch (Exception ex)
{
return(new TOTransaction <CtRevPrSalida>()
{
objTransaction = null, retorno = 1, txtRetorno = ex.Message
});
}
}
public TOTransaction setStatePropo(int emp_codi, int rev_cont)
{
DAOCtConsu daoCtConsu = new DAOCtConsu();
DAOGnInsta daoInsta = new DAOGnInsta();
mailHandler mailHandler = new mailHandler();
try
{
daoCtConsu.setCtpropo(emp_codi, rev_cont, "R");
string subject = ConfigurationManager.AppSettings["asuntoRechazo"].ToString();
string body = ConfigurationManager.AppSettings["cuerpoRechazo"].ToString();
body = string.Format("{0}{1}{2}", "<p style = 'text-align: justify; '>", body, "</p>");
Mail mail = mailHandler.generateMailCtPropo(email, subject, body);
GnInsta insta = daoInsta.GetGnInsta();
mailHandler.sendMail(mail, insta);
return(new TOTransaction()
{
retorno = 0, txtRetorno = ""
});
}
catch (Exception ex)
{
return(new TOTransaction()
{
retorno = 1, txtRetorno = ex.Message
});
}
}
public TOTransaction SetCfScrev(Cf_Screv credito)
{
float cas_cont = 0;
var daoCodeu = new DAO_Cf_Codeu();
try
{
var infoFlujo = new DAOWfRflup().GetInfoFlujo("SCFSCREV", credito.emp_codi);
if (credito.codeudores != null)
{
foreach (Cf_Codeu codeudor in credito.codeudores)
{
if (codeudor.cod_cont == 0)
{
codeudor.cod_cont = daoCodeu.GetContCfCodeu(codeudor.emp_codi);
daoCodeu.SetCfCodeu(codeudor);
}
else
{
daoCodeu.Update(codeudor);
}
if (codeudor.referencias != null && codeudor.referencias.Any())
{
foreach (Cf_Refen referecia in codeudor.referencias)
{
referecia.cod_cont = codeudor.cod_cont;
//referecia.ref_cont = codeudor.referencias.IndexOf(referecia) + 1;
referecia.ref_noco = string.Format("{0} {1} {2} {3}", referecia.ref_nm1r, referecia.ref_nm2r, referecia.ref_ap1r, referecia.ref_ap2r);
new DAO_Cf_Refen().SetCfRefe(referecia);
}
}
}
}
SCfScrev.SCfScrevDMR com = new SCfScrev.SCfScrevDMR();
string usuario = ConfigurationManager.AppSettings["usuario"];
string password = ConfigurationManager.AppSettings["password"];
string alias = ConfigurationManager.AppSettings["alias"];
//SCfCodeu.SCfCodeuDMR comCodeudor = new SCfCodeu.SCfCodeuDMR();
//comCodeudor.emp_codi = credito.emp_codi;
//comCodeudor.InsertCfCodeu(;
com.loginAlias(usuario, password, alias);
credito.aud_usua = ConfigurationManager.AppSettings["usuario"] == null ? "Seven" : ConfigurationManager.AppSettings["usuario"];
credito.aud_ufac = DateTime.Now;
credito.aud_esta = "A";
credito.dcl_codd = 1;
credito.scr_anop = DateTime.Now.Year;
credito.scr_mesp = DateTime.Now.Month;
credito.scr_diap = DateTime.Now.Day;
credito.scr_fech = DateTime.Now;
credito.scr_nech = int.Parse(DateTime.Now.ToString("ddMMyyyy"));
credito.scr_fevi = DateTime.Now;
credito.scr_esta = "S";
credito.dcl_codd = 1;
com.scr_gerj = "M";
com.scr_cara = "P";
com.scr_gefc = "M";
com.dcl_dire = credito.scr_dire;
com.dcl_ntel = credito.scr_tele;
com.dcl_nfax = credito.dcl_nfax;
com.dcl_mail = credito.dcl_mail;
com.top_codi = credito.top_codi;
string arb_csuc = new DAO_Gn_Arbol().GetGnArbol(credito.emp_codi, credito.arb_sucu).arb_codi;
var x = com.InsertarCfScrev(credito.emp_codi, credito.top_codi, 0, credito.scr_fech.ToString("dd-MM-yyyy"), arb_csuc,
new DAO_Fa_Clien().GetCliCoda(credito.emp_codi, credito.cli_codi), credito.dcl_codd, new DAO_Ca_Licre().GetCaLicre(credito.emp_codi, credito.lic_cont).lic_codi, 0, 0, credito.scr_ncuo, credito.scr_fech.ToString("dd-MM-yyyy"), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, credito.scr_vsol, ".", "0", "",
credito.scr_fpcu.ToString("dd-MM-yyyy"), "N", credito.scr_gene, DateTime.Now.ToString("dd-MM-yyyy"), credito.scr_trab, 0, 0, 0, "E", DateTime.Now.ToString("dd-MM-yyyy"), credito.scr_nent, credito.scr_diem, credito.scr_teem, "", credito.pai_codu, credito.dep_codu, credito.mun_codu, credito.scr_sala, "", "", 0, 0, 0, 0, "0", "", "",
0, 0, "", "", 0, "", credito.scr_care, "", "", "", "", "", "", DateTime.Now.ToString("dd-MM-yyyy"), "", credito.codeudores.FirstOrDefault().cod_dnum, "", "", "", DateTime.Now.ToString("dd-MM-yyyy"), "", "");
if (x != 0)
{
throw new Exception(com.TxtError);
}
if (infoFlujo.Rows.Count > 0)
{
//caso 620238: Se inicia la creación del flujo.
int scr_cont = 0;
cas_cont = new mailHandler().createWorkFlow("SCR_CONT", string.Format("Solicitud de crédito número {0} con tipo de operación {1}", com.scr_nume, credito.top_codi), "SCFSCREV", scr_cont, credito.emp_codi, "SCFSCREV", "CA_SCREV");
if (cas_cont > 0)
{
new DAO_Cf_Screv().updateWorkFlow(credito.emp_codi, com.scr_cont, cas_cont);
}
}
return(new TOTransaction()
{
Retorno = 0, TxtError = ""
});
}
catch (Exception ex)
{
return(new TOTransaction()
{
Retorno = 1, TxtError = ex.Message
});
}
}
public TOTransaction setInfoCtPropo(int emp_codi, int rev_cont, List <CtRevdo> ctrevdo)
{
SCtPropo.SCtPropoDMR ws = new SCtPropo.SCtPropoDMR();
ws.loginAlias(usuario, password, alias);
DAOCtConsu daoCtConsu = new DAOCtConsu();
DAOGnInsta daoInsta = new DAOGnInsta();
mailHandler mailHandler = new mailHandler();
CtPropo propo = new CtPropo();
try
{
int procont = 0;
ws.emp_codi = emp_codi;
ws.GenerarProCont();
string subject = ConfigurationManager.AppSettings["asuntoAprobacion"].ToString();
string body = ConfigurationManager.AppSettings["cuerpoAprobacion"].ToString();
body = string.Format("{0}{1}{2}", "<p style = 'text-align: justify;'>", body, "</p>");
if (ws.txtError != null)
{
throw new Exception(ws.txtError);
}
else
{
procont = Convert.ToInt32(ws.pro_cont);
}
daoCtConsu.insertCtPropo(rev_cont, procont, emp_codi);
daoCtConsu.insertCtDtrda(rev_cont, procont, emp_codi);
daoCtConsu.insertCtAcxpr(rev_cont, procont, emp_codi);
daoCtConsu.insertCtDocpr(rev_cont, procont, emp_codi, ctrevdo);
daoCtConsu.setCtpropo(emp_codi, rev_cont, "A");
propo = daoCtConsu.getctpropo(emp_codi, rev_cont);
Mail mail = mailHandler.generateMailCtPropo(propo.pro_mail, subject, body);
GnInsta insta = daoInsta.GetGnInsta();
mailHandler.sendMail(mail, insta);
ws.loginAlias(usuario, password, alias);
ws.emp_codi = propo.emp_codi;
ws.pro_coal = propo.pro_codi;
ws.pro_dive = propo.pro_dive;
ws.tip_codi = propo.tip_codi;
ws.pro_nomb = propo.pro_nomb;
ws.pro_apel = propo.pro_apel;
ws.pro_clap = propo.pro_clap;
ws.pro_nroe = propo.pro_nroe;
ws.pro_fesc = propo.pro_fesc;
ws.pro_nomr = propo.pro_nomr;
ws.pro_nror = propo.pro_nror;
ws.pvr_clad = propo.pro_clad; // clasificacion DIAN
ws.pvr_riva = propo.pro_riva; // Regimen IVA
ws.pvd_clad = propo.pro_claf; // clasificacion
ws.pro_ntel = propo.pro_ntel;
ws.pro_mail = propo.pro_mail;
ws.pro_nfax = propo.pro_nfax;
ws.pro_pais = propo.pro_pais;
ws.pro_regi = propo.pro_regi;
ws.pro_depa = propo.pro_depa;
ws.pro_muni = propo.pro_muni;
ws.InsertarProveedor();
return(new TOTransaction()
{
retorno = 0, txtRetorno = ""
});
}
catch (Exception ex)
{
return(new TOTransaction()
{
retorno = 1, txtRetorno = ex.Message
});
}
}
