static ManglerBase GetMangler(CFType type) { if (type == CFType.Switch) return Switch; return Jump; }
internal static bool RequiresDxf(CFType type) { switch (type) { case CFType.IconSet: case CFType.ColorScale: case CFType.DataBar: return false; default: return true; } }
public CFRule(CFType type, int priority = 1) { Priority = priority; Type = type; Operator = null; Formula1 = null; Formula2 = null; Formula3 = null; IsBottom = false; Rank = 10; IsPercent = false; StdDev = 0; IsAboveAverage = true; IsEqualAverage = false; IsStdDev = false; Text = null; TimePeriod = TimePeriod.Today; }
public static string CreateFormula(string value, CFType type, string firstCell) { switch (type) { case CFType.ContainsText: return string.Format(containsText, value, firstCell); case CFType.NotContainsText: return string.Format(notContainsText, value, firstCell); case CFType.BeginsWith: return string.Format(beginsWith, value, firstCell); case CFType.EndsWith: return string.Format(endsWith, value, firstCell); case CFType.ContainsBlanks: return string.Format(containsBlanks, firstCell); case CFType.NotContainsBlanks: return string.Format(notContainsBlanks, firstCell); case CFType.ContainsErrors: return string.Format(containsErrors, firstCell); case CFType.NotContainsErrors: return string.Format(notContainsErrors, firstCell); default: return value; } }
public CFRule(CFType type, CellStyle style, CFOperator @operator = CFOperator.LessThan, string formula1 = "", string formula2 = "", string formula3 = "") { Type = type; Style = style; Operator = @operator; Formula1 = formula1; Formula2 = formula2; Formula3 = formula3; IsBottom = false; Rank = 10; IsPercent = false; StdDev = 0; IsAboveAverage = true; IsEqualAverage = false; IsStdDev = false; Text = null; TimePeriod = TimePeriod.Today; }
public CFRule AddGreaterThanOrEqual(string value, CellStyle style) { CFType type = CFType.CellIs; return(GetRuleForOneValue(type, value, style, CFOperator.GreaterThanOrEqual)); }
public CFRule AddLessThan(string value, CellStyle style) { CFType type = CFType.CellIs; return(GetRuleForOneValue(type, value, style, CFOperator.LessThan)); }
public static void Initialize(FinPlannerContext context) { context.Database.EnsureCreated(); if (context.CFTypes.Any()) { return; } var cfTypes = new CFType[] { new CFType { Id = Guid.NewGuid().ToString(), Custom = false, Name = "Salary" }, new CFType { Id = Guid.NewGuid().ToString(), Custom = false, Name = "Rent" }, new CFType { Id = Guid.NewGuid().ToString(), Custom = false, Name = "Groceries" }, new CFType { Id = Guid.NewGuid().ToString(), Custom = false, Name = "Electricty" }, new CFType { Id = Guid.NewGuid().ToString(), Custom = false, Name = "Loans" }, new CFType { Id = Guid.NewGuid().ToString(), Custom = false, Name = "Car Loan" }, new CFType { Id = Guid.NewGuid().ToString(), Custom = false, Name = "Insurance" }, new CFType { Id = Guid.NewGuid().ToString(), Custom = false, Name = "Bank Charges" }, new CFType { Id = Guid.NewGuid().ToString(), Custom = false, Name = "Domestic" }, new CFType { Id = Guid.NewGuid().ToString(), Custom = false, Name = "Cellphone" }, new CFType { Id = Guid.NewGuid().ToString(), Custom = false, Name = "Gym" }, new CFType { Id = Guid.NewGuid().ToString(), Custom = false, Name = "Internet" }, new CFType { Id = Guid.NewGuid().ToString(), Custom = false, Name = "Medical Aid" }, new CFType { Id = Guid.NewGuid().ToString(), Custom = false, Name = "Entertainment" }, new CFType { Id = Guid.NewGuid().ToString(), Custom = false, Name = "Takeout" }, new CFType { Id = Guid.NewGuid().ToString(), Custom = false, Name = "School Fees" }, new CFType { Id = Guid.NewGuid().ToString(), Custom = false, Name = "Transportation" }, new CFType { Id = Guid.NewGuid().ToString(), Custom = false, Name = "Medication" }, new CFType { Id = Guid.NewGuid().ToString(), Custom = true, ClientReference = "999", Name = "Transfer" } }; foreach (CFType item in cfTypes) { context.CFTypes.Add(item); } context.SaveChanges(); if (context.CFClassifications.Any()) { return; } var cfClass = new CFClassification[] { new CFClassification { Id = Guid.NewGuid().ToString(), Name = "Income", Sign = 1 }, new CFClassification { Id = Guid.NewGuid().ToString(), Name = "Expense", Sign = -1 }, }; foreach (CFClassification item in cfClass) { context.CFClassifications.Add(item); } context.SaveChanges(); }