public bool deleteAccount(string staffUsername)
{
bool result = false;
using (SqlConnection conn = DB.GetConnection())
{
string sql = "delete from account where username = @username";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@username", staffUsername);
try
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
result = cmd.ExecuteNonQuery() > 0;
}
}
finally
{
conn.Close();
}
}
return(result);
}