private void button8_Click(object sender, EventArgs e)
{
// clear display result
dataGridView1.Rows.Clear();
string word = "";
// check if string is empty
UtilityClass.CheckIfEmpty(textBox2.Text);
// radio button product name is checked
if (radioButton1.Checked)
{
word = textBox2.Text.Trim();
var sqlquery = $"SELECT * FROM Product WHERE Product_Name = '{word}'";
QueryDataClass.QueryAllData(dataGridView1, sqlquery);
}
// if radio button price is checked
if (radioButton2.Checked)
{
word = textBox2.Text;
var price = Convert.ToDecimal(word);
var sqlquery = $"SELECT * FROM Product WHERE Cost_Price = '{price}'";
QueryDataClass.QueryAllData(dataGridView1, sqlquery);
}
}
// form loader
private void Form1_Load(object sender, EventArgs e)
{
// check start position
if (Start == 0)
{
button3.Enabled = false;
}
// query string
var sqlString = $"select* from Product order by Product_Name offset {Start} rows fetch next {Next} rows only;";
// reload result
QueryDataClass.QueryAllData(dataGridView1, sqlString);
}
// next button
private void button4_Click(object sender, EventArgs e)
{
// set next button visible
button3.Enabled = true;
//clear disaplay
dataGridView1.Rows.Clear();
// create pagination
Start = Start + 5;
// query string
var sqlString = $"select* from Product order by Product_Name offset {Start} rows fetch next {Next} rows only;";
var count = QueryDataClass.QueryAllData(dataGridView1, sqlString);
// enable prvious button
if (count == 0)
{
button4.Enabled = false;
}
}
// previous button
private void button3_Click(object sender, EventArgs e)
{
// clear display
dataGridView1.Rows.Clear();
// check if sart is more than 0
if (Start > 0)
{
Start = Start - 5;
var sqlString = $"select* from Product order by Product_Name offset {Start} rows fetch next {Next} rows only;";
var count = QueryDataClass.QueryAllData(dataGridView1, sqlString);
}
else if (Start == 0)
{
// disable previous button
button3.Enabled = false;
// Enable next button
button4.Enabled = true;
}
}
// delete button
private void button2_Click(object sender, EventArgs e)
{
// get id of selected item
var id = dataGridView1.SelectedCells[0].Value.ToString();
int value = int.Parse(id);
// database connection
database.DataBaseConnection();
// query string
var sqlString = $"DELETE FROM Product WHERE Id = {value}";
// query database
var result = database.QueryDatabase(sqlString);
result.ExecuteNonQuery();
// clear display result
dataGridView1.Rows.Clear();
// display new result
QueryDataClass.QueryAllData(dataGridView1, sqlString);
}
