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