// // GET: /Manage/Index public async Task <ActionResult> Index(ManageMessageId?message) { ViewBag.StatusMessage = message == ManageMessageId.ChangePasswordSuccess ? "Your password has been changed." : message == ManageMessageId.SetPasswordSuccess ? "Your password has been set." : message == ManageMessageId.SetTwoFactorSuccess ? "Your two-factor authentication provider has been set." : message == ManageMessageId.Error ? "An error has occurred." : message == ManageMessageId.AddPhoneSuccess ? "Your phone number was added." : message == ManageMessageId.RemovePhoneSuccess ? "Your phone number was removed." : ""; var userId = User.Identity.GetUserId(); var model = new IndexViewModel { HasPassword = HasPassword(), PhoneNumber = await UserManager.GetPhoneNumberAsync(userId), TwoFactor = await UserManager.GetTwoFactorEnabledAsync(userId), Logins = await UserManager.GetLoginsAsync(userId), BrowserRemembered = await AuthenticationManager.TwoFactorBrowserRememberedAsync(userId) }; using (WebshopModel db = new WebshopModel()) { string uID = User.Identity.GetUserId(); ViewBag.UserDataDb = db.UserDatas.Where(x => x.UserID == uID).FirstOrDefault(); ViewBag.AddresDb = db.Addresses.Where(x => x.UserId == uID).ToList(); } return(View(model)); }
public ActionResult RiportDetails() { using (WebshopModel _context = new WebshopModel()) { List <Order> allOrders = _context.Orders.Where(x => x.OrderStatus != OrderStatusEnum.DELETED.ToString() && x.OrderStatus != OrderStatusEnum.NOTCREATED.ToString()).ToList(); List <OrderEntry> allOrderEntry = new List <OrderEntry>(); foreach (Order item in allOrders) { List <OrderEntry> o = _context.OrderEntries.Where(x => x.Order_ID == item.OrderID).ToList(); foreach (OrderEntry orderItem in o) { allOrderEntry.Add(orderItem); } } int allOrderPrice = 0; foreach (OrderEntry item in allOrderEntry) { allOrderPrice += item.ProductPrice * item.Quantity; } ViewBag.SumAllOrders = allOrderPrice; return(View(allOrders)); } }
public async Task <ActionResult> Register(RegisterViewModel model, UserData userData) { if (ModelState.IsValid) { var user = new ApplicationUser { UserName = model.Email, Email = model.Email }; var result = await UserManager.CreateAsync(user, model.Password); if (result.Succeeded) { UserManager.AddToRole(user.Id, "Customer"); await SignInManager.SignInAsync(user, isPersistent : false, rememberBrowser : false); // For more information on how to enable account confirmation and password reset please visit https://go.microsoft.com/fwlink/?LinkID=320771 // Send an email with this link // string code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id); // var callbackUrl = Url.Action("ConfirmEmail", "Account", new { userId = user.Id, code = code }, protocol: Request.Url.Scheme); // await UserManager.SendEmailAsync(user.Id, "Confirm your account", "Please confirm your account by clicking <a href=\"" + callbackUrl + "\">here</a>"); using (WebshopModel db = new WebshopModel()) { var newUser = db.UserDatas.Create(); newUser.FirstName = userData.FirstName; newUser.LastName = userData.LastName; newUser.UserName = userData.UserName; newUser.City = userData.City; newUser.Street = userData.Street; newUser.HouseNumber = userData.HouseNumber; newUser.PostCode = userData.PostCode; newUser.UserID = user.Id; newUser.UserEmail = user.Email; db.UserDatas.Add(newUser); Address newAddress = db.Addresses.Create(); newAddress.UserId = user.Id; newAddress.City = userData.City; newAddress.Street = userData.Street; int.TryParse(userData.HouseNumber, out int hausNumber); newAddress.HouseNumber = hausNumber; int.TryParse(userData.PostCode, out int zipCode); newAddress.ZipCode = zipCode; db.Addresses.Add(newAddress); db.SaveChanges(); } return(RedirectToAction("Index", "Shop")); } AddErrors(result); } // If we got this far, something failed, redisplay form return(View(model)); }
//public void ConfirmOrder() //{ // OrderStatusEnum order = (OrderStatusEnum)OrderStatus; // if (order != OrderStatusEnum.DELETED) // { // if (order == OrderStatusEnum.ACTIVE) // { // OrderStatus = (int)OrderStatusEnum.SHIPPING; // }else if (order == OrderStatusEnum.SHIPPING) // { // OrderStatus = (int)OrderStatusEnum.SHIPPED; // } // } //} //public void CancelOrder() //{ // OrderStatus = (int)OrderStatusEnum.DELETED; //} //public Address ChangeAddress() //{ //} public static List <Address> UserAddresses(IPrincipal user) { List <Address> addresses = new List <Address>(); using (WebshopModel db = new WebshopModel()) { string userID = user.Identity.GetUserId(); addresses = db.Addresses.Where(x => x.UserId == userID).ToList(); } return(addresses); }
public ActionResult Index() { using (WebshopModel _context = new WebshopModel()) { ViewBag.CountOrders = _context.Orders.Count(); ViewBag.CountProducts = _context.Products.Count(); ViewBag.CountOrderEntries = _context.OrderEntries.Count(); } using (ApplicationDbContext _context2 = new ApplicationDbContext()) { ViewBag.CountUsers = _context2.Users.Count(); } return(View()); }
//public static string CanSee(Address address, IPrincipal user) //{ // using (WebshopModel db = new WebshopModel()) // { // string uID = user.Identity.GetUserId(); // List<Address> addresses = db.Addresses.Where(x => x.UserId == uID).ToList(); // UserData userData = db.UserDatas.Where(y => y.UserID == uID).FirstOrDefault(); // if (address.City == userData.City && // address.HouseNumber.ToString() == userData.HouseNumber && // address.ZipCode.ToString() == userData.PostCode && // address.Street == userData.Street) // { // return "display:none"; // } // else // { // return ""; // } // } //} public static string CanSee(Address address, IPrincipal user) { using (WebshopModel db = new WebshopModel()) { string uID = user.Identity.GetUserId(); List <Address> addresses = db.Addresses.Where(x => x.UserId == uID).ToList(); if (addresses.Count() <= 1) { return("display:none"); } else { return(""); } } }
static void Main(string[] args) { using (var db = new WebshopModel()) { // Create Console.WriteLine("Inserting a new User"); db.Add(new User { Username = "******", Password = "******", Email_addres = "*****@*****.**" }); db.SaveChanges(); // Read Console.WriteLine("Querying for a user"); var user = db.Users .OrderBy(b => b.UserId) .First(); Console.WriteLine("Felhasználónév:" + user.Username); Console.WriteLine("Email:" + user.Email_addres); Console.WriteLine("Jelszó:" + user.Password); /* // Update * Console.WriteLine("Updating the blog and adding a post"); * blog.Url = "https://devblogs.microsoft.com/dotnet"; * blog.Posts.Add( * new Post * { * Title = "Hello World", * Content = "I wrote an app using EF Core!" * }); * db.SaveChanges(); * * // Delete * Console.WriteLine("Delete the blog"); * db.Remove(blog); * db.SaveChanges();*/ Console.WriteLine("Hello there"); } }