public static List<Transaction> getTransactionForUserRefCode(int ShowID, int UserID, int refcode)
 {
     String moduleSettings = ModuleConfig.GetSettings();
     Fpp.Data.Transaction t = new Fpp.Data.Transaction(moduleSettings);
     DataSet ds = t.getTransactionsFor(ShowID, UserID, refcode);
     List<Transaction> translist = new List<Transaction>();
     foreach (DataRow row in ds.Tables[0].Rows)
     {
         translist.Add(new Transaction(row));
     }
     return translist;
 }
 /*
  * public static List<Transaction> getTransactionForShowUser(int ShowID, int UserID)
 {
     String moduleSettings = ModuleConfig.GetSettings();
     Data.Transaction t = new Fpp.WebModules.Data.Transaction(moduleSettings);
     DataSet ds = t.getTransactionsFor(ShowID, UserID, RefCode);
     List<Transaction> translist = new List<Transaction>();
     foreach (DataRow row in ds.Tables[0].Rows)
     {
         translist.Add(new Transaction(row));
     }
     return translist;
 }
  *
  * */
 public static List<Transaction> GetTransactionForShowUser(int Id)
 {
     String moduleSettings = ModuleConfig.GetSettings();
     Fpp.Data.Transaction t = new Fpp.Data.Transaction(moduleSettings);
     DataSet ds = t.getTransactionsFor(Id.ToString());
     List<Transaction> translist = new List<Transaction>();
     foreach (DataRow row in ds.Tables[0].Rows)
     {
         translist.Add(new Transaction(row));
     }
     return translist;
 }