/// <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; } }