protected void ImageButtonAnswer_Click(object sender, ImageClickEventArgs e)
{
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString);
SqlCommand sqlCmd = new SqlCommand("sp_supportRequestAnswer", sqlConn);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add("@RequestId", SqlDbType.Int).Value = GridViewRequests.SelectedDataKey.Value;
sqlCmd.Parameters.Add("@Conversation", SqlDbType.NVarChar).Value = "پاسخ پشتیبانی:\n" + TextBoxAnswer.Text + "\n\n------------------------------\n\n" + TextBoxConversation.Text;
sqlCmd.Parameters.Add("@Status", SqlDbType.Int).Value = 2;
sqlConn.Open();
sqlCmd.ExecuteNonQuery();
SqlCommand sqlCmd2 = new SqlCommand("sp_supportRequestUnread", sqlConn);
sqlCmd2.CommandType = CommandType.StoredProcedure;
sqlCmd2.Parameters.Add("@UserId", SqlDbType.Int).Value = Convert.ToInt32(LabelRequestUserId.Text);
sqlCmd2.ExecuteNonQuery();
sqlCmd.Dispose();
sqlConn.Dispose();
GridViewRequests.DataBind();
PanelRequest.Visible = false;
}
protected void ImageButtonArchive_Click(object sender, ImageClickEventArgs e)
{
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString);
SqlCommand sqlCmd = new SqlCommand("sp_supportRequestArchive", sqlConn);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add("@RequestId", SqlDbType.Int).Value = GridViewRequests.SelectedDataKey.Value;
sqlConn.Open();
sqlCmd.ExecuteNonQuery();
sqlCmd.Dispose();
sqlConn.Dispose();
GridViewRequests.DataBind();
PanelRequestInfo.Visible = false;
}
protected void ImageButtonDelete_Click(object sender, ImageClickEventArgs e)
{
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString);
SqlCommand sqlCmd = new SqlCommand("sp_supportRequestDelete", sqlConn);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add("@RequestId", SqlDbType.Int).Value = GridViewRequests.SelectedDataKey.Value;
sqlConn.Open();
sqlCmd.ExecuteNonQuery();
DataTable dt = new DataTable();
DataSet ds = new DataSet();
SqlDataAdapter sda = new SqlDataAdapter("sp_userMenuRemindersCount", sqlConn);
sda.SelectCommand.CommandType = CommandType.StoredProcedure;
sda.SelectCommand.Parameters.Add("@UserId", SqlDbType.Int).Value = Convert.ToInt32(Session["UserId"]);
sda.Fill(ds);
dt = ds.Tables[0];
if (Convert.ToInt32(dt.Rows[0]["SupportRequestsCount"].ToString()) != 0)
{
LabelRequestsNewCount.Visible = true;
LabelRequestsNewCount.Text = "(" + dt.Rows[0]["SupportRequestsCount"].ToString() + " درخواست پاسخ داده شده)";
}
else
{
LabelRequestsNewCount.Visible = false;
}
sda.Dispose();
sqlCmd.Dispose();
sqlConn.Dispose();
GridViewRequests.DataBind();
PanelRequestInfo.Visible = false;
}