Bplus/ApiWeb/ApiProcessToken/Controllers/luckySix.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Net.Http;

using ResfullApi.Models;
using Newtonsoft.Json;
using System.Data;
using Newtonsoft.Json.Linq;
using Microsoft.AspNetCore.Mvc;

namespace ApiProcess.Controllers
{
    [ApiController]
    [Route("api/[controller]/[action]/data")]
    public class luckySix : ControllerBase
    {
        static readonly log4net.ILog logger = log4net.LogManager.GetLogger(typeof(luckySix));
        // {"users":"50940227941","serviceId":"30","listNumber":"1$12$23%65$23$23","money":"30","times":"3"}
        [HttpPost]
        public IActionResult bet([FromBody] dynamic sendData)
        {
            ////log4net.ILog logger = log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
            ////log4net.Config.XmlConfigurator.Configure();
            lksObjBetResponse response = new lksObjBetResponse();
            response.status = "-1";
            response.message = "Err unknow";
            try
            {
                lksObjBetResquest data = JsonConvert.DeserializeObject<lksObjBetResquest>(sendData.ToString());
                logger.Info("New request income bet :" + data.ToString());
                DataSet ds_regist = lksDataAccess.LKS_BET(data.users, data.serviceid, data.listNumber, data.money, data.times);
                logger.Info("Call database LKS_BET success:");
                if (ds_regist != null & ds_regist.Tables[0].Rows.Count > 0)
                {
                    response.listBetId = ds_regist.Tables[0].Rows[0]["listBetId"].ToString();
                    response.status = ds_regist.Tables[0].Rows[0]["status"].ToString();
                    response.message = ds_regist.Tables[0].Rows[0]["message"].ToString();
                    response.listRandomId = ds_regist.Tables[0].Rows[0]["listRandomId"].ToString();
                    response.bet_coin = ds_regist.Tables[0].Rows[0]["bet_coin"].ToString();
                    response.cash_coin = ds_regist.Tables[0].Rows[0]["cash_coin"].ToString();
                }


            }
            catch (Exception ex)
            {

                logger.Info("Err:" + ex.ToString());
            }
            logger.Info("Responase to web: " + response.ToString());
            return Ok(response);
        }

        //lay danh sach cac bet gan nhat
        //{"users":"50940227941","serviceId":"30","status":"0","date":"-1","top":"100","isWin":"1"}
        [HttpPost]
        public IActionResult getListBet([FromBody] dynamic sendData)
        {
            //log4net.ILog logger = log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
            //log4net.Config.XmlConfigurator.Configure();
            lksObjGetBetResponse response = new lksObjGetBetResponse();
            response.status = "-1";
            response.message = "Err unknow";
            logger.Info("New request income getListBet :" + sendData.ToString());

            
            try
            {
                var userObj = JObject.Parse(sendData.ToString());
                string users = Convert.ToString(userObj["users"]);
                string serviceid = Convert.ToString(userObj["serviceId"]);
                string status = Convert.ToString(userObj["status"]);
                string date = Convert.ToString(userObj["date"]);
                string top = Convert.ToString(userObj["top"]);
                string isWin = Convert.ToString(userObj["isWin"]);

                if (string.IsNullOrEmpty(users)) users = "-1";
                if (string.IsNullOrEmpty(serviceid)) serviceid = "-1";
                if (string.IsNullOrEmpty(status)) status = "-1";
                if (string.IsNullOrEmpty(date)) date = "-1";
                if (string.IsNullOrEmpty(top)) top = "-1";
                if (string.IsNullOrEmpty(isWin)) isWin = "0";

                DataSet ds_regist = lksDataAccess.LKS_BET_GET_LIST(users, serviceid, status, date, top, isWin);
                logger.Info("Call database LKS_BET_GET_LIST success:");
                if (ds_regist != null & ds_regist.Tables[0].Rows.Count > 0)
                {
                    response.status = "0";
                    response.message = "Get list Bet of user is success";
                    response.listBet = new lksObjBet[ds_regist.Tables[0].Rows.Count];
                    for (int j = 0; j < ds_regist.Tables[0].Rows.Count; j++)
                    {
                        lksObjBet obj = new lksObjBet();
                        obj.id = ds_regist.Tables[0].Rows[j]["id"].ToString();
                        obj.userId = ds_regist.Tables[0].Rows[j]["USERS_ID"].ToString();
                        obj.listNumber = ds_regist.Tables[0].Rows[j]["STR"].ToString();
                        obj.listNumberSort = ds_regist.Tables[0].Rows[j]["STR_SORT"].ToString();
                        obj.randomResult = ds_regist.Tables[0].Rows[j]["randomResult"].ToString();
                        obj.dateBet = ds_regist.Tables[0].Rows[j]["VSYSDATE"].ToString();
                        obj.typeBet = ds_regist.Tables[0].Rows[j]["TYPE"].ToString();
                        obj.moneyBet = ds_regist.Tables[0].Rows[j]["BET_MONEY"].ToString();
                        obj.moneyWin = ds_regist.Tables[0].Rows[j]["MONEY_WIN"].ToString();
                        obj.randomId = ds_regist.Tables[0].Rows[j]["RANDOM_ID"].ToString();
                        obj.randomStatus = ds_regist.Tables[0].Rows[j]["RANDOM_STATUS"].ToString();
                        obj.randomStartDate = ds_regist.Tables[0].Rows[j]["RANDOM_START_DATE"].ToString();
                        obj.randomEndDate = ds_regist.Tables[0].Rows[j]["RANDOM_END_DATE"].ToString();
                        obj.randomSysDate = ds_regist.Tables[0].Rows[j]["RANDOM_SYS_DATE"].ToString();


                        //Thong tin usser
                        obj.users = ds_regist.Tables[0].Rows[0]["users"].ToString();
                        obj.serviceid = ds_regist.Tables[0].Rows[0]["serviceid"].ToString();
                        obj.fullName = ds_regist.Tables[0].Rows[0]["fullName"].ToString();
                        obj.sex = ds_regist.Tables[0].Rows[0]["sex"].ToString();
                        obj.address = ds_regist.Tables[0].Rows[0]["address"].ToString();
                        obj.provinceId = ds_regist.Tables[0].Rows[0]["provinceId"].ToString();
                        obj.cardNumber = ds_regist.Tables[0].Rows[0]["cardNumber"].ToString();
                        obj.email = ds_regist.Tables[0].Rows[0]["email"].ToString();
                        obj.company = ds_regist.Tables[0].Rows[0]["company"].ToString();
                        obj.description = ds_regist.Tables[0].Rows[0]["description"].ToString();
                        obj.picture = ds_regist.Tables[0].Rows[0]["picture"].ToString();
                        obj.sexNeed = ds_regist.Tables[0].Rows[0]["sexNeed"].ToString();
                        obj.birthday = ds_regist.Tables[0].Rows[0]["birthday"].ToString();
                        obj.height = ds_regist.Tables[0].Rows[0]["height"].ToString();


                        obj.weight = ds_regist.Tables[0].Rows[0]["weight"].ToString();
                        obj.work = ds_regist.Tables[0].Rows[0]["work"].ToString();




                        response.listBet[j] = obj;
                    }
                    
                }
                else
                {
                    response.status = "1";
                    response.message = "No data";
                }



            }
            catch (Exception ex)
            {

                logger.Info("Err:" + ex.ToString());
            }
            logger.Info("Responase to web: " + response.ToString());
            return Ok(response);
        }











        //{"users":"50940227941","serviceId":"30","date":"-1","top":"100"}
        [HttpPost]
        public IActionResult getTopUsersBet([FromBody] dynamic sendData)
        {
            //log4net.ILog logger = log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
            //log4net.Config.XmlConfigurator.Configure();
            usersObjProfileList response = new usersObjProfileList();
            
            logger.Info("New request income getListBet :" + sendData.ToString());


            try
            {
                var userObj = JObject.Parse(sendData.ToString());
                string users = Convert.ToString(userObj["users"]);
                string serviceid = Convert.ToString(userObj["serviceId"]);
                string date = Convert.ToString(userObj["date"]);
                string top = Convert.ToString(userObj["top"]);

                if (string.IsNullOrEmpty(users)) users = "-1";
                if (string.IsNullOrEmpty(serviceid)) serviceid = "-1";
                
                if (string.IsNullOrEmpty(date)) date = "-1";
                if (string.IsNullOrEmpty(top)) top = "-1";

                DataSet ds_regist = lksDataAccess.LKS_BET_GET_TOP_USERS(users, serviceid, date, top);
                logger.Info("Call database LKS_BET_GET_TOP_USERS success:");



                if (ds_regist != null & ds_regist.Tables[0].Rows.Count > 0)
                {

                    response.status = "0";
                    response.message = "Success";
                    response.rowsOnPage = ds_regist.Tables[0].Rows[0]["ROW_ON_PAGE"].ToString();
                    response.seqPage = ds_regist.Tables[0].Rows[0]["SEQ_PAGE"].ToString();
                    response.totalPage = ds_regist.Tables[0].Rows[0]["TOTAL_PAGE"].ToString();

                    response.listProfile = new usersObjProfile[ds_regist.Tables[0].Rows.Count];
                    for (int j = 0; j < ds_regist.Tables[0].Rows.Count; j++)
                    {
                        usersObjProfile obj = new usersObjProfile();
                        obj.id = ds_regist.Tables[0].Rows[j]["id"].ToString();
                        obj.users = ds_regist.Tables[0].Rows[j]["users"].ToString();
                        obj.serviceid = ds_regist.Tables[0].Rows[j]["serviceid"].ToString();
                        obj.fullName = ds_regist.Tables[0].Rows[j]["fullName"].ToString();
                        obj.sex = ds_regist.Tables[0].Rows[j]["sex"].ToString();
                        obj.address = ds_regist.Tables[0].Rows[j]["address"].ToString();
                        obj.provinceId = ds_regist.Tables[0].Rows[j]["provinceId"].ToString();
                        obj.cardNumber = ds_regist.Tables[0].Rows[j]["cardNumber"].ToString();
                        obj.email = ds_regist.Tables[0].Rows[j]["email"].ToString();
                        obj.company = ds_regist.Tables[0].Rows[j]["company"].ToString();
                        obj.description = ds_regist.Tables[0].Rows[j]["description"].ToString();
                        obj.picture = ds_regist.Tables[0].Rows[j]["picture"].ToString();
                        obj.sexNeed = ds_regist.Tables[0].Rows[j]["sexNeed"].ToString();
                        obj.birthday = ds_regist.Tables[0].Rows[j]["birthday"].ToString();
                        obj.height = ds_regist.Tables[0].Rows[j]["height"].ToString();


                        obj.weight = ds_regist.Tables[0].Rows[j]["weight"].ToString();
                        obj.work = ds_regist.Tables[0].Rows[j]["work"].ToString();
                        obj.isLike = ds_regist.Tables[0].Rows[j]["isLike"].ToString();
                        obj.usersId = ds_regist.Tables[0].Rows[j]["USER_ID"].ToString();
                        obj.totalPic = ds_regist.Tables[0].Rows[j]["PIC_TOTAL"].ToString();
                        obj.totalLike = ds_regist.Tables[0].Rows[j]["TOTALLIKE"].ToString();
                        obj.totalView = ds_regist.Tables[0].Rows[j]["TOTALVIEW"].ToString();

                        obj.lookingFor = ds_regist.Tables[0].Rows[j]["LOOKING_FOR"].ToString();


                        DataSet dsInterests = new DataSet();
                        dsInterests = usersDataAccess.USERS_GET_INTERESTS_BY_USER("-1", users, serviceid);
                        if (dsInterests != null & dsInterests.Tables[0].Rows.Count > 0)
                        {
                            obj.listInterests = new usersInterests[dsInterests.Tables[0].Rows.Count];
                            for (int k = 0; k < dsInterests.Tables[0].Rows.Count; k++)
                            {
                                usersInterests obj1 = new usersInterests();
                                obj1.id = dsInterests.Tables[0].Rows[k]["id"].ToString();
                                obj1.code = dsInterests.Tables[0].Rows[k]["code"].ToString();
                                obj1.name = dsInterests.Tables[0].Rows[k]["name"].ToString();
                                obj1.picture = dsInterests.Tables[0].Rows[k]["PICTURE"].ToString();

                                obj.listInterests[k] = obj1;


                            }
                        }


                        DataSet dsGift = new DataSet();
                        dsGift = usersDataAccess.USERS_GIFT_GET_BUY_TOTAL_USERS(users, serviceid);
                        if (dsGift != null & dsGift.Tables[0].Rows.Count > 0)
                        {
                            obj.listGift = new usersGift[dsGift.Tables[0].Rows.Count];
                            for (int n = 0; n < dsGift.Tables[0].Rows.Count; n++)
                            {
                                usersGift obj2 = new usersGift();
                                obj2.id = dsGift.Tables[0].Rows[n]["id"].ToString();
                                obj2.code = dsGift.Tables[0].Rows[n]["code"].ToString();
                                obj2.name = dsGift.Tables[0].Rows[n]["name"].ToString();
                                obj2.chargMoney = dsGift.Tables[0].Rows[n]["CHARGE_MONEY"].ToString();
                                obj2.chargeCode = dsGift.Tables[0].Rows[n]["CHARGE_CODE"].ToString();
                                obj2.coin = dsGift.Tables[0].Rows[n]["COIN"].ToString();
                                obj2.status = dsGift.Tables[0].Rows[n]["STATUS"].ToString();

                                obj.listGift[n] = obj2;


                            }
                        }


                        response.listProfile[j] = obj;
                    }

                }
                else
                {
                    response.status = "1";
                    response.message = "No data";
                }



            }
            catch (Exception ex)
            {

                logger.Info("Err:" + ex.ToString());
            }
            logger.Info("Responase to web: " + response.ToString());
            return Ok(response);
        }




        //{"users":"50940227941","serviceId":"30","totalDay":"30"}
        [HttpPost]
        public IActionResult getTotalBet([FromBody] dynamic sendData)
        {
            //log4net.ILog logger = log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
            //log4net.Config.XmlConfigurator.Configure();
            lksObjGetBetTotalResponse response = new lksObjGetBetTotalResponse();
            response.status = "-1";
            response.message = "Err unknow";
            string total_day = "30";
            try
            {
                lksObjGetBetTotalRequest data = JsonConvert.DeserializeObject<lksObjGetBetTotalRequest>(sendData.ToString());
                if (!string.IsNullOrEmpty(data.totalDay)) total_day = data.totalDay;
                logger.Info("New request income getTotalBet :" + data.ToString());
                DataSet ds_regist = lksDataAccess.LKS_BET_GET_TOTAL(data.users, data.serviceid, total_day);
                logger.Info("Call database LKS_BET_GET_TOTAL success:");
                if (ds_regist != null & ds_regist.Tables[0].Rows.Count > 0)
                {
                    response.status = "0";
                    response.message = "Get list Bet of user is success";
                    response.listTotalBet = new lksObjGetBetTotal[ds_regist.Tables[0].Rows.Count];
                    for (int j = 0; j < ds_regist.Tables[0].Rows.Count; j++)
                    {
                        lksObjGetBetTotal obj = new lksObjGetBetTotal();
                        obj.date = ds_regist.Tables[0].Rows[j]["vdate"].ToString();
                        obj.betWin = ds_regist.Tables[0].Rows[j]["is_win"].ToString();
                        obj.betLost = ds_regist.Tables[0].Rows[j]["is_lost"].ToString();
                        response.listTotalBet[j] = obj;
                    }

                }
                else
                {
                    response.status = "1";
                    response.message = "No data";
                }



            }
            catch (Exception ex)
            {

                logger.Info("Err:" + ex.ToString());
            }
            logger.Info("Responase to web: " + response.ToString());
            return Ok(response);
        }






        // {"randomId":"3","status":"-1","date":"02/02/2020"}
        [HttpPost]
        public IActionResult getListRandom([FromBody] dynamic sendData)
        {
            //log4net.ILog logger = log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
            //log4net.Config.XmlConfigurator.Configure();
            lksObjRandomGetResponse response = new lksObjRandomGetResponse();

            try
            {
                lksObjRandomGetRequest data = JsonConvert.DeserializeObject<lksObjRandomGetRequest>(sendData.ToString());
                logger.Info("New request income getListRandom :" + data.ToString());
                DataSet ds_regist = lksDataAccess.LKS_RANDOM_GET_BY_DATE(data.randomId,data.status,data.date);
                logger.Info("Call database LKS_RANDOM_GET_BY_DATE success:");
                if (ds_regist != null & ds_regist.Tables[0].Rows.Count > 0)
                {
                    response.status = "0";
                    response.message = "Get list Bet of user is success";
                    response.listRandom = new lksObjRandom[ds_regist.Tables[0].Rows.Count];
                    for (int j = 0; j < ds_regist.Tables[0].Rows.Count; j++)
                    {
                        lksObjRandom obj = new lksObjRandom();

                        obj.id = ds_regist.Tables[0].Rows[j]["id"].ToString();
                        obj.status = ds_regist.Tables[0].Rows[j]["STATUS"].ToString();
                        obj.randomStr = ds_regist.Tables[0].Rows[j]["STR"].ToString();
                        obj.dateStart = ds_regist.Tables[0].Rows[j]["DATE_START"].ToString();
                        obj.dateEnd = ds_regist.Tables[0].Rows[j]["DATE_END"].ToString();
                        obj.sysdate = ds_regist.Tables[0].Rows[j]["DATE_SYS"].ToString();


                        
                        response.listRandom[j] = obj;
                    }

                }
                else
                {
                    response.status = "1";
                    response.message = "No data";
                }



            }
            catch (Exception ex)
            {

                logger.Info("Err:" + ex.ToString());
            }
            logger.Info("Responase to web: " + response.ToString());
            return Ok(response);
        }





        // {"randomId":"3"}
        [HttpPost]
        public IActionResult getRandomById([FromBody] dynamic sendData)
        {
            //log4net.ILog logger = log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
            //log4net.Config.XmlConfigurator.Configure();
            lksObjRandomResponse response = new lksObjRandomResponse();
            
            try
            {
                lksObjRandomRequest data = JsonConvert.DeserializeObject<lksObjRandomRequest>(sendData.ToString());
                logger.Info("New request income getRandomById :" + data.ToString());
                DataSet ds_regist = lksDataAccess.LKS_RANDOM_GET(data.randomId);
                logger.Info("Call database LKS_RANDOM_GET success:");
                if (ds_regist != null & ds_regist.Tables[0].Rows.Count > 0)
                {
                    response.id = ds_regist.Tables[0].Rows[0]["id"].ToString();
                    response.status = ds_regist.Tables[0].Rows[0]["STATUS"].ToString();
                    response.randomStr = ds_regist.Tables[0].Rows[0]["STR"].ToString();
                    response.dateStart = ds_regist.Tables[0].Rows[0]["DATE_START"].ToString();
                    response.dateEnd = ds_regist.Tables[0].Rows[0]["DATE_END"].ToString();
                    response.sysdate = ds_regist.Tables[0].Rows[0]["DATE_SYS"].ToString();
                    
                    
                }


            }
            catch (Exception ex)
            {

                logger.Info("Err:" + ex.ToString());
            }
            logger.Info("Responase to web: " + response.ToString());
            return Ok(response);
        }


        [HttpPost]
        //{"users":"10","serviceId":"30","fromdDate":"01/01/2020","toDate":"01/10/2020" } 
        public IActionResult reportTotalBuyDate([FromBody] dynamic sendData)
        {
            //log4net.ILog logger = log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
            //log4net.Config.XmlConfigurator.Configure();
            lksReportTotalList response = new lksReportTotalList();
            response.status = "-1";
            response.message = "Err unknow";
            logger.Info("New request income report_total :" + sendData.ToString());


            try
            {

                var userObj = JObject.Parse(sendData.ToString());
                string users = Convert.ToString(userObj["users"]);
                string serviceid = Convert.ToString(userObj["serviceId"]);
                string fromdate = Convert.ToString(userObj["fromDate"]);
                string todate = Convert.ToString(userObj["toDate"]);

                if (string.IsNullOrEmpty(users)) users = "-1";
                if (string.IsNullOrEmpty(serviceid)) serviceid = "-1";
                if (string.IsNullOrEmpty(fromdate)) fromdate = "01/01/1990";
                if (string.IsNullOrEmpty(todate)) todate = "01/01/1990";


                DataSet ds_regist = lksDataAccess.LKS_REPORT_TOTAL(users, serviceid, fromdate, todate);
                logger.Info("Call database LKS_REPORT_TOTAL success:");
                if (ds_regist != null & ds_regist.Tables[0].Rows.Count > 0)
                {

                    response.status = "0";
                    response.message = "Success";
                    response.listOfDate = new lksReportTotalObj[ds_regist.Tables[0].Rows.Count];
                    for (int j = 0; j < ds_regist.Tables[0].Rows.Count; j++)
                    {
                        lksReportTotalObj obj = new lksReportTotalObj();
                        obj.date = ds_regist.Tables[0].Rows[j]["ngay"].ToString();
                        obj.totalBet = ds_regist.Tables[0].Rows[j]["total_bet"].ToString();
                        obj.totalBetWin = ds_regist.Tables[0].Rows[j]["total_bet_win"].ToString();
                        obj.totalBetNotWin = ds_regist.Tables[0].Rows[j]["total_bet_not_win"].ToString();
                        obj.totalCoins = ds_regist.Tables[0].Rows[j]["total_coins"].ToString();
                        obj.totalCoinsWin = ds_regist.Tables[0].Rows[j]["total_coins_win"].ToString();
                        obj.totalMoneyBuy = ds_regist.Tables[0].Rows[j]["total_money_buy"].ToString();
                        obj.totalCoinsBuy = ds_regist.Tables[0].Rows[j]["total_coins_buy"].ToString();
                        obj.totalMoneyChange = ds_regist.Tables[0].Rows[j]["total_money_change"].ToString();
                        obj.totalCoinsChange = ds_regist.Tables[0].Rows[j]["total_coins_change"].ToString();

                        response.listOfDate[j] = obj;
                    }

                }
                else
                {
                    response.status = "1";
                    response.message = "No data";
                }


            }
            catch (Exception ex)
            {

                logger.Info("Err:" + ex.ToString());
            }
            logger.Info("Responase to web: " + response.ToString());
            return Ok(response);
        }

        



    }
}