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)
{
JObject keyData = new JObject().AddRange(ForeignKey, base.Value(db, data));
return(db.ForeignKey(Table, keyData));
}
