コード例 #1
0
        public IActionResult Create()
        {
            if (!_loginServices.isInAdminRoles(this.GetRoles()))
            {
                return(RedirectToAction("Login", "Accounts"));
            }
            var model = new PointCondition();

            model.Status               = StatusType.Active;
            model.IsAllDay             = true;
            model.Gold                 = true;
            model.Silver               = true;
            ViewBag.ListTransacionType = this._context.PointTransacionTypes.OrderBy(o => o.TransacionTypeID);
            ViewBag.ListProduct        = this._context.Products.Where(w => w.Status == StatusType.Active).OrderBy(o => o.ProductCode);
            ViewBag.ListCustomerClass  = this._context.CustomerClasses;

            model.ProductList       = new List <PointConditionProduct>();
            model.CustomerClassList = new List <PointConditionCustomerClass>();

            return(View("ConditionInfo", model));
        }
コード例 #2
0
        public IActionResult Delete()
        {
            if (!_loginServices.isInAdminRoles(this.GetRoles()))
            {
                return(RedirectToAction("Login", "Accounts"));
            }
            string         idParam = this.RouteData.Values["id"].ToString();
            PointCondition model   = null;

            if (idParam != null && idParam != string.Empty)
            {
                int recordId = Int32.Parse(idParam);
                model = this._context.PointConditions.Include(i => i.PointConditionCustomerClasses).Include(i => i.PointConditionProducts).Include(i => i.PointConditionTiers).Where(a => a.ConditionID == recordId).FirstOrDefault();
                if (model == null)
                {
                    ModelState.AddModelError("Error", "ไม่พบข้อมูล");
                }
                else
                {
                    if (model.PointConditionProducts.Count > 0)
                    {
                        this._context.PointConditionProducts.RemoveRange(model.PointConditionProducts);
                    }
                    if (model.PointConditionTiers.Count > 0)
                    {
                        this._context.PointConditionTiers.RemoveRange(model.PointConditionTiers);
                    }
                    if (model.PointConditionCustomerClasses.Count > 0)
                    {
                        this._context.PointConditionCustomerClasses.RemoveRange(model.PointConditionCustomerClasses);
                    }
                    this._context.PointConditions.Remove(model);
                    this._context.SaveChanges();
                }
            }
            return(RedirectToAction("Index"));
        }
コード例 #3
0
        public IActionResult Modify(PointCondition model)
        {
            if (!_loginServices.isInAdminRoles(this.GetRoles()))
            {
                return(RedirectToAction("Login", "Accounts"));
            }
            if (ModelState.IsValid)
            {
                model.StartDate = DateUtil.ToDate(model.sDate);
                model.EndDate   = DateUtil.ToDate(model.eDate);
                if (!model.IsAllDay)
                {
                    if (!model.IsSun & !model.IsMon & !model.IsTue & !model.IsWed & !model.IsThu & !model.IsFri & !model.IsSat)
                    {
                        model.IsAllDay = true;
                    }
                }
                using (var dbContextTransaction = this._context.Database.BeginTransaction())
                {
                    try
                    {
                        if (model.ConditionID <= 0)
                        {
                            model.Create_On = DateUtil.Now();
                            model.Create_By = this.HttpContext.User.Identity.Name;
                            model.Update_On = DateUtil.Now();
                            model.Update_By = this.HttpContext.User.Identity.Name;
                            if (model.TransacionTypeID == (int)TransacionTypeID.BuyInsure | model.TransacionTypeID == (int)TransacionTypeID.Renew)
                            {
                                foreach (var item in model.ProductList.Where(w => w.ProductID > 0))
                                {
                                    model.PointConditionProducts.Add(item);
                                }
                            }
                            if (model.PointType == PointType.Tier)
                            {
                                foreach (var item in model.TierList)
                                {
                                    model.PointConditionTiers.Add(item);
                                }
                            }
                            foreach (var item in model.CustomerClassList.Where(w => w.CustomerClassID > 0))
                            {
                                model.CustomerClassList.Add(item);
                            }
                            this._context.PointConditions.Add(model);
                            this._context.SaveChanges();
                            dbContextTransaction.Commit();
                            return(RedirectToAction("Index"));
                        }
                        else
                        {
                            model.Update_On = DateUtil.Now();
                            model.Update_By = this.HttpContext.User.Identity.Name;
                            this._context.Update(model);

                            /*Product*/
                            IEnumerable <int> itemIDs = Enumerable.Empty <int>();
                            if ((model.TransacionTypeID == (int)TransacionTypeID.BuyInsure | model.TransacionTypeID == (int)TransacionTypeID.Renew) && model.ProductList != null)
                            {
                                itemIDs = model.ProductList.Where(w => w.ID > 0 & w.ProductID > 0).Select(s => s.ID);
                            }
                            foreach (var item in this._context.PointConditionProducts.Where(w => w.ConditionID == model.ConditionID))
                            {
                                if (!itemIDs.Contains(item.ID))
                                {
                                    this._context.PointConditionProducts.Remove(item);
                                    var tmpitem = model.PointConditionProducts.Where(w => w.ID == item.ID).FirstOrDefault();
                                    if (tmpitem != null)
                                    {
                                        model.PointConditionProducts.Remove(tmpitem);
                                    }
                                }
                            }

                            if (model.TransacionTypeID == (int)TransacionTypeID.BuyInsure | model.TransacionTypeID == (int)TransacionTypeID.Renew)
                            {
                                foreach (var item in model.ProductList)
                                {
                                    item.ConditionID = model.ConditionID;
                                    if (item.ID <= 0)
                                    {
                                        this._context.PointConditionProducts.Add(item);
                                    }
                                }
                            }
                            this._context.SaveChanges();

                            /*Tier*/
                            itemIDs = Enumerable.Empty <int>();

                            if (model.PointType == PointType.Tier && model.TierList != null)
                            {
                                itemIDs = model.TierList.Where(w => w.ID > 0).Select(s => s.ID);
                            }
                            foreach (var item in this._context.PointConditionTiers.Where(w => w.ConditionID == model.ConditionID))
                            {
                                if (!itemIDs.Contains(item.ID))
                                {
                                    this._context.PointConditionTiers.Remove(item);
                                    var tmpitem = model.PointConditionTiers.Where(w => w.ID == item.ID).FirstOrDefault();
                                    if (tmpitem != null)
                                    {
                                        model.PointConditionTiers.Remove(tmpitem);
                                    }
                                }
                            }
                            if (model.PointType == PointType.Tier && model.TierList != null)
                            {
                                foreach (var item in model.TierList)
                                {
                                    item.ConditionID = model.ConditionID;
                                    if (item.ID <= 0)
                                    {
                                        this._context.PointConditionTiers.Add(item);
                                    }
                                    else
                                    {
                                        this._context.Update(item);
                                    }
                                }
                            }
                            this._context.SaveChanges();

                            /*Customer Class*/
                            itemIDs = Enumerable.Empty <int>();

                            if (model.CustomerClassList != null)
                            {
                                itemIDs = model.CustomerClassList.Where(w => w.ID > 0).Select(s => s.ID);
                            }
                            foreach (var item in this._context.PointConditionCustomerClasses.Where(w => w.ConditionID == model.ConditionID))
                            {
                                if (!itemIDs.Contains(item.ID))
                                {
                                    this._context.PointConditionCustomerClasses.Remove(item);
                                    var tmpitem = model.PointConditionCustomerClasses.Where(w => w.ID == item.ID).FirstOrDefault();
                                    if (tmpitem != null)
                                    {
                                        model.PointConditionCustomerClasses.Remove(tmpitem);
                                    }
                                }
                            }
                            if (model.CustomerClassList != null)
                            {
                                foreach (var item in model.CustomerClassList)
                                {
                                    item.ConditionID = model.ConditionID;
                                    if (item.ID <= 0)
                                    {
                                        this._context.PointConditionCustomerClasses.Add(item);
                                    }
                                    else
                                    {
                                        this._context.Update(item);
                                    }
                                }
                            }
                            this._context.SaveChanges();

                            this._context.PointConditionProducts.RemoveRange(this._context.PointConditionProducts.Where(w => w.ProductID <= 0));
                            this._context.SaveChanges();
                            dbContextTransaction.Commit();

                            return(RedirectToAction("Index"));
                        }
                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine(ex.ToString());
                        dbContextTransaction.Rollback();
                        ModelState.AddModelError("Error", "มีข้อผิดพลาดไม่สามารถบันทึกข้อมูล: " + ex.Message);
                    }
                }
            }
            else
            {
                ModelState.AddModelError("Error", "มีข้อผิดพลาดไม่สามารถบันทึกข้อมูล");
            }
            ViewBag.ListTransacionType = this._context.PointTransacionTypes.OrderBy(o => o.TransacionTypeID);
            ViewBag.ListProduct        = this._context.Products.Where(w => w.Status == StatusType.Active).OrderBy(o => o.ProductCode);
            if (model.ProductList == null)
            {
                model.ProductList = new List <PointConditionProduct>();
            }
            return(View("ConditionInfo", model));
        }