public void DeleteOrganizationProduct(int organizationProductID, bool bypass = true) { if (!UserSession.CurrentUser.IsSystemAdmin && bypass) { return; } try { OrganizationProducts organizationProducts = new OrganizationProducts(UserSession.LoginUser); organizationProducts.LoadByOrganizationProductID(organizationProductID); UserProducts userProducts = new UserProducts(UserSession.LoginUser); //userProducts.LoadByOrganizationProductAndVersionID(organizationProducts[0].OrganizationID, "hola", "adios"); userProducts.LoadByOrganizationProductAndVersionID(organizationProducts[0].OrganizationID, organizationProducts[0].ProductID, organizationProducts[0].ProductVersionID); userProducts.DeleteAll(); userProducts.Save(); organizationProducts.DeleteFromDB(organizationProductID); Product p = Products.GetProduct(TSAuthentication.GetLoginUser(), organizationProducts[0].ProductID); string description = String.Format("{0} deleted product association to {1} ", TSAuthentication.GetUser(TSAuthentication.GetLoginUser()).FirstLastName, p.Name); ActionLogs.AddActionLog(TSAuthentication.GetLoginUser(), ActionLogType.Delete, ReferenceType.Organizations, organizationProducts[0].OrganizationID, description); } catch (Exception ex) { DataUtils.LogException(UserSession.LoginUser, ex); } }
public bool BuyProduct(string userId, int productId) { var user = this.DbContext .Users .FirstOrDefault(x => x.Id == userId); var product = this.DbContext .Products .FirstOrDefault(x => x.Id == productId); if (user == null || product == null) { return(false); } var userProduct = new UserProducts() { UserId = userId, ProductId = productId, BoughtOn = DateTime.UtcNow }; bool alreadyInFavourites = this.DbContext.UserBoughtProducts .Any(x => x.UserId == userId && x.ProductId == productId); if (alreadyInFavourites) { return(false); } user.BoughtProducts.Add(userProduct); this.DbContext.SaveChanges(); return(true); }
// GET public ActionResult Index() { var model = new UserProducts(); model.Users = _userRepo.GetAll(); model.Products = _productRepo.GetAll(); return(View(model)); }
public void Update(UserProducts userProducts) { using (IDbConnection db = new SqlConnection(connectionString)) { var sqlQuery = "UPDATE UserProducts SET UserId = @UserId, ProductId = @ProductId WHERE Id = @Id"; db.Execute(sqlQuery, userProducts); } }
public ActionResult RemoveFromFav(int id) { UserProducts userProd = db.UserProducts.Find(User.Identity.GetUserId(), id); db.UserProducts.Remove(userProd); db.SaveChanges(); return(RedirectToAction("Show", "Products", new { id = id })); }
public void Create(UserProducts userProducts) { using (IDbConnection db = new SqlConnection(connectionString)) { var sqlQuery = "INSERT INTO UserProducts (UserId, ProductId) VALUES(@UserId, @ProductId); SELECT CAST(SCOPE_IDENTITY() as int)"; int?id = db.Query <int>(sqlQuery, userProducts).FirstOrDefault(); userProducts.Id = id ?? 0; } }
public void DeleteProduct(Guid idProduct, Guid idUser) { UserProducts userProduct = context.UserProducts.Where(x => x.IdProduct == idProduct && x.IdUser == idUser) .FirstOrDefault(); context.UserProducts.Remove(userProduct); context.SaveChanges(); }
public void Update(DataContracts.UserProducts entity) { UserProducts up = _source.First(o => o.IdProduct == entity.IdProduct && o.IdUser == entity.IdUser); if (up != null) { up.Quantity = entity.Quantity; } }
public static string GetUserProduct(RestCommand command, int userProductID) { UserProduct userProduct = UserProducts.GetUserProduct(command.LoginUser, userProductID); if (userProduct.OrganizationID != command.Organization.OrganizationID) { throw new RestException(HttpStatusCode.Unauthorized); } return(userProduct.GetXml("UserProduct", true)); }
public UserProducts Get(int id) { UserProducts userProducts = null; using (IDbConnection db = new SqlConnection(connectionString)) { userProducts = db.Query <UserProducts>("SELECT * FROM UserProducts WHERE Id = @id", new { id }).FirstOrDefault(); } return(userProducts); }
private void SaveProducts() { foreach (var prod in this.HandleDoublons()) { UserProducts entity = new UserProducts(); entity.IdProduct = prod.First.ID; entity.IdUser = this.Context.ApplicationUser.ID; entity.Quantity = prod.Second; UserProductsRepo.Insert(entity); } }
public void SaveProduct(UserProducts product) { if (product.Id == default) { context.Entry(product).State = EntityState.Added;// объект будет добавлен как новый } else { context.Entry(product).State = EntityState.Modified;// старый объект будет изменён } context.SaveChanges(); }
public ActionResult FromCart(string id, string name, string amount) { if (id != null) { var str = Request.Cookies["cart"].Value.ToString(); var id_s = id + "," + name + "," + amount; var replace = ""; var res = Regex.Replace(str, id_s, replace); Response.Cookies["cart"].Value = res; var c_ps = res.Split('|'); List <Product> temp = new List <Product>(); foreach (var i in c_ps) { var p = i.Split(','); if (p[0] != "") { int ii_int = Convert.ToInt32(p[0]); int amountt = Convert.ToInt32(p[2]); var new_p = new Product { Id = ii_int, Pname = p[1], Amount = amountt, Status = 1 }; temp.Add(new_p); } } UserProducts cart_pros = new UserProducts { ProductsV = temp }; if (cart_pros.ProductsV.Count > 0) { return(PartialView("~/Views/Users/_Cart.cshtml", cart_pros)); } else { return(Content("You don't have any product in your cart at the time...")); } } else { TempData["Error"] = "Spmething went wrong ! Please try again... "; return(RedirectToAction("Index", "Products")); } }
public static string GetUserProducts(RestCommand command) { UserProducts userProducts = new UserProducts(command.LoginUser); userProducts.LoadByOrganizationID(command.Organization.OrganizationID); if (command.Format == RestFormat.XML) { return(userProducts.GetXml("UserProducts", "UserProduct", true, command.Filters)); } else { throw new RestException(HttpStatusCode.BadRequest, "Invalid data format"); } }
// GET: Users/Profile/5 public ActionResult Profile(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } List <Product> temp = new List <Product>(); if (Request.Cookies["cart"] != null) { var ps = Request.Cookies["cart"].Value.ToString().Split('|'); foreach (var i in ps) { if (i != "") { var p = i.Split(','); int i_int = Convert.ToInt32(p[0]); int amount = Convert.ToInt32(p[2]); var new_p = new Product { Id = i_int, Pname = p[1], Amount = amount, Status = 1 }; temp.Add(new_p); } } } else { temp = null; } UserProducts user = new UserProducts { UserV = ent.Users.Find(id), ProductsV = temp, Bought_Prod = ent.Sold_products.Where(x => x.U_id == id).ToList() }; if (user.UserV == null) { return(HttpNotFound()); } return(View(user)); }
public void DeleteUserProduct(int userProductID) { if (!UserSession.CurrentUser.IsSystemAdmin) { return; } try { UserProducts userProducts = new UserProducts(UserSession.LoginUser); userProducts.DeleteFromDB(userProductID); } catch (Exception ex) { DataUtils.LogException(UserSession.LoginUser, ex); } }
private List <UserProducts> MapUSERPRODUCTS(IDataReader reader) { List <UserProducts> list = new List <UserProducts>(); while (reader.Read()) { UserProducts userproducts = new UserProducts() { IdUser = Tools.ChangeType <int>(reader["idUser"]), IdProduct = Tools.ChangeType <int>(reader["idProduct"]), Quantity = Tools.ChangeType <int>(reader["quantity"]), }; list.Add(userproducts); } return(list); }
public CloseOrderVM(ApplicationDbContext ctx, int orderID, ApplicationUser user) { DefaultShippingAddress = ctx.ShippingAddress.SingleOrDefault(sa => sa.User == user && sa.IsDefault == true); DefaultBillingAddress = ctx.BillingAddress.SingleOrDefault(ba => ba.User == user && ba.IsDefault == true); DefaultPaymentType = ctx.PaymentType.SingleOrDefault(pt => pt.User == user && pt.IsActive == true && pt.IsPrimary == true); User = user; Order = ctx.Order.SingleOrDefault(o => o.OrderID == orderID && o.User == user); UserProducts = ctx.CompositeProduct .Include(cp => cp.ProductType) .Include(cp => cp.Ink) .Include(cp => cp.Screen) .Where(cp => cp.OrderID == orderID); ShoppingCartTotal = UserProducts.Sum(cp => cp.Price); }
public ActionResult AddToFav(int id) { if (!User.Identity.IsAuthenticated) { return(RedirectToAction("Login", "Account")); } UserProducts userProd = new UserProducts(); userProd.ProductId = id; userProd.UserId = User.Identity.GetUserId(); try { db.UserProducts.Add(userProd); db.SaveChanges(); return(RedirectToAction("Show", "Products", new { id = id })); } catch (Exception e) { return(RedirectToAction("Show", "Products", new { id = id })); } }
// GET: Sold public ActionResult Buy(string p_id, string amount) { if (Session["u_id"] != null) { int id = Convert.ToInt32(p_id); int a_int = Convert.ToInt32(amount); if (id != 0) { var prod = ent.Products.FirstOrDefault(x => x.Id == id); int i_int = (int)Session["u_id"]; Sold_products product = new Sold_products { P_id = prod.Id, U_id = i_int, C_id = (int)prod.Cid, Date = DateTime.UtcNow, P_name = prod.Pname }; ent.Sold_products.Add(product); var flag = ent.SaveChanges(); prod.Amount = prod.Amount - a_int; ent.Entry(prod).State = System.Data.Entity.EntityState.Modified; ent.SaveChanges(); //Fromcart(prod.Id, prod.Pname, prod.Amount + a_int); var str = Request.Cookies["cart"].Value.ToString(); var id_s = prod.Id.ToString() + "," + prod.Pname + "," + (prod.Amount + a_int).ToString(); var replace = ""; var res = Regex.Replace(str, id_s, replace); Response.Cookies["cart"].Value = res; //var c_ps = Request.Cookies["cart"].Value.ToString().Split('|'); var c_ps = res.Split('|'); List <Product> temp = new List <Product>(); foreach (var i in c_ps) { var p = i.Split(','); if (p[0] != "") { int ii_int = Convert.ToInt32(p[0]); int amountt = Convert.ToInt32(p[2]); var new_p = new Product { Id = ii_int, Pname = p[1], Amount = amountt, Status = 1 }; temp.Add(new_p); } } UserProducts cart_pros = new UserProducts { ProductsV = temp }; if (cart_pros.ProductsV.Count > 0) { return(PartialView("~/Views/Users/_Cart.cshtml", cart_pros)); } else { return(Content("You don't have any product in your cart at the time...")); } } else { TempData["Error"] = "There was an error, please try again..."; return(RedirectToAction("Profile", "Users", new { id = (int)Session["u_id"] })); } } else { return(RedirectToAction("Index", "Account")); } }
public static List <UserProducts> GetProductsOfUser(int UserId) { List <Tuple <int, int> > productIDs = new List <Tuple <int, int> >(); List <UserProducts> products = new List <UserProducts>(); try { connection.Open(); using (SQLiteCommand cmd = new SQLiteCommand(connection)) { cmd.CommandText = "SELECT * FROM user_products WHERE user_id = @ID"; cmd.Parameters.AddWithValue("@ID", UserId); using (SQLiteDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { productIDs.Add(new Tuple <int, int>(reader.GetInt32(1), reader.GetInt32(2))); } } } using (SQLiteCommand cmd = new SQLiteCommand(connection)) { User tempUser = UserController.GetUserById(UserId); cmd.CommandText = "SELECT * FROM products WHERE productid = @ProductId"; productIDs.ForEach(productamount => { cmd.Parameters.AddWithValue("@ProductId", productamount.Item1); using (SQLiteDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { Product tempProduct = new Product(); tempProduct.ProductID = reader.GetInt32(0); tempProduct.Name = reader.GetString(1); tempProduct.Price = reader.GetFloat(2); UserProducts tempUserProducts = new UserProducts(); tempUserProducts.User = tempUser; tempUserProducts.Product = tempProduct; tempUserProducts.Amount = productamount.Item2; products.Add(tempUserProducts); } } }); } connection.Close(); } catch (SQLiteException e) { connection.Close(); Debug.WriteLine(e); return(null); } return(products); }
public ResponseModel AddProduct(AddProductModel addProduct) { ResponseModel result = new ResponseModel(); result = ValidateAddProduct(addProduct); if (!result.IsSuccess) { return(result); } using (var t = new TransactionScope()) { try { UserProducts new_p = new UserProducts(); new_p.UserID = addProduct.UserID; new_p.CreateDate = DateTime.Now; new_p.Description = addProduct.Description; new_p.IsPublish = addProduct.IsPublish; new_p.Keywords = addProduct.Keywords; new_p.Price = addProduct.Price; new_p.Tags = addProduct.Tags; new_p.Name = addProduct.Name; new_p.Uri = new PostManager().GenerateUriFormat(addProduct.Uri); new_p.ID = _proRepo.Insert(new_p); if (addProduct.MainImage != null) { string file_name = Guid.NewGuid().ToString().Replace("-", "") + ".jpg"; string baseMap = Path.Combine(addProduct.BasePhotoPath, file_name); _imM.SaveProductImage(addProduct.MainImage, baseMap); ProductPhotos mainPhoto = new ProductPhotos(); mainPhoto.IsMain = true; mainPhoto.Photo = file_name; mainPhoto.ProductID = new_p.ID; _photoRepo.Insert(mainPhoto); } if (addProduct.Photos != null) { foreach (var item in addProduct.Photos) { string file_name = Guid.NewGuid().ToString().Replace("-", "") + ".jpg"; string baseMap = Path.Combine(addProduct.BasePhotoPath, file_name); _imM.SavePostMainPage(item, baseMap); ProductPhotos mainPhoto = new ProductPhotos(); mainPhoto.IsMain = false; mainPhoto.Photo = file_name; mainPhoto.ProductID = new_p.ID; _photoRepo.Insert(mainPhoto); } } result.Message = "Ürün başarı ile eklendi!"; result.IsSuccess = true; t.Complete(); } catch (Exception ex) { result.IsSuccess = false; result.Message = ex.Message; t.Dispose(); } } return(result); }