using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;

using SMWebServer;
using Sog;
using LitJson;
using SimpleHttpServer;
using MySql.Data.MySqlClient;
using System.IO;
using System.Drawing;
using ProtoCSStruct;

namespace SMWebServer
{
    public class delete_notice
    {
        private MySqlDB db;
        private SMWebServerConfig config;
        public void InitConnection()
        {
            config = SMWebServerUtils.GetServerConfig();
            db = new MySqlDB(config.dbname,
                config.dbip,
                config.dbuser,
                config.dbpassword
                );
        }
        public void Dodelete_notice(JsonData Jsondata, HttpResponse rsp, HttpRequest request, HttpQueryParams query)
        {
            var id = query.GetValue("id");


            string sqlStr = "SELECT * from notice ";
            if (!String.IsNullOrEmpty(id))
            {
                sqlStr += " WHERE id = " + id;
            }
            MySqlDataReader reader = db.ExecReader(sqlStr);

            //通知chat删除
            while (reader.Read())
            {

                var Id = reader.GetInt32("id");
                var popUp = reader.GetInt32("popUp");
                var realmlist = reader.GetString("realmlist");
                SSSysNoticeDel notice = new SSSysNoticeDel();
                notice.Id = int.Parse(id);
                notice.Noticetype = popUp == 1 ? NoticeType.Popup : NoticeType.Click;

                //SMWebServerUtils.GetPacketSender().SendToVersionServer((int)SSGameMsgID.CHATDelNOTICE, ref notice, 0, 0);

                //SMWebServerUtils.SendToWorld((int)SSGameMsgID.CHATDelNOTICE, ref notice, 0, 0, realmlist);
                 
            }
            reader.Close();
             

            //通知数据库删除
            var MySqlParameters = new List<MySqlParameter>(){
                     new MySqlParameter("?id", MySqlDbType.Int32) { Value = id }
            }.ToArray();

            string editSql = $"DELETE FROM notice WHERE  id=?id;";
            db.ExecNonQuery(editSql, MySqlParameters);

            db.Dispose();

            Jsondata["ret"] = 0;
            Jsondata["msg"] = "操作成功";
        }



        public void ProccessRequest(JsonData Jsondata, HttpResponse rsp, HttpRequest request, HttpQueryParams query)
        {
            InitConnection();

            Dodelete_notice(Jsondata, rsp, request, query);

            db.Dispose();
        }
    }
}