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