public int setCtpropo(int emp_codi, int rev_cont, string state)
{
StringBuilder sql = new StringBuilder();
DateTime date = DateTime.Now;
sql.Append(" UPDATE CT_REVPR");
sql.Append(" SET REV_ESTA = @REV_ESTA,");
sql.Append(" AUD_ESTA = @AUD_ESTA, ");
sql.Append(" AUD_UFAC = @AUD_UFAC, ");
sql.Append(" AUD_USUA = @AUD_USUA ");
sql.Append(" WHERE EMP_CODI = @EMP_CODI");
sql.Append(" AND REV_CONT = @REV_CONT");
List <Parameter> parametros = new List <Parameter>();
parametros.Add(new Parameter("@EMP_CODI", emp_codi));
parametros.Add(new Parameter("@REV_CONT", rev_cont));
parametros.Add(new Parameter("@AUD_ESTA", "M"));
parametros.Add(new Parameter("@AUD_UFAC", date));
parametros.Add(new Parameter("@AUD_USUA", "SEVEN"));
parametros.Add(new Parameter("@REV_ESTA", state));
OTOContext pTOContext = new OTOContext();
var conection = DBFactory.GetDB(pTOContext);
return(conection.Insert(pTOContext, sql.ToString(), parametros.ToArray()));
}
public int insertCtAcxpr(int rev_cont, int pro_cont, int emp_codi)
{
StringBuilder sql = new StringBuilder();
DateTime date = DateTime.Now;
sql.Append(" INSERT INTO CT_ACXPR(AUD_ESTA, AUD_UFAC, AUD_USUA, EMP_CODI, ARB_CONT, PRO_CONT) ");
sql.Append(" SELECT @AUD_ESTA, @AUD_UFAC, @AUD_USUA, EMP_CODI, ARB_CONT, @PRO_CONT ");
sql.Append(" FROM CT_REVAC ");
sql.Append(" WHERE EMP_CODI = @EMP_CODI ");
sql.Append(" AND REV_CONT = @REV_CONT ");
List <Parameter> parametros = new List <Parameter>();
parametros.Add(new Parameter("@REV_CONT", rev_cont));
parametros.Add(new Parameter("@EMP_CODI", emp_codi));
parametros.Add(new Parameter("@PRO_CONT", pro_cont));
parametros.Add(new Parameter("@AUD_USUA", "SEVEN"));
parametros.Add(new Parameter("@AUD_UFAC", date));
parametros.Add(new Parameter("@AUD_ESTA", "A"));
OTOContext pTOContext = new OTOContext();
var conection = DBFactory.GetDB(pTOContext);
return(conection.Insert(pTOContext, sql.ToString(), parametros.ToArray()));
}
public int UpdSoSocip(TOSoSocio toSoSocio)
{
List <Parameter> listAux = new List <Parameter>();
try
{
StringBuilder sql = new StringBuilder();
sql.Append(" UPDATE SO_SBENE ");
sql.Append(" SET SBE_PASS = @P_SBE_PASS ");
sql.Append(" WHERE EMP_CODI = @P_EMP_CODI ");
sql.Append(" AND SOC_CONT = @P_SOC_CONT ");
sql.Append(" AND SBE_CONT = @P_SBE_CONT ");
listAux.Add(new Parameter("@P_SBE_PASS", toSoSocio.Soc_pass));
listAux.Add(new Parameter("@P_EMP_CODI", toSoSocio.Emp_codi));
listAux.Add(new Parameter("@P_SOC_CONT", toSoSocio.Soc_cont));
listAux.Add(new Parameter("@P_SBE_CONT", toSoSocio.Sbe_cont));
Parameter[] oParameter = listAux.ToArray();
OTOContext pTOContext = new OTOContext();
var conection = DBFactory.GetDB(pTOContext);
var objeto = conection.Update(pTOContext, sql.ToString(), oParameter);
return(objeto.AsInt());
}
catch (Exception ex)
{
BOException.Throw(this.GetType().ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
return(-1);
}
}
public int setCtRevdo(int emp_codi, int rev_cont, int doc_cont, bool chkApro)
{
StringBuilder sql = new StringBuilder();
sql.Append(" UPDATE CT_REVDO");
sql.Append(" SET REV_APRO = @REV_APRO");
sql.Append(" WHERE EMP_CODI = @EMP_CODI");
sql.Append(" AND REV_CONT = @REV_CONT");
sql.Append(" AND DOC_CONT = @DOC_CONT");
List <Parameter> parametros = new List <Parameter>();
parametros.Add(new Parameter("@EMP_CODI", emp_codi));
parametros.Add(new Parameter("@REV_CONT", rev_cont));
parametros.Add(new Parameter("@DOC_CONT", doc_cont));
if (chkApro)
{
parametros.Add(new Parameter("@REV_APRO", "S"));
}
else
{
parametros.Add(new Parameter("@REV_APRO", "N"));
}
OTOContext pTOContext = new OTOContext();
var conection = DBFactory.GetDB(pTOContext);
return(conection.Insert(pTOContext, sql.ToString(), parametros.ToArray()));
}
public List <PqInpqr> getPqInPqrEncuestas(int inp_cont, int emp_codi = 0)
{
StringBuilder sql = new StringBuilder();
List <Parameter> parameters = new List <Parameter>();
sql.Append(" SELECT case when ISNUMERIC(PQ_INPQR.INP_TIDO) = 1 then GN_TIPDO.TIP_NOMB else GN_TIPDO2.TIP_NOMB end INP_TIDO, ");
sql.Append(" PQ_INPQR.*, '' DIG_VALO ");
sql.Append(" FROM PQ_INPQR ");
sql.Append(" left join GN_TIPDO on convert(varchar, GN_TIPDO.TIP_CODI) = PQ_INPQR.INP_TIDO ");
sql.Append(" left join GN_TIPDO GN_TIPDO2 on convert(varchar, GN_TIPDO2.TIP_ABRE) = PQ_INPQR.INP_TIDO ");
sql.Append(" WHERE INP_CONT = @INP_CONT ");
if (emp_codi > 0)
{
sql.Append(" AND EMP_CODI=@EMP_CODI");
parameters.Add(new Parameter("@EMP_CODI", emp_codi));
}
parameters.Add(new Parameter("@INP_CONT", inp_cont));
OTOContext pTOContext = new OTOContext();
var conection = DBFactory.GetDB(pTOContext);
var data = conection.ReadList(pTOContext, sql.ToString(), Make, parameters.ToArray());
return(data);
}
public int GetInfoValidEnc(string cli_coda, int ite_serv, int emp_codi, string redEnc)
{
StringBuilder sql = new StringBuilder();
List <Parameter> parametros = new List <Parameter>();
sql.Append(" SELECT REM_CONT ");
sql.Append(" FROM EE_REMES ");
sql.Append(" WHERE CLI_CODA = @CLI_CODA ");
sql.Append(" AND ITE_SERV = @ITE_SERV ");
sql.Append(" AND EMP_CODI = @EMP_CODI ");
sql.Append(" AND REM_CONT ");
sql.Append(" IN ( ");
sql.Append(" SELECT REM_CONT FROM EE_RESEN WHERE EMP_CODI = @EMP_CODI ");
sql.Append(" UNION ");
sql.Append(" SELECT REM_CONT FROM EE_RESEM WHERE EMP_CODI = @EMP_CODI ");
sql.Append(" ) ");
if (redEnc == "N")
{
sql.Append(" AND CONVERT(VARCHAR,REM_FECH,103) = CONVERT(VARCHAR,GETDATE(),103) ");
}
parametros.Add(new Parameter("@CLI_CODA", cli_coda));
parametros.Add(new Parameter("@EMP_CODI", emp_codi));
parametros.Add(new Parameter("@ITE_SERV", ite_serv));
OTOContext pTOContext = new OTOContext();
var conection = DBFactory.GetDB(pTOContext);
var result = conection.GetScalar(pTOContext, sql.ToString(), parametros.ToArray());
if (result == null)
{
return(0);
}
return(result.AsInt());
}
public List <TOPqInpqr> GetPqInpqr(short emp_codi, int soc_cont, int sbe_cont)
{
List <Parameter> listAux = new List <Parameter>();
try
{
StringBuilder sql = new StringBuilder();
sql.Append(" SELECT INP_CONT, INP_ESTA, INP_MPQR, INP_FEVE ");
sql.Append(" FROM PQ_INPQR ");
sql.Append(" WHERE EMP_CODI = @P_EMP_CODI ");
sql.Append(" AND SOC_CONT = @P_SOC_CONT ");
sql.Append(" AND SBE_CONT = @P_SBE_CONT ");
sql.Append(" AND SBE_CONT = @P_SBE_CONT ");
listAux.Add(new Parameter("@P_EMP_CODI", emp_codi));
listAux.Add(new Parameter("@P_SOC_CONT", soc_cont));
listAux.Add(new Parameter("@P_SBE_CONT", sbe_cont));
Parameter[] oParameter = listAux.ToArray();
OTOContext pTOContext = new OTOContext();
var conection = DBFactory.GetDB(pTOContext);
var objeto = conection.ReadList(pTOContext, sql.ToString(), Make, oParameter);
return(objeto);
}
catch (Exception ex)
{
BOException.Throw(this.GetType().ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
return(null);
}
}
internal List <Models.TOAeOsApp> GetAeOsApp(short emp_codi)
{
try
{
StringBuilder sql = new StringBuilder();
sql.AppendLine(" SELECT CONVERT(VARBINARY (MAX), AE_OSAPP.OSA_BMPR) AS OSA_IMAGE, * FROM AE_OSAPP");
sql.AppendLine(" WHERE EMP_CODI = @P_EMP_CODI ");
//sql.AppendLine(" AND AUD_ESTA = 'A' ");
sql.AppendLine(" AND OSA_MAPP = 'S' ");
Parameter[] oParameter = new Parameter[] {
new Parameter("P_EMP_CODI", emp_codi)
};
OTOContext pTOContext = new OTOContext();
var conection = DBFactory.GetDB(pTOContext);
return(conection.ReadList(pTOContext, sql.ToString(), Make, oParameter));
}
catch (Exception ex)
{
BOException.Throw(this.GetType().ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
return(null);
}
}
public bool SEBOEsVendedorCmVende(string pUsuario)
{
try
{
StringBuilder builder = new StringBuilder();
builder.AppendLine("SELECT * FROM CA_VENDE WHERE VEN_ESTA = 'A' AND USU_CODI = @Usuario ");
Parameter[] oParameter = new Parameter[] {
new Parameter("Usuario", pUsuario)
};
OTOContext pTOContext = new OTOContext();
var conection = DBFactory.GetDB(pTOContext);
DataSet objeto = conection.GetDataSet(pTOContext, builder.ToString(), oParameter);
if (objeto == null || objeto.Tables.Count == 0)
{
return(false);
}
return(true);
}
catch (Exception)
{
return(false);
}
}
public TOGnTerce GetGnTerce(short emp_codi, int ter_codi)
{
List <Parameter> listAux = new List <Parameter>();
try
{
StringBuilder sql = new StringBuilder();
sql.Append(" SELECT CONVERT(VARBINARY(MAX), GN_TERCE.TER_FOTO) TER_FOTO,TER_NOCO,TER_CODI ");
sql.Append(" FROM GN_TERCE WHERE TER_CODI = @TER_CODI AND EMP_CODI = @EMP_CODI ");
listAux.Add(new Parameter("@EMP_CODI", emp_codi));
listAux.Add(new Parameter("@TER_CODI", ter_codi));
Parameter[] oParameter = listAux.ToArray();
OTOContext pTOContext = new OTOContext();
var conection = DBFactory.GetDB(pTOContext);
var objeto = conection.Read(pTOContext, sql.ToString(), Make, oParameter);
return(objeto);
}
catch (Exception ex)
{
BOException.Throw(this.GetType().ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
return(null);
}
}
internal TOAeClase GetAeClaseByClaCont(int emp_codi, int cla_cont)
{
try
{
StringBuilder sql = new StringBuilder();
sql.Append(" SELECT EMP_CODI,CLA_CONT,CLA_CODI,CLA_NOMB,CLA_CLTI,AUD_ESTA,AUD_UFAC,CLA_TICA,CLA_DESC, ");
sql.Append(" AUD_USUA, LIP_CONT, LIP_CONB, CLA_FOTO, CLA_FCHR ");
sql.Append(" FROM AE_CLASE");
sql.Append(" WHERE EMP_CODI = @P_EMP_CODI");
sql.Append(" AND CLA_CONT = @P_CLA_CONT");
Parameter[] listAux =
{
new Parameter("@P_EMP_CODI", emp_codi),
new Parameter("@P_CLA_CONT", cla_cont),
};
OTOContext pTOContext = new OTOContext();
var conection = DBFactory.GetDB(pTOContext);
var objeto = conection.Read(pTOContext, sql.ToString(), Make, listAux);
return(objeto);
}
catch (Exception ex)
{
BOException.Throw(this.GetType().ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
return(null);
}
}
public int insertDAOPqEncue(PQEncue encue)
{
StringBuilder sql = new StringBuilder();
sql.Append("INSERT INTO PQ_ENCUE ");
sql.Append("(EMP_CODI,AUD_ESTA, AUD_UFAC,AUD_USUA,ENC_CONT,INP_CONT,TIP_CODI,ENC_DOCU,ENC_NOMB,ENC_APEL,ENC_PREG, ");
sql.Append("ENC_RESP,ENC_FECH )VALUES ");
sql.Append("(@EMP_CODI,@AUD_ESTA,@AUD_UFAC, @AUD_USUA, @ENC_CONT,@INP_CONT,@TIP_CODI,@ENC_DOCU,@ENC_NOMB, @ENC_APEL, ");
sql.Append(" @ENC_PREG,@ENC_RESP, @ENC_FECH) ");
OTOContext ptoContext = new OTOContext();
List <Parameter> parameters = new List <Parameter>();
parameters.Add(new Parameter("@EMP_CODI", encue.emp_codi));
parameters.Add(new Parameter("@AUD_ESTA", "A"));
parameters.Add(new Parameter("@AUD_UFAC", DateTime.Now));
parameters.Add(new Parameter("@AUD_USUA", "seven"));
parameters.Add(new Parameter("@ENC_CONT", encue.enc_cont));
parameters.Add(new Parameter("@INP_CONT", encue.inp_cont));
parameters.Add(new Parameter("@TIP_CODI", encue.tip_codi));
parameters.Add(new Parameter("@ENC_DOCU", encue.enc_docu));
parameters.Add(new Parameter("@ENC_NOMB", encue.enc_nomb));
parameters.Add(new Parameter("@ENC_APEL", encue.enc_apel));
parameters.Add(new Parameter("@ENC_PREG", encue.enc_preg));
parameters.Add(new Parameter("@ENC_RESP", encue.enc_resp));
parameters.Add(new Parameter("@ENC_FECH", encue.enc_fech));
var connection = DBFactory.GetDB(ptoContext);
int result = connection.Insert(ptoContext, sql.ToString(), parameters.ToArray());
return(result);
}
public List <TOGnArbol> GetGnArbol(short emp_codi, short tar_codi)
{
List <Parameter> listAux = new List <Parameter>();
try
{
StringBuilder sql = new StringBuilder();
sql.Append(" SELECT EMP_CODI, ARB_CONT, ARB_CODI, ARB_NOMB ");
sql.Append(" FROM GN_ARBOL ");
sql.Append(" WHERE TAR_CODI = @P_TAR_CODI ");
sql.Append(" AND ARB_MOVI = 'S' ");
sql.Append(" AND ARB_ACTI = 'A' ");
sql.Append(" AND EMP_CODI = @P_EMP_CODI ");
listAux.Add(new Parameter("@P_TAR_CODI", tar_codi));
listAux.Add(new Parameter("@P_EMP_CODI", emp_codi));
Parameter[] oParameter = listAux.ToArray();
OTOContext pTOContext = new OTOContext();
var conection = DBFactory.GetDB(pTOContext);
var objeto = conection.ReadList(pTOContext, sql.ToString(), Make, oParameter);
return(objeto);
}
catch (Exception ex)
{
BOException.Throw(this.GetType().ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
return(null);
}
}
public string DAOSEConsultarAdicionales(short pEMP_CODI, int pCAS_CONT, string pSQL)
{
try
{
StringBuilder builder = new StringBuilder();
pSQL = pSQL.ToUpper().Replace(":P_EMP_CODI", pEMP_CODI.AsString());
pSQL = pSQL.ToUpper().Replace(":P_CAS_CONT", "'" + pCAS_CONT + "'");
OTOContext pTOContext = new OTOContext();
var conection = DBFactory.GetDB(pTOContext);
var objeto = conection.GetDataSet(pTOContext, pSQL.ToString(), null);
List <string> lData = new List <string>();
for (int j = 0; j < objeto.Tables[0].Rows.Count; j++)
{
for (int k = 0; k < objeto.Tables[0].Columns.Count; k++)
{
DataColumn col = objeto.Tables[0].Columns[k];
lData.Add(string.Format("{0}: {1}", col.ColumnName, objeto.Tables[0].Rows[j][k].ToString()));
}
}
return(string.Join("<br />", lData));
}
catch (Exception)
{
//this.BOException.Throw("KDAOGeneral", "DAOSEListaFlujos", exception);
return("");
}
}
internal List <WF_ACCIO> DAOSEListaAccionesdeUnaEtapa(short emp_codi, int flu_cont, short eta_cont)
{
try
{
StringBuilder builder = new StringBuilder();
builder.AppendLine(" SELECT WF_ACCIO.ACC_CONT,WF_ACCIO.ACC_NOMB,WF_ACCIO.ACC_ESTT ");
builder.AppendLine(" FROM WF_ACCIO,WF_RUTAS ");
builder.AppendLine(" WHERE WF_ACCIO.EMP_CODI=WF_RUTAS.EMP_CODI ");
builder.AppendLine(" AND WF_ACCIO.FLU_CONT=WF_RUTAS.FLU_CONT ");
builder.AppendLine(" AND WF_ACCIO.ETA_CONT=WF_RUTAS.ETA_CONT ");
builder.AppendLine(" AND WF_ACCIO.ACC_CONT=WF_RUTAS.ACC_CONT ");
builder.AppendLine(" AND WF_ACCIO.EMP_CODI= " + emp_codi + " ");
builder.AppendLine(" AND WF_ACCIO.FLU_CONT= " + flu_cont + " ");
builder.AppendLine(" AND WF_ACCIO.ETA_CONT= " + eta_cont + " ");
OTOContext pTOContext = new OTOContext();
var conection = DBFactory.GetDB(pTOContext);
var objeto = conection.ReadList(pTOContext, builder.ToString(), MkAcc, null);
return(objeto);
}
catch (Exception exception)
{
//this.BOException.Throw("KDAOGeneral", "DAOSEListaAccionesdeUnaEtapa", exception);
return(null);
}
}
public List <TOPqDinpq> GetPqDinpqDetail(short emp_codi, int inp_cont, int din_cont)
{
List <Parameter> listAux = new List <Parameter>();
try
{
StringBuilder sql = new StringBuilder();
sql.Append(" SELECT DIN_CONT, DIN_SEGT, DIN_FESE ");
sql.Append(" FROM PQ_DINPQ ");
sql.Append(" WHERE EMP_CODI = @P_EMP_CODI ");
sql.Append(" AND INP_CONT = @P_INP_CONT ");
sql.Append(" AND DIN_CONT = @P_DIN_CONT ");
sql.Append(" ORDER BY DIN_CONT DESC ");
listAux.Add(new Parameter("@P_EMP_CODI", emp_codi));
listAux.Add(new Parameter("@P_INP_CONT", inp_cont));
listAux.Add(new Parameter("@P_DIN_CONT", din_cont));
Parameter[] oParameter = listAux.ToArray();
OTOContext pTOContext = new OTOContext();
var conection = DBFactory.GetDB(pTOContext);
var objeto = conection.ReadList(pTOContext, sql.ToString(), Make, oParameter);
return(objeto);
}
catch (Exception ex)
{
BOException.Throw(this.GetType().ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
return(null);
}
}
public List <TOAeEspac> GetAeEspac(short emp_codi, int cla_cont)
{
List <Parameter> listAux = new List <Parameter>();
try
{
StringBuilder sql = new StringBuilder();
sql.Append(" SELECT EMP_CODI, ESP_CONT, ESP_CODI, ESP_NOMB, CLA_CONT, TIP_CONT, ESP_DESC, BOD_CODI, ESP_ESTA, AUD_ESTA,");
sql.Append(" AUD_UFAC, AUD_USUA, ESP_AREA, ESP_CAPA, ESP_PADR, ESP_IMAG, BOD_CONT, CAS_CONT, ESP_MDIT,ESP_IMAG FROM AE_ESPAC");
sql.Append(" WHERE EMP_CODI = @P_EMP_CODI");
sql.Append(" AND AE_ESPAC.CLA_CONT = @P_CLA_CONT");
sql.Append(" AND AE_ESPAC.ESP_CONT > 0");
sql.Append(" AND AE_ESPAC.ESP_ESTA = 'A' ");
sql.Append(" AND AE_ESPAC.ESP_MAPP = 'S' ");
listAux.Add(new Parameter("@P_EMP_CODI", emp_codi));
listAux.Add(new Parameter("@P_CLA_CONT", cla_cont));
Parameter[] oParameter = listAux.ToArray();
OTOContext pTOContext = new OTOContext();
var conection = DBFactory.GetDB(pTOContext);
var objeto = conection.ReadList(pTOContext, sql.ToString(), Make, oParameter);
return(objeto);
}
catch (Exception ex)
{
BOException.Throw(this.GetType().ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
return(null);
}
}
public List <TOAeClase> GetAeClase(short emp_codi)
{
List <Parameter> listAux = new List <Parameter>();
try
{
StringBuilder sql = new StringBuilder();
sql.Append(" SELECT EMP_CODI,CLA_CONT,CLA_CODI,CLA_NOMB,CLA_CLTI,AUD_ESTA,AUD_UFAC,CLA_TICA,");
sql.Append(" AUD_USUA, LIP_CONT, LIP_CONB, CLA_FOTO, CLA_FCHR, CLA_DESC ");
sql.Append(" FROM AE_CLASE");
sql.Append(" WHERE EMP_CODI = @P_EMP_CODI");
sql.Append(" AND AE_CLASE.CLA_CODI > '0' ");
sql.Append(" AND AE_CLASE.CLA_MAPP = 'S'");
sql.Append(" AND EXISTS(SELECT 1 FROM AE_ESPAC ");
sql.Append(" WHERE AE_ESPAC.EMP_CODI = AE_CLASE.EMP_CODI ");
sql.Append(" AND AE_ESPAC.CLA_CONT = AE_CLASE.CLA_CONT ");
sql.Append(" AND AE_ESPAC.ESP_ESTA = 'A') ");
listAux.Add(new Parameter("@P_EMP_CODI", emp_codi));
Parameter[] oParameter = listAux.ToArray();
OTOContext pTOContext = new OTOContext();
var conection = DBFactory.GetDB(pTOContext);
var objeto = conection.ReadList(pTOContext, sql.ToString(), Make, oParameter);
return(objeto);
}
catch (Exception ex)
{
BOException.Throw(this.GetType().ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
return(null);
}
}
public List <GnBarri> GetGnBarri(int pai_codi, int reg_codi, int dep_codi, int mun_codi, int loc_codi)
{
StringBuilder sql = new StringBuilder();
sql.Append(" SELECT BAR_NOMB, BAR_CODI");
sql.Append(" FROM GN_BARRI WHERE PAI_CODI=@PAI_CODI ");
sql.Append(" AND REG_CODI=@REG_CODI ");
sql.Append(" AND DEP_CODI=@DEP_CODI ");
sql.Append(" AND MUN_CODI=@MUN_CODI ");
sql.Append(" AND LOC_CODI=@LOC_CODI ");
sql.Append(" ORDER BY BAR_NOMB ");
List <Parameter> sqlParams = new List <Parameter>();
sqlParams.Add(new Parameter("PAI_CODI", pai_codi));
sqlParams.Add(new Parameter("REG_CODI", reg_codi));
sqlParams.Add(new Parameter("DEP_CODI", dep_codi));
sqlParams.Add(new Parameter("MUN_CODI", mun_codi));
sqlParams.Add(new Parameter("LOC_CODI", loc_codi));
OTOContext pTOContext = new OTOContext();
var conection = DBFactory.GetDB(pTOContext);
List <GnBarri> data = conection.ReadList(pTOContext, sql.ToString(), Make, sqlParams.ToArray());
return(data);
}
public int updateTratamiento(Rnradtd radtd, int emp_codi, int rad_cont)
{
StringBuilder sql = new StringBuilder();
sql.Append(" UPDATE RN_TRARD");
sql.Append(" SET TRA_ACEP = @TRA_ACEP");
sql.Append(" WHERE EMP_CODI = @EMP_CODI");
sql.Append(" AND RAD_CONT = @RAD_CONT");
sql.Append(" AND ITE_CONT = @ITE_CONT");
List <Parameter> parametros = new List <Parameter>();
parametros.Add(new Parameter("@EMP_CODI", emp_codi));
parametros.Add(new Parameter("@RAD_CONT", rad_cont));
parametros.Add(new Parameter("@ITE_CONT", radtd.ite_cont));
if (radtd.ite_chkd)
{
parametros.Add(new Parameter("@TRA_ACEP", "S"));
}
else
{
parametros.Add(new Parameter("@TRA_ACEP", "N"));
}
OTOContext pTOContext = new OTOContext();
var conection = DBFactory.GetDB(pTOContext);
return(conection.Update(pTOContext, sql.ToString(), parametros.ToArray()));
}
public List <TOGnItems> GetGnItems(int tit_cont)
{
List <Parameter> listAux = new List <Parameter>();
try
{
StringBuilder sql = new StringBuilder();
sql.Append(" SELECT ITE_CONT, TIT_CONT, ITE_CODI, ITE_NOMB ");
sql.Append(" FROM GN_ITEMS ");
sql.Append(" WHERE ITE_ACTI = 'S' ");
sql.Append(" AND TIT_CONT = @P_TIT_CONT ");
sql.Append(" AND ITE_CODI > '0' ");
listAux.Add(new Parameter("@P_TIT_CONT", tit_cont));
Parameter[] oParameter = listAux.ToArray();
OTOContext pTOContext = new OTOContext();
var conection = DBFactory.GetDB(pTOContext);
var objeto = conection.ReadList(pTOContext, sql.ToString(), Make, oParameter);
return(objeto);
}
catch (Exception ex)
{
BOException.Throw(this.GetType().ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
return(null);
}
}
public int InseCTREVTD(myObject revtd)
{
DateTime date = DateTime.Now;
foreach (CtRevtd item in revtd.detail)
{
StringBuilder sql = new StringBuilder();
sql.Append(" INSERT INTO CT_REVTD(EMP_CODI, AUD_USUA, AUD_ESTA, AUD_UFAC, ITE_CONT, REV_CONT, DTR_ACEP) ");
sql.Append(" VALUES(@EMP_CODI, @AUD_USUA, @AUD_ESTA, @AUD_UFAC, @ITE_CONT, @REV_CONT, @DTR_ACEP) ");
List <Parameter> parametros = new List <Parameter>();
parametros.Add(new Parameter("@EMP_CODI", revtd.emp_codi));
parametros.Add(new Parameter("@AUD_USUA", "SEVEN"));
parametros.Add(new Parameter("@AUD_ESTA", "A"));
parametros.Add(new Parameter("@AUD_UFAC", date));
parametros.Add(new Parameter("@ITE_CONT", item.ite_cont));
parametros.Add(new Parameter("@REV_CONT", revtd.rev_cont));
if (item.ite_chkd)
{
parametros.Add(new Parameter("@DTR_ACEP", "S"));
}
else
{
parametros.Add(new Parameter("@DTR_ACEP", "N"));
}
OTOContext pTOContext = new OTOContext();
var conection = DBFactory.GetDB(pTOContext);
conection.Insert(pTOContext, sql.ToString(), parametros.ToArray());
}
return(0);
}
internal TOProducto GetProducto(short emp_codi, int pro_cont)
{
List <Parameter> listAux = new List <Parameter>();
try
{
StringBuilder sql = new StringBuilder();
sql.Append(" SELECT PRO_CONT, PRO_CODI, PRO_NOMB,PRO_DMIN FROM IN_PRODU");
sql.Append(" WHERE IN_PRODU.PRO_CONT = @P_PRO_CONT");
sql.Append(" AND IN_PRODU.EMP_CODI = @P_EMP_CODI");
listAux.Add(new Parameter("@P_PRO_CONT", pro_cont));
listAux.Add(new Parameter("@P_EMP_CODI", emp_codi));
Parameter[] oParameter = listAux.ToArray();
OTOContext pTOContext = new OTOContext();
var conection = DBFactory.GetDB(pTOContext);
var objeto = conection.Read(pTOContext, sql.ToString(), MakeProducto, oParameter);
return(objeto);
}
catch (Exception ex)
{
BOException.Throw(this.GetType().ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
return(null);
}
}
public List <GnTipdo> getListGnTipdo()
{
StringBuilder sql = new StringBuilder();
sql.AppendLine(" SELECT * FROM GN_TIPDO WHERE TIP_CODI <> 0 ");
OTOContext pTOContext = new OTOContext();
var conection = DBFactory.GetDB(pTOContext);
List <GnTipdo> data = conection.ReadList(pTOContext, sql.ToString(), Make);
return(data);
}
public List <TOInfReser> GetInfoReservas(short emp_codi, int soc_cont, int sbe_cont)
{
List <Parameter> listAux = new List <Parameter>();
DateTime ahora = DateTime.Now.AddDays(-2);
try
{
StringBuilder sql = new StringBuilder();
sql.Append(" SELECT AE_CLASE.CLA_NOMB, AE_ESPAC.ESP_NOMB, AE_CLASE.CLA_TICA, ");
sql.Append(" IN_PRODU.PRO_NOMB, AE_CLASE.CLA_CONT, AE_CLASE.CLA_FOTO, ");
sql.Append(" AE_RESER.RES_FINI, AE_RESER.RES_FINA,");
sql.Append(" AE_RESER.RES_CONT, AE_RESER.RES_NUME, AE_RESER.RES_ESTA,AE_ESPAC.ESP_MDIT, AE_ESPAC.ESP_IMAG,AE_RESER.TER_CODI ");
sql.Append(" FROM AE_ESPAC, AE_RESER, AE_CLASE, AE_DPROD, IN_PRODU");
sql.Append(" WHERE AE_ESPAC.EMP_CODI = AE_RESER.EMP_CODI");
sql.Append(" AND AE_ESPAC.ESP_CONT = AE_RESER.ESP_CONT");
sql.Append(" AND AE_ESPAC.EMP_CODI = @P_EMP_CODI");
sql.Append(" AND AE_RESER.SOC_CONT = @P_SOC_CONT");
sql.Append(" AND AE_RESER.SBE_CONT = @P_SBE_CONT");
sql.Append(" AND AE_RESER.RES_FINI > @P_RES_FINI");
//sql.Append(" AND AE_RESER.RES_ESTA IN('R', 'C', 'U', 'E')");
sql.Append(" AND AE_RESER.RES_ESTA = 'C'");
sql.Append(" AND AE_RESER.RES_TIPO = 'U'");
sql.Append(" AND AE_RESER.EMP_CODI = AE_DPROD.EMP_CODI");
sql.Append(" AND AE_RESER.RES_CONT = AE_DPROD.RES_CONT");
sql.Append(" AND AE_ESPAC.EMP_CODI = AE_CLASE.EMP_CODI");
sql.Append(" AND AE_ESPAC.CLA_CONT = AE_CLASE.CLA_CONT");
sql.Append(" AND AE_DPROD.EMP_CODI = IN_PRODU.EMP_CODI");
sql.Append(" AND AE_DPROD.PRO_CONT = IN_PRODU.PRO_CONT");
//sql.Append(" ORDER BY 7 DESC ");
sql.Append(" ORDER BY AE_RESER.RES_NUME DESC ");
listAux.Add(new Parameter("@P_EMP_CODI", emp_codi));
listAux.Add(new Parameter("@P_SOC_CONT", soc_cont));
listAux.Add(new Parameter("@P_SBE_CONT", sbe_cont));
listAux.Add(new Parameter("@P_RES_FINI", ahora));
Parameter[] oParameter = listAux.ToArray();
OTOContext pTOContext = new OTOContext();
var conection = DBFactory.GetDB(pTOContext);
var objeto = conection.ReadList(pTOContext, sql.ToString(), Make, oParameter);
return(objeto);
}
catch (Exception ex)
{
BOException.Throw(this.GetType().ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
return(null);
}
}
public List <TOEcEvent> GetEcEvent(short emp_codi, int soc_cont, int sbe_cont)
{
List <Parameter> listAux = new List <Parameter>();
try
{
StringBuilder sql = new StringBuilder();
sql.Append(" SELECT EVE_ESTA, EVE_FEIN, EVE_FESA, GN_TOPER.TOP_NOMB, ");
sql.Append(" EVE_VATO, EVE_NOMB, 'N' INVITADO ");
sql.Append(" FROM EC_EVENT, GN_TOPER ");
sql.Append(" WHERE EC_EVENT.EMP_CODI = GN_TOPER.EMP_CODI ");
sql.Append(" AND EC_EVENT.TOP_CODI = GN_TOPER.TOP_CODI ");
sql.Append(" AND EC_EVENT.EVE_ESTA IN('C', 'P') ");
sql.Append(" AND EC_EVENT.EVE_CONT > 0 ");
sql.Append(" AND EC_EVENT.EMP_CODI = @P_EMP_CODI ");
sql.Append(" AND EC_EVENT.SOC_CONT = @P_SOC_CONT ");
sql.Append(" AND EC_EVENT.SBE_CONT = @P_SBE_CONT ");
sql.Append(" UNION ALL ");
sql.Append(" SELECT EVE_ESTA, EVE_FEIN, EVE_FESA, GN_TOPER.TOP_NOMB, ");
sql.Append(" EVE_VATO, EVE_NOMB, 'S' INVITADO ");
sql.Append(" FROM EC_EVENT, GN_TOPER, EC_LISEV,SO_SBENE ");
sql.Append(" WHERE EC_EVENT.EMP_CODI = GN_TOPER.EMP_CODI ");
sql.Append(" AND EC_EVENT.TOP_CODI = GN_TOPER.TOP_CODI ");
sql.Append(" AND EC_EVENT.EMP_CODI = EC_LISEV.EMP_CODI ");
sql.Append(" AND EC_EVENT.EVE_CONT = EC_LISEV.EVE_CONT ");
sql.Append(" AND EC_LISEV.EMP_CODI = SO_SBENE.EMP_CODI ");
sql.Append(" AND EC_LISEV.DLI_IDIN = SO_SBENE.SBE_CODI ");
sql.Append(" AND EC_EVENT.EVE_ESTA IN('C', 'P') ");
sql.Append(" AND EC_EVENT.EVE_CONT > 0 ");
sql.Append(" AND EC_EVENT.EMP_CODI = @P_EMP_CODI ");
sql.Append(" AND SO_SBENE.SOC_CONT = @P_SOC_CONT ");
sql.Append(" AND SO_SBENE.SBE_CONT = @P_SBE_CONT ");
listAux.Add(new Parameter("@P_EMP_CODI", emp_codi));
listAux.Add(new Parameter("@P_SOC_CONT", soc_cont));
listAux.Add(new Parameter("@P_SBE_CONT", sbe_cont));
Parameter[] oParameter = listAux.ToArray();
OTOContext pTOContext = new OTOContext();
var conection = DBFactory.GetDB(pTOContext);
var objeto = conection.ReadList(pTOContext, sql.ToString(), Make, oParameter);
return(objeto);
}
catch (Exception ex)
{
BOException.Throw(this.GetType().ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
return(null);
}
}
public List <TOGnEmpre> ConsultarEmpresas()
{
StringBuilder sql = new StringBuilder();
sql.Append(" SELECT * FROM GN_EMPRE ");
OTOContext pTOContext = new OTOContext();
var conection = DBFactory.GetDB(pTOContext);
var objeto = conection.ReadList(pTOContext, sql.ToString(), Make, null);
return(objeto);
}
public GnInsta GetGnInsta()
{
List <Parameter> parametros = new List <Parameter>();
StringBuilder sql = new StringBuilder();
sql.Append(" SELECT PAR_NMIN,PAR_NMAX,PAR_CCLN,PAR_CCLG,PAR_HOST,PAR_MAIL,PAR_PCOR,PAR_USMT,PAR_USSL,PAR_UTLS,PAR_CLMA,PAR_INFA ,PAR_ADJU");
sql.Append(" FROM GN_INSTA ");
OTOContext pTOContext = new OTOContext();
var conection = DBFactory.GetDB(pTOContext);
var data = conection.Read(pTOContext, sql.ToString(), Make);
return(data);
}
internal FA_CLIEN DAOSEGetNombreSolicitante(short emp_codi, int cas_cont)
{
try
{
StringBuilder builder = new StringBuilder();
builder.AppendLine("SELECT FA_CLIEN.CLI_NOCO AS CLI_NOCO, FA_DCLIE.DCL_NOMB AS DCL_NOMB FROM TS_ANTIC, FA_CLIEN, FA_DCLIE ");
builder.AppendLine("WHERE TS_ANTIC.EMP_CODI = FA_CLIEN.EMP_CODI ");
builder.AppendLine(" AND TS_ANTIC.CLI_CODI = FA_CLIEN.CLI_CODI ");
builder.AppendLine(" AND TS_ANTIC.EMP_CODI = FA_DCLIE.EMP_CODI ");
builder.AppendLine(" AND TS_ANTIC.CLI_CODI = FA_DCLIE.CLI_CODI ");
builder.AppendLine(" AND TS_ANTIC.DCL_CODD = FA_DCLIE.DCL_CODD ");
builder.AppendLine(" AND TS_ANTIC.EMP_CODI = @EMP_CODI ");
builder.AppendLine(" AND TS_ANTIC.CAS_CONT = @CAS_CONT ");
builder.AppendLine(" AND TS_ANTIC.ANT_TIPO = 'C' ");
builder.AppendLine("UNION ALL ");
builder.AppendLine("SELECT PO_PVDOR.PVR_NOCO AS CLI_NOCO, PO_DEPRO.DEP_NOMB AS DCL_NOMB FROM TS_ANTIC, PO_PVDOR, PO_DEPRO ");
builder.AppendLine("WHERE TS_ANTIC.EMP_CODI = PO_PVDOR.EMP_CODI ");
builder.AppendLine(" AND TS_ANTIC.PVD_CODI = PO_PVDOR.PVD_CODI ");
builder.AppendLine(" AND TS_ANTIC.EMP_CODI = PO_DEPRO.EMP_CODI ");
builder.AppendLine(" AND TS_ANTIC.PVD_CODI = PO_DEPRO.PVD_CODI ");
builder.AppendLine(" AND TS_ANTIC.DEP_CODD = PO_DEPRO.DEP_CODD ");
builder.AppendLine(" AND TS_ANTIC.EMP_CODI = @EMP_CODI ");
builder.AppendLine(" AND TS_ANTIC.CAS_CONT = @CAS_CONT ");
builder.AppendLine(" AND TS_ANTIC.ANT_TIPO = 'P' ");
builder.AppendLine("UNION ALL ");
builder.AppendLine("SELECT CR_PROSP.PRO_NOCO collate Latin1_General_Bin AS CLI_NOCO, CR_DPROS.DPR_NOMB AS DCL_NOMB FROM TS_ANTIC, CR_PROSP, CR_DPROS ");
builder.AppendLine("WHERE TS_ANTIC.EMP_CODI = CR_PROSP.EMP_CODI ");
builder.AppendLine(" AND TS_ANTIC.PRO_CONT = CR_PROSP.PRO_CONT ");
builder.AppendLine(" AND TS_ANTIC.EMP_CODI = CR_DPROS.EMP_CODI ");
builder.AppendLine(" AND TS_ANTIC.PRO_CONT = CR_DPROS.PRO_CONT ");
builder.AppendLine(" AND TS_ANTIC.DPR_CODI = CR_DPROS.DPR_CODI ");
builder.AppendLine(" AND TS_ANTIC.EMP_CODI = @EMP_CODI ");
builder.AppendLine(" AND TS_ANTIC.CAS_CONT = @CAS_CONT ");
builder.AppendLine(" AND TS_ANTIC.ANT_TIPO <> 'C' ");
builder.AppendLine(" AND TS_ANTIC.ANT_TIPO <> 'P' ");
Parameter[] param = new Parameter[] {
new Parameter("EMP_CODI", emp_codi),
new Parameter("CAS_CONT", cas_cont)
};
OTOContext pTOContext = new OTOContext();
var conection = DBFactory.GetDB(pTOContext);
var objeto = conection.Read(pTOContext, builder.ToString(), MkFaClien, param);
return(objeto);
}
catch (Exception)
{
return(null);
}
}
public void deleteDocumentos(int emp_codi, int rev_cont, string tabla)
{
StringBuilder sql = new StringBuilder();
sql.Append("DELETE FROM " + tabla + " WHERE EMP_CODI = @EMP_CODI AND REV_CONT= @REV_CONT ");
List <Parameter> parametros = new List <Parameter>();
parametros.Add(new Parameter("@EMP_CODI", emp_codi));
parametros.Add(new Parameter("@REV_CONT", rev_cont));
OTOContext pTOContext = new OTOContext();
var conection = DBFactory.GetDB(pTOContext);
conection.Delete(pTOContext, sql.ToString(), parametros.ToArray());
}
