private void cmbProductName_SelectionChangeCommitted(object sender, EventArgs e) { TblProduct tblProduct = new TblProduct(); //upon selection if (Convert.ToInt16(cmbProductName.SelectedValue) != 0) { btnAdd.Hide(); btnSave.Show(); tblProduct = _productService.GetProductById(Convert.ToInt32(cmbProductName.SelectedValue)); txtProductCode.Text = tblProduct.ProductCode; txtProductDesc.Text = tblProduct.ProductDesc; txtProductName.Text = tblProduct.ProductName; txtProductPrice.Text = tblProduct.ProductPrice.ToString(); } else { //if zero, then option to add btnAdd.Show(); btnSave.Hide(); //clear the fields txtProductCode.Clear(); txtProductDesc.Clear(); txtProductName.Clear(); txtProductPrice.Clear(); } }
public void DeleteProduct(int productId) { TblProduct lstProductById = GetProductById(productId); lstProductById.IsDeleted = true; dbContext.SaveChanges(); }
public IActionResult Update_Quantity_Cart(IFormCollection form) { Cart cart = null; try { cart = JsonConvert.DeserializeObject <Cart>(HttpContext.Session.GetString("Cart")); } catch { } string id_pro = form["productID"]; int quantity = Int32.Parse(form["quantity"]); TblProduct pro = _context.TblProducts.SingleOrDefault(s => s.ProductId == id_pro); int quantityRemain = pro.Quantity; if (quantityRemain < quantity) { TempData["Message"] = "Out of stock!"; return(RedirectToAction("ShowToCart", "ShoppingCart")); } cart.Update_Quantity_Shopping(id_pro, quantity); HttpContext.Session.SetString("Cart", JsonConvert.SerializeObject(cart)); TempData["Message"] = "Update success!"; return(RedirectToAction("ShowToCart", "ShoppingCart")); }
private void btnAdd_Click(object sender, EventArgs e) { //add new product btnAdd.Hide(); btnSave.Show(); cmbProductName.Hide(); txtProductName.Show(); try { TblProduct tblProduct = new TblProduct(); tblProduct.ProductPrice = Convert.ToDouble(txtProductPrice.Text); tblProduct.ProductDesc = txtProductDesc.Text; tblProduct.ProductName = txtProductName.Text; tblProduct.ProductCode = txtProductCode.Text; tblProduct.ProductQuantity = Convert.ToInt32(txtProductQuantity.Text); tblProduct.IsDeleted = false; if (Convert.ToInt16(cmbProductName.SelectedValue) == 0) { //new _productService.SaveProduct(tblProduct); MessageBox.Show("Product Saved!"); } ClearForm(); } catch (Exception a) { throw a; } }
public IActionResult Product(TblProduct P) { foreach (var file in Request.Form.Files) { string name = file.Name; string ext = System.IO.Path.GetExtension(file.FileName); string filename = DateTime.Now.ToString("ddMMyyyyhhmmss") + ext; P.ProductImage = filename; string path = env.WebRootPath + "/Data/pimg/" + filename; using (FileStream fs = new FileStream(path, FileMode.Create)) { file.CopyTo(fs); } } P.CreatedDate = DateTime.Now.ToString("dd/MM/yyyy/hh/mm/ss"); P.ModifyDate = DateTime.Now.ToString("dd/MM/yyyy/hh/mm/ss"); context.TblProduct.Add(P); context.SaveChanges(); ViewBag.Message = "Your Desired Product Added Successfully"; //return View(); return(RedirectToAction("Product")); }
public async Task <IActionResult> Edit(string id, [Bind("ProductId,ProductName,Price,Description,Quantity,ImgSrc,CategoryId")] TblProduct tblProduct) { if (id != tblProduct.ProductId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(tblProduct); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TblProductExists(tblProduct.ProductId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["CategoryId"] = new SelectList(_context.TblCategories, "CategoryId", "CategoryId", tblProduct.CategoryId); return(View(tblProduct)); }
public short Update(ProductModel entity) { TblProduct obj = _mapper.Map <ProductModel, TblProduct>(entity); _repository.Update(obj); return(obj.ProductId); }
public IActionResult Ratings(int productId) { if (HttpContext.Session.GetString("UserID") == null) { return(RedirectToAction("Login", "Register")); } else if (HttpContext.Session.GetString("UserID") == "Admin") { return(RedirectToAction("Category", "Admin")); } TblProduct tbl = _context.TblProduct.Where(i => i.ProductId == productId).First(); ViewBag.name = tbl.ProductName; ViewBag.image = tbl.ProductImage; ViewBag.users = getMembers(); TempData["id"] = productId; List <TblCustomerRatings> x; if (_context.TblCustomerRatings.Where(i => i.ProductId == productId) != null) { x = _context.TblCustomerRatings.Where(i => i.ProductId == productId).ToList(); } else { x = null; } ViewBag.Comments = x; return(View()); }
public ActionResult SetDetail() { int id = Request.Form["ModelId"].ParseInt(); TblProduct ob = uow.Modules.Product.Get(id); if (ob.ProductId <= 0) { ob.CategoryId = Request.Form["CategoryId"].ParseInt(); ob.Category = uow.Modules.ProductCategory.Get(ob.CategoryId); ob.CreatedBy = CurrentUID; ob.CreatedDate = CurrentDate; } int modelId = Request.Form["ModelId"].ParseInt(); if (modelId <= 0) { ob.ModelId = null; ob.Model = null; } else { ob.ModelId = modelId; ob.Model = uow.Modules.ProductModel.Get(modelId); } ob.ProductCode = Request.Form["ProductCode"]; ob.ProductName = Request.Form["ProductName"]; ob.ProductNameBilling = Request.Form["ProductNameBilling"]; ob.ProductNameTrade = Request.Form["ProductNameTrade"]; ob.UnitId = Request.Form["UnitId"].ParseInt(); ob.PriceNet = Request.Form["PriceNet"].ParseDecimal(); ob.PriceVat = Request.Form["PriceVat"].ParseDecimal(); ob.PriceTot = ob.PriceNet + ob.PriceVat; ob.CostNet = 0; ob.CostVat = 0; ob.CostTot = 0; ob.QtyStock = Request.Form["QtyStock"].ParseInt(); ob.FlagVat = true; ob.FlagActive = Request.Form["FlagDeactive"].ParseBoolean() ? false : true; ob.UpdatedBy = CurrentUID; ob.UpdatedDate = CurrentDate; try { //Validate model b4 save uow.Modules.Product.Set(ob); uow.SaveChanges(); return(RedirectToAction("Index", new { controller = MVCController, msg = "บันทึกข้อมูลเรียบร้อยแล้ว", msgType = AlertMsgType.Success })); } catch (Exception ex) { string msg = ex.GetMessage(true); return(ViewDetail(ob, msg, AlertMsgType.Danger)); } }
private void fillproducts(string pCode) { this.entidades = new marketsaveusEntities(); TblProduct products = this.entidades.TblProduct.FirstOrDefault(e => e.code == pCode); if (products != null) { this.txtCode.Text = products.code; this.txtDescripcion.Text = products.productDescription; this.txtInventory.Text = products.stock.ToString(); this.txtname.Text = products.productName; this.txtprize.Text = products.prize.ToString(); this.txtImage.Visible = false; this.lblImage.Visible = false; this.btnRegister.Visible = false; this.btnDelete.Visible = true; this.btnConsult.Visible = true; this.btnUpdate.Visible = true; this.txtCode.Enabled = false; } }
public async Task <IActionResult> Create([Bind("Id,Name,ImageFile,taste,price")] TblProduct tblProduct) { if (ModelState.IsValid) { //Save image to wwwroot/image string wwwRootPath = _hostEnvironment.WebRootPath; string fileName = Path.GetFileNameWithoutExtension(tblProduct.ImageFile.FileName); string extension = Path.GetExtension(tblProduct.ImageFile.FileName); tblProduct.ImageName = fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension; string path = Path.Combine(wwwRootPath + "/Image/", fileName); using (var fileStream = new FileStream(path, FileMode.Create)) { await tblProduct.ImageFile.CopyToAsync(fileStream); } if (_context.TblProduct.Any(ac => ac.Name.Equals(tblProduct.Name))) { ModelState.AddModelError("Name", "Name already exists."); } else { _context.Add(tblProduct); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } } return(View(tblProduct)); }
public TblProduct Update(TblProduct product) { try { using Repository <TblProduct> repo = new Repository <TblProduct>(); var _supplier = GetSupplierGroupList().Where(x => x.SupplierGroupName == product.SupplierName).ToArray().FirstOrDefault(); var _product = GetProductGroupList().Where(x => x.GroupCode == product.ProductGroupCode).ToArray().FirstOrDefault(); var _productpacking = GetProductPackingList().Where(x => x.PackingCode == product.PackingCode).ToArray().FirstOrDefault(); var _taxgroup = GetTaxGroup().Where(x => x.TaxGroupCode == product.TaxGroupCode).ToArray().FirstOrDefault(); var _unit = GetUnitList().Where(x => x.UnitId == product.UnitId).FirstOrDefault(); var _taxstructure = GetTaxStructure().Where(x => x.TaxStructureCode == product.TaxStructureCode).ToArray().FirstOrDefault(); var _taxapplicable = GetTaxApplicableList().Where(x => x.Id == product.TaxapplicableOnId).ToArray().FirstOrDefault(); product.PackingId = _productpacking.PackingId; product.PackingName = _productpacking.PackingName; product.ProductGroupId = _product.GroupId; product.ProductGroupName = _product.GroupName; product.TaxGroupId = _taxgroup.TaxGroupId; product.TaxGroupName = _taxgroup.TaxGroupName; product.UnitName = _unit.UnitName; product.TaxapplicableOn = _taxapplicable.Name; product.SupplierId = _supplier.SupplierGroupId; product.SupplierCode = Convert.ToInt64(_supplier.SupplierGroupCode); product.TaxStructureId = _taxstructure.TaxStructureId; repo.TblProduct.Update(product); if (repo.SaveChanges() > 0) { return(product); } return(null); } catch { throw; } }
public void UpdateProduct(TblProduct updatedProduct) { TblProduct product = GetProductById(updatedProduct.ProductKey); dbContext.Entry(product).CurrentValues.SetValues(updatedProduct); dbContext.SaveChanges(); }
public async Task <ApiResponse> ProductById(TblProduct objproduct) { var categoryList = await _context.TblCategoryMaster.ToListAsync(); var varientname = categoryList.Where(i => i.Type == "Variant").Select(i => i.CategoryType).FirstOrDefault(); var productList = await _context.TblProduct.ToListAsync(); var colorlist = await _context.TblColor.ToListAsync(); var items = (from pl in productList select new { prodictid = pl.Id, productType = pl.ProductType, typeid = pl.Typeid, modelid = pl.ModelId, makerid = pl.MakerId, variantid = pl.VariantId, makername = categoryList.Where(i => i.Id == pl.MakerId).Select(i => i.CategoryType).FirstOrDefault() != null ? "N/A" : categoryList.Where(i => i.Id == pl.MakerId).Select(i => i.CategoryType).FirstOrDefault(), modelname = categoryList.Where(i => i.Id == pl.ModelId && i.Type == "ModelMaster").Select(i => i.CategoryType).FirstOrDefault() != null ? "N/A" : categoryList.Where(i => i.Id == pl.ModelId && i.Type == "ModelMaster").Select(i => i.CategoryType).FirstOrDefault(), type = categoryList.Where(i => i.Id == pl.Typeid && i.Type == "TypeMaster").Select(i => i.CategoryType).FirstOrDefault() != null ? "N/A" : categoryList.Where(i => i.Id == pl.Typeid && i.Type == "TypeMaster").Select(i => i.CategoryType).FirstOrDefault(), variant = categoryList.Where(i => i.Id == pl.VariantId && i.Type == "Variant").Select(i => i.CategoryType).FirstOrDefault() != null ? "N/A" : categoryList.Where(i => i.Id == pl.VariantId && i.Type == "Variant").Select(i => i.CategoryType).FirstOrDefault(), noofsheats = pl.NoOfSeats, noofdoor = pl.NoOfDoors, fuel = pl.Fuel, drive = pl.Drive, chassisType = pl.ChassisType, engine_cc = pl.EngineCc }).Where(i => i.prodictid == objproduct.Id).OrderBy(i => i.makername).ToList(); var ApiResponse = await response.ApiResult("OK", items, "Product Found"); return(ApiResponse); }
public async Task <ActionResult <TblProduct> > PostTblProduct(TblProduct tblProduct) { _context.TblProduct.Add(tblProduct); await _context.SaveChangesAsync(); return(CreatedAtAction("GetTblProduct", new { id = tblProduct.Id }, tblProduct)); }
public async Task <IActionResult> PutTblProduct(long id, TblProduct tblProduct) { if (id != tblProduct.Id) { return(BadRequest()); } _context.Entry(tblProduct).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TblProductExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public void Index() { ProductInput model = new ProductInput(); model.lstProduct = TblProduct.GetAllProduct(); //Checks for count of records Assert.AreNotEqual(model.lstProduct.Count, 0); }
protected void btnSubmit_Click(object sender, EventArgs e) { TblProduct obj = new TblProduct(); obj.IsNew = true; obj.Product = txtProduct.Text; obj.Save(); }
public bool ChangeStatus(short id) { TblProduct obj = _repository.GetById(id); obj.IsActive = !obj.IsActive; _repository.Update(obj); return(true); }
public ActionResult DeleteConfirmed(int id) { TblProduct tblProduct = db.TblProduct.Find(id); db.TblProduct.Remove(tblProduct); db.SaveChanges(); return(RedirectToAction("Index")); }
public async Task <IActionResult> Edit(int id, [Bind("Id,IdCtgPhone,Name,Cost,Quantity,Image,Description,Configuration,Rating,UpdatedDate,UserCreatedId")] TblProduct tblProduct , List <IFormFile> postedFiles) { //Save file string wwwPath = this.Environment.WebRootPath; string contentPath = this.Environment.ContentRootPath; string path = Path.Combine(this.Environment.WebRootPath, "images"); if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } List <string> uploadedFiles = new List <string>(); foreach (IFormFile postedFile in postedFiles) { var date = DateTime.Now.Ticks.ToString() + "_"; string fileName = date + "_" + Path.GetFileName(postedFile.FileName); using (FileStream stream = new FileStream(Path.Combine(path, fileName), FileMode.Create)) { postedFile.CopyTo(stream); uploadedFiles.Add(fileName); } tblProduct.Image = fileName; } //End save file if (id != tblProduct.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(tblProduct); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TblProductExists(tblProduct.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["IdCtgPhone"] = new SelectList(_context.TblCategory, "Id", "Id", tblProduct.IdCtgPhone); ViewData["UserCreatedId"] = new SelectList(_context.TblUser, "Id", "Id", tblProduct.UserCreatedId); return(View(tblProduct)); }
public ActionResult Edit(TblProduct tblProduct) { try { ViewBag.ProductCategoryId = new SelectList(db.TblProductCategories.Where(e => e.IsDelete == false).Select(e => new { e.ProductCategoryId, e.CategoryName }), "ProductCategoryId", "CategoryName", tblProduct.ProductCategoryId); ViewBag.SupplierId = new SelectList(db.TblSuppliers.Where(e => e.IsDelete == false && e.IsActive == true).Select(e => new { e.SupplierId, e.SupplierName }), "SupplierId", "SupplierName", tblProduct.SupplierId); tblProduct.ModifiedBy = Convert.ToInt32(BaseUtil.GetSessionValue(AdminInfo.LoginID.ToString())); tblProduct.ModifiedDate = DateTime.Now; tblProduct.ProductName = tblProduct.productTitle; if (tblProduct.srNumber == 0) { tblProduct.srNumber = 1000; } if (ModelState.IsValid) { db.Entry(tblProduct).State = EntityState.Modified; db.SaveChanges(); var AlreadyselectedAttributes = db.TblProductAttributes.Where(e => e.ProductID == tblProduct.ProductID).ToList(); db.TblProductAttributes.RemoveRange(AlreadyselectedAttributes); db.SaveChanges(); List <TblProductAttribute> LsttblProductAttributes = new List <TblProductAttribute>(); TblProductAttribute tblProductAttribute; if (tblProduct.Attributes != null && tblProduct.Attributes != "") { var arr = tblProduct.Attributes.Split('$'); for (var i = 0; i < arr.Length - 1; i++) { var att = arr[i].Split('!'); if (att[1] != "") { var dd = att[1].Split(',').ToArray(); for (var k = 0; k < dd.Length - 1; k++) { tblProductAttribute = new TblProductAttribute(); tblProductAttribute.AttributeId = Convert.ToInt16(att[0]); tblProductAttribute.MeasurementUnits = dd[k]; tblProductAttribute.ProductID = tblProduct.ProductID; tblProductAttribute.CreatedDate = DateTime.Now; LsttblProductAttributes.Add(tblProductAttribute); } } } } db.TblProductAttributes.AddRange(LsttblProductAttributes); db.SaveChanges(); TempData["msg"] = "2"; return(RedirectToAction("Index", new { id = tblProduct.StoreId })); } } catch (Exception e) { TempData["msg"] = "0"; } return(View(tblProduct)); }
public ActionResult AddNewProduct(TblProduct newProduct) { var category = DbStockEntities.TblCategory.Where(c => c.CategoryId == newProduct.TblCategory.CategoryId).FirstOrDefault(); newProduct.TblCategory = category; DbStockEntities.TblProduct.Add(newProduct); DbStockEntities.SaveChanges(); return(RedirectToAction("Index")); }
public async Task <ApiResponse> addProduct(TblProduct tblProduct) { _context.TblProduct.Add(tblProduct); await _context.SaveChangesAsync(); var ApiResponse = await response.ApiResult("OK", new { id = tblProduct.Id }, "Add Product Successfull"); return(ApiResponse); }
public TblProduct GetProductById(int productKey) { TblProduct lstProductById = (from p in dbContext.TblProduct where p.IsDeleted == false && p.ProductKey == productKey select p).FirstOrDefault(); return(lstProductById); }
public ActionResult Edit([Bind(Include = "ProductID,ProductCode,ProductName,ProductShortName,ProductNote,CategoryID")] TblProduct tblProduct) { if (ModelState.IsValid) { db.Entry(tblProduct).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tblProduct)); }
public ActionResult DeleteProduct(int productId) { if (ModelState.IsValid) { TblProduct tbl = (TblProduct)_context.TblProduct.Where(i => i.ProductId == productId); _context.TblProduct.Remove(tbl); _context.SaveChanges(); } return(RedirectToAction("Product")); }
public ActionResult Create([Bind(Include = "ProductID,ProductCode,ProductName,ProductShortName,ProductNote,CategoryID")] TblProduct tblProduct) { if (ModelState.IsValid) { db.TblProduct.Add(tblProduct); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tblProduct)); }
public async Task <IActionResult> Index(TblProduct tblProduct) { if (ModelState.IsValid) { dop.Add(tblProduct); await dop.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(tblProduct)); }
public async Task <IActionResult> Create([Bind("ProductId,ProductName,CategoryId,IsActive,IsDelete,CreatedDate,ModifiedDate,Description,ProductImage,IsFeatured,Quantity,Price")] TblProduct tblProduct) { if (ModelState.IsValid) { _context.Add(tblProduct); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["CategoryId"] = new SelectList(_context.TblCategories, "CategoryId", "CategoryId", tblProduct.CategoryId); return(View(tblProduct)); }