private void btnDelete_Click(object sender, EventArgs e)
{
DatabaseLibrary Obj = new DatabaseLibrary();
DialogResult Diag = new DialogResult();
Diag = MessageBox.Show("Do you want to Remove this data?", "Confirmation", MessageBoxButtons.YesNo);
if (Diag == DialogResult.Yes)
{
Obj.Connection();
Obj.Delete(@"DELETE FROM tblndc WHERE TripNum='" + int.Parse(lblTrip.Text) + "'");
Obj.Delete(@"DELETE FROM tbldocu WHERE TripNum='" + int.Parse(lblTrip.Text) + "'");
Obj.Delete(@"DELETE FROM tblsd WHERE TripNum='" + int.Parse(lblTrip.Text) + "'");
Obj.CloseConnection();
frm1.RefreshRDD();
this.Close();
}
else if (Diag == DialogResult.No)
{
}
}
private void listView1_DoubleClick(object sender, EventArgs e)
{
DatabaseLibrary Obj = new DatabaseLibrary();
DialogResult Diag = new DialogResult();
Diag = MessageBox.Show("Do you want to Remove this data?", "Confirmation", MessageBoxButtons.YesNo);
if (Diag == DialogResult.Yes)
{
Obj.Connection();
Obj.Delete(@"DELETE FROM tblaudit WHERE AuditNum='" + int.Parse(lblAuditNum.Text) + "'");
Obj.CloseConnection();
FillAuditData();
}
else if (Diag == DialogResult.No)
{
FillAuditData();
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
DialogResult dr = MessageBox.Show(this, "Are you sure to Delete this data?", "Confimation", MessageBoxButtons.YesNo, MessageBoxIcon.Stop);
if (dr == DialogResult.Yes)
{
Obj.Connection();
Obj.Delete(@"DELETE FROM tbltruck WHERE BodyNum = '" + lblBNum.Text + "'");
Obj.CloseConnection();
btnDelete.Visible = false;
FillListView();
}
else
{
btnDelete.Visible = false;
FillListView();
}
}
private void listView1_DoubleClick(object sender, EventArgs e)
{
DialogResult Diag = new DialogResult();
Diag = MessageBox.Show("Do you want to Remove this data?", "Confirmation", MessageBoxButtons.YesNo);
if (Diag == DialogResult.Yes)
{
Obj.Connection();
Obj.Delete(@"DELETE FROM tbluser WHERE UserName='******'");
Obj.CloseConnection();
txtUser.Text = string.Empty;
txtPass.Text = string.Empty;
lblUserPost.Text = string.Empty;
FillListData();
}
else if (Diag == DialogResult.No)
{
FillListData();
}
}
