public ProductRateViewModel ToViewModelProductRate(Mst_ProductRate product, ICollection <Mst_ProductRateDetails> ProductTrnList) { var rateviewmodel = new ProductRateViewModel { Product = product.Pr_Product, ProductRateDate = product.Pr_Date.ToShortDateString(), ID = product.Pr_Id, }; List <ProductRateDetailsVM> ProductTrnViewModelList = new List <ProductRateDetailsVM>(); foreach (var c in ProductTrnList) { var rateTrnViewModel = new ProductRateDetailsVM(); rateTrnViewModel.ID = c.Prd_Id; rateTrnViewModel.Purity = c.Prd_Purity; var puritystr = _context.Mst_PurityMaster.Where(x => x.id == c.Prd_Purity).Select(x => x.PurityName).FirstOrDefault(); rateTrnViewModel.PurityStr = puritystr; rateTrnViewModel.GrossRate = c.Prd_GrossRate; rateTrnViewModel.DeductionsType = c.Prd_Deductions; rateTrnViewModel.DeductionAmount = c.Prd_DeductionsAmount; rateTrnViewModel.NetRate = c.Prd_NetRate; ProductTrnViewModelList.Add(rateTrnViewModel); } rateviewmodel.ProductRateList = ProductTrnViewModelList; return(rateviewmodel); }
public ActionResult GetProductRateTable(string Operation) { Session["Operation"] = Operation; var model = new ProductRateViewModel(); var list = _productrateService.SetDataofModalList(); return(PartialView("_ProductRateList", list)); }
public ActionResult ProductRate() { ButtonVisiblity("Index"); var model = new ProductRateViewModel(); model.ProductRateList = new List <ProductRateDetailsVM>(); ViewBag.PurityList = new SelectList(dd._context.Mst_PurityMaster.ToList(), "Id", "PurityName"); return(View(model)); }
public ActionResult ProductRate() { ButtonVisiblity("Index"); var model = new ProductRateViewModel(); model.ProductRateList = new List <ProductRateDetailsVM>(); ViewBag.PurityList = new SelectList(_productrateService.GetAllPurityMaster(), "Id", "PurityName"); ViewBag.ProductList = new SelectList(_productrateService.GetProductList(), "Id", "Name"); return(View(model)); }
public ProductRateViewModel SetRecordinEdit(int ID) { var productRatevm = new ProductRateViewModel(); var Productrate = _context.Mst_ProductRate.Where(x => x.Pr_Id == ID).FirstOrDefault(); productRatevm.ProductRateDate = Productrate.Pr_Date.ToShortDateString(); var Producttrndatalist = _context.Mst_ProductRateDetails.Where(x => x.Prd_FkId == ID).ToList(); productRatevm = ToViewModelProductRate(Productrate, Producttrndatalist); return(productRatevm); }
public ActionResult GetProductRateById(int ID) { string operation = Session["Operation"].ToString(); ButtonVisiblity(operation); var productRatevm = new ProductRateViewModel(); var Productrate = dd._context.Mst_ProductRate.Where(x => x.Pr_Id == ID).FirstOrDefault(); productRatevm.ProductRateDate = Productrate.Pr_Date.ToShortDateString(); var Producttrndatalist = dd._context.Mst_ProductRateDetails.Where(x => x.Prd_FkId == ID).ToList(); ViewBag.PurityList = new SelectList(dd._context.Mst_PurityMaster.Where(x => x.PurityType == Productrate.Pr_Product).ToList(), "Id", "PurityName"); productRatevm = ToViewModelProductRate(Productrate, Producttrndatalist); return(View("ProductRate", productRatevm)); }
public List <ProductRateViewModel> SetDataofModalList() { List <ProductRateViewModel> list = new List <ProductRateViewModel>(); var model = new ProductRateViewModel(); var tablelist = _context.Mst_ProductRate.ToList(); foreach (var item in tablelist) { model = new ProductRateViewModel(); model.ID = item.Pr_Id; model.ProductRateDate = item.Pr_Date.ToShortDateString(); model.ProductStr = _context.Mst_Product.Where(x => x.Id == item.Pr_Product).Select(x => x.Name).FirstOrDefault(); list.Add(model); } return(list); }
public ActionResult GetProductRateTable(string Operation) { Session["Operation"] = Operation; var model = new ProductRateViewModel(); List <ProductRateViewModel> list = new List <ProductRateViewModel>(); var tablelist = dd._context.Mst_ProductRate.ToList(); foreach (var item in tablelist) { model = new ProductRateViewModel(); model.ID = item.Pr_Id; model.ProductRateDate = item.Pr_Date.ToShortDateString(); model.ProductStr = item.Pr_Product == 1 ? "Gold" : "Diamond"; list.Add(model); } return(PartialView("_ProductRateList", list)); }
public bool InsertData(ProductRateViewModel productratevm) { bool retVal = false; productratevm.CreatedBy = Convert.ToInt32(Session["UserLoginId"]); productratevm.UpdatedBy = Convert.ToInt32(Session["UserLoginId"]); try { _productrateService.SaveRecord(productratevm); retVal = true; } catch (Exception ex) { throw ex; } return(retVal); }
public async Task <IActionResult> RateProductAsync([FromBody] ProductRateViewModel productRateViewModel, CancellationToken cancellationToken) { try { if (string.IsNullOrEmpty(productRateViewModel.ProductId) || productRateViewModel.Rate <= 0) { return(BadRequest()); } // select db var product = await _catalogContext.Products.SingleOrDefaultAsync(x => x.Id != productRateViewModel.ProductId, cancellationToken); if (product != null) { var rates = new ProductRating { ProductId = productRateViewModel.ProductId, Rate = productRateViewModel.Rate, User = productRateViewModel.User }; product.UpdateRate(product.ProductRatings.Count, productRateViewModel.Rate); await _catalogContext.ProductRatings.AddAsync(rates, cancellationToken); _catalogContext.Products.Update(product); await _catalogContext.SaveChangesAsync(cancellationToken); return(CreatedAtAction(nameof(RateProductAsync), product.Name + " Rated.")); } return(NotFound()); } catch (Exception ex) { return(Json("Rate Product Failed: " + ex.Message)); } }
public ActionResult Insert(ProductRateViewModel objViewModel) { ModelState.Remove("Id"); if (objViewModel.ID == 0) { if (InsertData(objViewModel)) { return(Json(1, JsonRequestBehavior.AllowGet)); } else { return(Json(3, JsonRequestBehavior.AllowGet)); } } else { if (InsertData(objViewModel)) { return(Json(2, JsonRequestBehavior.AllowGet)); } } return(View("ProductRate", objViewModel)); }
public void SaveRecord(ProductRateViewModel productratevm) { Mst_ProductRate tblProductRate = new Mst_ProductRate(); Mst_ProductRateDetails tblProductRateDetails = new Mst_ProductRateDetails(); if (productratevm.ID <= 0) { tblProductRate.Pr_Date = Convert.ToDateTime(productratevm.ProductRateDate); tblProductRate.Pr_Product = productratevm.Product; tblProductRate.Pr_RecordCreated = DateTime.Now; tblProductRate.Pr_RecordCreatedBy = productratevm.CreatedBy; tblProductRate.Pr_RecordUpdated = DateTime.Now; tblProductRate.Pr_RecordUpdatedBy = productratevm.UpdatedBy; _context.Mst_ProductRate.Add(tblProductRate); _context.SaveChanges(); int PID = _context.Mst_ProductRate.Max(x => x.Pr_Id); foreach (var p in productratevm.ProductRateList) { var prdrate = new Mst_ProductRateDetails { Prd_FkId = PID, Prd_Purity = p.Purity, Prd_GrossRate = p.GrossRate, Prd_Deductions = p.DeductionsType, Prd_DeductionsAmount = p.DeductionAmount, Prd_NetRate = p.NetRate, Prd_RecordCreatedBy = productratevm.CreatedBy, Prd_RecordCreated = DateTime.Now, Prd_RecordUpdatedBy = productratevm.UpdatedBy, Prd_RecordUpdated = DateTime.Now, }; _context.Mst_ProductRateDetails.Add(prdrate); _context.SaveChanges(); } } else { //update the data in Charge Details table var productObj = _context.Mst_ProductRate.Where(x => x.Pr_Id == productratevm.ID).FirstOrDefault(); //update the data in product rate table productObj.Pr_Date = Convert.ToDateTime(productratevm.ProductRateDate); productObj.Pr_Product = productratevm.Product; productObj.Pr_RecordUpdatedBy = productratevm.UpdatedBy; productObj.Pr_RecordUpdated = DateTime.Now; List <Mst_ProductRateDetails> NewProductRateList = new List <Mst_ProductRateDetails>(); //update the data in Charge Details table foreach (var p in productratevm.ProductRateList) { var FindRateobject = _context.Mst_ProductRateDetails.Where(x => x.Prd_Id == p.ID && x.Prd_FkId == productratevm.ID).FirstOrDefault(); if (FindRateobject == null) { var ratetrnnew = new Mst_ProductRateDetails { Prd_FkId = productratevm.ID, Prd_Purity = p.Purity, Prd_GrossRate = p.GrossRate, Prd_Deductions = p.DeductionsType, Prd_DeductionsAmount = p.DeductionAmount, Prd_NetRate = p.NetRate, Prd_RecordCreated = DateTime.Now, Prd_RecordCreatedBy = productratevm.CreatedBy, Prd_RecordUpdatedBy = productratevm.UpdatedBy, Prd_RecordUpdated = DateTime.Now }; _context.Mst_ProductRateDetails.Add(ratetrnnew); } else { FindRateobject.Prd_Purity = p.Purity; FindRateobject.Prd_GrossRate = p.GrossRate; FindRateobject.Prd_Deductions = p.DeductionsType; FindRateobject.Prd_DeductionsAmount = p.DeductionAmount; FindRateobject.Prd_NetRate = p.NetRate; FindRateobject.Prd_RecordUpdatedBy = productratevm.UpdatedBy; FindRateobject.Prd_RecordUpdated = DateTime.Now; } NewProductRateList.Add(FindRateobject); } #region product rate details remove //take the loop of table and check from list if found in list then not remove else remove from table itself var trnobjlist = _context.Mst_ProductRateDetails.Where(x => x.Prd_FkId == productratevm.ID).ToList(); if (trnobjlist != null) { foreach (Mst_ProductRateDetails item in trnobjlist) { if (NewProductRateList.Contains(item)) { continue; } else { _context.Mst_ProductRateDetails.Remove(item); } } _context.SaveChanges(); } #endregion product trn remove } }
public void SaveRecord(ProductRateViewModel model) { _productRateRepository.SaveRecord(model); }