public List <userWeb> getAllNames()
{
List <userWeb> users = new List <userWeb>();
try
{
connection.Open();
MySqlCommand cmd = connection.CreateCommand();
cmd.CommandText = "SELECT * FROM user";
MySqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read() == true)
{
userWeb u = new userWeb();
u.id = int.Parse(dataReader["id"].ToString());
u.idUser = dataReader["userid"].ToString();
u.name = dataReader["name"].ToString();
u.url = dataReader["url"].ToString();
u.@checked = bool.Parse(dataReader["checked"].ToString());
u.date = dataReader["date"].ToString();
u.score = int.Parse(dataReader["score"].ToString());
users.Add(u);
}
users.GroupBy(x => x.idUser).Select(x => x.First()).OrderBy(x => x.name).ToList();
return(users);
}
catch (Exception e) { throw e; }
}
public List <userWeb> getAllNotChecked()
{
List <userWeb> users = new List <userWeb>();
connection.Open();
MySqlCommand cmd = connection.CreateCommand();
try
{
cmd.CommandText = "SELECT * FROM user WHERE checked=false";
MySqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read() == true)
{
userWeb u = new userWeb();
u.id = int.Parse(dataReader["id"].ToString());
u.idUser = dataReader["userid"].ToString();
u.name = dataReader["name"].ToString();
u.url = dataReader["url"].ToString();
u.@checked = bool.Parse(dataReader["checked"].ToString());
u.date = dataReader["date"].ToString();
u.score = int.Parse(dataReader["score"].ToString());
users.Add(u);
}
connection.Close();
return(users);
}
catch (Exception e)
{
throw e;
}
}
public void Post(userWeb user)
{
try
{
connection.Open();
MySqlCommand cmd = connection.CreateCommand();
cmd.CommandText = "INSERT INTO user(id,userid,name,date,score,url,checked) VALUES(@id,@userid,@name,@date,@score,@url,@checked)";
cmd.Parameters.Add("@id", MySqlDbType.Int64).Value = user.id;
cmd.Parameters.Add("@userid", MySqlDbType.String).Value = user.id;
cmd.Parameters.Add("@name", MySqlDbType.String).Value = user.name;
cmd.Parameters.Add("@date", MySqlDbType.String).Value = user.date;
cmd.Parameters.Add("@score", MySqlDbType.Int64).Value = user.score;
cmd.Parameters.Add("@url", MySqlDbType.String).Value = user.url;
cmd.Parameters.Add("@checked", MySqlDbType.Bit).Value = user.@checked;
cmd.ExecuteNonQuery();
connection.Close();
}
catch (Exception e) { throw e; }
}
