public string GetPendingPayments(string emailAddress)
{
SQLLogger.LogInfo(string.Format("GetPendingPayments({0})", emailAddress));
SQL sql = new SQL();
DataSet ds = sql.GetPendingPayments(emailAddress);
if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
return "";
// cheat for now and only return the first row
DataRow row = ds.Tables[0].Rows[0];
return string.Format("<Payment><BillParticipantId>{0}</BillParticipantId><TransactionId>{1}</TransactionId><BillParticipantEmail>{2}</BillParticipantEmail></Payment>", row["BillParticipantId"], SecurityElement.Escape((string)row["TransactionId"]), SecurityElement.Escape((string)row["BillParticipantEmail"]));
}
