public static AdminTotals getAdminTotalsv2(int ShowID, int EnteredBy) { String moduleSettings = ModuleConfig.GetSettings(); Data.Reporting r = new 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 static AdminTotals getAdminTotals(int ShowID, int EnteredBy) { String moduleSettings = ModuleConfig.GetSettings(); UserShows us = new UserShows(); DataSet ds = us.getAllUsersForShow(ShowID); AdminTotals adminTotals = new AdminTotals(); foreach (DataRow row in ds.Tables[0].Rows) { UserShows usdetails = new UserShows(row); User u = new User(usdetails.Userid); Transaction trans = new Transaction(usdetails.Userid, ShowID); if (EnteredBy == trans.EnteredBy) { adminTotals.Entries++; adminTotals.Runs += DogClasses.countDogsInClassForShow(usdetails.Userid, ShowID); } } return adminTotals; }