public bool AddNewProduct(Tbl_Products product) { try { //check if user already exists var res = from t in _context.Tbl_Products where t.Products_ID == product.Products_ID select t; if (res.Count() == 0) { _context.Tbl_Products.Add(product); _context.SaveChanges(); return(true); } else { Tbl_Products prod = _context.Tbl_Products.First(x => x.Products_ID == product.Products_ID); prod.ProductsName = product.ProductsName; prod.Description = product.Description; prod.LastUpdateUser_ID = product.LastUpdateUser_ID; prod.LastUpdateDate = product.LastUpdateDate; prod.LastUpdateTime = product.LastUpdateTime; _context.SaveChanges(); return(true); } } catch (Exception ex) { //_logRepository.Insert(new Log() { Type = LogType.Error, Priority = LogPriority.High, Description = ex.Message, PageUrl = "AddNewGroup", CreatedOn = DateTime.Now.ToString("yyyy-MM-dd HH:mm"), UpdatedOn = DateTime.Now.ToString("yyyy-MM-dd HH:mm") }); return(false); } }
public async Task <Tbl_Products> AddProductAsync(Tbl_Products tbl_Products) { await _context.Tbl_Products.AddAsync(tbl_Products); await _context.SaveChangesAsync(); return(tbl_Products); }
public ActionResult SubmitProduct(ProductListModel model) { HttpSessionStateBase session = HttpContext.Session; try { Tbl_Products tg = new Tbl_Products(); tg.ProductsName = model.ProductName; tg.Description = model.Description; tg.Products_ID = model.Product_ID; tg.LastUpdateUser_ID = Convert.ToInt32(session["UserID"]); tg.LastUpdateDate = DateTime.Now.ToString("yyyy-MM-dd"); tg.LastUpdateTime = DateTime.Now.ToString("HH:mm"); if (_productService.AddNewProduct(tg)) { var gridModel = new DataSourceResult { ExtraData = new ProductListModel { Message = Message.OperationSuccessful, MessageColor = "green" }, Total = 1 }; return(Json(gridModel)); } else { var gridModel = new DataSourceResult { ExtraData = new ProductListModel { Message = Message.OperationUnsuccessful, MessageColor = "red" }, Total = 1 }; return(Json(gridModel)); } } catch (Exception ex) { var gridModel = new DataSourceResult { ExtraData = new ProductListModel { Message = Message.OperationUnsuccessful, MessageColor = "red" }, Total = 1 }; return(Json(gridModel)); } }
public async Task <ActionResult <Tbl_Products> > UpdateProducts(int id, Tbl_Products tbl_Products) { if (id != tbl_Products.id) { return(BadRequest()); } if (!_productService.IsProductExisting(id)) { return(NotFound()); } return(await _productService.UpdateProductAsync(id, tbl_Products)); }
public async Task <Tbl_Products> UpdateProductAsync(int id, Tbl_Products tbl_Products) { _context.Update(tbl_Products); try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { throw; } return(tbl_Products); }
public ActionResult ProductAdd(Tbl_Products tbl, HttpPostedFileBase file) { string pic = null; if (file != null) { pic = System.IO.Path.GetFileName(file.FileName); string path = System.IO.Path.Combine(Server.MapPath("~/ProductImage/"), pic); //file is uploaded file.SaveAs(path); } tbl.ProductImage = pic; tbl.CreatedDate = DateTime.Now; _unitOfWork.GetRepositoryInstance <Tbl_Products>().Add(tbl); return(RedirectToAction("Product")); }
public ActionResult ProductEdit(Tbl_Products tbl, HttpPostedFileBase file) { string pic = null; if (file != null) { pic = System.IO.Path.GetFileName(file.FileName); string path = System.IO.Path.Combine(Server.MapPath("~/ProductImage/"), pic); //file is uploaded file.SaveAs(path); } else { //var pId = tbl.ProductId; //var product = _unitOfWork.GetRepositoryInstance<Tbl_Products>().GetFirstOrDefault(pId); pic = tbl.ProductImage; } tbl.ProductImage = pic; tbl.ModifiedDate = DateTime.Now; _unitOfWork.GetRepositoryInstance <Tbl_Products>().Update(tbl); return(RedirectToAction("Product")); }
public async Task <ActionResult <Tbl_Products> > CreateProduct(Tbl_Products tbl_Products) { var result = await _productService.AddProductAsync(tbl_Products); return(CreatedAtAction("GetProducts", new { id = result.id }, result)); }