/// <summary>
/// OBTENER EL USUARIO LOGEADO
/// </summary>
/// <param name="oBe"></param>
/// <returns></returns>
public IDataReader P0001SHPR_USUA_LIST(BESHMC_USUA oBe)
{
try
{
oDb = oDg.getDataBase();
oCon = oDg.getConnection();
if (oCon.State == ConnectionState.Closed)
{
oCon.Open();
}
var ocmd = oDb.GetStoredProcCommand("P0001SHPR_USUA_LIST", oBe.COD_USUA,
oBe.ALF_PASS,
oBe.NUM_ACCI);
ocmd.CommandTimeout = 2000;
var odr = oDb.ExecuteReader(ocmd);
return(odr);
}
finally
{
oCon.Close();
}
}
/// <summary>
/// GENERAR VISITA
/// </summary>
/// <param name="oBe"></param>
public void P0008SHPR_VISI(BESHMC_VISI oBe)
{
try
{
oDb = oDg.getDataBase();
oCon = oDg.getConnection();
if (oCon.State == ConnectionState.Closed)
{
oCon.Open();
}
using (var obts = oCon.BeginTransaction())
{
try
{
using (var ocmd = oDb.GetStoredProcCommand("P0008SHPR_VISI", oBe.COD_VISI,
oBe.COD_AGEN,
oBe.COD_MORO,
oBe.FEC_VISI,
oBe.ALF_GPSS_PART,
oBe.ALF_GPSS_LLEG,
oBe.COD_USUA_CREA,
oBe.NUM_ACCI))
{
ocmd.CommandTimeout = 2000;
oDb.ExecuteNonQuery(ocmd, obts);
oBe.COD_VISI = Convert.ToInt32(oDb.GetParameterValue(ocmd, "@P0008COD_VISI"));
obts.Commit();
}
}
catch (Exception ex)
{
obts.Rollback();
throw new ArgumentException(ex.Message);
}
}
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
finally
{
oCon.Close();
}
}
public IDataReader ListarResponsible(UsuarioResponsableEntity oBe)
{
try
{
oDb = oDg.getDataBase();
oCon = oDg.getConnection();
if (oCon.State == ConnectionState.Closed)
{
oCon.Open();
}
var ocmd = oDb.GetStoredProcCommand("up_ListarResponsable", oBe.USU_RESP_Description);
ocmd.CommandTimeout = 2000;
var odr = oDb.ExecuteReader(ocmd);
return(odr);
}
finally
{
oCon.Close();
}
}
/// <summary>
/// OBTENER LA LISTA DE TICKETS
/// </summary>
/// <param name="oBe"></param>
/// <returns></returns>
public IDataReader SHPR_TICKET_LIST(TicketEntity oBe)
{
try
{
oDb = oDg.getDataBase();
oCon = oDg.getConnection();
if (oCon.State == ConnectionState.Closed)
{
oCon.Open();
}
//var ocmd = oDb.GetStoredProcCommand("up_ConsultarTicket_Sebastian", oBe.TIC_Id,
var ocmd = oDb.GetStoredProcCommand("up_ConsultarTicket", oBe.TIC_Id,
oBe.EMP_RazonSocial,
oBe.TIC_StatDate,
oBe.TIC_EndDate,
oBe.TIC_CodigoEstado);
ocmd.CommandTimeout = 2000;
var odr = oDb.ExecuteReader(ocmd);
return(odr);
}
catch (Exception ex)
{
throw ex;
}
finally
{
oCon.Close();
}
}