public override JToken Value(CodeFirstWebFramework.Database db, JObject data) { string value = base.Value(db, data).ToString(); if (value.IndexOf("Bill Pmt") == 0) { value = "Bill Payment"; } JObject keyData = new JObject().AddRange("DocType", value); return(db.ForeignKey("DocumentType", keyData)); }
public override JToken Value(CodeFirstWebFramework.Database db, JObject data) { string value = base.Value(db, data).ToString(); switch (value) { case "INC": value = "Income"; break; case "EXP": value = "Expense"; break; case "COGS": value = "Expense"; break; // ??? case "EXINC": value = "Other Income"; break; case "EXEXP": value = "Other Expense"; break; case "FIXASSET": value = "Fixed Asset"; break; case "OASSET": value = "Other Asset"; break; case "AR": value = "Accounts Receivable"; break; case "BANK": value = "Bank"; break; case "OCASSET": value = "Other Current Asset"; break; case "CCARD": value = "Credit Card"; break; case "AP": value = "Accounts Payable"; break; case "OCLIAB": value = "Other Current Liability"; break; case "LTLIAB": value = "Long Term Liability"; break; case "OLIAB": value = "Other Liability"; break; // No example found case "EQUITY": value = "Equity"; break; default: throw new CheckException("Unknown account type {0}", value); } JObject keyData = new JObject().AddRange("AcctType", value); return(db.ForeignKey("AccountType", keyData)); }
public override JToken Value(CodeFirstWebFramework.Database db, JObject data) { string nameType; switch (data.AsString("Account")) { case "Purchase Ledger": nameType = "S"; break; case "Sales Ledger": nameType = "C"; break; default: string type = data.AsString("Type"); switch (type) { case "Invoice": case "Payment": case "Credit Memo": nameType = "C"; break; case "Bill": case "Bill Pmt": case "Credit": nameType = "S"; break; default: nameType = type.IndexOf("Bill Pmt") == 0 ? "S" : "O"; break; } break; } JObject keyData = new JObject().AddRange("Type", nameType, "Name", base.Value(db, data)); return(db.ForeignKey("NameAddress", keyData)); }
public override JToken Value(CodeFirstWebFramework.Database db, JObject data) { Match m = _r.Match(base.Value(db, data).ToString()); string ac = m.Groups[1].Value; if (ac == "") { return(null); } JObject id = db.QueryOne("SELECT idAccount FROM Account WHERE AccountName = " + db.Quote(ac)); if (id != null) { return(id["idAccount"]); } id = db.QueryOne("SELECT idAccount FROM Account WHERE AccountName LIKE " + db.Quote("%:" + ac)); if (id != null) { return(id["idAccount"]); } throw new CheckException("Account '{0}' not found", ac); }
public override JToken Value(CodeFirstWebFramework.Database db, JObject data) { return(string.Join("\r\n", _theirNames.Select(n => data.AsString(n)).Where(d => !string.IsNullOrEmpty(d)).ToArray())); }
public override JToken Value(CodeFirstWebFramework.Database db, JObject data) { return(_value); }
public override JToken Value(CodeFirstWebFramework.Database db, JObject data) { JObject keyData = new JObject().AddRange(ForeignKey, base.Value(db, data)); return(db.ForeignKey(Table, keyData)); }
public override JToken Value(CodeFirstWebFramework.Database db, JObject data) { return(_regex.Match(data[TheirName].ToString()).Groups[1].Value); }
public override JToken Value(CodeFirstWebFramework.Database db, JObject data) { string d = data.AsString(TheirName); return(string.IsNullOrWhiteSpace(d) ? (JToken)null : string.IsNullOrWhiteSpace(Importer.DateFormat) ? DateTime.Parse(d) : DateTime.ParseExact(d, Importer.DateFormat, System.Globalization.CultureInfo.InvariantCulture)); }
public virtual JToken Value(CodeFirstWebFramework.Database db, JObject data) { return(data[TheirName]); }
public static JObjectEnumerable Select(CodeFirstWebFramework.Database Database) { return(Database.Query("SELECT idContactType AS id, TypeOfContact AS value FROM ContactType ORDER BY TypeOfContact")); }