public int Insert(DataChart worker)
{
SqlCeCommand Insert = new SqlCeCommand("INSERT INTO Employees (Name, Sale) VALUES (@Name, @Sale)", Employees._connectionString);
Insert.Parameters.AddWithValue("@Name", worker.key);
Insert.Parameters.AddWithValue("@Sale", worker.value);
int returnQuery = Insert.ExecuteNonQuery();
return returnQuery;
}
public void FillRandom(int value)
{
Random rand = new Random();
for (int i = 0; i < value; i++)
{
string randomName = rand.Next(1, 1000000).ToString();
float randomSale = rand.Next(1, 100);
DataChart worker = new DataChart(randomName, randomSale);
this.Insert(worker);
}
}