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