protected void btnDelete_Click(object sender, EventArgs e)
{
using (SqlConnection con = new SqlConnection(CS))
{
con.Open();
try
{
int COUNTRYID;
COUNTRYID = Convert.ToInt32(gdvCountry.SelectedRow.Cells[0].Text);
if (COUNTRYID > 0)
{
editPanel.Visible = false;
CountryDA.Delete(COUNTRYID);
lblMessage.Text = "Row Deleted successfully";
viewPanel.Visible = false;
Reset();
}
else
{
lblMessage.Text = "Please Select a Row to Delete the info";
}
}
catch (SqlException ex)
{
if (ex.Number == 547)
{
lblMessage.Text = $"{ex.Number} occured.Sorry, You can't delete this row because it has associated row that you need to delete first.";
}
}
}
}
// Delete Item
private void deleteMenu_Click(object sender, EventArgs e)
{
using (SqlConnection con = new SqlConnection(CS))
{
con.Open();
try
{
if (COUNTRYID > 0)
{
EditPanel.Visible = false;
CountryDA.Delete(this.COUNTRYID);
MessageBox.Show("Row Deleted successfully", "Deletd", MessageBoxButtons.OK, MessageBoxIcon.Information);
viewPanel.Visible = false;
Reset();
}
else
{
MessageBox.Show("Please Select a Row to Delete the info", "Select?", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
}
}
}
public ResultEntity <int> DeleteById(int id)
{
var validationResult = new ResultEntity <int>();
using (var countryDA = new CountryDA())
{
var ids = new int[] { id };
validationResult.Value = countryDA.Delete(ids);
if (validationResult.Value != 1)
{
validationResult.Warning.Add("Failed delete record Country with ID: " + id);
return(validationResult);
}
}
return(validationResult);
}
public void Delete(int countryId)
{
CountryDA.Delete(countryId);
}
