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(); }