using System;
using System.Collections.Generic;
using System.Diagnostics;
using System.Linq;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Logging;
using Library;
using LitJson;
using System.Data;
using MySystem.Models.Main;

namespace MySystem.Controllers
{
    public class HomeController : Controller
    {
        private readonly ILogger<HomeController> _logger;

        public HomeController(ILogger<HomeController> logger)
        {
            _logger = logger;
        }

        public IActionResult Index()
        {
            return View();
        }

        public string test()
        {
            // List<int> MerchantIds = new List<int>();
            // MerchantIds.Add(5);
            // foreach(int MerchantId in MerchantIds)
            // {
            //     RedisDbconn.Instance.AddList("MerchantConfirmHdQueue", "{\"MerchantId\":\"" + MerchantId + "\"}");
            // }
            // TianYuVoiceHelper.Instance.doSomething(DateTime.Now.ToString("yyyyMMddHHmmssfff"),"2023100701","100");
            // MqLinksHelper.Instance.doSomething("LKB01230600250000585","100");

            WebCMSEntities db = new WebCMSEntities();
            Dictionary<string, decimal> ids = new Dictionary<string, decimal>();
            ids.Add("2023110210011368216017215", 262.47M);
            ids.Add("2023110209582965570227565", 251.64M);
            ids.Add("2023110209574326337435601", 251.64M);
            ids.Add("2023110209560893881718314", 251.65M);
            ids.Add("2023110209543045040095492", 262.47M);
            ids.Add("2023110120300992564524492", 229.98M);
            ids.Add("2023110117085160175731898", 197.50M);
            ids.Add("2023110211572884957467004", 284.14M);
            ids.Add("2023110120413202804978303", 229.95M);
            ids.Add("2023110420031422808138102", 216.61M);
            ids.Add("2023110209551553040540156", 251.64M);
            ids.Add("2023110113114323483481218", 175.83M);
            ids.Add("2023110119412078375206313", 208.34M);
            ids.Add("2023110119333924371118894", 208.32M);
            ids.Add("2023110100013510004332936", 165.01M);
            ids.Add("2023110100001381586035192", 175.85M);
            ids.Add("2023110316204063871545838", 54.15M);
            ids.Add("2023110117044613033713627", 197.49M);
            ids.Add("2023103116455918116251045", 132.51M);
            ids.Add("2023110115043281646491586", 186.68M);
            foreach(string orderno in ids.Keys)
            {
                decimal cur = ids[orderno];
                ConsumerOrders order = db.ConsumerOrders.FirstOrDefault(m => m.OrderNo == orderno) ?? new ConsumerOrders();
                order.CurDivi = cur;
                RedisDbconn.Instance.AddList("ConsumerOrdersHd:Divi:" + order.PayMode + ":" + order.MerchantId, order);
            }
            db.Dispose();            

            return "ok";
        }

        public string bindapp(int mid)
        {
            // DataTable dt = CustomerSqlConn.dtable("select Id,MchtNo from MerchantAddInfo where HdStatus=3 and CreateDate>='2023-10-01 00:00:00' and MchtNo!='' and MchtNo is not null", AppConfig.Base.SqlConnStr);
            // DataTable dt = CustomerSqlConn.dtable("select Id,MchtNo from MerchantAddInfo where Id=" + mid, AppConfig.Base.SqlConnStr);
            // foreach(DataRow dr in dt.Rows)
            // {
            //     CheckWeChatSignService.Instance.StartDo(new QueryMerchantStatus()
            //     {
            //         MerchantId = dr["Id"].ToString(),
            //         MerchantNo = dr["MchtNo"].ToString(),
            //     });
            // }

            Models.Main1.WebCMSEntities db1 = new Models.Main1.WebCMSEntities();
            WebCMSEntities db = new WebCMSEntities();
            MerchantAddInfo merchantadd = db.MerchantAddInfo.FirstOrDefault(m => m.Id == 1147);
            MerchantInfo merchant = db.MerchantInfo.FirstOrDefault(m => m.Id == 1147);
            string pwd = "417027";
            merchant.LoginPwd = function.MD532(pwd);
            Models.Main1.MerchantLoginInfo info = db1.MerchantLoginInfo.FirstOrDefault(m => m.LoginMobile == merchantadd.MobilePhone);
            if (info == null)
            {
                info = db1.MerchantLoginInfo.Add(new Models.Main1.MerchantLoginInfo()
                {
                    LoginMobile = merchantadd.MobilePhone,
                }).Entity;
                db1.SaveChanges();
            }
            info.LoginPwd = function.MD532(pwd);
            db1.SaveChanges();
            Models.Main1.MerchantAccountLinkInfo infolink = db1.MerchantAccountLinkInfo.FirstOrDefault(m => m.LoginId == info.Id && m.MerchantId == merchantadd.Id && m.Kind == 2);
            if (infolink == null)
            {
                infolink = db1.MerchantAccountLinkInfo.Add(new Models.Main1.MerchantAccountLinkInfo()
                {
                    LoginId = info.Id,
                    MerchantId = merchantadd.Id,
                    Kind = 2,
                }).Entity;
                db1.SaveChanges();
            }
            db1.Dispose();
            db.Dispose();

            return "ok";
        }
    }
}