public TOTransaction <List <TORevPr> > GetInfoDataCtConsu(int emp_codi, string rev_esta, string pro_codi, string pro_nomb)
{
DAOCtConsu daoCtConsu = new DAOCtConsu();
try
{
List <TORevPr> result = new List <TORevPr>();
result = daoCtConsu.getctconsu(emp_codi, rev_esta, pro_codi, pro_nomb);
if (result == null)
{
throw new Exception("No se encontraron datos con los parámetros especificados");
}
return(new TOTransaction <List <TORevPr> >()
{
objTransaction = result, retorno = 0, txtRetorno = ""
});
}
catch (Exception ex)
{
return(new TOTransaction <List <TORevPr> >()
{
objTransaction = null, retorno = 1, txtRetorno = ex.Message
});
}
}
public TOTransaction <List <GnArbol> > GetInfoCtAcxpr(int emp_codi, int rev_cont)
{
DAOCtConsu daoCtConsu = new DAOCtConsu();
try
{
List <GnArbol> result = new List <GnArbol>();
result = daoCtConsu.getctacxpr(emp_codi, rev_cont);
if (result == null)
{
throw new Exception("No se encontraron datos con los parámetros especificados");
}
return(new TOTransaction <List <GnArbol> >()
{
objTransaction = result, retorno = 0, txtRetorno = ""
});
}
catch (Exception ex)
{
return(new TOTransaction <List <GnArbol> >()
{
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 <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 setInfoVigencia(int emp_codi, int rev_cont, int doc_cont, bool chkApro)
{
DAOCtConsu daoCtConsu = new DAOCtConsu();
try
{
daoCtConsu.setCtRevdo(emp_codi, rev_cont, doc_cont, chkApro);
return(new TOTransaction()
{
retorno = 0, txtRetorno = ""
});
}
catch (Exception ex)
{
return(new TOTransaction()
{
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
});
}
}
public BOCtConsu(int emp_codi, int rev_cont)
{
DAOCtConsu daoCtConsu = new DAOCtConsu();
email = daoCtConsu.getSendMailTo(emp_codi, rev_cont);
}
