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(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(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(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(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); } } }