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