public JsonResult ReadNotification(string notId)
{
MongodbFunctions mongo = new MongodbFunctions();
Databases.DomainModel.Notification notification = mongo.GetNotification(new ObjectId(notId));
mongo.UpdateNotificationStatus(new ObjectId(notId));
return(Json(new { date = notification.Date.ToString("dd/MM/yyyy"), content = notification.Content, tag = notification.Tag }, JsonRequestBehavior.AllowGet));
}
public ActionResult Checkout()
{
MongodbFunctions mongo = new MongodbFunctions();
TimescaledbFunctions tdb = new TimescaledbFunctions();
Databases.DomainModel.CheckoutDetails details = new Databases.DomainModel.CheckoutDetails();
Databases.DomainModel.User user = mongo.GetUser(User.Identity.Name);
Databases.DomainModel.Order order = mongo.GetOpenOrder(user.Id);
details.User = user;
List <Databases.DomainModel.Product> products = new List <Databases.DomainModel.Product>();
List <Databases.DomainModel.Notification> discounts = new List <Databases.DomainModel.Notification>();
List <string> disc = tdb.GetDiscounts(user.Id.ToString());
if (order != null)
{
foreach (MongoDBRef r in order.Products)
{
Databases.DomainModel.Product product = mongo.GetProduct(new ObjectId(r.Id.ToString()));
products.Add(product);
}
if (disc.Count != 0)
{
foreach (string d in disc)
{
Databases.DomainModel.Notification notification = mongo.GetNotification(new ObjectId(d));
discounts.Add(notification);
}
}
}
details.Products = products;
details.Discounts = discounts;
tdb.CloseConnection();
return(View(details));
}
public JsonResult GetNotifications()
{
MongodbFunctions mongo = new MongodbFunctions();
Databases.DomainModel.User user = mongo.GetUser(User.Identity.Name);
TimescaledbFunctions tdb = new TimescaledbFunctions();
List <string> notifications = tdb.GetNotifications(user.Id.ToString());
List <Databases.DomainModel.NotificationShow> nots = new List <Databases.DomainModel.NotificationShow>();
int count = 0;
if (notifications.Count != 0)
{
foreach (string notId in notifications)
{
Databases.DomainModel.Notification not = mongo.GetNotification(new ObjectId(notId));
if (!not.Read)
{
count++;
}
Databases.DomainModel.NotificationShow nshow = new Databases.DomainModel.NotificationShow
{
Id = not.Id.ToString(),
Title = not.Title,
Date = not.Date.Date.ToString("dd/MM/yyyy"),
Read = not.Read
};
nots.Add(nshow);
}
}
tdb.CloseConnection();
return(Json(new { number = count, alerts = nots, total = notifications.Count }, JsonRequestBehavior.AllowGet));
}
public void SubmitOrder(string address, string note, string pay)
{
MongodbFunctions mongo = new MongodbFunctions();
TimescaledbFunctions tdb = new TimescaledbFunctions();
Databases.DomainModel.User user = mongo.GetUser(User.Identity.Name);
Databases.DomainModel.Order order = mongo.GetOpenOrder(user.Id);
List <string> disc = tdb.GetDiscounts(user.Id.ToString());
if (!user.Address.Contains(address))
{
user.Address.Add(address);
mongo.UpdateAddresses(user);
}
order.Note = note;
order.PayingMethod = pay;
order.Address = address;
mongo.CloseOrder(order);
foreach (string d in disc)
{
Databases.DomainModel.Notification notification = mongo.GetNotification(new ObjectId(d));
if (notification.Tag.Equals("popust"))
{
mongo.UpdateNotification(notification.Id, "iskorisceno");
tdb.UpdateNotification(user.Id.ToString(), d, "iskorisceno");
}
else if (notification.Tag.Equals("l_popust"))
{
mongo.UpdateNotification(notification.Id, "l_iskorisceno");
tdb.UpdateNotification(user.Id.ToString(), d, "l_iskorisceno");
}
}
//send email with details
MailMessage message = new MailMessage();
message.From = new MailAddress("*****@*****.**");
message.To.Add(new MailAddress(User.Identity.Name));
message.Subject = "Potvrda proudžbine";
message.Body = "Uspešno ste poručili sledeće proizvode:\n";
foreach (MongoDBRef p in order.Products)
{
Databases.DomainModel.Product prod = mongo.GetProduct(new ObjectId(p.Id.ToString()));
tdb.BuyProduct(user.Id.ToString(), prod.Id.ToString(), prod.Price);
message.Body += prod.Name + "\n";
}
message.Body += "Proizvodi će Vam biti isporučeni najkasnije za 7 dana na adresu " + order.Address;
SmtpClient smtpClient = new SmtpClient();
smtpClient.Credentials = new System.Net.NetworkCredential("*****@*****.**", "Krisgold02$");
smtpClient.Host = "smtp.office365.com";
smtpClient.Port = 587;
smtpClient.DeliveryMethod = SmtpDeliveryMethod.Network;
smtpClient.EnableSsl = true;
//smtpClient.Send(message);
//send notifications
if (!tdb.NotificationSent(user.Id.ToString()) && (30000 - tdb.MonthShopping(user.Id.ToString())) < 3000 && (30000 - tdb.MonthShopping(user.Id.ToString())) > 0)//notifikacija do popusta
{
Databases.DomainModel.Notification notification = new Databases.DomainModel.Notification
{
Content = "Poštovani, do ostvarivanja popusta od 20% ostalo Vam je manje od 3000 dinara.",
Title = "Mali iznos do popusta",
Date = DateTime.Now.Date,
Tag = "do_popusta",
Read = false,
User = new MongoDBRef("users", user.Id)
};
tdb.SendNotification(user.Id.ToString(), mongo.AddNotification(notification, user.Email).ToString(), "do_popusta");
}
else if (tdb.MonthShopping(user.Id.ToString()) >= 30000)
{
Databases.DomainModel.Notification notification = new Databases.DomainModel.Notification
{
Content = "Poštovani, ostvarili ste popust od 20% na sledeću kupovinu, koji možete iskoristiti u roku od nedelju dana.",
Title = "Popust 20%",
Date = DateTime.Now.Date,
Tag = "popust",
Read = false,
User = new MongoDBRef("users", user.Id)
};
tdb.SendNotification(user.Id.ToString(), mongo.AddNotification(notification, user.Email).ToString(), "popust");
}
tdb.CloseConnection();
}