public ActionResult GetStoreProductForDatatable(Guid?batchId)
{
// Guid guidBatchId = Guid.Parse(batchId);
var storeProducts = _dbContext.StoreProducts.Where(s => s.BatchId == batchId).ToList();
List <StoreProductsViewModel> storeProductsViewModelList = new List <StoreProductsViewModel>();
foreach (var storeProduct in storeProducts)
{
StoreProductsViewModel storeProductViewModel = new StoreProductsViewModel();
storeProductViewModel.Id = storeProduct.Id;
storeProductViewModel.ProductEnterDate = storeProduct.ProductEnterDate;
storeProductViewModel.MRPPerUnit = storeProduct.MRPPerUnit;
storeProductViewModel.ProductName = storeProduct.Product.Name;
storeProductViewModel.Quantity = storeProduct.Quantity;
storeProductsViewModelList.Add(storeProductViewModel);
}
var result = new
{
iTotalRecords = storeProducts.Count,
iTotalDisplayRecords = storeProducts.Count,
aaData = storeProductsViewModelList
};
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult _Edit(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
StoreProduct storeProduct = _dbContext.StoreProducts.Find(id);
StoreProductsViewModel viewModel = new StoreProductsViewModel();
viewModel.Id = storeProduct.Id;
viewModel.BatchId = storeProduct.BatchId;
viewModel.BatchNumber = storeProduct.BatchNumber;
viewModel.CostPricePerUnit = storeProduct.CostPricePerUnit;
viewModel.Quantity = storeProduct.Quantity;
viewModel.MRPPerUnit = storeProduct.MRPPerUnit;
viewModel.ProductEnterDate = storeProduct.ProductEnterDate;
viewModel.ProductName = storeProduct.Product.Name;
viewModel.Code = storeProduct.Product.Code;
if (storeProduct == null)
{
return(HttpNotFound());
}
string modelString = RenderRazorViewToString("_Edit", viewModel);
//ViewBag.BatchId = new SelectList(_dbContext.Batch, "Id", "Name", storeProduct.BatchId);
return(Json(new { ModelString = modelString }, JsonRequestBehavior.AllowGet));
}
public JsonResult GetStoreProductsForAutocomplete(string term, Guid batchId)
{
Product[] productsMatching = String.IsNullOrWhiteSpace(term) ? null
: _dbContext.Products.Where(ii => ii.Code.Contains(term) || ii.Name.Contains(term)).ToArray();
List <StoreProductsViewModel> storeProductsViewModelList = new List <StoreProductsViewModel>();
foreach (var storeProducts in productsMatching.ToList())
{
foreach (var storeProduct in storeProducts.StoreProducts.Where(b => b.BatchId == batchId))
{
StoreProductsViewModel storeProductsViewModel = new StoreProductsViewModel();
storeProductsViewModel.Id = storeProduct.Id;
storeProductsViewModel.Code = storeProducts.Code;
storeProductsViewModel.AutoGenerateName = storeProducts.AutoGenerateName;
storeProductsViewModel.MRPPerUnit = storeProduct.Product.SalePrice;
storeProductsViewModelList.Add(storeProductsViewModel);
}
}
return(Json(storeProductsViewModelList.Select(m => new
{
Id = m.Id,
value = m.ProductName,
label = String.Format("{0}: {1}: {2}", m.AutoGenerateName, m.Code, m.MRPPerUnit),
MRPPerUnit = m.MRPPerUnit,
Name = m.ProductName,
Code = m.Code,
AutoGenerateName = m.AutoGenerateName,
ModelNumber = m.ModelNumber
}), JsonRequestBehavior.AllowGet));
}
public ActionResult Edit(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
StoreProduct storeProduct = _dbContext.StoreProducts.Find(id);
StoreProductsViewModel viewModel = new StoreProductsViewModel();
viewModel.Id = storeProduct.Id;
viewModel.BatchId = storeProduct.BatchId;
viewModel.StoreId = storeProduct.Batch.StoreId;
viewModel.BatchNumber = storeProduct.BatchNumber;
viewModel.CostPricePerUnit = storeProduct.CostPricePerUnit;
viewModel.Quantity = storeProduct.Quantity;
viewModel.MRPPerUnit = storeProduct.MRPPerUnit;
viewModel.ProductEnterDate = storeProduct.ProductEnterDate;
viewModel.ProductId = storeProduct.Product.Id;
viewModel.ProductName = storeProduct.Product.Name;
viewModel.Code = storeProduct.Product.Code;
// viewModel.SalePrice = storeProduct.SalePrice;
if (storeProduct == null)
{
return(HttpNotFound());
}
ViewBag.Batches = new SelectList(_dbContext.Batch, "Id", "Name", storeProduct.BatchId);
ViewBag.Stores = new SelectList(_dbContext.Stores, "Id", "Name", storeProduct.Batch.StoreId);
return(View(viewModel));
}
public ActionResult GetBatchesForDatatable()
{
var batches = _dbContext.Batch.ToList();
List <BatchViewModel> batchViewModelList = new List <BatchViewModel>();
foreach (var batch in batches)
{
BatchViewModel batchViewModel = new BatchViewModel();
batchViewModel.Id = batch.Id;
batchViewModel.Name = batch.Name;
batchViewModel.EnteredDate = batch.EnteredDate;
batchViewModelList.Add(batchViewModel);
List <StoreProductsViewModel> storeProductsViewModelList = new List <StoreProductsViewModel>();
foreach (var storeProduct in batch.StoreProducts)
{
StoreProductsViewModel storeProductsViewModel = new StoreProductsViewModel();
storeProductsViewModel.Id = storeProduct.Id;
storeProductsViewModel.ProductName = storeProduct.Product.Name;
storeProductsViewModel.Quantity = storeProduct.Quantity;
storeProductsViewModelList.Add(storeProductsViewModel);
}
batchViewModel.StoreProductsViewModel = storeProductsViewModelList;
}
// var jsonObject = JsonConvert.SerializeObject(ProductViewModelList);
// return View();
var result = new
{
iTotalRecords = batches.Count,
iTotalDisplayRecords = batches.Count,
aaData = batchViewModelList
};
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult IndexFullHeight()
{
StoreIndexViewModel storeIndexViewModel = new StoreIndexViewModel();
List <StoreViewModel> storeViewModelLst = new List <StoreViewModel>();
var stores = db.Stores.ToList();
var products = db.Products.ToList();
foreach (var store in stores)
{
StoreViewModel storeViewModel = new StoreViewModel();
storeViewModel.Id = store.Id;
storeViewModel.Name = store.Name;
storeViewModelLst.Add(storeViewModel);
List <BatchViewModel> batchesViewModelLst = new List <BatchViewModel>();
foreach (var batch in store.Batches)
{
BatchViewModel batchViewModel = new BatchViewModel();
batchViewModel.Id = batch.Id;
batchViewModel.StoreId = batch.StoreId;
batchViewModel.Name = batch.Name;
batchViewModel.EnteredDate = batch.EnteredDate;
batchesViewModelLst.Add(batchViewModel);
List <StoreProductsViewModel> storeProductsViewModelLst = new List <StoreProductsViewModel>();
if (batch.StoreProducts.Count != 0)
{
foreach (var storeProduct in batch.StoreProducts)
{
StoreProductsViewModel storeProductsViewModel = new StoreProductsViewModel();
storeProductsViewModel.Id = storeProduct.Id;
storeProductsViewModel.BatchId = storeProduct.BatchId;
storeProductsViewModel.ProductId = storeProduct.ProductId;
storeProductsViewModel.ProductEnterDate = storeProduct.ProductEnterDate;
Product product = products.Where(p => p.Id == storeProduct.ProductId).FirstOrDefault();
storeProductsViewModel.ProductName = product.Name;
storeProductsViewModel.AutoGenerateName = product.AutoGenerateName;
storeProductsViewModel.Code = product.Code;
storeProductsViewModel.ModelNumber = product.ModelNumber;
storeProductsViewModel.MRPPerUnit = storeProduct.MRPPerUnit;
storeProductsViewModel.CostPricePerUnit = storeProduct.CostPricePerUnit;
storeProductsViewModel.DiscountRatePerUnit = storeProduct.DiscountRatePerUnit;
storeProductsViewModel.Quantity = storeProduct.Quantity;
storeProductsViewModelLst.Add(storeProductsViewModel);
//batchViewModel.StoreProductsViewModel.Add(storeProductsViewModel);
}
}
batchViewModel.StoreProductsViewModel = storeProductsViewModelLst;
}
storeViewModel.BatchesViewModel = batchesViewModelLst;
}
storeIndexViewModel.StoreViewModel = storeViewModelLst;
return(View(storeIndexViewModel));
}
public ActionResult Edit(StoreProductsViewModel viewModel)
{
if (ModelState.IsValid)
{
StoreProduct storeProduct = _dbContext.StoreProducts.Find(viewModel.Id);
storeProduct.ProductId = viewModel.ProductId;
storeProduct.BatchId = viewModel.BatchId;
storeProduct.CostPricePerUnit = viewModel.CostPricePerUnit;
storeProduct.MRPPerUnit = storeProduct.MRPPerUnit;
storeProduct.Quantity = viewModel.Quantity;
_dbContext.Entry(storeProduct).State = EntityState.Modified;
_dbContext.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BatchId = new SelectList(_dbContext.Batch, "Id", "Name", viewModel.BatchId);
ViewBag.Stores = new SelectList(_dbContext.Stores, "Id", "Name", viewModel.StoreId);
return(View(viewModel));
}
public ActionResult Create(StoreProductsViewModel viewModel)
{
if (ModelState.IsValid)
{
StoreProduct storeProduct = new StoreProduct();
storeProduct.Id = Guid.NewGuid();
storeProduct.BatchId = viewModel.BatchId;
storeProduct.CostPricePerUnit = viewModel.CostPricePerUnit;
storeProduct.Quantity = viewModel.Quantity;
storeProduct.CostPricePerUnit = viewModel.CostPricePerUnit;
storeProduct.MRPPerUnit = viewModel.MRPPerUnit;
storeProduct.ProductEnterDate = viewModel.ProductEnterDate;
storeProduct.ProductId = viewModel.ProductId;
// storeProduct.SalePrice = viewModel.SalePrice;
_dbContext.StoreProducts.Add(storeProduct);
_dbContext.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Batches = new SelectList(_dbContext.Batch, "Id", "Name");
ViewBag.Stores = new SelectList(_dbContext.Stores, "Id", "Name");
return(View(viewModel));
}
public ActionResult Index()
{
ViewBag.Batches = new SelectList(_dbContext.Batch, "Id", "Name");
ViewBag.Stores = new SelectList(_dbContext.Stores, "Id", "Name");
ViewBag.Contacts = new SelectList(_dbContext.Contacts, "Id", "FullName");
var storeProducts = _dbContext.StoreProducts.OrderBy(d => d.CreatedDate).ToList();
List <StoreProductsViewModel> storeProductsViewModelList = new List <StoreProductsViewModel>();
IEnumerable <StoreProductsViewModel> storeProductsViewModelEnu;
foreach (var storeProduct in storeProducts)
{
StoreProductsViewModel viewModel = new StoreProductsViewModel();
viewModel.Id = storeProduct.Id;
viewModel.ProductName = storeProduct.Product.Name;
viewModel.ProductEnterDate = storeProduct.ProductEnterDate;
viewModel.Quantity = storeProduct.Quantity;
viewModel.BatchNumber = storeProduct.Batch.Name;
viewModel.AutoGenerateName = storeProduct.Product.AutoGenerateName;
storeProductsViewModelList.Add(viewModel);
}
storeProductsViewModelEnu = storeProductsViewModelList;
return(View(storeProductsViewModelEnu));
}
