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();
}
