public ActionResult SetItemLocation(ItemLocationModel itemLocationModel)
{
var Item = db.ItemMaster.Where(p => p.Id == itemLocationModel.ItemId).FirstOrDefault();
Item.RackName = itemLocationModel.RackName;
Item.CellInRack = itemLocationModel.CellInRack;
db.Entry(Item).State = EntityState.Modified;
db.SaveChanges();
var items = db.ItemMaster.Where(p => p.StoreName == "MS").ToList();
return(PartialView("~/Areas/PharmacyModule/Views/PharmacyMaster/_SetItemLocation.cshtml", items));
}
public static async Task <List <ItemLocationModel> > GetItemLocations(this PrimaryDbContext db, SecondaryDbContext sdb)
{
var items = await sdb.GetItems();
var model = new List <ItemLocationModel>();
foreach (var i in items)
{
var il = new ItemLocationModel
{
Item = i,
Locations = await db.GetLocations(sdb, i.Id)
};
model.Add(il);
}
return(model);
}