public static AdminTotals getAdminTotalsv2(int ShowID, int EnteredBy) { String moduleSettings = ModuleConfig.GetSettings(); Fpp.Data.Reporting r = new Fpp.Data.Reporting(moduleSettings); DataSet ds = r.getTransactionDetails(ShowID, EnteredBy, 0); AdminTotals adminTotals = new AdminTotals(); adminTotals.Entries = ds.Tables[0].Rows.Count; foreach (DataRow row in ds.Tables[0].Rows) { int userid = Convert.ToInt32(row["UserID"]); DataSet ds2 = r.getClassesCountForDog(ShowID, userid); if (ds2.Tables[0].Rows.Count > 0) { int cnt = Convert.ToInt32(ds2.Tables[0].Rows[0]["Count"]); adminTotals.Runs += cnt; } } return adminTotals; }
public Reporting(DataRow row) : base() { _reporting = new Fpp.Data.Reporting(ModuleSettings); LoadFromRow(row); }