Beispiel #1
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);
        }
Beispiel #2
0
        public PrqPurchaseYearTarget SetToBussinessObject(Prq_PurchaseYearTarget Entity)
        {
            PrqPurchaseYearTarget Model = new PrqPurchaseYearTarget();

            Model.YearID        = Entity.YearID;
            Model.PurchaseYear  = Entity.PurchaseYear;
            Model.YearStartDate = Entity.YearStartDate.Date.ToString("dd/MM/yyyy");
            Model.YearEndDate   = Entity.YearEndDate.Date.ToString("dd/MM/yyyy");
            Model.RecordStatus  = Entity.RecordStatus;

            return(Model);
        }
Beispiel #3
0
        public Prq_PurchaseYearTarget SetToModelObject(PrqPurchaseYearTarget model)
        {
            Prq_PurchaseYearTarget Entity = new Prq_PurchaseYearTarget();

            Entity.YearStartDate = DalCommon.SetDate(model.YearStartDate); // Convert.ToDateTime(Convert.ToDateTime(model.YearStartDate).ToString("dd/MM/yyyy"));
            Entity.YearEndDate   = DalCommon.SetDate(model.YearEndDate);   //Convert.ToDateTime(Convert.ToDateTime(model.YearEndDate).ToString("dd/MM/yyyy"));
            Entity.PurchaseYear  = model.PurchaseYear;
            Entity.SetOn         = DateTime.Now;
            Entity.SetBy         = model.SetBy;
            Entity.IPAddress     = string.Empty;

            return(Entity);
        }
        public ActionResult GetPeriodList(string yearId)
        {
            PrqPurchaseYearTarget model = new PrqPurchaseYearTarget();
            int yearid   = string.IsNullOrEmpty(yearId) ? 0 : Convert.ToInt32(yearId);
            var yearData = Dalobject.GetYearData(yearid);

            if (yearData != null)
            {
                model.PurchaseYearPeriodList = Dalobject.GetPeriodList(yearid);
                model.YearEndDate            = yearData.FirstOrDefault().YearEndDate;
                model.YearStartDate          = yearData.FirstOrDefault().YearStartDate;
                //model.YearStartDate = model.PurchaseYearPeriodList.Count > 0 ? model.PurchaseYearPeriodList[0].EndDate : yearData.FirstOrDefault().YearStartDate;
                model.PeriodID = model.PurchaseYearPeriodList.Count == 1 ? model.PurchaseYearPeriodList[0].PeriodID : 0;
            }


            return(Json(model, JsonRequestBehavior.AllowGet));
        }
Beispiel #5
0
        public ValidationMsg YearlyTargetConfirmed(PrqPurchaseYearTarget model, int userid)
        {
            _vmMsg = new ValidationMsg();
            try
            {
                using (var tx = new TransactionScope())
                {
                    using (_context)
                    {
                        var originalEntityYear = _context.Prq_PurchaseYearTarget.First(m => m.YearID == model.YearID);
                        originalEntityYear.RecordStatus = "CNF";

                        var originalEntity = _context.Prq_PurchaseYearPeriod.First(m => m.PeriodID == model.PeriodID);
                        originalEntity.RecordStatus = "CNF";

                        if (model.PurchaseYearPeriodItemList != null)
                        {
                            foreach (PrqPurchaseYearPeriodItem objPrqPurchaseYearPeriodItem in model.PurchaseYearPeriodItemList)
                            {
                                var originalEntityItem = _context.Prq_PurchaseYearPeriodItem.First(m => m.PeriodItemID == objPrqPurchaseYearPeriodItem.PeriodItemID);
                                originalEntityItem.RecordStatus = "CNF";
                            }
                        }

                        _context.SaveChanges();

                        tx.Complete();
                        _vmMsg.Type = Enums.MessageType.Success;
                        _vmMsg.Msg  = "Confirmed Successfully.";
                    }
                }
            }
            catch
            {
                _vmMsg.Type = Enums.MessageType.Error;
                _vmMsg.Msg  = "Failed to Confirmed.";
            }
            return(_vmMsg);
        }
 public ActionResult YearlyTargetRevisioned(PrqPurchaseYearTarget model)
 {
     _vmMsg = Dalobject.YearlyTargetRevisioned(model, Convert.ToInt32(Session["UserID"]));
     return(Json(new { msg = _vmMsg }));
 }
 public ActionResult PrqPurchaseYearPeriodItemv(PrqPurchaseYearTarget model)
 {
     _vmMsg = model.YearID == 0 ? Dalobject.Save(model, Convert.ToInt32(Session["UserID"])) : Dalobject.Update(model, Convert.ToInt32(Session["UserID"]));
     return(Json(new { YearID = Dalobject.GetYearID(), msg = _vmMsg }));
 }
Beispiel #8
0
        public ValidationMsg Save(PrqPurchaseYearTarget model, int userid)
        {
            _vmMsg = new ValidationMsg();
            try
            {
                IList <string> periodlist = new List <string>();
                periodlist.Add(model.YearStartDate);
                foreach (var period in model.PeriodList)
                {
                    periodlist.Add(period.StartDate.Contains("/") ? period.StartDate : Convert.ToDateTime(period.StartDate).ToString("dd/MM/yyyy"));
                    periodlist.Add(period.EndDate.Contains("/") ? period.EndDate : Convert.ToDateTime(period.EndDate).ToString("dd/MM/yyyy"));
                }

                for (int i = 1; i <= periodlist.Count - 1; i++)
                {
                    double day = (DalCommon.SetDate(periodlist[i]) - DalCommon.SetDate(periodlist[i - 1])).TotalDays;
                    if (i != 1)
                    {
                        if (day <= 0)
                        {
                            error = 1;
                            break;
                        }
                    }
                }
                if (error == 0)
                {
                    #region Save

                    using (var tx = new TransactionScope())
                    {
                        using (_context)
                        {
                            var exitData = _context.Prq_PurchaseYearTarget.Where(m => m.PurchaseYear == model.PurchaseYear).ToList();
                            if (exitData.Count > 0)
                            {
                                _vmMsg.Type = Enums.MessageType.Error;
                                _vmMsg.Msg  = "Alreary Exit This Year.";
                            }
                            else
                            {
                                model.SetBy = userid;
                                Prq_PurchaseYearTarget tblPurchaseYearTarget = SetToModelObject(model);
                                _context.Prq_PurchaseYearTarget.Add(tblPurchaseYearTarget);
                                _context.SaveChanges();

                                #region Save Period Records

                                if (model.PurchaseYearPeriodList != null)
                                {
                                    foreach (PrqPurchaseYearPeriod objPrqPurchaseYearPeriod in model.PurchaseYearPeriodList)
                                    {
                                        ////var yearStartDate = Convert.ToDateTime(objPrqPurchaseYearPeriod.StartDate).Date;
                                        ////var yearEndDate = Convert.ToDateTime(objPrqPurchaseYearPeriod.EndDate).Date;
                                        //objPrqPurchaseYearPeriod.SetBy = userid;
                                        //objPrqPurchaseYearPeriod.StartDate =
                                        //    Convert.ToDateTime(objPrqPurchaseYearPeriod.StartDate)
                                        //        .Date.ToString("dd/MM/yyyy");
                                        //objPrqPurchaseYearPeriod.EndDate =
                                        //    Convert.ToDateTime(objPrqPurchaseYearPeriod.EndDate)
                                        //        .Date.ToString("dd/MM/yyyy");

                                        objPrqPurchaseYearPeriod.StartDate = objPrqPurchaseYearPeriod.StartDate.Contains("/") ? objPrqPurchaseYearPeriod.StartDate : Convert.ToDateTime(objPrqPurchaseYearPeriod.StartDate).ToString("dd/MM/yyyy");
                                        objPrqPurchaseYearPeriod.EndDate   = objPrqPurchaseYearPeriod.EndDate.Contains("/") ? objPrqPurchaseYearPeriod.EndDate : Convert.ToDateTime(objPrqPurchaseYearPeriod.EndDate).ToString("dd/MM/yyyy");
                                        objPrqPurchaseYearPeriod.YearID    = tblPurchaseYearTarget.YearID;
                                        Prq_PurchaseYearPeriod tblPurchaseYearPeriod =
                                            SetToModelObject(objPrqPurchaseYearPeriod);
                                        _context.Prq_PurchaseYearPeriod.Add(tblPurchaseYearPeriod);

                                        _context.SaveChanges();

                                        #region Save Period Item List

                                        if (model.PurchaseYearPeriodItemList != null)
                                        {
                                            foreach (
                                                PrqPurchaseYearPeriodItem objPrqPurchaseYearPeriodItem in
                                                model.PurchaseYearPeriodItemList)
                                            {
                                                objPrqPurchaseYearPeriodItem.PeriodID =
                                                    tblPurchaseYearPeriod.PeriodID;
                                                objPrqPurchaseYearPeriodItem.SetBy = userid;
                                                Prq_PurchaseYearPeriodItem tblPurchaseYearPeriodItem =
                                                    SetToModelObject(objPrqPurchaseYearPeriodItem);
                                                _context.Prq_PurchaseYearPeriodItem.Add(tblPurchaseYearPeriodItem);
                                            }
                                        }

                                        #endregion
                                    }
                                }
                                _context.SaveChanges();

                                #endregion

                                tx.Complete();
                                YearID      = tblPurchaseYearTarget.YearID;
                                _vmMsg.Type = Enums.MessageType.Success;
                                _vmMsg.Msg  = "Saved Successfully.";
                            }
                        }
                    }

                    #endregion
                }
                else
                {
                    _vmMsg.Type = Enums.MessageType.Error;
                    _vmMsg.Msg  = "Period is not Properly Define.";
                }
            }
            catch
            {
                _vmMsg.Type = Enums.MessageType.Error;
                _vmMsg.Msg  = "Failed to save.";
            }

            return(_vmMsg);
        }
Beispiel #9
0
        public ValidationMsg Update(PrqPurchaseYearTarget model, int userid)
        {
            _vmMsg = new ValidationMsg();
            try
            {
                IList <string> periodlist = new List <string>();
                periodlist.Add(model.YearStartDate);
                foreach (var period in model.PeriodList)
                {
                    periodlist.Add(period.StartDate.Contains("/") ? period.StartDate : Convert.ToDateTime(period.StartDate).ToString("dd/MM/yyyy"));
                    periodlist.Add(period.EndDate.Contains("/") ? period.EndDate : Convert.ToDateTime(period.EndDate).ToString("dd/MM/yyyy"));
                }

                for (int i = 1; i <= periodlist.Count - 1; i++)
                {
                    double day = (DalCommon.SetDate(periodlist[i]) - DalCommon.SetDate(periodlist[i - 1])).TotalDays;
                    if (day < 0)
                    {
                        error = 1;
                        break;
                    }
                }
                if (error == 0)
                {
                    #region Update

                    using (var tx = new TransactionScope())
                    {
                        using (_context)
                        {
                            Prq_PurchaseYearTarget CurrentEntity = SetToModelObject(model);
                            var OriginalEntity = _context.Prq_PurchaseYearTarget.First(m => m.YearID == model.YearID);

                            OriginalEntity.PurchaseYear  = CurrentEntity.PurchaseYear;
                            OriginalEntity.YearStartDate = CurrentEntity.YearStartDate;
                            OriginalEntity.YearEndDate   = CurrentEntity.YearEndDate;
                            OriginalEntity.ModifiedBy    = userid;
                            OriginalEntity.ModifiedOn    = DateTime.Now;

                            #region Save Period Records

                            if (model.PurchaseYearPeriodList != null)
                            {
                                foreach (PrqPurchaseYearPeriod objPrqPurchaseYearPeriod in model.PurchaseYearPeriodList)
                                {
                                    objPrqPurchaseYearPeriod.StartDate = objPrqPurchaseYearPeriod.StartDate.Contains("/") ? objPrqPurchaseYearPeriod.StartDate : Convert.ToDateTime(objPrqPurchaseYearPeriod.StartDate).ToString("dd/MM/yyyy");
                                    objPrqPurchaseYearPeriod.EndDate   = objPrqPurchaseYearPeriod.EndDate.Contains("/") ? objPrqPurchaseYearPeriod.EndDate : Convert.ToDateTime(objPrqPurchaseYearPeriod.EndDate).ToString("dd/MM/yyyy");

                                    //objPrqPurchaseYearPeriod.StartDate =
                                    //    Convert.ToDateTime(objPrqPurchaseYearPeriod.StartDate)
                                    //        .Date.ToString("dd/MM/yyyy");
                                    //objPrqPurchaseYearPeriod.EndDate =
                                    //    Convert.ToDateTime(objPrqPurchaseYearPeriod.EndDate)
                                    //        .Date.ToString("dd/MM/yyyy");

                                    if (objPrqPurchaseYearPeriod.PeriodID == 0)
                                    {
                                        objPrqPurchaseYearPeriod.YearID = model.YearID;
                                        objPrqPurchaseYearPeriod.SetBy  = userid;
                                        Prq_PurchaseYearPeriod tblPurchaseYearPeriod = SetToModelObject(objPrqPurchaseYearPeriod);
                                        _context.Prq_PurchaseYearPeriod.Add(tblPurchaseYearPeriod);
                                        PeriodID = tblPurchaseYearPeriod.PeriodID;
                                    }
                                    else
                                    {
                                        Prq_PurchaseYearPeriod CurEntity = SetToModelObject(objPrqPurchaseYearPeriod);
                                        var OrgEntity = _context.Prq_PurchaseYearPeriod.First(m => m.PeriodID == objPrqPurchaseYearPeriod.PeriodID);

                                        OrgEntity.StartDate  = CurEntity.StartDate;
                                        OrgEntity.EndDate    = CurEntity.EndDate;
                                        OrgEntity.ModifiedBy = userid;
                                        OrgEntity.ModifiedOn = DateTime.Now;
                                    }

                                    #region Save Period Item List

                                    if (model.PurchaseYearPeriodItemList != null)
                                    {
                                        foreach (
                                            PrqPurchaseYearPeriodItem objPrqPurchaseYearPeriodItem in
                                            model.PurchaseYearPeriodItemList)
                                        {
                                            if (objPrqPurchaseYearPeriodItem.PeriodItemID == 0)
                                            {
                                                objPrqPurchaseYearPeriodItem.PeriodID = PeriodID;
                                                objPrqPurchaseYearPeriodItem.SetBy    = userid;
                                                Prq_PurchaseYearPeriodItem tblPurchaseYearPeriodItem =
                                                    SetToModelObject(objPrqPurchaseYearPeriodItem);
                                                _context.Prq_PurchaseYearPeriodItem.Add(tblPurchaseYearPeriodItem);
                                            }
                                            else
                                            {
                                                Prq_PurchaseYearPeriodItem CurrEntity =
                                                    SetToModelObject(objPrqPurchaseYearPeriodItem);
                                                var OrgrEntity =
                                                    _context.Prq_PurchaseYearPeriodItem.First(
                                                        m =>
                                                        m.PeriodItemID ==
                                                        objPrqPurchaseYearPeriodItem.PeriodItemID);

                                                OrgrEntity.ItemTypeID     = CurrEntity.ItemTypeID;
                                                OrgrEntity.LeatherType    = CurrEntity.LeatherType;
                                                OrgrEntity.LeatherStatus  = CurrEntity.LeatherStatus;
                                                OrgrEntity.SizeID         = CurrEntity.SizeID;
                                                OrgrEntity.TargetQuantity = CurrEntity.TargetQuantity;
                                                OrgrEntity.UnitID         = CurrEntity.UnitID;
                                                OrgrEntity.TargetValue    = CurrEntity.TargetValue;
                                                OrgrEntity.CurrencyID     = CurrEntity.CurrencyID;
                                                OrgrEntity.RecordStatus   = CurrEntity.RecordStatus;
                                            }
                                        }
                                    }

                                    #endregion
                                }
                            }
                            else
                            {
                                #region Save Period Item List

                                if (model.PurchaseYearPeriodItemList != null)
                                {
                                    foreach (
                                        PrqPurchaseYearPeriodItem objPrqPurchaseYearPeriodItem in
                                        model.PurchaseYearPeriodItemList)
                                    {
                                        if (objPrqPurchaseYearPeriodItem.PeriodItemID == 0)
                                        {
                                            objPrqPurchaseYearPeriodItem.PeriodID = model.PeriodID;
                                            Prq_PurchaseYearPeriodItem tblPurchaseYearPeriodItem =
                                                SetToModelObject(objPrqPurchaseYearPeriodItem);
                                            _context.Prq_PurchaseYearPeriodItem.Add(tblPurchaseYearPeriodItem);
                                        }
                                        else
                                        {
                                            Prq_PurchaseYearPeriodItem CurrEntity =
                                                SetToModelObject(objPrqPurchaseYearPeriodItem);
                                            var OrgrEntity =
                                                _context.Prq_PurchaseYearPeriodItem.First(
                                                    m => m.PeriodItemID == objPrqPurchaseYearPeriodItem.PeriodItemID);

                                            OrgrEntity.ItemTypeID     = CurrEntity.ItemTypeID;
                                            OrgrEntity.LeatherType    = CurrEntity.LeatherType;
                                            OrgrEntity.LeatherStatus  = CurrEntity.LeatherStatus;
                                            OrgrEntity.SizeID         = CurrEntity.SizeID;
                                            OrgrEntity.TargetQuantity = CurrEntity.TargetQuantity;
                                            OrgrEntity.UnitID         = CurrEntity.UnitID;
                                            OrgrEntity.TargetValue    = CurrEntity.TargetValue;
                                            OrgrEntity.CurrencyID     = CurrEntity.CurrencyID;
                                            OrgrEntity.RecordStatus   = CurrEntity.RecordStatus;
                                        }
                                    }
                                }

                                #endregion
                            }
                            _context.SaveChanges();

                            #endregion

                            tx.Complete();
                            _vmMsg.Type = Enums.MessageType.Update;
                            _vmMsg.Msg  = "Updated Successfully.";
                        }
                    }

                    #endregion
                }
                else
                {
                    _vmMsg.Type = Enums.MessageType.Error;
                    _vmMsg.Msg  = "Period is not Properly Define.";
                }
            }
            catch
            {
                _vmMsg.Type = Enums.MessageType.Error;
                _vmMsg.Msg  = "Failed to Update.";
            }
            return(_vmMsg);
        }