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
});
}
}
private void insertPqr(PqInpqr pqr, string typeRequest)
{
DAOPqParam daoPqParam = new DAOPqParam();
DAOGnInsta daoInsta = new DAOGnInsta();
DAOGnLogo daoLogo = new DAOGnLogo();
if (string.IsNullOrEmpty(pqr.inp_nide))
{
pqr.inp_nide = ".";
}
int result = daoPqr.InseRSELFANG(pqr);
pqr.genratedKey = mailHandler.GetPassword(pqr);
// valida si tiene parametrizado Manejo Correo de Ingreso PQR en PQ_PARAM
var MailPQParam = daoPqParam.GetMailParam(pqr.emp_codi);
if (MailPQParam.par_mcin == "S") // Si tiene configurado envio de correo al ingresar un PQR
{
if (MailPQParam.par_tcin == null) // si no tiene una plantilla configurada para ingreso de PQR, continua con el metodo original para Defensa Civil
{
pqr.genratedKey = mailHandler.GetPassword(pqr);
Mail mail = mailHandler.generateMail(pqr, MailPQParam, typeRequest);
Mail mailModulo = mailHandler.generateMail(pqr, MailPQParam, "", "Modulo");
GnInsta insta = daoInsta.GetGnInsta();
mailHandler.sendMail(mail, insta);
mailHandler.sendMail(mailModulo, insta);
}
else
{
Gnlogo Logo = daoLogo.GetGnLogo(pqr.emp_codi);
MailImages ItemList = new MailImages();
ItemList.imageType = "Jpeg";
ItemList.sourceName = "logo";
ItemList.imgBytes = Logo.emp_logs;
List <MailImages> LstImg = new List <MailImages>();
LstImg.Add(ItemList);
Mail mail = mailHandler.generateMailFromPQParam(pqr, MailPQParam, typeRequest);
Mail mailModulo = mailHandler.generateMailFromPQParam(pqr, MailPQParam, "", "Modulo");
GnInsta insta = daoInsta.GetGnInsta();
mailHandler.sendMail(mail, insta, true, LstImg);
mailHandler.sendMail(mailModulo, insta, true, LstImg);
}
}
}
public TOTransaction <List <CtRevdo> > GetInfoVigencia(int emp_codi, int rev_cont)
{
DAOCtConsu daoCtConsu = new DAOCtConsu();
DAOGnInsta daoInsta = new DAOGnInsta();
try
{
List <CtRevdo> result = new List <CtRevdo>();
GnInsta insta = daoInsta.GetGnInsta();
result = daoCtConsu.GetCtRevDoBD(emp_codi, rev_cont);
if (result != null)
{
foreach (CtRevdo file in result)
{
downLoadFileFromDb(file.rad_llav, "SCTREVDO", "CT_REVDO", emp_codi, file.adj_nomb, file.adj_file);
}
}
else
{
result = daoCtConsu.GetCtRevDo(emp_codi, rev_cont);
foreach (CtRevdo file in result)
{
downLoadFile(file.rad_llav, "SCTREVDO", "CT_REVDO", emp_codi, file.adj_nomb);
}
}
return(new TOTransaction <List <CtRevdo> >()
{
objTransaction = result, retorno = 0, txtRetorno = ""
});
}
catch (Exception ex)
{
return(new TOTransaction <List <CtRevdo> >()
{
objTransaction = null, retorno = 1, txtRetorno = 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
});
}
}
