protected void Approve_Command(object sender, CommandEventArgs e)
{
anm_Utility ut = new anm_Utility();
string[] commandArgs = e.CommandArgument.ToString().Split(new char[] { ',' });
string idc = commandArgs[0];
string idn = commandArgs[1];
string value = commandArgs[2];
//string approve = commandArgs[3];
string approve = "";
int nc = ut.GetCommentsNews(idn);
string strConn = ConfigurationManager.ConnectionStrings["anmcs"].ToString();
SqlConnection myConnection = new SqlConnection(strConn);
SqlCommand myCommand = new SqlCommand();
myCommand.Connection = myConnection;
myConnection.Open();
myCommand.CommandText = "SELECT approved FROM anm_Comments WHERE idcomment=" + idc;
SqlDataReader reader = myCommand.ExecuteReader();
while (reader.Read())
{
approve = reader["approved"].ToString();
}
myConnection.Close();
ut.ApproveComment(idc, value);
if (value == "true" && approve == "False")
{
ut.IcreaseComments(idn, nc + 1);
}
else if (value == "false" && approve == "True")
{
ut.IcreaseComments(idn, nc - 1);
}
Response.Redirect(Page.Request.Url.AbsolutePath.ToString() + "?p=AdminComments");
}
