public ActionResult StockReport(int cat, int type, int stock)
{
EHMSEntities ent = new EHMSEntities();
StockItemMasterModel model = new StockItemMasterModel();
if (cat != 0 && type != 0)
{
model.StockItemMasterList = new List <StockItemMasterModel>(AutoMapper.Mapper.Map <IEnumerable <StockItemMaster>, IEnumerable <StockItemMasterModel> >(ent.StockItemMasters).Where(x => x.Status == true && ent.SetupStockItemEntries.Where(y => y.StockItemEntryId == x.StockItemEntryId).SingleOrDefault().StockCategoryId == cat && ent.SetupStockItemEntries.Where(z => z.StockItemEntryId == x.StockItemEntryId).SingleOrDefault().StockItemTypeId == type));
}
else if (cat != 0)
{
model.StockItemMasterList = new List <StockItemMasterModel>(AutoMapper.Mapper.Map <IEnumerable <StockItemMaster>, IEnumerable <StockItemMasterModel> >(ent.StockItemMasters).Where(x => x.Status == true && ent.SetupStockItemEntries.Where(y => y.StockItemEntryId == x.StockItemEntryId).SingleOrDefault().StockCategoryId == cat));
}
else if (type != 0)
{
model.StockItemMasterList = new List <StockItemMasterModel>(AutoMapper.Mapper.Map <IEnumerable <StockItemMaster>, IEnumerable <StockItemMasterModel> >(ent.StockItemMasters).Where(x => x.Status == true && ent.SetupStockItemEntries.Where(z => z.StockItemEntryId == x.StockItemEntryId).SingleOrDefault().StockItemTypeId == type));
}
else
{
model.StockItemMasterList = new List <StockItemMasterModel>(AutoMapper.Mapper.Map <IEnumerable <StockItemMaster>, IEnumerable <StockItemMasterModel> >(ent.StockItemMasters).Where(x => x.Status == true));
}
Session["report"] = model.StockItemMasterList;
if (stock == 2)
{
Session["report"] = model.StockItemMasterList.Where(x => x.Quantity <= ent.SetupStockItemEntries.Where(y => y.StockItemEntryId == x.StockItemEntryId).SingleOrDefault().MinStockQuantity).ToList();
}
if (stock == 3)
{
Session["report"] = model.StockItemMasterList.Where(x => x.Quantity >= ent.SetupStockItemEntries.Where(y => y.StockItemEntryId == x.StockItemEntryId).SingleOrDefault().MaxStockQuantity).ToList();
}
return(null);
}
public ActionResult StockReport()
{
EHMSEntities ent = new EHMSEntities();
StockItemMasterModel model = new StockItemMasterModel();
model.StockItemMasterList = Session["report"] as List <StockItemMasterModel>;
if (Session["report"] == null)
{
model.StockItemMasterList = new List <StockItemMasterModel>(AutoMapper.Mapper.Map <IEnumerable <StockItemMaster>, IEnumerable <StockItemMasterModel> >(ent.StockItemMasters).Where(x => x.Status == true));
}
Session["report"] = null;
return(View(model.StockItemMasterList));
}
