public bool ActivateDiscount()
{
MongodbFunctions mongo = new MongodbFunctions();
Databases.DomainModel.User user = mongo.GetUser(User.Identity.Name);
bool sent = false;
TimescaledbFunctions tdb = new TimescaledbFunctions();
if (!tdb.ActivatedDiscount(user.Id.ToString()))
{
Databases.DomainModel.Notification notification = new Databases.DomainModel.Notification
{
Content = "Poštovani, ostvarili ste popust od 10% na sledeću kupovinu, koji možete iskoristiti u roku od nedelju dana.",
Title = "Popust 10%",
Date = DateTime.Now.Date,
Tag = "l_popust",
Read = false,
User = new MongoDB.Driver.MongoDBRef("users", user.Id)
};
tdb.SendNotification(user.Id.ToString(), mongo.AddNotification(notification, user.Email).ToString(), "l_popust");
sent = true;
}
tdb.CloseConnection();
return(sent);
}
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 void AddReview(string id, int grade, string comment)
{
MongodbFunctions mongo = new MongodbFunctions();
TimescaledbFunctions tdb = new TimescaledbFunctions();
Databases.DomainModel.User user = mongo.GetUser(User.Identity.Name);
Databases.DomainModel.Review review = mongo.GetReview(user.Id, new ObjectId(id));
if (review == null)
{
Databases.DomainModel.Review newReview = new Databases.DomainModel.Review
{
Grade = grade,
Comment = comment,
Product = new MongoDBRef("products", new ObjectId(id))
};
mongo.AddReview(newReview, id, User.Identity.Name);
tdb.ReviewProduct(user.Id.ToString(), id, grade);
}
else
{
mongo.UpdateReview(review.Id, grade, comment);
tdb.UpdateReview(user.Id.ToString(), id, grade);
}
if (tdb.LowGrades(user.Id.ToString()) >= 4)
{
Databases.DomainModel.Notification notification = new Databases.DomainModel.Notification
{
Content = "Poštovani, primetili smo da ste više proizvoda ocenili lošom ocenom. Ako želite da zamenite neki od njih, " +
"pozovite naš call centar i dogovorite se sa operaterom. Takođe, imate opciju popusta od 10% prilikom sledeće kupovine. " +
"Popust možete aktivirati klikom na link u ovom obaveštenju i važi nedelju dana. U jednom trenutku možete aktivirati samo jedan popust.",
Title = "Niste zadovoljni kupljenim proizvodima?",
Date = DateTime.Now.Date,
Tag = "lose_ocene",
Read = false,
User = new MongoDB.Driver.MongoDBRef("users", user.Id)
};
tdb.SendNotification(user.Id.ToString(), mongo.AddNotification(notification, user.Email).ToString(), "lose_ocene");
}
tdb.CloseConnection();
}
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 ActionResult Index()
{
List <Databases.DomainModel.Product> products = new List <Databases.DomainModel.Product>();
MongodbFunctions mongo = new MongodbFunctions();
if (User.Identity.IsAuthenticated && User.IsInRole("User"))
{
TimescaledbFunctions tdb = new TimescaledbFunctions();
Databases.DomainModel.User user = mongo.GetUser(User.Identity.Name);
if (!tdb.NotificationSent(user.Id.ToString()) && (30000 - tdb.MonthShopping(user.Id.ToString())) < 3000)
{
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 MongoDB.Driver.MongoDBRef("users", user.Id)
};
tdb.SendNotification(user.Id.ToString(), mongo.AddNotification(notification, user.Email).ToString(), "do_popusta");
}
//recommend za proizvode
RecommendationEngine.Interfaces.IRater rater = new LinearRater(1.0, 5.0);
RecommendationEngine.Interfaces.IComparer comparer = new CosineComparer();
RecommendationEngine.Recommenders.ItemCollaborativeFilterRecommender recommender1 = new RecommendationEngine.Recommenders.ItemCollaborativeFilterRecommender(comparer, rater, 3);
RecommendationEngine.Recommenders.UserCollaborativeFilterRecommender recommender2 = new RecommendationEngine.Recommenders.UserCollaborativeFilterRecommender(comparer, rater, 5);
RecommendationEngine.Parsers.UserBehaviorDatabaseParser parser = new RecommendationEngine.Parsers.UserBehaviorDatabaseParser();
List <Databases.DomainModel.RecommenderAction> actions = parser.LoadForHome();
RecommendationEngine.Parsers.UserBehaviorDatabase db = parser.LoadUserBehaviorDatabase(actions);
recommender1.Train(db);
recommender2.Train(db);
if (actions.Count(x => x.UserId.Equals(user.Id)) > 0)//if user has actions, recommendation can be done
{
List <RecommendationEngine.Objects.Suggestion> suggestions1 = recommender1.GetSuggestions(user.Id, 6);
List <RecommendationEngine.Objects.Suggestion> suggestions2 = recommender2.GetSuggestions(user.Id, 3);
foreach (RecommendationEngine.Objects.Suggestion s in suggestions1)
{
Databases.DomainModel.Product product = mongo.GetProduct(s.ProductID);
if (!products.Exists(x => x.Id.Equals(product.Id)))
{
products.Add(product);
}
}
foreach (RecommendationEngine.Objects.Suggestion s in suggestions2)
{
Databases.DomainModel.Product product = mongo.GetProduct(s.ProductID);
if (!products.Exists(x => x.Id.Equals(product.Id)))
{
products.Add(product);
}
}
}
else//no actions, recommendation using gender and birth date
{
List <Databases.DomainModel.Product> CategoryProducts = new List <Databases.DomainModel.Product>();
foreach (string subcat in user.Interests)
{
CategoryProducts.AddRange(mongo.GetCategoryProducts(subcat).Take(2));
}
List <RecommendationEngine.Objects.Suggestion> suggestions1 = recommender1.GetFirstSuggestions(db, user, 10);
foreach (RecommendationEngine.Objects.Suggestion s in suggestions1)
{
Databases.DomainModel.Product product = mongo.GetProduct(s.ProductID);
if (!products.Exists(x => x.Id.Equals(product.Id)))
{
products.Add(product);
}
}
foreach (Databases.DomainModel.Product p in CategoryProducts)
{
if (!products.Exists(x => x.Id.Equals(p.Id)))
{
products.Add(p);
}
}
}
//recommend za reklame
List <Databases.DomainModel.Advert> adverts = new List <Databases.DomainModel.Advert>();
actions = parser.LoadForAdverts();
db = parser.LoadUserBehaviorDatabase(actions);
recommender1.Train(db);
List <RecommendationEngine.Objects.Suggestion> suggestionsU = new List <RecommendationEngine.Objects.Suggestion>();
List <RecommendationEngine.Objects.Suggestion> suggestionsI = new List <RecommendationEngine.Objects.Suggestion>();
List <Databases.DomainModel.Product> categoryProducts = new List <Databases.DomainModel.Product>();
if (actions.Count(x => x.UserId.Equals(user.Id)) > 0)
{
suggestionsU = recommender2.GetSuggestions(user.Id, 5);
suggestionsI = recommender1.GetSuggestions(user.Id, 5);
}
else
{
foreach (string subcat in user.Interests)
{
categoryProducts.AddRange(mongo.GetCategoryProducts(subcat).Take(2));
}
foreach (Databases.DomainModel.Product p in categoryProducts)
{
foreach (Databases.DomainModel.Advert advert in mongo.GetAdverts(p.Subcategory))
{
if (!adverts.Exists(x => x.Id.Equals(advert.Id)))
{
adverts.Add(advert);
}
}
}
suggestionsI = recommender1.GetFirstSuggestions(db, user, 10);
}
foreach (RecommendationEngine.Objects.Suggestion s in suggestionsI)
{
Databases.DomainModel.Product product = mongo.GetProduct(s.ProductID);
foreach (Databases.DomainModel.Advert advert in mongo.GetAdverts(product.Subcategory))
{
if (!adverts.Exists(x => x.Id.Equals(advert.Id)))
{
adverts.Add(advert);
}
}
}
foreach (RecommendationEngine.Objects.Suggestion s in suggestionsU)
{
Databases.DomainModel.Product product = mongo.GetProduct(s.ProductID);
foreach (Databases.DomainModel.Advert advert in mongo.GetAdverts(product.Subcategory))
{
if (!adverts.Exists(x => x.Id.Equals(advert.Id)))
{
adverts.Add(advert);
}
}
}
ViewBag.Adverts = adverts;
//last seen
List <MongoDB.Bson.ObjectId> prodIds = tdb.LastSeen(user.Id.ToString());
List <Databases.DomainModel.Product> lastSeen = new List <Databases.DomainModel.Product>();
foreach (MongoDB.Bson.ObjectId id in prodIds)
{
lastSeen.Add(mongo.GetProduct(id));
}
tdb.CloseConnection();
ViewBag.LastSeen = lastSeen;
}
else //admin logged
{
products = mongo.GetProducts();
}
return(View(products));
}
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();
}
