public IActionResult PostTblLeague(ConfirmLeague confrimLeague) { _context.Database.ExecuteSqlCommand("use Gambling_App; TRUNCATE Table tbl_confirmLeague;"); _context.Database.ExecuteSqlCommand("use Gambling_App; TRUNCATE Table tbl_preUpcomingEvent;"); foreach (var item in confrimLeague.LeagueList) { TblConfirmLeague confirmLeague = new TblConfirmLeague() { LeagueId = item.LeagueId, RapidLeagueId = item.RapidLeagueId, Active = true }; _context.TblConfirmLeague.Add(confirmLeague); _context.SaveChanges(); var result = _context.TblUpcomingEvent.Find(item.LeagueId); TblPreUpcomingEvent preUpcomingEvent = new TblPreUpcomingEvent { RapidEventId = result.RapidEventId, LeagueId = result.LeagueId, HomeTeamId = result.HomeTeamId, AwayTeamId = result.AwayTeamId, EventDate = result.EventDate, EventTime = result.EventTime, Active = result.Active }; _context.TblPreUpcomingEvent.Add(preUpcomingEvent); _context.SaveChanges(); } return(Ok(new { message = "Successfully Inserted" })); }
public IActionResult Lock(decimal id) { TblUser tblUser = _context.TblUser.Find(id); tblUser.Username = tblUser.Username; tblUser.Password = tblUser.Password; tblUser.Lock = true; tblUser.RoleId = tblUser.RoleId; tblUser.Mobile = tblUser.Mobile; tblUser.SharePercent = tblUser.SharePercent; tblUser.BetLimitForMix = tblUser.BetLimitForMix; tblUser.BetLimitForSingle = tblUser.BetLimitForSingle; tblUser.CreatedBy = tblUser.CreatedBy; tblUser.CreatedDate = tblUser.CreatedDate; _context.SaveChanges(); return(Ok(new { Message = "Successfully locked" })); }
public IActionResult BettingPost(UserBetting userBetting) { var user_id = User.FindFirst("userId")?.Value; TblGambling tblGambling = new TblGambling { PostingNo = userBetting.PostingNo, TransactionTypeId = 10, GamblingTypeId = userBetting.GamblingTypeId, EventId = userBetting.EventId, RapidEventId = userBetting.RapidEventId, TeamCount = userBetting.TeamCount, Amount = userBetting.Amount, UserId = userBetting.UserId, Active = true }; _context.TblGambling.Add(tblGambling); _context.SaveChanges(); var gamblingId = tblGambling.GamblingId; foreach (var item in userBetting.Details) { TblGamblingDetails gamblingDetails = new TblGamblingDetails { GamblingId = gamblingId, LeagueId = item.LeagueId, FootballTeamId = item.FootballTeamId, Under = item.Under, Overs = item.Overs, BodyOdd = item.BodyOdd, GoalOdd = item.GoalOdd }; _context.TblGamblingDetails.Add(gamblingDetails); _context.SaveChanges(); } TblUserPosting userPosting = new TblUserPosting() { PostingNo = userBetting.PostingNo, TransactionTypeId = 10, UserId = userBetting.UserId, Inward = 0, Outward = userBetting.Amount, Active = true, CreatedBy = Decimal.Parse(user_id), CreatedDate = DateTime.Now }; _context.TblUserPosting.Add(userPosting); _context.SaveChanges(); var parentId = _context.TblUser.Where(a => a.UserId == userBetting.UserId).First().CreatedBy; TblUserPosting parent_userPosting = new TblUserPosting() { PostingNo = userBetting.PostingNo, TransactionTypeId = 9, UserId = parentId, Inward = userBetting.Amount, Outward = 0, Active = true, CreatedBy = Decimal.Parse(user_id), CreatedDate = DateTime.Now }; _context.TblUserPosting.Add(parent_userPosting); _context.SaveChanges(); return(Ok(new { message = "Betting Successfully" })); }
public IActionResult PutTblUser(decimal id, Commission tblUser) { if (id != tblUser.UserId) { return(BadRequest()); } var userRole = User.FindFirst("roleId")?.Value; var userId = User.FindFirst("userId")?.Value; if (!TblUserExists(id)) { return(NotFound()); } else { //Update user information //Admin if (Convert.ToInt32(userRole) == 1) { TblUser editUser = _context.TblUser.Find(id); editUser.Username = tblUser.Username; editUser.Mobile = tblUser.Mobile; editUser.Password = tblUser.Password; editUser.RoleId = tblUser.RoleId; editUser.Lock = false; editUser.SharePercent = tblUser.SharePercent; editUser.BetLimitForMix = tblUser.BetLimitForMix; editUser.CreatedBy = Decimal.Parse(userId); editUser.CreatedDate = DateTime.Now; _context.SaveChanges(); //Find commissions of current logged user and its created user var tblUser1 = _context.TblUserCommission.Where(a => a.UserId == Decimal.Parse(userId) && a.SubUserId == id) .Select(a => a.UserCommissionId) .ToList(); //Delete previous user commissions foreach (var item in tblUser1) { TblUserCommission editUser1 = _context.TblUserCommission.Find(item); _context.TblUserCommission.Remove(editUser1); _context.SaveChanges(); } //Created new user commissions foreach (var s in tblUser.commission) { TblUserCommission userCommission = new TblUserCommission(); userCommission.UserCommissionTypeId = s.CommissionTypeId; userCommission.UserId = Decimal.Parse(userId); userCommission.UserCommission = 0; userCommission.SubUserId = id; userCommission.SubUserCommission = s.SubUserCommission; _context.TblUserCommission.Add(userCommission); } _context.SaveChanges(); }//admin //Other user(seniorMaster,Master,Agent) else { TblUser editUser = _context.TblUser.Find(id); editUser.Username = tblUser.Username; editUser.Mobile = tblUser.Mobile; editUser.Password = tblUser.Password; editUser.RoleId = tblUser.RoleId; editUser.Lock = false; editUser.SharePercent = tblUser.SharePercent; editUser.BetLimitForMix = tblUser.BetLimitForMix; editUser.CreatedBy = Decimal.Parse(userId); editUser.CreatedDate = DateTime.Now; _context.SaveChanges(); //Find commissions of current logged user and its created user var tblUser1 = _context.TblUserCommission.Where(a => a.UserId == Decimal.Parse(userId) && a.SubUserId == id) .Select(a => a.UserCommissionId) .ToList(); //Delete previous user commissions foreach (var item in tblUser1) { TblUserCommission editUser1 = _context.TblUserCommission.Find(item); _context.TblUserCommission.Remove(editUser1); _context.SaveChanges(); } //Get previous user commissions var prevCommission = _context.TblUserCommission.Where(a => a.SubUserId == Decimal.Parse(userId)) .Select(c => new { c.UserCommissionTypeId, c.SubUserCommission }) .ToDictionary(c => c.UserCommissionTypeId, c => c.SubUserCommission); //Create new user commissions foreach (var s in tblUser.commission) { TblUserCommission userCommission = new TblUserCommission(); userCommission.UserCommissionTypeId = s.CommissionTypeId; userCommission.UserId = Decimal.Parse(userId); userCommission.UserCommission = prevCommission.ElementAt(1).Value - s.SubUserCommission; userCommission.SubUserId = id; userCommission.SubUserCommission = s.SubUserCommission; _context.TblUserCommission.Add(userCommission); } _context.SaveChanges(); } //other } //user id exists return(Ok()); }
public IActionResult AddBalance(decimal id, [FromBody] Balance balance) { //Created user's balance var user_id = User.FindFirst("userId")?.Value; DateTime moment = DateTime.Now; TblUserPosting userPosting = new TblUserPosting(); var role = _context.TblUser.Where(a => a.UserId == id).First().RoleId; var year = moment.Year; var month = moment.Month; var day = moment.Day; var hour = moment.Hour; var minute = moment.Minute; var second = moment.Second; var str = "UB" + id.ToString() + role.ToString() + year.ToString() + month.ToString() + day.ToString() + hour.ToString() + minute.ToString() + second.ToString(); userPosting.UserId = id; userPosting.PostingNo = str; userPosting.TransactionTypeId = 1; userPosting.Inward = balance.Amount; userPosting.Outward = 0; userPosting.Active = true; userPosting.CreatedBy = Decimal.Parse(user_id); userPosting.CreatedDate = DateTime.Now; _context.TblUserPosting.Add(userPosting); _context.SaveChanges(); //Created user' balance TblUserBalance userBalance = new TblUserBalance(); userBalance.PostingNo = str; userBalance.TransactionTypeId = 1; userBalance.UserId = id; userBalance.Inward = Convert.ToInt32(balance.Amount); userBalance.Outward = 0; userBalance.CreatedDate = DateTime.Now; _context.TblUserBalance.Add(userBalance); _context.SaveChanges(); //Current logged user's balance DateTime parent_moment = DateTime.Now; TblUserPosting parent_userPosting = new TblUserPosting(); var parent_role = _context.TblUser.Where(a => a.UserId == Decimal.Parse(user_id)).First().RoleId; var parent_year = parent_moment.Year; var parent_month = parent_moment.Month; var parent_day = parent_moment.Day; var parent_hour = parent_moment.Hour; var parent_minute = parent_moment.Minute; var parent_second = parent_moment.Second; var parent_str = "UB" + id.ToString() + parent_role.ToString() + parent_year.ToString() + parent_month.ToString() + parent_day.ToString() + parent_hour.ToString() + parent_minute.ToString() + parent_second.ToString(); parent_userPosting.UserId = Decimal.Parse(user_id); parent_userPosting.PostingNo = parent_str; parent_userPosting.TransactionTypeId = 2; parent_userPosting.Inward = 0; parent_userPosting.Outward = balance.Amount; parent_userPosting.Active = true; parent_userPosting.CreatedBy = Decimal.Parse(user_id); parent_userPosting.CreatedDate = DateTime.Now; _context.TblUserPosting.Add(parent_userPosting); _context.SaveChanges(); //Current logged user's balance TblUserBalance parent_userBalance = new TblUserBalance(); parent_userBalance.PostingNo = parent_str; parent_userBalance.TransactionTypeId = 2; parent_userBalance.UserId = Decimal.Parse(user_id); parent_userBalance.Inward = 0; parent_userBalance.Outward = Convert.ToInt32(balance.Amount); parent_userBalance.CreatedDate = DateTime.Now; _context.TblUserBalance.Add(parent_userBalance); _context.SaveChanges(); return(Ok(new { message = "Deposit Successfully" })); }