public List <Skater> GetSkaterList(SqlConnection dbconAPP, int seasonID, int isDrafted = 0) { List <Skater> tempList = new List <Skater>(); using (SqlCommand cmd = new SqlCommand("wbogSkaterList", dbconAPP)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@SeasonID", seasonID); cmd.Parameters.AddWithValue("@isDrafted", isDrafted); using (SqlDataReader dr = cmd.ExecuteReader()) { if (dr.HasRows) { while (dr.Read()) { Skater tempModel = new Skater(); tempModel.SkaterID = Convert.ToInt32(dr["SkaterID"].ToString()); tempModel.DerbyTeamID = Convert.ToInt32(dr["DerbyTeamID"].ToString()); tempModel.DerbyName = dr["DerbyName"].ToString(); tempModel.DerbyNumber = Convert.ToInt32(dr["DerbyNumber"].ToString()); tempModel.Position = dr["Position"].ToString(); tempModel.Photo = dr["Photo"].ToString(); tempModel.FirstName = dr["FirstName"].ToString(); tempModel.LastName = dr["LastName"].ToString(); tempList.Add(tempModel); } } } } return(tempList); }
public List <Skater> GetFantasyTeamSkaterList(SqlConnection dbconAPP, int seasonID, int fantasyTeamID) { List <Skater> tempList = new List <Skater>(); using (SqlCommand cmd = new SqlCommand("wbogFantasyTeamSkaterList", dbconAPP)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@SeasonID", seasonID); cmd.Parameters.AddWithValue("@FantasyTeamID", fantasyTeamID); using (SqlDataReader dr = cmd.ExecuteReader()) { if (dr.HasRows) { while (dr.Read()) { Skater tempModel = new Skater(); tempModel.DerbyTeamID = Convert.ToInt32(dr["DerbyTeamID"].ToString()); tempModel.DerbyTeamName = dr["DerbyTeamName"].ToString(); tempModel.DerbyTeamNameCode = dr["DerbyTeamNameCode"].ToString(); tempModel.DerbyTeamLogo = dr["DerbyTeamLogo"].ToString(); tempModel.SkaterID = Convert.ToInt32(dr["SkaterID"].ToString()); tempModel.DerbyName = dr["SkaterDerbyName"].ToString(); tempModel.DerbyNumber = Convert.ToInt32(dr["SkaterDerbyNumber"].ToString()); tempModel.Photo = dr["SkaterDerbyPhoto"].ToString(); tempModel.DraftPickNumber = Convert.ToInt32(dr["DraftPickNumber"].ToString()); tempList.Add(tempModel); } } } } return(tempList); }
public List <Skater> GetSkaterGameStats(SqlConnection dbconAPP, int seasonID, int leagueID, string startDate, string endDate) { List <Skater> returnList = new List <Skater>(); using (SqlCommand cmd = new SqlCommand("wbogSkaterGameStats", dbconAPP)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@SeasonID", seasonID); cmd.Parameters.AddWithValue("@LeagueID", leagueID); cmd.Parameters.AddWithValue("@StartDate", startDate); cmd.Parameters.AddWithValue("@EndDate", endDate); using (SqlDataReader dr = cmd.ExecuteReader()) { if (dr.HasRows) { while (dr.Read()) { Skater tempModel = new Skater(); tempModel.GameStatID = Convert.ToInt32(dr["GameStatID"].ToString()); tempModel.SkaterID = Convert.ToInt32(dr["SkaterID"].ToString()); tempModel.DerbyName = dr["DerbyName"].ToString(); tempModel.Photo = dr["Photo"].ToString(); tempModel.GameStatValue = Convert.ToDouble(dr["GameStatValue"].ToString()); tempModel.StatTypeValue = Convert.ToDouble(dr["StatTypeValue"].ToString()); tempModel.TotalSkaterGameStatValue = Convert.ToDouble(dr["TotalSkaterGameStatValue"].ToString()); tempModel.StatTypeID = Convert.ToInt32(dr["StatTypeID"].ToString()); tempModel.StatTypeName = dr["Name"].ToString(); tempModel.StatTypeNameCode = dr["NameCode"].ToString(); tempModel.GameDate = Convert.ToDateTime(dr["GameDate"].ToString()); tempModel.FantasyTeamID = Convert.ToInt32(dr["FantasyTeamID"].ToString()); tempModel.FantasyTeamRosterID = Convert.ToInt32(dr["FantasyTeamRosterID"].ToString()); returnList.Add(tempModel); } } } } return(returnList); }