public static List <CreateProject> GetAll() { List <CreateProject> allCreateProjects = new List <CreateProject> { }; MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT * FROM createprojects;"; var rdr = cmd.ExecuteReader() as MySqlDataReader; while (rdr.Read()) { int id = rdr.GetInt32(0); string projectName = rdr.GetString(1); string userName = rdr.GetString(2); string tags = rdr.GetString(3); CreateProject newCreateProject = new CreateProject(projectName, userName, tags); allCreateProjects.Add(newCreateProject); } conn.Close(); if (conn != null) { conn.Dispose(); } return(allCreateProjects); }
public override bool Equals(System.Object otherCreateProject) { if (!(otherCreateProject is CreateProject)) { return(false); } else { CreateProject newCreate = (CreateProject)otherCreateProject; bool idEquality = this.Id == newCreate.Id; bool nameOneEquality = this.ProjectName == newCreate.ProjectName; bool nameTwoEquality = this.UserName == newCreate.UserName; bool tagsEquality = this.Tags == newCreate.Tags; return(idEquality && nameOneEquality && nameTwoEquality && tagsEquality); } }