public static void AddPending(PALMPending pending)
{
string tableName = "PALM_Pending";
string searchString = "UserID LIKE '" + pending.User.ID + "'";
string targetString = null;
DataTable _dataTable = QuantApp.Kernel.Database.DB["CloudApp"].GetDataTable(tableName, targetString, searchString);
DataRowCollection rows = _dataTable.Rows;
var lrows = from lrow in new LINQList <DataRow>(rows)
where (DateTime)lrow["SubmissionDate"] == pending.SubmissionDate && (string)lrow["Provider"] == pending.Provider && (string)lrow["AccountID"] == pending.AccountID
select lrow;
if (lrows.Count() == 0)
{
DataRow r = _dataTable.NewRow();
r["UserID"] = pending.User.ID;
r["StrategyID"] = pending.Strategy == null ? -1 : pending.Strategy.ID;
r["SubmissionDate"] = pending.SubmissionDate;
r["AttorneyID"] = pending.Attorney == null ? "" : pending.Attorney.ID;
r["Provider"] = pending.Provider;
r["AccountID"] = pending.AccountID;
rows.Add(r);
QuantApp.Kernel.Database.DB["CloudApp"].UpdateDataTable(_dataTable);
}
}
public static void UpdatePending(PALMPending pending)
{
string tableName = "PALM_Pending";
string searchString = "UserID LIKE '" + pending.User.ID + "' AND Provider LIKE '" + pending.Provider + "' AND AccountID LIKE '" + pending.AccountID + "'";
string targetString = null;
DataTable _dataTable = QuantApp.Kernel.Database.DB["CloudApp"].GetDataTable(tableName, targetString, searchString);
DataRowCollection rows = _dataTable.Rows;
List <PALMPending> ret = new List <PALMPending>();
if (rows.Count != 0)
{
foreach (DataRow row in rows)
{
row["StrategyID"] = pending.Strategy == null ? -1 : pending.Strategy.ID;
row["AttorneyID"] = pending.Attorney.ID;
row["Provider"] = pending.Provider;
row["AccountID"] = pending.AccountID;
if (pending.CreationDate != DateTime.MinValue || pending.CreationDate != DateTime.MaxValue)
{
row["CreationDate"] = pending.CreationDate;
}
}
}
QuantApp.Kernel.Database.DB["CloudApp"].UpdateDataTable(_dataTable);
}