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 RenderEditorRow(int itemId)
        {
            ExcessPartsSetItem epsItem = new ExcessPartsSetItem
            {
                Item = itemRepo.GetById(itemId)
            };

            return PartialView("_EditorRow", epsItem);
        }