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