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