public TOTransaction setInfoRemes(EeReenc eereenc)
{
DAOEeRemes daoEeRemes = new DAOEeRemes();
try
{
int emp_codi = int.Parse(ConfigurationManager.AppSettings["emp_codi"]);
int rem_cont = daoEeRemes.insertEeremes(eereenc, emp_codi);
if (rem_cont == -1)
{
throw new Exception("Se produjo un error, comuniquese con el administrador");
}
return(new TOTransaction()
{
retorno = 0, txtRetorno = rem_cont.ToString()
});
}
catch (Exception ex)
{
return(new TOTransaction()
{
retorno = 1, txtRetorno = ex.Message
});
}
}
public int insertEeremes(EeReenc eereenc, int emp_codi)
{
try
{
StringBuilder sql = new StringBuilder();
sql.Append("INSERT INTO EE_REMES(REM_CONT, CLI_CODA, ITE_SERV, ITE_MORE, EMP_CODI, AUD_USUA, AUD_ESTA, AUD_UFAC,REM_FECH)");
sql.Append("VALUES(@REM_CONT, @CLI_CODA, @ITE_SERV, @ITE_MORE, @EMP_CODI, @AUD_USUA, @AUD_ESTA, @AUD_UFAC,@REM_FECH)");
int rem_cont = GetCont(emp_codi, "EE_REMES");
List <SQLParams> sqlparams = new List <SQLParams>();
sqlparams.Add(new SQLParams("REM_CONT", rem_cont));
sqlparams.Add(new SQLParams("CLI_CODA", eereenc.cli_coda));
sqlparams.Add(new SQLParams("ITE_SERV", eereenc.ree_serv));
sqlparams.Add(new SQLParams("ITE_MORE", eereenc.ree_more));
sqlparams.Add(new SQLParams("EMP_CODI", emp_codi));
sqlparams.Add(new SQLParams("AUD_USUA", "SEVEN"));
sqlparams.Add(new SQLParams("AUD_ESTA", "A"));
sqlparams.Add(new SQLParams("AUD_UFAC", DateTime.Now));
sqlparams.Add(new SQLParams("REM_FECH", DateTime.Now));
new DbConnection().Insert(sql.ToString(), false, sqlparams);
return(rem_cont);
}
catch (Exception ex)
{
return(-1);
}
}
public TOTransaction Post(EeReenc eereenc)
{
BoEeRemes bo = new BoEeRemes();
return(bo.setInfoRemes(eereenc));
}
