/// <summary>
/// Gets the list of guids of busy markets.
///
/// Returns the guids for those markets with submissions at them. This is used to exclude them from the marketlist filter
/// </summary>
/// <returns>
/// The list of guids of busy markets.
/// </returns>
public static List<string> GetListOfGuidsOfBusyMarkets(LayoutPanelBase CurrentLayout)
{
List<string> BusyMarkets = new List<string> ();
List<string> result = CurrentLayout.GetListOfStringsFromSystemTable (TABLE_ReplyTypes, 1, String.Format ("2|{0}", CODE_NO_REPLY_YET), false);
if (result != null && result.Count > 0) {
List<TransactionBase> allsubs = LayoutDetails.Instance.TransactionsList.GetEventsForLayoutGuid
("*", String.Format (" and data7='{0}' and {1}='{2}'", result[0], TransactionsTable.TYPE, TransactionSubmission.T_SUBMISSION));
// this should give us a list of EVERY submission that has not received a VALID REPLY.
// HENCE> Every market on this list would be BUSY
foreach (TransactionBase sub in allsubs) {
// if (sub is TransactionSubmission)
{
// NewMessage.Show ("Adding " + sub.Display);
BusyMarkets.Add (((TransactionSubmission)sub).MarketGuid);
}
// else
// {
// NewMessage.Show ("Not adding " + sub.Display);
// }
}
}
return BusyMarkets;
}
/// <summary>
/// Returns the number of acceptances
/// </summary>
/// <returns>
/// The acceptances.
/// </returns>
public static int CountAcceptances(LayoutPanelBase CurrentLayout, string ProjectGUID)
{
int count = 0;
string filter= "";
List<string> result = CurrentLayout.GetListOfStringsFromSystemTable (TABLE_ReplyTypes, 1, String.Format ("2|{0}", CODE_ACCEPTANCE), false);
if (result != null && result.Count > 0) {
foreach (string s in result)
{
string SPACE ="";
if (filter != "")
{
SPACE = " or ";
}
filter = filter + SPACE + String.Format ("data7='{0}'", s);
}
//NewMessage.Show (filter);
List<TransactionBase> allsubs = LayoutDetails.Instance.TransactionsList.GetEventsForLayoutGuid
("*",String.Format(" and ({0}) and {1}='{2}' and {3}='{4}'", filter, TransactionsTable.TYPE, TransactionSubmission.T_SUBMISSION,
TransactionsTable.DATA1_LAYOUTGUID, ProjectGUID));
if (allsubs != null)
{
count = allsubs.Count;
}
}
return count;
}