public bool IsAdmin(string userName) { using (var db = new RacingDbContext()) { return(db.UserRole.Where(r => r.User.UserName == userName && r.RoleId == RoleConst.Role_Id_Admin).Any()); } }
public List <PK> GetNotBonusPKs() { using (var db = new RacingDbContext()) { return(db.PK.Where(pk => !pk.IsBonused && pk.Ranks != null).ToList()); } }
public List <PKRate> GetPKRates(int pkId) { using (var db = new RacingDbContext()) { return(db.PKRate.Where(r => r.PKId == pkId).ToList()); } }
public List <PK> GetPKs(List <int> pkIds) { using (var db = new RacingDbContext()) { return(db.PK.Where(pk => pkIds.Contains(pk.PKId)).ToList()); } }
public PK GetPK(int pkId) { using (var db = new RacingDbContext()) { return(db.PK.Where(pk => pk.PKId == pkId).FirstOrDefault()); } }
public override bool IsInRole(string userName, params int[] roleIds) { using (var context = new RacingDbContext()) { return(context.User.Any(u => u.UserName == userName && u.UserRoles.Any(ur => roleIds.Contains(ur.RoleId)))); } }
/// <summary> /// 判断是否处于封盘期 /// </summary> public bool IsClosed(PK pk) { using (var db = new RacingDbContext()) { return(pk.BeginTime.AddSeconds(pk.OpeningSeconds) <= DateTime.Now && DateTime.Now <= pk.BeginTime.AddSeconds(pk.OpeningSeconds + pk.CloseSeconds)); } }
public User GetUserOnly(int userId) { using (var db = new RacingDbContext()) { return(db.User.Where(u => u.UserId == userId).FirstOrDefault()); } }
public User GetUserByUserName(string userName) { using (var db = new RacingDbContext()) { return(db.User.Where(u => u.UserName == userName).FirstOrDefault()); } }
public Post GetPostById(int postId) { using (var db = new RacingDbContext()) { return(db.Post.Where(p => p.PostId == postId).FirstOrDefault()); } }
public bool IsAdmin(int userId) { using (var db = new RacingDbContext()) { return(db.UserRole.Where(ur => ur.UserId == userId && ur.RoleId == RoleConst.Role_Id_Admin).Any()); } }
/// <summary> /// 取投注, 计算奖金使用 /// </summary> public List <Bet> GetBets(int pkId, int rank, int num) { using (var db = new RacingDbContext()) { return(db.Bet.Where(b => b.PKId == pkId && b.Rank == rank && b.Num == num).ToList()); } }
public AppConfig GetAppConfig(string name) { using (var db = new RacingDbContext()) { return(db.AppConfig.Where(a => a.Name == name).FirstOrDefault()); } }
public List <AppConfig> GetAll() { using (var db = new RacingDbContext()) { return(db.AppConfig.ToList()); } }
public override bool Exsits(string username) { using (var context = new RacingDbContext()) { return(context.User.Count(u => u.UserName == username) > 0); } }
public bool ExistUserName(string userName) { using (var db = new RacingDbContext()) { return(db.User.Where(u => u.UserName == userName).Any()); } }
/// <returns> /// 0: valid /// -1: user doesn't exist /// </returns> public override int LockUser(int userId, bool locked) { using (var context = new RacingDbContext()) { var user = context.User.FirstOrDefault(u => u.UserId == userId); if (user == null) { return(-1); } user.IsLocked = locked; if (locked) { user.LockedDate = DateTime.Now; } else { user.LockedDate = null; } context.SaveChanges(); } return(0); }
/// <summary> /// 更新父User.UserExtension的AgentCount/MemberCount /// </summary> /// <param name="user">当前用户</param> /// <param name="roleId">当前用户的角色Id</param> /// <param name="userOperation">操作: 增/删/改</param> public void UpdateParentUserExtension(User user, int roleId, UserOperation userOperation) { using (var db = new RacingDbContext()) { var parentUserExtension = db.UserExtension .Include(nameof(UserExtension.User)) .Where(u => u.UserId == user.ParentUserId).FirstOrDefault(); if (parentUserExtension != null) { switch (userOperation) { case UserOperation.Add: //新增用户 switch (roleId) { case RoleConst.Role_Id_General_Agent: //新增用户是总代理 parentUserExtension.AgentCount = parentUserExtension.AgentCount + 1; break; case RoleConst.Role_Id_Agent: //新增用户是代理 parentUserExtension.AgentCount = parentUserExtension.AgentCount + 1; break; case RoleConst.Role_Id_Member: //新增用户是会员 //更新代理 parentUserExtension.MemberCount = parentUserExtension.MemberCount + 1; //更新总代理 UpdateParentUserExtension(parentUserExtension.User, RoleConst.Role_Id_Member, UserOperation.Add); break; } break; case UserOperation.Edit: //修改用户 break; case UserOperation.Delete: //删除用户 switch (roleId) { case RoleConst.Role_Id_General_Agent: //删除用户是总代理 parentUserExtension.AgentCount = parentUserExtension.AgentCount - 1; break; case RoleConst.Role_Id_Agent: //删除用户是代理 parentUserExtension.AgentCount = parentUserExtension.AgentCount - 1; parentUserExtension.MemberCount = parentUserExtension.MemberCount - user.UserExtension.MemberCount; break; case RoleConst.Role_Id_Member: //删除用户是会员 parentUserExtension.MemberCount = parentUserExtension.MemberCount - 1; //更新总代理 UpdateParentUserExtension(parentUserExtension.User, RoleConst.Role_Id_Member, UserOperation.Delete); break; } break; } db.SaveChanges(); } } }
public bool ExistPK(DateTime dt) { using (var db = new RacingDbContext()) { return(db.PK.Where(pk => pk.BeginTime <= dt && dt <= pk.EndTime).Any()); } }
/// <summary> /// 更新用户扩展 UserExtension /// </summary> /// <param name="user"></param> /// <param name="roleId"></param> public void UpdateUserExtension(User user, int roleId) { using (var db = new RacingDbContext()) { var userExtension = db.UserExtension.Where(u => u.UserId == user.UserId).FirstOrDefault(); if (userExtension != null) { switch (roleId) { case RoleConst.Role_Id_General_Agent: userExtension.GeneralAgentUserId = user.UserId; userExtension.AgentUserId = user.UserId; break; case RoleConst.Role_Id_Agent: userExtension.GeneralAgentUserId = user.ParentUserId; userExtension.AgentUserId = user.UserId; break; case RoleConst.Role_Id_Member: userExtension.AgentUserId = user.ParentUserId; if (user.ParentUserId.HasValue) { userExtension.GeneralAgentUserId = db.User.Where(agent => agent.UserId == user.ParentUserId).Select(u => u.ParentUserId).First(); } break; } db.SaveChanges(); } } }
/// <summary> /// 取最后一个PK /// </summary> /// <returns></returns> public PK GetLastPK() { using (var db = new RacingDbContext()) { return(db.PK.OrderByDescending(pk => pk.PKId).FirstOrDefault()); } }
/// <summary> /// 添加代理/会员时取父亲节点 /// </summary> /// <param name="roleId">角色类型</param> public List <User> GetParentUsers(int roleId) { using (var db = new RacingDbContext()) { var parentRoleId = 0; switch (roleId) { case RoleConst.Role_Id_General_Agent: //总代理 parentRoleId = RoleConst.Role_Id_Admin; break; case RoleConst.Role_Id_Agent: //删除用户是代理 parentRoleId = RoleConst.Role_Id_General_Agent; break; case RoleConst.Role_Id_Member: //删除用户是会员 parentRoleId = RoleConst.Role_Id_Agent; break; } return(parentRoleId > 0 ? db.User.Where(u => u.Enabled && u.UserRoles.Where(ur => ur.RoleId == parentRoleId).Any()).ToList() : new List <User>()); } }
public List <PK> GetRanksNotSyncedPKs() { using (var db = new RacingDbContext()) { return(db.PK.Where(pk => !pk.IsRanksSynced && pk.Ranks != null).ToList()); } }
/// <summary> /// 用户资金信息 /// </summary> /// <param name="userId">userId</param> public UserCreditModel GetUserCredit(int userId) { using (var db = new RacingDbContext()) { var model = new UserCreditModel(); // 今日消费 model.TodayBetAmount = db.Bet.Where(b => b.UserId == userId && DbFunctions.DiffDays(b.PK.EndTime, DateTime.Now) == 0) .Select(b => b.Amount).DefaultIfEmpty(0m).Sum(); // 未开奖消费 model.NotBonusAmount = db.Bet.Where(b => b.UserId == userId && b.PK.EndTime > DateTime.Now) .Select(b => b.Amount).DefaultIfEmpty(0m).Sum(); // 今日返点 model.TodayRebateAmount = db.PKBonus.Where(b => b.UserId == userId && DbFunctions.DiffDays(b.PK.EndTime, DateTime.Now) == 0 && b.BonusType == BonusType.Rebate) .Select(b => b.Amount).DefaultIfEmpty(0m).Sum(); // 今日利润 model.TodayProfitAmount = db.PKBonus.Where(b => b.UserId == userId && DbFunctions.DiffDays(b.PK.EndTime, DateTime.Now) == 0 && b.BonusType == BonusType.Bonus) .Select(b => b.Amount).DefaultIfEmpty(0m).Sum(); // 今日盈亏 model.TodayProfitAndLossAmount = model.TodayRebateAmount + model.TodayProfitAmount - model.TodayBetAmount; // 退水+限额 //model.User = new UserService().GetUser(userId); model.UserRebates = new UserRebateService().GetUserRebates(userId); return(model); } }
public List <PK> GetNotCalculatePKs() { using (var db = new RacingDbContext()) { return(db.PK.Where(pk => pk.Ranks == null).ToList()); } }
public int?GetParentUserId(int userId) { using (var db = new RacingDbContext()) { return(db.User.Where(u => u.UserId == userId).Select(u => u.ParentUserId).FirstOrDefault()); } }
/// <summary> /// 未退水且比赛结束 /// </summary> /// <returns></returns> public List <PK> GetNotRebatePKs() { using (var db = new RacingDbContext()) { return(db.PK.Where(pk => !pk.IsRebated && DbFunctions.DiffSeconds(DateTime.Now, pk.EndTime) <= AppConfigCache.Racing_Lottery_Seconds).ToList()); } }
public List <int> GetParentUserIds(List <int> userIds) { using (var db = new RacingDbContext()) { return(db.User.Where(u => u.ParentUserId.HasValue && userIds.Contains(u.UserId)).Select(u => u.ParentUserId.Value).ToList()); } }
public List <PKRate> GetPKRates(List <int> pkIds) { using (var db = new RacingDbContext()) { return(db.PKRate.Where(r => pkIds.Contains(r.PKId)).ToList()); } }
public List <UserRole> GetUserRoles(string userName) { using (var db = new RacingDbContext()) { return(db.UserRole.Where(r => r.User.UserName == userName).ToList()); } }