// GET: UserClubs/Create public ActionResult Create(int id) { var club = _db.Clubs.Find(id); if (club == null) { return(HttpNotFound()); } ViewBag.Name = club.Name; var list = _db.Users.Where(x => x.Roles != "Mailer" && x.Roles != "Admin").ToList(); foreach (var userClub in _db.UserClubs.Where(x => x.ClubId == id)) { if (list.Any(x => x.id == userClub.UserId)) { list.RemoveAll(x => x.id == userClub.UserId); } } ViewBag.UserId = new SelectList(list, "id", "username"); var userclub = new UserClub() { ClubId = id }; return(View(userclub)); }
public static void ApproveClub(int clubID, bool approve) { var club = GetClubInfo(clubID); if (club != null) { club.IsActive = approve; club.UpdateDate = DateTime.Now; if (approve) club.IsAppliable = true; SaveClub(club); var uc = new UserClub(); uc.ClubUid = clubID; uc.JoinClubDate = DateTime.Now; uc.FromDate = DateTime.Now; uc.IsActive = true; uc.Responsibility = (int) Responsibility.Manager; uc.Userid = club.ManagerUid; uc.UserName = club.ManagerUserName; SaveUserClub(uc); ClubSysPrivateMessage.SendMessage(clubID, string.Empty, ClubSysMessageType.ApproveClub); } else throw new Exception("Club not exist."); }
public async Task <JoinClubRequest> ApproveJoinClubRequest(string requestId, int requestType) { JoinClubRequest request = await this.dbContext.JoinClubRequests .FirstOrDefaultAsync(x => x.Id == requestId); if (requestType == 1) { UserClub userClub = new UserClub() { Club = request.Club, User = request.User, ClubId = request.ClubId, UserId = request.UserId }; await this.dbContext.UserClubs.AddAsync(userClub); request.RequestType = RequestType.Approved; } else if (requestType == 2) { request.RequestType = RequestType.Removed; } await this.dbContext.SaveChangesAsync(); return(request); }
public static void ApproveClub(int clubID, bool approve) { var club = GetClubInfo(clubID); if (club != null) { club.IsActive = approve; club.UpdateDate = DateTime.Now; if (approve) { club.IsAppliable = true; } SaveClub(club); var uc = new UserClub(); uc.ClubUid = clubID; uc.JoinClubDate = DateTime.Now; uc.FromDate = DateTime.Now; uc.IsActive = true; uc.Responsibility = (int)Responsibility.Manager; uc.Userid = club.ManagerUid; uc.UserName = club.ManagerUserName; SaveUserClub(uc); ClubSysPrivateMessage.SendMessage(clubID, string.Empty, ClubSysMessageType.ApproveClub); } else { throw new Exception("Club not exist."); } }
public async Task <Unit> Handle(Command request, CancellationToken cancellationToken) { var club = new Club { Id = request.Id, Name = request.Name, LeagueName = request.LeagueName, StadiumName = request.StadiumName, DateEstablished = request.DateEstablished, ShortName = request.ShortName }; _context.Clubs.Add(club); var user = await _context.Users.SingleOrDefaultAsync(x => x.UserName == _userAccessor.GetCurrentUsername()); var clubAttendee = new UserClub { AppUser = user, Club = club, IsHost = true, DateJoined = DateTime.Now }; _context.UserClubs.Add(clubAttendee); var success = await _context.SaveChangesAsync() > 0; if (success) { return(Unit.Value); } throw new Exception("Problem saving club chnages"); }
public ActionResult Edit([Bind(Include = "id,UserId,ClubId,Roles,rowversion")] UserClub userClub) { try { if (ModelState.IsValid) { _db.Entry(userClub).State = EntityState.Modified; _db.SaveChanges(); return(RedirectToAction("Index", new { id = userClub.ClubId })); } } catch (DbUpdateConcurrencyException ex) { var entry = ex.Entries.Single(); var clientValues = (UserClub)entry.Entity; var databaseEntry = entry.GetDatabaseValues(); if (databaseEntry == null) { ModelState.AddModelError(string.Empty, "Unable to save changes. The member was deleted by another user."); } else { var databaseValues = (UserClub)databaseEntry.ToObject(); if (databaseValues.UserId != clientValues.UserId) { ModelState.AddModelError("User", "Current value: " + databaseValues.User.username); } if (databaseValues.ClubId != clientValues.ClubId) { ModelState.AddModelError("Club", "Current value: " + databaseValues.Club.Name); } ModelState.AddModelError(string.Empty, "The record you attempted to edit " + "was modified by another user after you got the original value. The " + "edit operation was canceled and the current values in the database " + "have been displayed. If you still want to edit this record, click " + "the Save button again. Otherwise click the Back to List hyperlink."); userClub.rowversion = databaseValues.rowversion; } } catch (Exception dex) { //Log the error (uncomment dex variable name and add a line here to write a log.) ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists, see your system administrator."); ErrorSignal.FromCurrentContext().Raise(dex); } return(View(userClub)); }
protected void Page_Load(object sender, EventArgs e) { #region Assign Control Property ctrlLeftPanel.UserId = userid; ctrlLeftPanel.UserName = username; ctrlFieldTooBar.UserId = userid; ctrlMenuTabBar.CurrentMenu = CasinoMenuType.CasinoBetLog; if (CurrentMatch != Guid.Empty) { ctrlCasinoHeader.UserId = userid; ctrlCasinoHeader.MatchGuid = CurrentMatch; ctrlCasinoHeader.IsHistoryView = false; hlBetLog.NavigateUrl = $"CasinoBetLog.aspx?Match={CurrentMatch}"; hlBetLog.Target = "_self"; hlBetLog.Visible = true; } else { ctrlCasinoHeader.Visible = false; hlBetLog.Visible = false; } #endregion if (!IsPostBack) { // Bind ddlGroup var dtClub = UserClub.GetAllClubs(); if (dtClub != null) { ddlClub.DataSource = dtClub; ddlClub.DataTextField = "FullName"; ddlClub.DataValueField = "ClubUid"; ddlClub.DataBind(); var item = new ListItem("所有球会", "0"); ddlClub.Items.Insert(0, item); } else { ddlClub.Visible = false; } } BindData(); }
public static void ApproveJoinClub(int applyHistoryId, bool approved, string operatorUserName) { var ah = ClubLogic.GetApplyHistory(applyHistoryId); ah.IsAccepted = approved; ClubLogic.SaveApplyHistory(ah); var ch = new ClubHistory(); ch.ClubID = ah.ClubUid; ch.ActionUserName = ah.UserName; ch.OperatorUserName = operatorUserName; ch.ActionDate = DateTime.Now; if (approved) { //insert user club var uc = new UserClub(); uc.ClubUid = ah.ClubUid; uc.JoinClubDate = DateTime.Now; uc.FromDate = DateTime.Now; uc.IsActive = true; uc.Responsibility = (int)Responsibility.Member; uc.Userid = ah.Userid; uc.UserName = ah.UserName; ClubLogic.SaveUserClub(uc); ch.ActionType = ClubHistoryActionType.JoinClub.ToString(); ch.ActionDescription = ClubLogic.BuildClubHistoryActionDesc(ClubHistoryActionType.JoinClub, null); } else { ch.ActionType = ClubHistoryActionType.RejectJoinClub.ToString(); ch.ActionDescription = ClubLogic.BuildClubHistoryActionDesc(ClubHistoryActionType.RejectJoinClub, null); } ClubLogic.SaveClubHistory(ch); if (approved) { ClubSysPrivateMessage.SendMessage(ah.ClubUid, ah.UserName, ClubSysMessageType.ApproveJoinClub); } else { ClubSysPrivateMessage.SendMessage(ah.ClubUid, ah.UserName, ClubSysMessageType.RejectJoinClub); } }
public async Task <UserClub> RemoveFromClub(string clubId, string userId) { UserClub userClub = await this.dbContext.UserClubs .FirstOrDefaultAsync(x => x.ClubId == clubId && x.UserId == userId); if (userClub != null) { this.dbContext.UserClubs.Remove(userClub); } await this.dbContext.SaveChangesAsync(); return(userClub); }
public static void ApproveJoinClub(int applyHistoryId, bool approved, string operatorUserName) { var ah = ClubLogic.GetApplyHistory(applyHistoryId); ah.IsAccepted = approved; ClubLogic.SaveApplyHistory(ah); var ch = new ClubHistory(); ch.ClubID = ah.ClubUid; ch.ActionUserName = ah.UserName; ch.OperatorUserName = operatorUserName; ch.ActionDate = DateTime.Now; if (approved) { //insert user club var uc = new UserClub(); uc.ClubUid = ah.ClubUid; uc.JoinClubDate = DateTime.Now; uc.FromDate = DateTime.Now; uc.IsActive = true; uc.Responsibility = (int) Responsibility.Member; uc.Userid = ah.Userid; uc.UserName = ah.UserName; ClubLogic.SaveUserClub(uc); ch.ActionType = ClubHistoryActionType.JoinClub.ToString(); ch.ActionDescription = ClubLogic.BuildClubHistoryActionDesc(ClubHistoryActionType.JoinClub, null); } else { ch.ActionType = ClubHistoryActionType.RejectJoinClub.ToString(); ch.ActionDescription = ClubLogic.BuildClubHistoryActionDesc(ClubHistoryActionType.RejectJoinClub, null); } ClubLogic.SaveClubHistory(ch); if (approved) { ClubSysPrivateMessage.SendMessage(ah.ClubUid, ah.UserName, ClubSysMessageType.ApproveJoinClub); } else { ClubSysPrivateMessage.SendMessage(ah.ClubUid, ah.UserName, ClubSysMessageType.RejectJoinClub); } }
// GET: UserClubs/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } UserClub userClub = _db.UserClubs.Find(id); if (userClub == null) { return(HttpNotFound()); } ViewBag.Name = userClub.Club.Name; return(View(userClub)); }
public ActionResult Create([Bind(Include = "id,UserId,ClubId,rowversion")] UserClub userClub) { if (ModelState.IsValid) { _db.UserClubs.Add(userClub); try { _db.SaveChanges(); return(RedirectToAction("Index", new { id = userClub.ClubId })); } catch (System.Data.Entity.Infrastructure.DbUpdateException e) { ErrorSignal.FromCurrentContext().Raise(e); Exception ex = e; while (ex.InnerException != null) { ex = ex.InnerException; } ModelState.AddModelError(string.Empty, ex.Message); } catch (Exception e) { ErrorSignal.FromCurrentContext().Raise(e); ModelState.AddModelError(string.Empty, "Insert failed"); } } var list = _db.Users.Where(x => x.Roles != "Mailer" || x.Roles != "Admin").ToList(); foreach (var item in _db.UserClubs.Where(x => x.ClubId == userClub.ClubId)) { if (list.Any(x => x.id == item.UserId)) { list.RemoveAll(x => x.id == item.UserId); } } ViewBag.UserId = new SelectList(list, "id", "username"); var club = _db.Clubs.Find(userClub.ClubId); ViewBag.Name = club.Name; return(View(userClub)); }
internal static void SaveUserClub(UserClub uc) { using (var con = SQLConn.GetConnection()) { var com = new SqlCommand(); com.Connection = con; com.CommandType = CommandType.StoredProcedure; com.CommandText = "[dbo].[SaveUserClub]"; com.Parameters.Add(new SqlParameter("@ID", ParseNullableParam(uc.ID))); com.Parameters.Add(new SqlParameter("@userID", uc.Userid)); com.Parameters.Add(new SqlParameter("@userName", uc.UserName)); com.Parameters.Add(new SqlParameter("@clubUid", uc.ClubUid)); com.Parameters.Add(new SqlParameter("@responsibility", uc.Responsibility)); com.Parameters.Add(new SqlParameter("@fromDate", uc.FromDate)); com.Parameters.Add(new SqlParameter("@toDate", ParseNullableParam(uc.ToDate))); com.Parameters.Add(new SqlParameter("@joinClubDate", ParseNullableParam(uc.JoinClubDate))); com.Parameters.Add(new SqlParameter("@isActive", uc.IsActive)); con.Open(); com.ExecuteNonQuery(); //con.Close(); } }
public static void ChangeResponsibility(int userID, string userName, int clubID, Responsibility res, string operatorUserName) { var userClub = ClubLogic.GetActiveUserClub(userID, clubID); if (userClub != null && userClub.Responsibility == (int) res) return; var club = ClubLogic.GetClubInfo(clubID); if (club != null) { if (res == Responsibility.Manager) { #region Proceed previous manager user club info var preManagerUid = club.ManagerUid.Value; var preManagerName = club.ManagerUserName; LeaveClub(preManagerUid, clubID); var preManagerUc = ClubLogic.GetActiveUserClub(preManagerUid, clubID); var preUC = new UserClub(); preUC.ClubUid = clubID; preUC.JoinClubDate = preManagerUc.JoinClubDate; preUC.FromDate = DateTime.Now; preUC.IsActive = true; preUC.Responsibility = (int) Responsibility.Member; preUC.Userid = preManagerUid; preUC.UserName = preManagerName; ClubLogic.SaveUserClub(preUC); #endregion club.ManagerUid = userID; club.ManagerUserName = userName; club.UpdateDate = DateTime.Now; ClubLogic.SaveClub(club); } LeaveClub(userID, clubID); var uc = new UserClub(); uc.ClubUid = clubID; uc.JoinClubDate = userClub.JoinClubDate; uc.FromDate = DateTime.Now; uc.IsActive = true; uc.Userid = userID; uc.UserName = userName; var ch = new ClubHistory(); ch.ClubID = clubID; ch.ActionUserName = userName; ch.OperatorUserName = operatorUserName; if (userClub.Responsibility.Value > (int) res) { //nominate ch.ActionType = ClubHistoryActionType.Nominated.ToString(); ch.ActionDescription = ClubLogic.BuildClubHistoryActionDesc(ClubHistoryActionType.Nominated, ClubLogic.TranslateResponsibility(res)); } else { //dismiss ch.ActionType = ClubHistoryActionType.Dismiss.ToString(); ch.ActionDescription = ClubLogic.BuildClubHistoryActionDesc(ClubHistoryActionType.Dismiss, ClubLogic.TranslateResponsibility(res)); } uc.Responsibility = (int) res; ClubLogic.SaveUserClub(uc); ClubLogic.SaveClubHistory(ch); } else throw new Exception("Club not exist."); }
public static void ChangeResponsibility(int userID, string userName, int clubID, Responsibility res, string operatorUserName) { var userClub = ClubLogic.GetActiveUserClub(userID, clubID); if (userClub != null && userClub.Responsibility == (int)res) { return; } var club = ClubLogic.GetClubInfo(clubID); if (club != null) { if (res == Responsibility.Manager) { #region Proceed previous manager user club info var preManagerUid = club.ManagerUid.Value; var preManagerName = club.ManagerUserName; LeaveClub(preManagerUid, clubID); var preManagerUc = ClubLogic.GetActiveUserClub(preManagerUid, clubID); var preUC = new UserClub(); preUC.ClubUid = clubID; preUC.JoinClubDate = preManagerUc.JoinClubDate; preUC.FromDate = DateTime.Now; preUC.IsActive = true; preUC.Responsibility = (int)Responsibility.Member; preUC.Userid = preManagerUid; preUC.UserName = preManagerName; ClubLogic.SaveUserClub(preUC); #endregion club.ManagerUid = userID; club.ManagerUserName = userName; club.UpdateDate = DateTime.Now; ClubLogic.SaveClub(club); } LeaveClub(userID, clubID); var uc = new UserClub(); uc.ClubUid = clubID; uc.JoinClubDate = userClub.JoinClubDate; uc.FromDate = DateTime.Now; uc.IsActive = true; uc.Userid = userID; uc.UserName = userName; var ch = new ClubHistory(); ch.ClubID = clubID; ch.ActionUserName = userName; ch.OperatorUserName = operatorUserName; if (userClub.Responsibility.Value > (int)res) { //nominate ch.ActionType = ClubHistoryActionType.Nominated.ToString(); ch.ActionDescription = ClubLogic.BuildClubHistoryActionDesc(ClubHistoryActionType.Nominated, ClubLogic.TranslateResponsibility(res)); } else { //dismiss ch.ActionType = ClubHistoryActionType.Dismiss.ToString(); ch.ActionDescription = ClubLogic.BuildClubHistoryActionDesc(ClubHistoryActionType.Dismiss, ClubLogic.TranslateResponsibility(res)); } uc.Responsibility = (int)res; ClubLogic.SaveUserClub(uc); ClubLogic.SaveClubHistory(ch); } else { throw new Exception("Club not exist."); } }
protected void gvBet_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { var bet = e.Row.DataItem as Bet; if (bet != null) { var item = CasinoItem.GetCasinoItem(bet.CasinoItemGuid); var ltrlClub = e.Row.FindControl("ltrlClub") as Literal; if (ltrlClub != null) { var pathAcnClub = ConfigGlobal.PluginAcnClubPath; if ((!string.IsNullOrEmpty(pathAcnClub)) && (pathAcnClub != bool.FalseString.ToLower())) { var drClub = UserClub.GetUserClubHistoryInfo(bet.UserID, bet.BetTime); if ((drClub != null) && ((drClub["ClubUid"].ToString() == ddlClub.SelectedValue) || (ddlClub.SelectedValue == "0"))) { ltrlClub.Text = $"<a href=\"/{pathAcnClub}/ClubView.aspx?ClubID={drClub["ClubUid"]}\" target=\"_blank\">{drClub["ClubName"]}</a>"; } else if ((drClub == null) && (ddlClub.SelectedValue == "0")) { ltrlClub.Text = "/"; } else { e.Row.Visible = false; return; } } else { Response.Redirect($"CasinoBetLog.aspx?Match={CurrentMatch}"); } } var ltrlResult = e.Row.FindControl("ltrlResult") as Literal; var dt = BetDetail.GetBetDetailByBetId(bet.ID); if (dt != null && ltrlResult != null) { var dr = dt.Rows[0]; switch (item.ItemType) { case CasinoType.SingleChoice: if (dr["DetailName"].ToString() == MatchChoiceOption.HomeWinValue) { ltrlResult.Text = "主队胜"; } else if (dr["DetailName"].ToString() == MatchChoiceOption.DrawValue) { ltrlResult.Text = "双方平"; } else if (dr["DetailName"].ToString() == MatchChoiceOption.AwayWinValue) { ltrlResult.Text = "客队胜"; } break; case CasinoType.MatchResult: var betDetail = new MatchResultBetDetail(dt); ltrlResult.Text = $"{betDetail.Home}:{betDetail.Away}"; break; } } var ltrlBetResult = e.Row.FindControl("ltrlBetResult") as Literal; if (ltrlBetResult != null) { if (!bet.IsWin.HasValue) { ltrlBetResult.Text = string.Empty; } else { if (bet.IsWin.Value) { if (item.ItemType == CasinoType.SingleChoice) { ltrlBetResult.Text = "<span class=\"CasinoSys_True\" title=\"猜对输赢\"></span>"; } else if (item.ItemType == CasinoType.MatchResult) { ltrlBetResult.Text = "<span class=\"CasinoSys_Good\" title=\"猜对比分\"></span>"; } e.Row.CssClass = "RowCasinoSys_True"; } else { ltrlBetResult.Text = "<span class=\"CasinoSys_False\" title=\"失败\"></span>"; } } } } } }