void UpdateMemberStatusByID(string status)
{
if (CheckIfMemberExists())
{
try
{
SqlConnection con = new SqlConnection(strcon);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("UPDATE tbl_member SET account_status='" + status + "' WHERE member_id='" + MembersID.Text.Trim() + "'", con);
cmd.ExecuteNonQuery();
con.Close();
GridMemberManagement.DataBind();
Response.Write("<script>alert('" + MembersName.Text.Trim() + "' + ' status successfully updated.' ); </script>");
}
catch (Exception ex)
{
Response.Write("<script>alert('" + ex.Message + "');</script>");
}
}
else
{
Response.Write("<script>alert('Invalid Member ID');</script>");
}
}
}//bool_CheckIfMemebrExists
void DeleteMemberByID()
{
if (CheckIfMemberExists())
{
try
{
SqlConnection con = new SqlConnection(strcon);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("DELETE from tbl_member WHERE member_id='" + MembersID.Text.Trim() + "'", con);
cmd.ExecuteNonQuery();
con.Close();
Response.Write("<script>alert('" + MembersName.Text.Trim() + "' + ' is successfully deleted.' ); </script>");
GridMemberManagement.DataBind();
}
catch (Exception ex)
{
Response.Write("<script>alert('" + ex.Message + "');</script>");
}
}
else
{
Response.Write("<script>alert('Invalid Member ID');</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
GridMemberManagement.DataBind();
}
