private void addToolStripMenuItem1_Click(object sender, EventArgs e)
{
this.Close();
AddCategory Ac = new AddCategory(null);
Ac.Show();
}
private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
string id = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();
string query = "Select * from tblCategory where category_id=" + id;
DBConnection db = new DBConnection();
db.GetData(query);
DataTable dt = db.GetData(query);
if (dt.Rows.Count > 0)
{
Category c = new Category();
c.category_id = (int)dt.Rows[0]["category_id"];
c.category_name = (string)dt.Rows[0]["category_name"];
AddCategory category = new AddCategory(c);
category.Show();
}
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
string id = dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString();
string command = dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();
if (command.ToLower() == "delete")
{
try
{
if (MessageBox.Show("Are you sure to Delete", "message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
string deletequery = "delete from tblCategory where category_id=" + id;;
DBConnection db = new DBConnection();
db.executyQuery(deletequery);
MessageBox.Show("Category Successfully Deleted");
LoadDisplayCategory();
}
else
{
LoadDisplayCategory();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else if (command.ToLower() == "edit")
{
string query = "select * from tblCategory where category_id=" + id;;
DBConnection db = new DBConnection();
DataTable dt = db.GetData(query);
if (dt.Rows.Count > 0)
{
Category c = new Category();
c.category_id = (int)dt.Rows[0]["category_id"];
c.category_name = (string)dt.Rows[0]["category_name"];
this.Close();
AddCategory frmcategory = new AddCategory(c);
frmcategory.Show();
}
}
}