public ActionResult <string> Post([FromBody] CustomerNavigation customerNavigation)
{
try
{
// Fill IP and Date
customerNavigation.IP = this.Request.HttpContext.Connection.RemoteIpAddress.ToString();
customerNavigation.Date = DateTime.Now;
// serialize in JSON
String jsonPack = JsonConvert.SerializeObject(customerNavigation);
if (customerNavigation.IsValid())
{
// post to queue
Queue queue = new Queue(AppSettings);
queue.QueuePostJson(jsonPack, "Customer");
// return OK
return(new JsonResult("Send to queue successfully."));
}
else
{
// return Invalid
return(new JsonResult("Invalid entry..."));
}
}
catch (Exception ex)
{
return(new JsonResult("Error sending to queue: " + ex.Message));
}
}
public void AddSql(CustomerNavigation customerNavigation)
{
using (var context = new CustomerDataDbContext())
{
context.CustomerNavigations.Add(customerNavigation);
context.SaveChanges();
}
}
// NoSQL
public bool AddNoSql(CustomerNavigation customerNavigation)
{
// save in Couchbase
using (var cluster = new Cluster())
{
// users config
// pass to connectionstrings
var authenticator = new PasswordAuthenticator(AppSettings.NoSqlUser, AppSettings.NoSqlPass);
cluster.Authenticate(authenticator);
// open bucket
using (var bucket = cluster.OpenBucket(AppSettings.NoSqlBucket))
{
var document = new Document <dynamic>
{
Id = "CustomerNavigation::" + customerNavigation.Id,
Content = customerNavigation
};
// upset in base
var upsert = bucket.Upsert(document);
return(upsert.Success);
}
}
}
// consume data
public void QueueStartConsuming()
{
// pass to ConnectionStrings in appsettings.json
var factory = new ConnectionFactory();
factory.Uri = new Uri(this.AppSettings.RabbitMQConnectionString);
// open connection
using (var connection = factory.CreateConnection())
{
// open channel
using (var channel = connection.CreateModel())
{
// declare
channel.QueueDeclare(
queue: "Customer",
durable: true,
exclusive: false,
autoDelete: false,
arguments: null
);
// event handler to consume queue
var consumer = new EventingBasicConsumer(channel);
// callback on receive
consumer.Received += (model, ea) =>
{
// get message on queue
var body = ea.Body;
var message = Encoding.UTF8.GetString(body);
// pass json to a object
JObject objJson = JObject.Parse(message);
CustomerNavigation customerNavigation = new CustomerNavigation()
{
Date = (DateTime)objJson.GetValue("Date"),
Browser = (String)objJson.GetValue("Browser"),
PageTitle = (String)objJson.GetValue("PageTitle"),
IP = (String)objJson.GetValue("IP"),
Params = (String)objJson.GetValue("Params")
};
Console.WriteLine("* - Received From Queue: {0}", message);
CustomerNavigationRepository repo = new CustomerNavigationRepository(AppSettings);
// save in SqlServer
try
{
repo.AddSql(customerNavigation);
Console.WriteLine("- {0}->{1}. Saved in SqlServer. Id: {2}", customerNavigation.IP, customerNavigation.PageTitle, customerNavigation.Id);
}
catch (Exception ex)
{
Console.WriteLine("- {0}->{1}. Error * SQL: {2}", customerNavigation.IP, customerNavigation.PageTitle, ex.Message);
}
// save in NoSql
try
{
repo.AddNoSql(customerNavigation);
Console.WriteLine("- {0}->{1} Saved in Couchbase. Id: {2}", customerNavigation.IP, customerNavigation.PageTitle, ("CustomerNavigation::" + customerNavigation.Id.ToString()));
}
catch (Exception ex)
{
Console.WriteLine("- {0}->{1}. Error * NoSQL: {2}", customerNavigation.IP, customerNavigation.PageTitle, ex.Message);
}
// just log and wait 1 second
Console.WriteLine("Go next...");
Thread.Sleep(1000);
};
// setup handler consume queue
channel.BasicConsume(
queue: "Customer",
autoAck: true,
consumer: consumer
);
Console.WriteLine("Queue consuming start...");
Console.ReadLine();
}
}
}