public ClientsService(IDbConnectionFactory dbConnectionFactory) { Repository = new OrmLiteRepository<Client>(dbConnectionFactory.Open()); }
public MetroiLinksService(IDbConnectionFactory dbConnectionFactory) { Repository = new OrmLiteRepository<MetroiLinks>(dbConnectionFactory.Open()); }
public FolderService(IDbConnectionFactory dbConnectionFactory) { Repository = new OrmLiteRepository<Folder>(dbConnectionFactory.Open()); }
public static void CreateTransactionTable() { Transaction transaction = new Transaction(); transaction.Id = Guid.NewGuid(); transaction.Name = "Name"; transaction.ActivationDate = DateTime.Now; transaction.CreatedOn = DateTime.Now; transaction.Amount = 100; transaction.ExpiredDate = DateTime.Now.AddDays(10); transaction.CardAccountId = new Guid("c9867a69-257c-4c96-b328-be2c79abab1a"); OrmLiteRepository<Transaction> repo = new OrmLiteRepository<Transaction>(); repo.SafeAdd(transaction); }
public static void CreateTables() { var serializer = new JSSerializer(); OrmLiteRepository<LocalRestriction> table = new OrmLiteRepository<LocalRestriction>(); LocalRestriction ent = new LocalRestriction(); ent.LookupItemId = new Guid("c6eb436e-1021-45a5-b937-30b6b7be1970"); ent.Name = "LocalRestriction от бога"; ent.RuleId = new Guid("B999488A-9D27-4318-BE06-99DB84B25139"); ent.Production = true; ent.Sandbox = true; var settings = new Dictionary<string, object>(); settings.Add("Date", DateTime.Now); ent.Settings = serializer.Serialize(settings); ent.CreatedOn = DateTime.Now; table.SafeAdd(ent); }
public static void CreateRule() { var serializer = new JSSerializer(); OrmLiteRepository<Rule> table = new OrmLiteRepository<Rule>(); Rule rule = new Rule(); rule.ActivateBonusInDays = 1; rule.ChargeAmount = 100; rule.BonusLifeTime = 30; rule.Production = true; rule.Sandbox = true; rule.ActivateInDate = DateTime.Now; rule.ActivateOnCharge = true; rule.ChargePercent = 50; rule.LifeTimeFrom = DateTime.Now; rule.LifeTimeTo = DateTime.Now.AddDays(40); rule.Priority = 2; rule.Name = "Rule 2"; ConditionGroup mainGroup = new ConditionGroup(); mainGroup.ExpressionType = ExpressionType.AND; Condition cond1 = new Condition(new BaseCondition()); Dictionary<string, object> cond1Settings = new Dictionary<string, object>(); cond1Settings.Add("Date", DateTime.Now.AddDays(-40)); cond1.ConditionItem.Settings = cond1Settings; cond1.ConditionItem.ConditionId = new Guid("2be12ef8-00b9-47c5-a0cb-d6f15fb02aa5"); mainGroup.Add(cond1); ConditionGroup subGroup1 = new ConditionGroup(); subGroup1.ExpressionType = ExpressionType.AND; Condition cond2 = new Condition(new BaseCondition()); Dictionary<string, object> cond2Settings = new Dictionary<string, object>(); cond2Settings.Add("Date", DateTime.Now.AddDays(-40)); cond2.ConditionItem.Settings = cond2Settings; cond2.ConditionItem.ConditionId = new Guid("2be12ef8-00b9-47c5-a0cb-d6f15fb02aa5"); subGroup1.Add(cond2); mainGroup.Add(subGroup1); var conditionJson = serializer.Serialize(mainGroup); rule.Conditions = conditionJson; LocalRestrictionBase localRestriction = new LocalRestrictionBase(); localRestriction.RestrictionId = new Guid("C6EB436E-1021-45A5-B937-30B6B7BE1970"); localRestriction.Name = "LocalRestriction от бога"; var restrictionSettings = new Dictionary<string, object>(); restrictionSettings.Add("Date", DateTime.Now); localRestriction.Settings = restrictionSettings; LocalActionBase localAction = new LocalActionBase(); localAction.ActionId = new Guid("EB54BD15-D953-4986-AC89-47A9F5E527C0"); localAction.Name = "LocalAction от бога"; var actionSettings = new Dictionary<string, object>(); actionSettings.Add("Date", DateTime.Now); localAction.Settings = actionSettings; List<LocalRestrictionBase> restrictionList = new List<LocalRestrictionBase>(); restrictionList.Add(localRestriction); List<LocalActionBase> actionList = new List<LocalActionBase>(); actionList.Add(localAction); rule.LocalActions = serializer.Serialize(actionList); rule.LocalRestrictions = serializer.Serialize(restrictionList); table.SafeAdd(rule); //Console.WriteLine(json); //Console.ReadKey(); }
public static void CreateKVSTable() { KVSUncommitedPurchase purchase = new KVSUncommitedPurchase(); purchase.Id = Guid.NewGuid(); purchase.serializedData = ""; purchase.CreatedOn = DateTime.Now; OrmLiteRepository<KVSUncommitedPurchase> repo = new OrmLiteRepository<KVSUncommitedPurchase>(); repo.SafeAdd(purchase); }