public void Save(ExcessPartsSetDTO epsDTO)
        {
            ExcessPartsSet eps = new ExcessPartsSet();
            eps.No = epsRepo.GenerateEpsNo();
            eps.Date = DateTime.Now;

            eps.PreparedBy = Common.GetCurrentUser.Id;
            eps.ApprovedBy = Common.GetCurrentUser.GeneralManagerId;
            eps.CheckedBy = epsDTO.CheckedBy;

            context.ExcessPartsSets.Add(eps);
            context.SaveChanges();

            foreach (ExcessPartsSetDTO.Item dtoItem in epsDTO.Items)
            {
                ExcessPartsSetItem epsItem = new ExcessPartsSetItem();

                epsItem.ExcessPartsSetId = eps.Id;
                epsItem.ItemId = dtoItem.ItemId;
                epsItem.UnitCost = dtoItem.UnitCost;
                epsItem.Quantity = dtoItem.Quantity;
                epsItem.Remarks = dtoItem.Remarks;

                context.ExcessPartsSetItems.Add(epsItem);
                context.SaveChanges();

                InsertLogs(epsItem.ItemId, epsItem.Quantity);
            }
        }
        public ActionResult Create()
        {
            ViewBag.Items = new SelectList(context.Items, "Id", "Description");
            ViewBag.User = Common.GetCurrentUser.FullName;
            ViewBag.GeneralManager = Common.GetCurrentUser.GeneralManager.FullName;

            ExcessPartsSet eps = new ExcessPartsSet
            {
                No = epsRepo.GenerateEpsNo(),
                Date = DateTime.Now
            };

            return View(eps);
        }
        public ActionResult Details(int id)
        {
            ExcessPartsSet eps = epsRepo.GetById(id);

            return View(eps);
        }