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"])); }