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));
}
