public static AdminTotals getAdminTotals(int ShowID, int EnteredBy) { var us = new UserShows(); var ds = us.getAllUsersForShow(ShowID); var adminTotals = new AdminTotals(); foreach (DataRow row in ds.Tables[0].Rows) { var usdetails = new UserShows(row); var trans = new Transaction(usdetails.Userid, ShowID); if (EnteredBy != trans.EnteredBy) continue; adminTotals.Entries++; adminTotals.Runs += DogClasses.countDogsInClassForShow(usdetails.Userid, ShowID); } return adminTotals; }
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; }