public int SQLGetTotalCount(IEnumerable<int> accountIdList, TotalsColumn column)
{
DataTable table = sqlData.GetDataTable(String.Format("SELECT {0} FROM Accounts WHERE AccountId IN ({1})", column == TotalsColumn.FromTotal ? "FromTotal" : "ToTotal", String.Join(",", from id in accountIdList select id.ToString())));
IEnumerable<int> vals = from DataRow row in table.Rows select (int)(long)row[0];
return vals.Sum();
}
protected void SQLIncreaseTotalCount(int accountId, TotalsColumn column)
{
int old = SQLGetTotalCount(accountId, column);
sqlData.ExecuteNonQuery(String.Format("INSERT OR IGNORE INTO Accounts (AccountId) VALUES ({0}); UPDATE Accounts SET {1} = {2} WHERE AccountId = {0};", accountId, column == TotalsColumn.FromTotal ? "FromTotal" : "ToTotal", old + 1));
}
public int SQLGetTotalCount(int accountId, TotalsColumn column)
{
var ret = sqlData.ExecuteScalar(String.Format("SELECT {0} FROM Accounts WHERE AccountId='{1}'", column == TotalsColumn.FromTotal ? "FromTotal" : "ToTotal", accountId));
if (ret != null)
return (int)(long)ret;
return 0;
}
