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);
}
}