static void mayUseThisFuncLater() //func to change multiplier to step { DataClasses1DataContext db = new DataClasses1DataContext(); List <Rule> AllRules = db.Rules.Where(x => x.Type == 1).ToList(); JavaScriptSerializer jsS = new JavaScriptSerializer(); int i = 0; Console.WriteLine("Total record to be processed: {0}", AllRules.Count); foreach (Rule rule in AllRules) { i++; CostingRule cRule = jsS.Deserialize <CostingRule>(rule.Properties); if (cRule.type == 'S') { if (cRule.startW > 0.49 && cRule.startW < 0.51) { cRule.ndStartValue = 0; cRule.dStartValue = 0; } rule.Properties = jsS.Serialize(cRule); } if (i % 250 == 0) { Console.WriteLine("Processed records: {0}", i); } } Console.WriteLine("Trying to submit changes ..{0}", db.GetChangeSet().Updates.Count); db.SubmitChanges(); }
static void Main(string[] args) { DataClasses1DataContext db = new DataClasses1DataContext(); List <Rule> RuleList = db.Rules.Where(x => x.QID == 188).ToList(); Console.WriteLine("Rules found: " + RuleList.Count + ". Continue?"); Console.ReadLine(); JavaScriptSerializer serializer = new JavaScriptSerializer(); foreach (Rule rule in RuleList) { if (rule.Type == 1) { CostingRule crule = serializer.Deserialize <CostingRule>(rule.Properties); crule.Id = rule.ID; rule.Properties = serializer.Serialize(crule); } if (rule.Type == 2) { ServiceRule crule = serializer.Deserialize <ServiceRule>(rule.Properties); crule.Id = rule.ID; rule.Properties = serializer.Serialize(crule); } } var changeSet = db.GetChangeSet(); Console.WriteLine("Changes: " + changeSet.Updates.ToString()); Console.ReadLine(); db.SubmitChanges(); }
static void funcToAddGroupsToServices() { Console.WriteLine("Trying to load all costing rules..."); DataClasses1DataContext db = new DataClasses1DataContext(); List <Rule> ruleCollection = db.Rules.ToList(); Console.WriteLine("Attempting to process " + ruleCollection.Count + " rules."); JavaScriptSerializer serializer = new JavaScriptSerializer(); int i = 0; foreach (Rule rule in ruleCollection) { CostingRule cRule = serializer.Deserialize <CostingRule>(rule.Properties); List <string> groups = cRule.ServiceGroupList; if (groups != null) { if (groups.Contains("PTP 12:00")) { List <string> zones = cRule.ZoneList; if (zones.Contains("MET")) { zones.Add("NEA"); zones.Add("ROI"); cRule.ZoneList = zones; rule.Properties = serializer.Serialize(cRule); } } } i++; if (i % 250 == 0) { Console.WriteLine(i.ToString() + " records processed..."); } } Console.WriteLine("Records to be updated : " + db.GetChangeSet().Updates.Count); Console.WriteLine("Attempting to save data..."); db.SubmitChanges(); Console.WriteLine("Changes submitted..."); Console.ReadLine(); }