public void Actualizar(string pais, decimal costo) { using (var connection = new DatabaseContext().Database.Connection) { connection.Open(); connection.Execute("Update CostoEnvioPais set costo=@costo where pais=@pais", new { costo, pais }); } }
public void Actualizar(string pais, decimal costo) { using (var connection = new DatabaseContext().Database.Connection) { connection.Open(); connection.Execute("Update CostoEnvioPais set costo=@costo where pais=@pais", new { costo, pais }); } }
public void DisminuirInventario(int productoId, int cantidad) { using (var connection = new DatabaseContext().Database.Connection) { connection.Open(); connection.Execute("Update Inventario set cantidad=@cantidad where productoId=@productoId", new { productoId, cantidad }); } }
public void DisminuirInventario(int productoId, int cantidad) { using (var connection = new DatabaseContext().Database.Connection) { connection.Open(); connection.Execute("Update Inventario set cantidad=@cantidad where productoId=@productoId", new { productoId, cantidad }); } }
public decimal Obtener(string pais) { using (var connection = new DatabaseContext().Database.Connection) { connection.Open(); var costo = connection.Query<decimal>("Select costo from CostoEnvioPais where pais=@pais", new { pais }).Single(); return costo; } }
public decimal Obtener(string pais) { using (var connection = new DatabaseContext().Database.Connection) { connection.Open(); var costo = connection.Query <decimal>("Select costo from CostoEnvioPais where pais=@pais", new { pais }).Single(); return(costo); } }
public int CantidadInventario(int productoId) { using (var connection = new DatabaseContext().Database.Connection) { connection.Open(); var cantidad = connection.Query <int>("select cantidad from Inventario where productoId=@productoId", new { productoId }).Single(); return(cantidad); } }
public int CantidadInventario(int productoId) { using (var connection = new DatabaseContext().Database.Connection) { connection.Open(); var cantidad=connection.Query<int>("select cantidad from Inventario where productoId=@productoId", new { productoId }).Single(); return cantidad; } }