public void GetAndUpdateTeam(V_PointScreen viewVong1) { BLL myBLL = new BLL(); Model.Team team = myBLL.GetTeam(teamID); if (team != null) { if (_preGottenTeam == null) { viewVong1.Diem = team.Score; viewVong1.TenDoi = team.Name; // _preGottenTeam = team; } else { if (team.Score != _preGottenTeam.Score) { viewVong1.Diem = team.Score; viewVong1.TenDoi = team.Name; } _preGottenTeam = team; } } }
public Model.Team GetTeam(string teamID) { int year = DateTime.UtcNow.Year; List <Model.Team> teams = (new DAL()).GetPoint(year); Model.Team myTeam = teams.Find(x => x.ID == teamID); return(myTeam); }
public List <Model.Team> GetPoint(int nam) { SqlDataReader reader = null; try { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "exec GetPoint @nam='" + nam + "'"; cmd.Connection = connection; // List <Model.Team> teamS = new List <Model.Team>(); // reader = cmd.ExecuteReader(); while (reader.Read()) { string teamID = reader.GetString(0); string teamName = reader.GetString(1); int score = 0; if (!reader.IsDBNull(2)) { score = reader.GetInt32(2); } string round1State = reader.GetString(3); string round2State = reader.GetString(4); string round3State = reader.GetString(5); DateTime dateTime = reader.GetDateTime(6); // Model.Team team = new Model.Team(); team.ID = teamID; team.Name = teamName; team.Score = score; team.Round1State = round1State; team.Round2State = round2State; team.Round3State = round3State; team.LastModified = dateTime; // teamS.Add(team); } // reader.Close(); connection.Close(); return(teamS); } catch { reader.Close(); connection.Close(); return(null); } }
public Model.Team GetTeam(string teamId) { SqlDataReader reader = null; Model.Team team = null; try { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "exec GetTeam @id='" + teamId + "'"; cmd.Connection = connection; // //List<Model.Team> teamS = new List<Model.Team>(); // reader = cmd.ExecuteReader(); if (reader.Read()) { string teamID = reader.GetString(0); string teamName = reader.GetString(1); int score = reader.GetInt32(2); string round1State = reader.GetString(3); string round2State = reader.GetString(4); string round3State = reader.GetString(5); DateTime dateTime = reader.GetDateTime(6); // team = new Model.Team(); team.ID = teamID; team.Name = teamName; team.Round1State = round1State; team.Round2State = round2State; team.Round3State = round3State; team.LastModified = dateTime; // //teamS.Add(team); } // reader.Close(); connection.Close(); return(team); } catch { reader.Close(); connection.Close(); return(null); } }