Exemplo n.º 1
0
        public Prq_PurchaseYearPeriodItemAudit SetToModelObjectAudit(PrqPurchaseYearPeriodItem model)
        {
            Prq_PurchaseYearPeriodItemAudit Entity = new Prq_PurchaseYearPeriodItemAudit();

            Entity.RevisionReason = "I";
            Entity.RevisionNo     = 1;

            Entity.PeriodItemID   = model.PeriodItemID;
            Entity.PeriodID       = model.PeriodID;
            Entity.ItemTypeID     = _context.Sys_ItemType.Where(m => m.ItemTypeName == model.ItemTypeName).FirstOrDefault().ItemTypeID;
            Entity.LeatherType    = 1;
            Entity.LeatherStatus  = _context.Sys_LeatherStatus.Where(m => m.LeatherStatusName == model.LeatherStatusName).FirstOrDefault().LeatherStatusID;
            Entity.SizeID         = _context.Sys_Size.Where(m => m.SizeName == model.SizeName).FirstOrDefault().SizeID;
            Entity.PeriodID       = model.PeriodID;
            Entity.TargetQuantity = model.TargetQuantity;
            Entity.TargetValue    = model.TargetValue;
            Entity.UnitID         = _context.Sys_Unit.Where(m => m.UnitName == model.UnitName).FirstOrDefault().UnitID;
            Entity.CurrencyID     = _context.Sys_Currency.Where(m => m.CurrencyName == model.CurrencyName).FirstOrDefault().CurrencyID;
            Entity.RecordStatus   = "CNF";
            Entity.SetOn          = DateTime.Now;
            Entity.SetBy          = model.SetBy;
            Entity.IPAddress      = string.Empty;

            return(Entity);
        }
Exemplo n.º 2
0
        public ValidationMsg YearlyTargetRevisioned(PrqPurchaseYearTarget model, int userid)
        {
            _vmMsg = new ValidationMsg();
            try
            {
                var originalEntity = _context.Prq_PurchaseYearPeriod.First(m => m.PeriodID == model.PeriodID);
                originalEntity.RecordStatus = "NCF";

                foreach (PrqPurchaseYearPeriodItem objPrqPurchaseYearPeriodItem in model.PurchaseYearPeriodItemList)
                {
                    objPrqPurchaseYearPeriodItem.PeriodID = model.PeriodID;
                    objPrqPurchaseYearPeriodItem.SetBy    = userid;
                    Prq_PurchaseYearPeriodItemAudit tblPrqPurchaseYearPeriodItemAudit = SetToModelObjectAudit(objPrqPurchaseYearPeriodItem);
                    _context.Prq_PurchaseYearPeriodItemAudit.Add(tblPrqPurchaseYearPeriodItemAudit);
                }

                _context.SaveChanges();
                _vmMsg.Type = Enums.MessageType.Success;
                _vmMsg.Msg  = "Revisioned Successfully.";
            }
            catch
            {
                _vmMsg.Type = Enums.MessageType.Error;
                _vmMsg.Msg  = "Failed to Revisioned.";
            }
            return(_vmMsg);
        }