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);
}
private void dataGridView2_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
var id = dataGridView2.Rows[e.RowIndex].Cells[0].Value.ToString();
// delete product from chart
cart.DeleteProductFromChart(id);
// display Message
MessageBox.Show("Prodcut Deleted");
// clear grid
dataGridView2.Rows.Clear();
// load cart product
QueryDataClass.LoadChartProduct(dataGridView2, textBox2);
}
// 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);
}
private void Checkout_Load(object sender, EventArgs e)
{
// load grid
dataGridView2.ColumnCount = 5;
dataGridView2.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
// rows heading
dataGridView2.Columns[0].Name = "Product Name";
dataGridView2.Columns[1].Name = "Product Name";
dataGridView2.Columns[3].Name = "Quantity";
dataGridView2.Columns[2].Name = "Total Price";
dataGridView2.Columns[4].Name = "DateAdded";
// create button
DataGridViewButtonColumn btn = new DataGridViewButtonColumn();
btn.HeaderText = "Action";
btn.Name = "button";
btn.Text = "Delete Item ";
btn.UseColumnTextForButtonValue = true;
// add button
dataGridView2.Columns.Add(btn);
// load cart product
QueryDataClass.LoadChartProduct(dataGridView2, textBox2);
}
private void chartItem()
{
QueryDataClass.LoadChartProduct(dataGridView2, textBox2);
}
