public void UpdateCategorySize(int id, string name) { try { name = name.TrimEnd().TrimStart(); } catch (Exception) { throw new Exception("No es posible registrar la Categoría de Talla"); } CategorySizesDAO dao = new CategorySizesDAO(); List <CategorySize> categorySizes = GetAllCategorySizes(); CategorySize updateCategorySize = categorySizes.Find(c => c.id.Equals(id)); if (updateCategorySize != null) { if (categorySizes.FindAll(c => (c.name.ToUpperInvariant().Equals(name.ToUpperInvariant())) && (c.id != id)).Count > 0) { throw new Exception("Ya existe una Categoría Talla con este nombre"); } updateCategorySize.name = name; int result = dao.UpdateCategorySize(updateCategorySize); if (result < 1) { throw new Exception("No es posible actualizar la Categoría de Talla"); } } else { throw new Exception("El id de la Categoría Talla a actualizar no es válido"); } }
private void AddParameters(CategorySize categorySize, Database database, DbCommand command) { database.AddInParameter(command, "@pId", DbType.Int32, categorySize.id); database.AddInParameter(command, "@pName", DbType.String, categorySize.name); database.AddParameter(command, "@pIdReturn", DbType.Int32, ParameterDirection.ReturnValue , null, DataRowVersion.Default, null); }
public void InsertCategorySize(string name) { try { name = name.TrimEnd().TrimStart(); } catch (Exception) { throw new Exception("No es posible registrar la Categoría de Talla"); } CategorySizesDAO dao = new CategorySizesDAO(); List <CategorySize> categorySizes = GetAllCategorySizes(); if (categorySizes.FindAll(c => (c.name.ToUpperInvariant().Equals(name.ToUpperInvariant()))).Count > 0) { throw new Exception("Ya existe una Categoría de Talla con este nombre"); } CategorySize newCategorySize = new CategorySize(); newCategorySize.name = name; int result = dao.CreateCategorySize(newCategorySize); if (result < 1) { throw new Exception("No es posible registrar la Categoría de Talla"); } }
public ActionResult DeleteConfirmed(int id) { CategorySize categorySize = db.CategorySizes.Find(id); db.CategorySizes.Remove(categorySize); db.SaveChanges(); return(RedirectToAction("Index")); }
public CategorySize GetCategorySize(int id) { CategorySize categorySize = new CategorySize(); CategorySizesDAO dao = new CategorySizesDAO(); categorySize = dao.GetCategorySize(id); return(categorySize); }
protected void Page_Load(object sender, EventArgs e) { int productId = -1; if (!IsPostBack) { try { productId = Convert.ToInt32(Request.QueryString["productId"]); CtrlProducts ctrlProducts = new CtrlProducts(); Product product = ctrlProducts.GetProduct(productId); if (product != null && product.id > 0) { lblNombreProducto.Text = product.name; lblDescripcion.Text = product.shortDescription; CtrlProductTypes ctrlProductTypes = new CtrlProductTypes(); ProductType productType = ctrlProductTypes.GetProductType(product.productTypeId); if (productType != null && productType.id > 0) { CtrlCategorySizes ctrlCategorySizes = new CtrlCategorySizes(); CategorySize categorySize = ctrlCategorySizes.GetCategorySize(productType.categorySizeId); CtrlSizes ctrlSizes = new CtrlSizes(); List <Size> listAllSizes = ctrlSizes.GetAllSizes(); listAllSizes = listAllSizes.FindAll(s => s.categorySizeId.Equals(categorySize.id)); CtrlStockSizes ctrlStockSizes = new CtrlStockSizes(); List <StockSize> listAllStockSizes = ctrlStockSizes.GetAllStockSizes(); listAllStockSizes = listAllStockSizes.FindAll(ss => ss.productId.Equals(product.id)); foreach (Size size in listAllSizes) { StockSize stockSize = listAllStockSizes.Find(ss => ss.sizeId.Equals(size.id)); if (stockSize == null) { StockSize newStockSize = new StockSize(); newStockSize.productId = product.id; newStockSize.sizeId = size.id; newStockSize.stock = 0; ctrlStockSizes.InsertStockSize(newStockSize.productId, newStockSize.sizeId, newStockSize.stock); } } } } } catch (Exception) { Response.Redirect("Products.aspx"); } } }
public ActionResult Edit([Bind(Include = "Id,CategoryId,SectionId,SizeId")] CategorySize categorySize) { if (ModelState.IsValid) { db.Entry(categorySize).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CategoryId = new SelectList(db.Categories, "Id", "Name", categorySize.CategoryId); ViewBag.SectionId = new SelectList(db.Sections, "Id", "Name", categorySize.SectionId); ViewBag.SizeId = new SelectList(db.Sizes, "Id", "Name", categorySize.SizeId); return(View(categorySize)); }
// GET: Admin/CategorySizes/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CategorySize categorySize = db.CategorySizes.Find(id); if (categorySize == null) { return(HttpNotFound()); } return(View(categorySize)); }
// GET: Admin/CategorySizes/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CategorySize categorySize = db.CategorySizes.Find(id); if (categorySize == null) { return(HttpNotFound()); } ViewBag.CategoryId = new SelectList(db.Categories, "Id", "Name", categorySize.CategoryId); ViewBag.SectionId = new SelectList(db.Sections, "Id", "Name", categorySize.SectionId); ViewBag.SizeId = new SelectList(db.Sizes, "Id", "Name", categorySize.SizeId); return(View(categorySize)); }
public void DeleteCategorySize(int id) { CategorySizesDAO dao = new CategorySizesDAO(); CategorySize deleteCategorySize = dao.GetCategorySize(id); if (deleteCategorySize != null) { int result = dao.DeleteCategorySize(deleteCategorySize); if (result < 1) { throw new Exception("No es posible eliminar la Categoría de Talla, por favor verificar que no existan asociaciones a la Categoría de Talla"); } } else { throw new Exception("El id de la Categoría Talla a eliminar no es válido"); } }
public int DeleteCategorySize(CategorySize categorySize) { int result = -1; try { Database database = DatabaseFactory.CreateDatabase(); DbCommand command = database.GetStoredProcCommand(storedProcedureName); database.AddInParameter(command, "@pOperation", DbType.Int32, 5); AddParameters(categorySize, database, command); result = database.ExecuteNonQuery(command); } catch (Exception exc) { //Crear Exception } return(result); }
public CategorySize GetCategorySize(int id) { CategorySize categorySize = null; try { Database database = DatabaseFactory.CreateDatabase(); DbCommand command = database.GetStoredProcCommand(storedProcedureName); database.AddInParameter(command, "@pOperation", DbType.Int32, 3); database.AddInParameter(command, "@pId", DbType.Int32, id); DataSet dsAllCategorySizes = database.ExecuteDataSet(command); if (dsAllCategorySizes != null && dsAllCategorySizes.Tables.Count > 0) { categorySize = DAOUtilities.FillEntities <CategorySize>(dsAllCategorySizes.Tables[0]) .FirstOrDefault(); } } catch (Exception exc) { //Crear Exception } return(categorySize); }
public async Task <CatlogDto> Handle(Command request, CancellationToken cancellationToken) { //var test = request.test; var catalog = await _context.Catalogs .FindAsync(request.Id); if (catalog == null) { throw new RestException(HttpStatusCode.NotFound, new { Catalog = "Not found" }); } var CurrentUsername = _userAccessor.GetCurrentUsername(); float price = 0; if (!float.TryParse(request.Price, out price)) { throw new Exception("invalid Price"); } if (CurrentUsername.ToLower().ToString() == "admin" || catalog.Supplier.UserName == CurrentUsername) { var category = await _context.Categories.SingleOrDefaultAsync(x => x.Id == request.CategoryId); #region CategoryColores //delete all existing entries _context.CategoryColores.RemoveRange(catalog.Colores); //Add existing entries if (request.Colores != null) { foreach (string c in request.Colores) { var color = new CategoryColores { configid = c }; catalog.Colores.Add(color); } } #endregion CategoryColores #region Sizes //delete all existing entries _context.CategorySize.RemoveRange(catalog.Sizes); // Add existing entries if (request.Sizes != null) { foreach (CategorySize s in request.Sizes) { var size = new CategorySize { configid = s.configid, Title = s.Title, Qty = s.Qty }; catalog.Sizes.Add(size); } } #endregion Sizes if (category != null) { catalog.Category = category; } catalog.DisplayName = request.DisplayName ?? catalog.DisplayName; catalog.Description = request.Description ?? catalog.Description; catalog.Price = price; // _context.Entry(cl).State = EntityState.Modified; //.Entry(user).State = EntityState.Added; / var success = await _context.SaveChangesAsync() > 0; //if (success) return Unit.Value; if (success) { var toReturn = _mapper.Map <Catalog, CatlogDto>(catalog); return(toReturn); } } else { throw new Exception("Unauthorized access"); } throw new Exception("Problem saving changes"); }
public async Task <CatlogDto> Handle(Command request, CancellationToken cancellationToken) { var supplier = await _context.Users.SingleOrDefaultAsync(x => x.UserName == _userAccessor.GetCurrentUsername()); var category = await _context.Categories.SingleOrDefaultAsync(x => x.Id == request.CategoryId); //CategoryId float price = 0; if (!float.TryParse(request.Price, out price)) { throw new Exception("invalid Price"); } var cl = new List <CategoryColores>(); //Add existing entries if (request.Colores != null) { if (request.Colores != null) { foreach (string c in request.Colores) { var color = new CategoryColores { //Id = Guid.NewGuid(), //CatlogId = request.Id, configid = c }; cl.Add(color); } } } var cz = new List <CategorySize>(); if (request.Sizes != null) { foreach (CategorySize s in request.Sizes) { var size = new CategorySize { configid = s.configid, Title = s.Title, Qty = s.Qty }; //{ // Id = Guid.NewGuid(), // Title = s.Title, // Qty = s.Qty //}; cz.Add(size); } } var catalog = new Catalog { //Id = request.Id, DisplayName = request.DisplayName, Description = request.Description, Supplier = supplier, Category = category, Price = price, Colores = cl, Sizes = cz }; _context.Catalogs.Add(catalog); var success = await _context.SaveChangesAsync() > 0; if (success) { var toReturn = _mapper.Map <Catalog, CatlogDto>(catalog); return(toReturn); } //return Unit.Value; //var toReturn = _mapper.Map<Catalog, CatlogDto>(catalog); //return toReturn; throw new Exception("Problem saving changes"); }