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()));
}
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 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 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());
}
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 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 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 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(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));
}
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 GetTournamentUsersWithCreatedDate(StatusE statusID, int tournamentID)
{
return(BaseCollection.Select(InfiChess.TournamentUser, "TournamentID = " + tournamentID + " and StatusID = " + statusID.ToString("d") + " ORDER BY DateCreated ASC"));
}
/// <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"));
}
