private void txtFilt_TextChanged(object sender, EventArgs e)
{
BlackberryData db = new BlackberryData();
if (txtFilt.Text.Equals(""))
{
DataTable dt = db.GetProductsList();
dgvProducts.DataSource = dt;
}
else
{
DataTable dt = db.GetProductsInFilt(txtFilt.Text);
dgvProducts.DataSource = dt;
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (addNew)
{
string name = txtName.Text;
float price = float.Parse(txtPrice.Text);
BlackberryData db = new BlackberryData();
if (db.AddNewProduct(new Blackberry(lambID, name, manu, model, price, releasedYear)))
{
MessageBox.Show("Save successful");
}
else
{
MessageBox.Show("Save fail.");
}
setData();
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
string id = txtID.Text;
string name = txtName.Text;
string manu = txtManufacturer.Text;
string model = txtModel.Text;
float price = float.Parse(txtPrice.Text);
string year = txtYear.Text;
BlackberryData db = new BlackberryData();
if (db.UpdateProducts(new Blackberry(id, name, price)))
{
MessageBox.Show("Update successful");
}
else
{
MessageBox.Show("Update fail.");
}
setData();
}
private void setData()
{
BlackberryData db = new BlackberryData();
DataTable dt = db.GetProductsList();
txtID.DataBindings.Clear();
txtName.DataBindings.Clear();
txtManufacturer.DataBindings.Clear();
txtModel.DataBindings.Clear();
txtPrice.DataBindings.Clear();
txtYear.DataBindings.Clear();
txtID.DataBindings.Add("Text", dt, "LambID");
txtName.DataBindings.Add("Text", dt, "LambName");
txtManufacturer.DataBindings.Add("Text", dt, "Manufacturer");
txtModel.DataBindings.Add("Text", dt, "Model");
txtPrice.DataBindings.Add("Text", dt, "Price");
txtYear.DataBindings.Add("Text", dt, "ReleasedYear");
dgvProducts.DataSource = dt;
dgvProducts.Rows[0].Selected = true;
}
