/// <summary>
/// Insertar registro de session activa
/// </summary>
/// <param name="mensajeError"></param>
/// <param name="contador"></param>
public void Insertar(ref string mensajeError, SessionActiva contador)
{
try
{
using (var mavemRepository = new GenericRepository(this.DbConnectionString, typeof(System.Data.SqlClient.SqlConnection).Namespace))
{
var procedureName = "SP_CC_INSERTAR_SESSION_ACTIVA";
ICollection <DbParameterItem> inputParameters = new List <DbParameterItem>()
{
new DbParameterItem
{
Name = "@GUID",
Type = DbType.String,
Value = contador.Guid,
Direction = ParameterDirection.Input
},
new DbParameterItem
{
Name = "@FECHA_VIGENCIA",
Type = DbType.DateTime,
Value = contador.FechaVigencia,
Direction = ParameterDirection.Input
}
};
mavemRepository.ExecuteNonQuery(procedureName, inputParameters);
}
}
catch (Exception exc)
{
mensajeError = exc.Message;
}
}
/// <summary>
/// Insertar configuracion de punto de venta.
/// </summary>
/// <param name="puntoVenta">punto de </param>
public string InsertarConfiguracionPuntoVenta(vwPuntoVenta puntoVenta)
{
string mensajeError = string.Empty;
try
{
using (var mavemRepository = new GenericRepository(this.DbConnectionString, typeof(System.Data.SqlClient.SqlConnection).Namespace))
{
var procedureName = "SP_CC_PUNTO_VENTA_CONFIG_LOG";
ICollection <DbParameterItem> inputParameters = new List <DbParameterItem>()
{
new DbParameterItem
{
Name = "@ID_PUNTO_VENTA",
Type = DbType.Int64,
Value = puntoVenta.IdPuntoVenta,
Direction = ParameterDirection.Input
},
new DbParameterItem
{
Name = "@MAC_ADDRESS",
Type = DbType.String,
Value = puntoVenta.MacAddress,
Size = 100,
Direction = ParameterDirection.Input
}
};
mavemRepository.ExecuteNonQuery(procedureName, inputParameters);
}
}
catch (Exception exc)
{
mensajeError = exc.Message;
}
return(mensajeError);
}
public void Insertar(ref string mensajeError, Contador contador)//ur = * ó id separados por comas
{
try
{
using (var mavemRepository = new GenericRepository(this.DbConnectionString, typeof(System.Data.SqlClient.SqlConnection).Namespace))
{
var procedureName = "SP_CC_INSERTAR_CONTADOR_LOG";
ICollection <DbParameterItem> inputParameters = new List <DbParameterItem>()
{
new DbParameterItem
{
Name = "@ID_CENTRO_EXPERIENCIA",
Type = DbType.Int64,
Value = contador.IdCentroExperiencia,
Direction = ParameterDirection.Input
},
new DbParameterItem
{
Name = "@ID_TIPO_CONSULTA",
Type = DbType.Int64,
Value = contador.IdTipoConsulta,
Direction = ParameterDirection.Input
},
new DbParameterItem
{
Name = "@NUMERO_CELULAR",
Type = DbType.String,
Value = contador.NumeroCelular,
Direction = ParameterDirection.Input
},
new DbParameterItem
{
Name = "@NUMERO_FIJO",
Type = DbType.String,
Value = contador.NumeroFijo,
Direction = ParameterDirection.Input
},
new DbParameterItem
{
Name = "@NUMERO_CEDULA",
Type = DbType.String,
Value = contador.NumeroCedula,
Direction = ParameterDirection.Input
},
new DbParameterItem
{
Name = "@ID_TRANSACCION",
Type = DbType.Int64,
Value = contador.IdTransaccion,
Direction = ParameterDirection.Input
},
new DbParameterItem
{
Name = "@FECHA_REGISTRO",
Type = DbType.DateTime,
Value = contador.FechaRegistro,
Direction = ParameterDirection.Input
}
};
mavemRepository.ExecuteNonQuery(procedureName, inputParameters);
}
}
catch (Exception exc)
{
mensajeError = exc.Message;
}
}