private static JurisdictionGroup InitializeItem(JurisdictionGroup item, IEnumerable <ImportItem> systemValues)
        {
            if (item == null)
            {
                item = new OrderEntityFactory().CreateEntity <JurisdictionGroup>();
            }
            var itemProperties = item.GetType().GetProperties();

            systemValues.ToList().ForEach(x => SetPropertyValue(item, itemProperties.FirstOrDefault(y => y.Name == x.Name), x.Value));

            return(item);
        }
Esempio n. 2
0
        /// <summary>
        /// 获取权限组
        /// </summary>
        /// <returns></returns>
        public static void GetJurGroups(out List <JurisdictionGroup> list)
        {
            list = new List <JurisdictionGroup>();
            string sql = "select GroupID,GroupName,Description,DefaultGroup from ipvt_jurgrouptable";

            MySqlDataReader reader = null;

            try
            {
                reader = CustomMySqlHelper.ExecuteDataReader(sql);
                while (reader.Read())
                {
                    var group = new JurisdictionGroup();
                    group.GroupId     = EvaluationHelper.ObjectToInt(reader["GroupID"]);
                    group.Default     = EvaluationHelper.ObjectToInt(reader["DefaultGroup"]);
                    group.GroupName   = reader["GroupName"].ToString();
                    group.Description = reader["Description"].ToString();

                    list.Add(group);
                }
            }
            catch (Exception ex)
            {
                LogHelper.MainLog("error in JurisdictionManager.GetJurGroups()!" + ex.Message);
            }
            finally
            {
                if (reader != null)
                {
                    reader.Close(); //读取完关闭reader对象
                }
            }

            foreach (JurisdictionGroup group in list)
            {
                List <Jurisdiction> js;
                GetJurisdictions(group.GroupId, out js);
                if (js != null)
                {
                    foreach (Jurisdiction jur in js)
                    {
                        group.Jurisdictions.Add(jur);
                    }
                }
            }
        }
Esempio n. 3
0
        /// <summary>
        /// 更新权限组
        /// </summary>
        /// <param name="group"></param>
        /// <returns></returns>
        public static bool UpdateGroup(JurisdictionGroup group)
        {
            var models = new List <SqlTextModel>();

            if (group != null && group.GroupId > 0 && !string.IsNullOrEmpty(group.GroupName))
            {
                //更新权限组表组信息
                string gsql = "update ipvt_jurgrouptable set GroupName=?name,Description=?des where GroupID=?id";
                var    ps   = new MySqlParameter[3];
                ps[0] = new MySqlParameter("?name", group.GroupName);
                ps[1] = new MySqlParameter("?des", group.Description);
                ps[2] = new MySqlParameter("?id", group.GroupId);

                models.Add(new SqlTextModel {
                    SqlString = gsql, MySqlParams = ps
                });
                //删除权限组-权限表指定组的旧对应数据
                string delsql = "delete from ipvt_jurisdiction_grouptable where GroupID=?id";
                var    delps  = new[] { new MySqlParameter("?id", group.GroupId) };

                models.Add(new SqlTextModel {
                    SqlString = delsql, MySqlParams = delps
                });
                //添加权限组-权限表指定组的新对应数据
                foreach (Jurisdiction jur in group.Jurisdictions)
                {
                    string insertsql =
                        "insert into ipvt_jurisdiction_grouptable(GroupID,JurisdictionID) values(?gid,?jid)";
                    var inps = new MySqlParameter[2];
                    inps[0] = new MySqlParameter("?gid", group.GroupId);
                    inps[1] = new MySqlParameter("?jid", jur.Id);

                    models.Add(new SqlTextModel {
                        SqlString = insertsql, MySqlParams = inps
                    });
                }

                return(CustomMySqlHelper.ExecuteSqlList(models));//事务批量执行
            }

            return(false);
        }
Esempio n. 4
0
        /// <summary>
        /// 插入权限组
        /// </summary>
        /// <param name="group"></param>
        /// <returns></returns>
        public static bool InsertGroup(JurisdictionGroup group)
        {
            var models = new List <SqlTextModel>();

            if (group != null && !string.IsNullOrEmpty(group.GroupName))
            {
                //插入组信息
                string gsql =
                    "insert into ipvt_jurgrouptable(GroupName,Description) values(?name,?des);SELECT @@IDENTITY";
                var ps = new MySqlParameter[2];
                ps[0] = new MySqlParameter("?name", group.GroupName);
                ps[1] = new MySqlParameter("?des", group.Description);

                int newid = EvaluationHelper.ObjectToInt(CustomMySqlHelper.ExecuteScalar(gsql, ps));

                if (newid > 0)
                {
                    //添加权限组-权限表指定组的新对应数据
                    foreach (Jurisdiction jur in group.Jurisdictions)
                    {
                        string insertsql =
                            "insert into ipvt_jurisdiction_grouptable(GroupID,JurisdictionID) values(?gid,?jid)";
                        var inps = new MySqlParameter[2];
                        inps[0] = new MySqlParameter("?gid", newid);
                        inps[1] = new MySqlParameter("?jid", jur.Id);

                        models.Add(new SqlTextModel {
                            SqlString = insertsql, MySqlParams = inps
                        });
                    }

                    return(CustomMySqlHelper.ExecuteSqlList(models));//事务批量执行
                }
            }

            return(false);
        }
        public void Can_run_activity_calculatetaxtotals()
        {
            var orderGroup = CreateOrderConstant();

            var catrepository = new Mock <ICatalogRepository>();
            var items         = new List <Item>();

            orderGroup.OrderForms[0].Shipments[0].ShipmentItems.ToList().ForEach(item => items.Add(new Product
            {
                ItemId      = item.LineItem.CatalogItemId,
                TaxCategory = "472b9809-3530-4d95-9886-cbddcaa0b72e"
            }));

            orderGroup.OrderForms[0].Shipments[0].ShippingCost = 10;

            catrepository.Setup(x => x.Items).Returns(() => items.ToArray().AsQueryable());
            catrepository.SetupAllProperties();

            var taxrepository = new Mock <ITaxRepository>();
            var taxes         = new[]
            {
                new Tax {
                    Name = "US Shipment tax", TaxType = (int)TaxTypes.ShippingTax, SortOrder = 1
                },
                new Tax {
                    Name = "US Sales tax", TaxType = (int)TaxTypes.SalesTax, SortOrder = 1
                }
            };

            var jurisdiction = new Jurisdiction
            {
                Code             = "VAT",
                CountryCode      = "USA",
                JurisdictionType = (int)JurisdictionTypes.All
            };

            var jurisdictionGroup = new JurisdictionGroup
            {
                DisplayName      = "USA VAT",
                Code             = "USAVAT",
                JurisdictionType = (int)JurisdictionTypes.All
            };
            var jurisdictionRel = new JurisdictionRelation
            {
                JurisdictionGroup   = jurisdictionGroup,
                JurisdictionGroupId = jurisdictionGroup.JurisdictionGroupId,
                Jurisdiction        = jurisdiction,
                JurisdictionId      = jurisdiction.JurisdictionId
            };

            jurisdictionGroup.JurisdictionRelations.Add(jurisdictionRel);

            taxes[0].TaxValues.Add(new TaxValue()
            {
                AffectiveDate       = new DateTime(2013, 6, 1),
                Percentage          = 18,
                TaxCategory         = "472b9809-3530-4d95-9886-cbddcaa0b72e",
                TaxId               = taxes[0].TaxId,
                Tax                 = taxes[0],
                JurisdictionGroup   = jurisdictionGroup,
                JurisdictionGroupId = jurisdictionGroup.JurisdictionGroupId
            });

            taxes[1].TaxValues.Add(new TaxValue()
            {
                AffectiveDate       = new DateTime(2013, 6, 1),
                Percentage          = 5,
                TaxCategory         = "472b9809-3530-4d95-9886-cbddcaa0b72e",
                TaxId               = taxes[1].TaxId,
                Tax                 = taxes[1],
                JurisdictionGroup   = jurisdictionGroup,
                JurisdictionGroupId = jurisdictionGroup.JurisdictionGroupId
            });

            taxrepository.Setup(x => x.Taxes).Returns(taxes.AsQueryable);
            taxrepository.SetupAllProperties();

            var activity = new CalculateTaxActivity(catrepository.Object, taxrepository.Object, CacheRepository);

            var result = InvokeActivity(activity, orderGroup);

            var order = result.OrderGroup;

            // now check totals

            // Order totals
            Assert.Equal(order.TaxTotal, 660.24M);
            Assert.Equal(order.OrderForms[0].Shipments[0].ItemTaxTotal, 609.84M);
            Assert.Equal(order.OrderForms[0].Shipments[0].ShippingTaxTotal, 12.6M);
        }
Esempio n. 6
0
 public JurisdictionGroupOverviewStepViewModel(IRepositoryFactory <IOrderRepository> repositoryFactory, IOrderEntityFactory entityFactory, JurisdictionTypes jurisdictionType, JurisdictionGroup item)
     : base(repositoryFactory, entityFactory, jurisdictionType, item)
 {
 }
Esempio n. 7
0
 public CreateJurisdictionGroupViewModel(IViewModelsFactory <IJurisdictionGroupOverviewStepViewModel> vmFactory, JurisdictionTypes jurisdictionType, JurisdictionGroup item)
 {
     RegisterStep(vmFactory.GetViewModelInstance(
                      new KeyValuePair <string, object>("item", item)
                      , new KeyValuePair <string, object>("jurisdictionType", jurisdictionType)));
 }