private void RegisterPlayer(StatusE statusID, TournamentUserStatusE tournamentUserStatusID) { string userIDs = string.Empty; int i = 0; foreach (DataGridViewRow row in dgvRegisterPlayer.Rows) { int chessTypeID = Convert.ToInt32(GridTable.Rows[i]["ChessTypeId"]); if (dgvRegisterPlayer[0, row.Index].Value != null) { if ((bool)dgvRegisterPlayer[0, row.Index].Value) { int userID = BaseItem.ToInt32(GridTable.Rows[i]["UserID"]); userIDs += "," + userID.ToString(); } } i++; } if (userIDs.Length > 0) { userIDs = userIDs.Remove(0, 1); } SocketClient.SaveTournamentRegisteredUsers(statusID, tournamentUserStatusID, this.Tournament.TournamentID, userIDs, TeamId, GetEloBeforeRating); TournamentRegisterPlayer TournamentRegisterPlayer = (TournamentRegisterPlayer)this.ParentForm; TournamentRegisterPlayer.DialogResult = DialogResult.OK; }
public static DataTable UpdateTournamentWantinStatus(StatusE statusID, string TournamentWantinUserIDs) { // status id is deleted StringBuilder sb = new StringBuilder(); sb.Append("update TournamentWantinUser set TournamentUserStatusID = ").Append(statusID.ToString("d")).Append(" WHERE TournamentWantinUserID in (").Append(TournamentWantinUserIDs).Append(")"); return(BaseCollection.ExecuteSql(sb.ToString())); }
public static DataTable UpdateStatus(StatusE statusID, string userIDs) { // status id is deleted StringBuilder sb = new StringBuilder(); sb.Append("update [User] set statusid = ").Append(statusID.ToString("d")).Append(" WHERE userID in (").Append(userIDs).Append(")"); return(BaseCollection.ExecuteSql(sb.ToString())); }
public static DataTable UpdateStatus(StatusE statusID, string parm) { // status id is deleted StringBuilder sb = new StringBuilder(); sb.Append("update TournamentPrize set statusid = ").Append(statusID.ToString("d")).Append(" WHERE TeamID in (").Append(parm).Append(")"); return(BaseCollection.ExecuteSql(sb.ToString())); }
protected RemoteDevice(string deviceName, string ip, int port) { this.deviceName = deviceName; // Network settings this.ip = ip; this.port = port; Status = StatusE.DISCONNECTED; }
public static void UpdateTeamStatus(StatusE statusID, string teamIds) { Kv kv = new Kv(); kv.Set("MethodName", (int)MethodNameE.UpdateTeamStatus); kv.Set(StdKv.CurrentUserID, Ap.CurrentUserID); kv.Set("TeamIds", teamIds); kv.Set("StatusID", statusID.ToString("d")); SocketClient.Instance.InvokeAsync(kv.DataTable.Copy()); }
public static void UpdateBanStatus(StatusE statusID, string userIds) { Kv kv = new Kv(); kv.Set("MethodName", (int)MethodNameE.UpdateBanStatus); kv.Set(StdKv.CurrentUserID, Ap.CurrentUserID); kv.Set("UserIDs", userIds); kv.Set("StatusID", statusID.ToString("d")); //kv.Set("BanMachineKey", WmiHelper.GetMachineKey()); SocketClient.Instance.InvokeAsync(kv.DataTable.Copy()); }
void UpdateBanStatus(StatusE statusID) { try { int i = 0; string userIDs = string.Empty; foreach (DataGridViewRow row in dataGridView1.Rows) { if (row.Cells[0].Value != null) { if ((bool)row.Cells[0].Value) { int statusIDx = BaseItem.ToInt32(GridTable.Rows[i]["StatusID"]); if (statusIDx == (int)StatusE.Ban) { int userID = BaseItem.ToInt32(GridTable.Rows[i]["UserID"]); userIDs += "," + userID.ToString(); } } } i++; } if (userIDs.Length > 0) { userIDs = userIDs.Remove(0, 1); if (MessageForm.Confirm(this.ParentForm, MsgE.ConfirmItemTask, "remove ban", "user") == DialogResult.Yes) { ProgressForm frmProgress = ProgressForm.Show(this, "Removing Ban..."); SocketClient.UpdateBanStatus(statusID, userIDs); frmProgress.Close(); RefreshGrid(); MessageForm.Show(this.ParentForm, MsgE.InfoBanRemove); } } else { MessageForm.Show(this.ParentForm, MsgE.ErrorSelectCheckBox); } } catch (Exception ex) { MessageForm.Show(ex); } }
public static DataTable UpdateBanStatus(StatusE statusID, string userIDs) { // status id is deleted StringBuilder sb = new StringBuilder(); sb.Append("update [User] set statusid = ").Append(statusID.ToString("d")); //sb.Append(", BanMachineKey = '").Append(machineKey).Append("'"); sb.Append(", BanEndDate = NULL, BanEndTime = NULL, BanStartDate = NULL, BanStartTime = NULL "); sb.Append(" WHERE userID in (").Append(userIDs).Append(")"); return(BaseCollection.ExecuteSql(sb.ToString())); }
public static DataSet GetTournamentRegisteredUser(StatusE statusID, int tournamentID) { Kv kv = new Kv(); kv.Set("MethodName", (int)MethodNameE.GetTournamentRegisteredUser); kv.Set(StdKv.CurrentUserID, Ap.CurrentUserID); kv.Set("TournamentID", tournamentID); kv.Set("StatusID", statusID.ToString("d")); DataSet ds = SocketClient.Instance.Invoke(kv.DataTable); return(ds); }
void UpdateRoomStatus(StatusE statusID) { try { int i = 0; string roomIDs = string.Empty; foreach (DataGridViewRow row in dataGridView1.Rows) { if (row.Cells[0].Value != null) { if ((bool)row.Cells[0].Value) { Int32 roomId = BaseItem.ToInt32(GridTable.Rows[i]["RoomID"]); roomIDs += "," + roomId.ToString(); } } i++; } if (roomIDs.Length > 0) { roomIDs = roomIDs.Remove(0, 1); if (MessageForm.Confirm(this.ParentForm, MsgE.ConfirmItemTask, statusID.ToString().ToLower(), "room") == DialogResult.Yes) { ProgressForm frmProgress = ProgressForm.Show(this, "Updating Room Status..."); SocketClient.UpdateRoomStatus(statusID, roomIDs); frmProgress.Close(); RefreshGrid(); MessageForm.Show(this.ParentForm, MsgE.InfoUpdateRoom); } } else { MessageForm.Show(this.ParentForm, MsgE.ErrorSelectCheckBox); } } catch (Exception ex) { TestDebugger.Instance.WriteError(ex); MessageForm.Show(ex); } }
public Taga(Taga t) { Дата = t.Дата; ДатаПрихода = t.ДатаПрихода; Артикул = t.Артикул; НомерЗаказа = t.НомерЗаказа; Количество = t.Количество; ИмяТовара = t.ИмяТовара; НомерКлиента = t.НомерКлиента; ИмяКлиента = t.ИмяКлиента; Статус = t.Статус; Поставщик = t.Поставщик; ИмяПродавца = t.ИмяПродавца; }
public Taga(DateTime Дата, DateTime ДатаПрихода, ulong Артикул, int НомерЗаказа, int Количество, string ИмяТовара, string НомерКлиента, string ИмяКлиента, StatusE Статус, string Поставщик, string ИмяПродавца) { this.Дата = Дата; this.ДатаПрихода = ДатаПрихода; this.Артикул = Артикул; this.НомерЗаказа = НомерЗаказа; this.Количество = Количество; this.ИмяТовара = ИмяТовара; this.НомерКлиента = НомерКлиента; this.ИмяКлиента = ИмяКлиента; this.Статус = Статус; this.Поставщик = Поставщик; this.ИмяПродавца = ИмяПродавца; }
void SaveTournamentRegisteredUsers(StatusE statusID, TournamentUserStatusE tournamentUserStatusID) { int i = 0; string userIDs = string.Empty; int teamID = 0; if (dgvRegisterPlayer.Rows.Count == 0) { MessageForm.Error(this.ParentForm, MsgE.ErrorNoSelection, "player"); return; } try { foreach (DataGridViewRow row in dgvRegisterPlayer.Rows) { if (dgvRegisterPlayer[0, row.Index].Value != null) { if ((bool)dgvRegisterPlayer[0, row.Index].Value) { if (this.Tournament.TournamentTypeE == TournamentTypeE.Scheveningen) { teamID = Convert.ToInt32(GridTable.Rows[i]["TeamID"]); } int userID = BaseItem.ToInt32(GridTable.Rows[i]["UserID"]); userIDs += "," + userID.ToString(); } } i++; } if (userIDs.Length > 0) { userIDs = userIDs.Remove(0, 1); } SocketClient.SaveTournamentRegisteredUsers(statusID, tournamentUserStatusID, this.Tournament.TournamentID, userIDs, teamID, GetEloBeforeRating); } catch (Exception ex) { TestDebugger.Instance.WriteError(ex); MessageForm.Show(ex); } }
public virtual void connect() { if (null == tcpClient) { tcpClient = new TcpClient(AddressFamily.InterNetwork); } if (status == StatusE.CONNECTING || status == StatusE.CONNECTED) { return; } Status = StatusE.CONNECTING; Logger.Instance.log(LogLevel.INFO, string.Format("Connecting with device: {0}...", this)); tcpClient.BeginConnect(ip, port, connectCallback, tcpClient); }
public static void UpdateStatus(Cxt cxt, StatusE statusID, string tournamentIDs) { SqlTransaction trans = null; Rooms Rooms = new Rooms(); try { trans = SqlHelper.BeginTransaction(Config.ConnectionString); //BaseCollection.ExecuteSql2(trans, "update Tournament set statusid = @p1 WHERE TournamentID in (@p2)", statusID.ToString("d"), tournamentIDs); Tournaments Tournaments = new Tournaments(); string[] tournamentIDArr = tournamentIDs.Split(','); for (int i = 0; i < tournamentIDArr.Length; i++) { Tournament Tournament = new Tournament(cxt, Convert.ToInt32(tournamentIDArr[i])); Tournament.StatusIDE = statusID; Tournaments.Add(Tournament); Room Room = Room.GetRoomByTournamentID(cxt, Convert.ToInt32(tournamentIDArr[i])); if (Room.RoomID != 0) { if (statusID == StatusE.Deleted) { Room.TournamentID = 0; Room.StatusIDE = StatusE.Inactive; Rooms.Add(Room); } } } Tournaments.Save(trans); if (Rooms.Count > 0) { Rooms.Save(trans); } SqlHelper.CommitTransaction(trans); } catch (Exception ex) { SqlHelper.RollbackTransaction(trans); Log.Write(cxt, ex); } }
//public static void UpdateWantinUsers(Cxt cxt, UpdateTournamentUsersS UpdateTournamentUsersS) //{ // SqlTransaction sqltrans = null; // try // { // sqltrans = SqlHelper.BeginTransaction(Config.ConnectionString); // BaseCollection.Execute(sqltrans, "UpdateTournamentUserStatus", // UpdateTournamentUsersS.TournamentUserIDs, // UpdateTournamentUsersS.TournamentID, // UpdateTournamentUsersS.UserId, // DateTime.Now, // UpdateTournamentUsersS.statusID.ToString("d")); // BaseCollection.Execute(sqltrans, "UpdateTournamentWantinUserStatus", // "", // UpdateTournamentUsersS.TournamentWantinUserIDs, // UpdateTournamentUsersS.tournamentUserStatusID.ToString("d"), // (int)StatusE.Active, // UpdateTournamentUsersS.UserId, DateTime.Now); // //BaseCollection.Execute(sqltrans, "DeleteTournamentMatchByUserID", // // UpdateTournamentUsersS.TournamentUserIDs, // // UpdateTournamentUsersS.TournamentID , // // 1); // SqlHelper.CommitTransaction(sqltrans); // } // catch (Exception ex) // { // SqlHelper.RollbackTransaction(sqltrans); // Log.Write(cxt, ex); // } //} /// <summary> /// Online client wantin user update /// </summary> /// <param name="cxt"></param> /// <param name="statusID"></param> /// <param name="tournamentUserStatusID"></param> /// <param name="tournamentID"></param> /// <param name="userIDs"></param> /// <param name="tournamentWantinUserIDs"></param> public static void SaveWantinUsers(Cxt cxt, int statusID, int tournamentUserStatusID, int tournamentID, string userIDs, string tournamentWantinUserIDs, int teamID, int eloBefore) { SqlTransaction sqltrans = null; try { sqltrans = SqlHelper.BeginTransaction(Config.ConnectionString); StatusE StatusIDE = (StatusE)Enum.ToObject(typeof(StatusE), statusID); if (StatusIDE == StatusE.Active) { SaveWantinUsers(sqltrans, cxt, statusID, tournamentUserStatusID, tournamentID, userIDs, tournamentWantinUserIDs, teamID, eloBefore); } else { BaseCollection.Execute(sqltrans, "UpdateTournamentUserStatus", userIDs, tournamentID, cxt.CurrentUserID, DateTime.Now, statusID); BaseCollection.Execute(sqltrans, "UpdateWantinUserStatusByUserID", userIDs, tournamentID, tournamentUserStatusID, cxt.CurrentUserID, DateTime.Now); } SqlHelper.CommitTransaction(sqltrans); } catch (Exception ex) { SqlHelper.RollbackTransaction(sqltrans); Log.Write(cxt, ex); } }
public static void UpdateWantinUsers(StatusE statusID, TournamentUserStatusE TournamentUserStatusID, int tournamentID, string userIDs, string tournamentWantinUserIDs) { Kv kv = new Kv(); kv.Set("MethodName", (int)MethodNameE.UpdateWantinUsers); kv.Set(StdKv.CurrentUserID, Ap.CurrentUserID); kv.Set("StatusID", statusID.ToString("d")); kv.Set("TournamentUserStatusID", TournamentUserStatusID.ToString("d")); kv.Set("TournamentID", tournamentID); kv.Set("UserIDs", userIDs); kv.Set("TournamentWantinUserIDs", tournamentWantinUserIDs); SocketClient.Instance.InvokeAsync(kv.DataTable.Copy()); }
public virtual void disconnect() { try { networkStream?.Close(); TcpClient?.Close(); TcpClient = null; networkStream = null; Status = StatusE.DISCONNECTED; Logger.Instance.log(LogLevel.INFO, string.Format("{0} disconnected.", this)); } catch (Exception ex) { Status = StatusE.DISCONNECTED; Logger.Instance .log(LogLevel.ERROR, string.Format("An error occurred while disconnecting with device: {0}.", this), ex); } }
public static DataSet SaveTournamentRegisteredUsers(StatusE statusID, TournamentUserStatusE TournamentUserStatusID, int tournamentID, string userIDs, int teamID, int eloBefore ) { Kv kv = new Kv(); kv.Set("MethodName", (int)MethodNameE.SaveTournamentRegisteredUsers); kv.Set(StdKv.CurrentUserID, Ap.CurrentUserID); kv.Set("StatusID", statusID.ToString("d")); kv.Set("TournamentUserStatusID", TournamentUserStatusID.ToString("d")); kv.Set("TournamentID", tournamentID); kv.Set("UserIDs", userIDs); kv.Set("TeamID", teamID); kv.Set("EloBefore", eloBefore); return(SocketClient.Instance.Invoke(kv.DataTable)); }
public void connectCallback(IAsyncResult result) { try { tcpClient = (TcpClient)result.AsyncState; tcpClient.EndConnect(result); if (tcpClient.Connected) { // run all networkStream = tcpClient.GetStream(); receiveData(); Status = StatusE.CONNECTED; Logger.Instance.log(LogLevel.INFO, string.Format("Connected to {0}.", this)); } } catch (Exception ex) { Status = StatusE.DISCONNECTED; Logger.Instance.log(LogLevel.WARNING, string.Format("Could not connect to {0}.", this), ex); } }
public static string ToString(StatusE status) { switch (status) { case StatusE.Active: return("Active"); case StatusE.Disabled: return("Disabled"); case StatusE.Inactive: return("Inactive"); case StatusE.Deleted: return("Deleted"); case StatusE.Ban: return("Ban"); default: return(""); } }
void SaveTournamentRegisteredUsers(StatusE statusID, TournamentUserStatusE tournamentUserStatusID) { if (this.Tournament == null) { return; } if (this.Tournament.TournamentID == 0) { return; } if (dgvRegisterPlayer.Rows.Count == 0) { MessageForm.Error(this.ParentForm, MsgE.ErrorNoSelection, "player"); return; } try { if (this.UserID == 0) { RegisterPlayer(statusID, tournamentUserStatusID); } else { UpdateReplacePlayer(); } } catch (Exception ex) { TestDebugger.Instance.WriteError(ex); MessageForm.Show(ex); } }
public static DataTable UpdateStatus(SqlTransaction t, StatusE statusID, string tournamentUserID) { return(BaseCollection.ExecuteSql(t, InfiChess.TournamentWantinUser, "update TournamentWantinUser set TournamentWantinUserStatusID = @p1 WHERE TournamentUserID in (@p2)", statusID.ToString("d"), tournamentUserID)); }
private void Save(StatusE statusID, TournamentUserStatusE tournamentUserStatusID) { if (this.Tournament == null) { return; } if (this.Tournament.TournamentID == 0) { return; } if (this.Tournament.TournamentStatusIDE != TournamentStatusE.Scheduled) { return; } int i = 0; string userIDs = string.Empty; string tournamentWantinUserIDs = string.Empty; int teamID = 0, eloBefore = 0; try { foreach (DataGridViewRow row in dgvWantin.Rows) { int chessTypeID = Convert.ToInt32(GridTable.Rows[i]["ChessTypeId"]); if (dgvWantin[0, row.Index].Value != null) { if ((bool)dgvWantin[0, row.Index].Value) { if (this.Tournament.TournamentTypeE == TournamentTypeE.Scheveningen) { teamID = Convert.ToInt32(GridTable.Rows[i]["TeamID"]); } if (DBNull.Value != GridTable.Rows[i]["Rating"]) { eloBefore = GetEloBeforeRating(Convert.ToInt32(GridTable.Rows[i]["Rating"]), chessTypeID); } else { eloBefore = GetEloBeforeRating(0, chessTypeID); } int userID = BaseItem.ToInt32(GridTable.Rows[i]["UserID"]); int tournamentWantinUserID = BaseItem.ToInt32(GridTable.Rows[i]["TournamentWantinUserID"]); tournamentWantinUserIDs += "," + tournamentWantinUserID.ToString(); userIDs += "," + userID.ToString(); } } i++; } if (tournamentWantinUserIDs.Length > 0) { tournamentWantinUserIDs = tournamentWantinUserIDs.Remove(0, 1); } if (userIDs.Length > 0) { userIDs = userIDs.Remove(0, 1); } SocketClient.SaveWantinUsers(statusID, tournamentUserStatusID, this.Tournament.TournamentID, userIDs, tournamentWantinUserIDs, 0, eloBefore); RefreshGrid(); } catch (Exception ex) { TestDebugger.Instance.WriteError(ex); MessageForm.Show(ex); } }
public static DataTable GetAllUserByID(Cxt cxt, StatusE statusID) { DataTable table = BaseCollection.ExecuteSql(InfiChess.User, "SELECT u.*,UserRole.RoleID as RoleID, c.Name AS Country, Rank.Name AS Rank FROM [User] AS u LEFT OUTER JOIN Rank ON u.HumanRankID = Rank.RankID LEFT OUTER JOIN Country AS c ON u.CountryID = c.CountryID LEFT OUTER JOIN UserRole ON u.UserID = UserRole.UserRoleID where u.StatusID <>" + statusID.ToString("d")); return(table); }
public static DataTable GetAllTeam(StatusE statusE) { return(BaseCollection.ExecuteSql(InfiChess.Team, "SELECT * FROM Team WHERE statusID = @p1 ORDER BY DateCreated DESC", (int)statusE)); }
public static DataTable GetTournamentUsersWithCreatedDate(StatusE statusID, int tournamentID) { return(BaseCollection.Select(InfiChess.TournamentUser, "TournamentID = " + tournamentID + " and StatusID = " + statusID.ToString("d") + " ORDER BY DateCreated ASC")); }
public ClientStatusEventArgs(StatusE status) { Status = status; }
/// <summary> /// for online client /// </summary> /// <param name="statusID"></param> /// <param name="tournamentID"></param> /// <returns></returns> public static DataTable GetTournamentUsersByTournamentID(StatusE statusID, int tournamentID) { return(BaseCollection.Select(InfiChess.TournamentUser, "TournamentID = " + tournamentID + " and StatusID = " + statusID.ToString("d") + " ORDER BY EloBefore DESC")); }
public static void SetStatus(Cxt cxt, int id, StatusE status) { _Item item = new _Item(cxt, id); item.StatusID = status; item.Save(); }