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