public void Update(ShoppingCart shoppingCart) { if(shoppingCart == null) throw new ArgumentNullException("shoppingCart"); using(var context = new MyShopReadModelDataContext()) { context.ShoppingCarts.Attach(shoppingCart, true); context.SubmitChanges(); } }
public ShoppingCart FindById(Guid id) { ShoppingCart result; using(var context = new MyShopReadModelDataContext()) { result = context.ShoppingCarts.FirstOrDefault(c => c.Id == id); } return result; }
public override string[] GetRolesForUser(string username) { using (var context = new MyShopReadModelDataContext()) { var query = from user in context.Users join role in context.UserRoles on user.Id equals role.UserId where user.Username == username select role.RoleName; var buffer = new List<String>(); buffer.AddRange(query); return buffer.ToArray(); } }
public User FindById(Guid id) { User result; using (var context = new MyShopReadModelDataContext()) { var query = from u in context.Users where u.Id == id select u; result = query.FirstOrDefault(); } return result; }
public ActionResult Edit(Guid id) { using (var context = new MyShopReadModelDataContext()) { var result = context.Products.FirstOrDefault(p => p.Id == id); if (result == null) { return View("NotFound"); } else { return View(result); } } }
public ShoppingCart FindByVisitorId(Guid visitorId) { ShoppingCart result = null; using (var context = new MyShopReadModelDataContext()) { context.DeferredLoadingEnabled = false; var query = from cart in context.ShoppingCarts where cart.VisitorId == visitorId select cart; result = query.FirstOrDefault(); } return result; }
public ActionResult Details(Guid id) { ActionResult result; using (var context = new MyShopReadModelDataContext()) { Product product = context.Products.FirstOrDefault(p => p.Id == id); if (product == null) { result = View("NotFound"); } else { result = View(product); } } return result; }
public ActionResult Edit(Product edited) { using (var context = new MyShopReadModelDataContext()) { Product original = context.Products.FirstOrDefault(p => p.Id == edited.Id); if (original == null) { return View("NotFound"); } else { var commands = new List<ICommand>(GetCommandsForEditedProduct(original, edited)); if (commands.Count > 0) { MyShopWebApplication.CommandService.Execute(commands.ToArray()); } return View(edited); } } }
public override bool ValidateUser(String username, String password) { string hashPassword = EncodePassword(password); using (var context = new MyShopReadModelDataContext()) { User user = context.Users.FirstOrDefault(u => u.Username.Equals(username) && u.Password == hashPassword); return user != null; } }
public override String GetUserNameByEmail(String email) { String result = null; using (var context = new MyShopReadModelDataContext()) { User user = context.Users.FirstOrDefault(u => u.Email == email); if (user != null) { result = user.Username; } } return result; }
public override MembershipUser GetUser(String username, bool userIsOnline) { MembershipUser result = null; using (var context = new MyShopReadModelDataContext()) { User user = context.Users.FirstOrDefault(u => u.Username == username); if (user != null) { result = user.ToMembershipUser(Name); } } return result; }
public override MembershipUserCollection GetAllUsers(int pageIndex, int pageSize, out int totalRecords) { var result = new MembershipUserCollection(); using (var context = new MyShopReadModelDataContext()) { totalRecords = context.Users.Count(); foreach (User user in context.Users) { result.Add(user.ToMembershipUser(Name)); } } return result; }
public ActionResult List() { using (var context = new MyShopReadModelDataContext()) { var result = context.Products.ToList(); return View(result); } }
public override bool IsUserInRole(string username, string roleName) { using (var context = new MyShopReadModelDataContext()) { var query = from user in context.Users join role in context.UserRoles on user.Id equals role.UserId where user.Username == username where role.RoleName == roleName select role; return query.Count() > 0; } }