public int CreatNewElement(AssociatedUri uri) { int result; using (IDbConnection db = new SqlConnection(_connectionString.GetConnectionString())) { var sqlQuery = "INSERT INTO [UriReduction].[AssociatedUri] (LongUri, ShortUri,UserId) VALUES(@LongUri,@ShortUri,@UserId);"; result = db.Execute(sqlQuery, uri); } return(result); }
public async Task <string> Post([FromBody] AssociatedUri longUri) { UserAccount user = new UserAccount { Id = null }; if (User.Identity.Name != null) { user = await _userManager.FindByNameAsync(User.Identity.Name); } var shortUri = _shortener.Shorten(longUri.LongUri, user.Id); return(Request.Host + "/SUGC/" + shortUri); }
public void ReceiveMessage() { var factory = new ConnectionFactory { HostName = "localhost" }; using (var connection = factory.CreateConnection()) { using (var channel = connection.CreateModel()) { channel.QueueDeclare(queue: "ShortUriIncrementQueue", durable: true, exclusive: false, autoDelete: false, arguments: null); var consumer = new EventingBasicConsumer(channel); consumer.Received += (model, ea) => { var body = ea.Body; var shortUri = Encoding.UTF8.GetString(body); AssociatedUri uri = _repository.GetElementByShortUri(shortUri); _repository.UpdateElementRequestFieldById(uri.RequestCount + 1, uri.Id); uri = _repository.GetElementById(uri.Id); channel.BasicAck(deliveryTag: ea.DeliveryTag, multiple: false); }; channel.BasicConsume(queue: "ShortUriIncrementQueue", autoAck: false, consumer: consumer); Console.WriteLine("Press [enter] to exit."); Console.ReadLine(); } } }
public async Task <IActionResult> Delete([FromBody] AssociatedUri uri) { var result = await _deleteService.DeleteUri(uri.ShortUri, User.Identity.Name); return(result ? (IActionResult)Ok() : NotFound()); }