protected void btnDelete_Click(object sender, EventArgs e)
{
try
{
var dataAccess = new HeroicData();
var result = dataAccess.ExecuteNonQuery(
query: "DELETE FROM [User] WHERE ID = @id;",
parameters: new List <HeroicData.Parameters>
{
new HeroicData.Parameters {
Name = "@id", Value = hidID.Value
}
});
if (result == 0)
{
lbl.Text = "Record not deleted";
lbl.Visible = true;
}
else
{
Response.Redirect("~/Default.aspx");
}
}
catch (Exception ex)
{
lbl.Text = "Something went wrong, Message: " + ex.Message;
lbl.Visible = true;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
var dataAccess = new HeroicData();
var result = dataAccess.ExecuteNonQuery(
query: "UPDATE [User] SET UserName = @userName, Email = @email, Mobile = @mobile, Password = @password WHERE ID = @id;",
parameters: new List <HeroicData.Parameters>
{
new HeroicData.Parameters {
Name = "@id", Value = hidID.Value
},
new HeroicData.Parameters {
Name = "@userName", Value = txtUserName.Text
},
new HeroicData.Parameters {
Name = "@email", Value = txtEmail.Text
},
new HeroicData.Parameters {
Name = "@mobile", Value = txtMobile.Text
},
new HeroicData.Parameters {
Name = "@password", Value = txtPassword.Text
},
});
if (result == 0)
{
lbl.Text = "Record not updated";
lbl.Visible = true;
}
else
{
Response.Redirect("~/Default.aspx");
}
}
catch (Exception ex)
{
lbl.Text = "Something went wrong, Message: " + ex.Message;
lbl.Visible = true;
}
}