public static void Add(BlindsLevel level)
{
try
{
long id = long.Parse(DateTime.Now.ToString("yyyyMMddHHmmss"));
string sql = @"INSERT INTO blindschedule ( tournamentid,
level,
stage,
length,
smallblind,
bigblind,
ante
)
values(
@tournamentid,
@level,
@stage,
@length,
@smallblind,
@bigblind,
@ante
)";
SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);
command.Parameters.AddWithValue("@tournamentid", level.TournamentId);
command.Parameters.AddWithValue("@level", level.Level);
command.Parameters.AddWithValue("@stage", level.Stage);
command.Parameters.AddWithValue("@length", level.Length);
command.Parameters.AddWithValue("@smallblind", level.SmallBlind);
command.Parameters.AddWithValue("@bigblind", level.BigBlind);
command.Parameters.AddWithValue("@ante", level.Ante);
command.ExecuteNonQuery();
}
catch
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
txtTotalOfLevels.Attributes.Add("onchange", "validateTotalOfLevels()");
txtStartingTime.Attributes.Add("placeholder", "dd/MM/yyyy - HH:mm");
}
else
{
string errorMsg = string.Empty;
List <BlindsLevel> levels = new List <BlindsLevel>();
NameValueCollection form = Request.Form;
if (!GetString("txtName", form, ref tournamentName))
{
errorMsg = "Tên tournament không được rỗng";
}
if (!GetInt("txtStartingChips", form, ref startingChips))
{
errorMsg = "Starting Chips rỗng hoặc không phải là số";
}
if (!GetInt("txtRebuy", form, ref rebuy))
{
errorMsg = "Rebuy rỗng hoặc không phải là số";
}
if (!GetInt("txtAddon", form, ref addon))
{
errorMsg = "Addon rỗng hoặc không phải là số";
}
if (!GetDateTime("txtStartingTime", form, ref startingTime))
{
errorMsg = "StartingTime rỗng hoặc không đúng định dạng";
}
if (!GetInt("txtTotalOfLevels", form, ref totalOfLevels))
{
errorMsg = "Total of levels rỗng hoặc không phải là số";
}
if (!GetInt("txtLevelTimeLength", form, ref levelTimeLength))
{
errorMsg = "Level time length rỗng hoặc không phải là số";
}
if (!GetInt("txtBreakLevelRange", form, ref breakAfterLevel))
{
errorMsg = "Break after level rỗng hoặc không phải là số";
}
if (!GetInt("txtBreakTime", form, ref breakTime))
{
errorMsg = "BreakTime rỗng hoặc không phải là số";
}
BlindData[] datas = new BlindData[totalOfLevels];
blindScheduleContent.InnerHtml = string.Empty;
for (int i = 0; i < totalOfLevels; i++)
{
datas[i] = new BlindData();
int small = -1, big = -1, ante = -1;
if (!GetInt("small_" + i.ToString(), form, ref small))
{
errorMsg = string.Format("Tham số Small (Level {0}) rỗng hoặc không phải là số", i + 1);
}
if (!GetInt("big_" + i.ToString(), form, ref big))
{
errorMsg = string.Format("Tham số Big (Level {0}) rỗng hoặc không phải là số", i + 1);
}
if (!GetInt("ante_" + i.ToString(), form, ref ante))
{
errorMsg = string.Format("Tham số Ante (Level {0}) rỗng hoặc không phải là số", i + 1);
}
datas[i].Small = small; datas[i].Big = big; datas[i].Ante = ante;
blindScheduleContent.InnerHtml += string.Format("<tr><td>{5}</td><td><input name=\"small_{0}\" id=\"small_{0}\" value=\"{1}\"/></td><td><input name=\"big_{0}\" id=\"big_{0}\" value=\"{2}\"/></td><td><input name=\"ante_{0}\" id=\"ante_{0}\" value=\"{3}\"/></td><td name=\"length_{0}\" id=\"length_{0}\">{4}</td></tr>", i, form["small_" + i.ToString()], form["big_" + i.ToString()], form["ante_" + i.ToString()], levelTimeLength, i + 1);
}
if (!string.IsNullOrEmpty(errorMsg))
{
string cRefreshParent = "<script language='javascript'>" +
" alert('" + errorMsg + "');</script>";
string cRefreshParentKey = "RefreshParentKey";
if (!this.Page.ClientScript.IsClientScriptBlockRegistered(cRefreshParentKey))
{
this.Page.ClientScript.RegisterClientScriptBlock(this.GetType(),
cRefreshParentKey, cRefreshParent);
}
return;
}
else
{
Tournament tour = new Tournament();
tour.Id = -1;
tour.Name = tournamentName;
tour.StartingChips = startingChips;
tour.Rebuy = rebuy;
tour.Addon = addon;
tour.StartingTime = startingTime;
tour.IsStopped = false;
tour.LastStage = 0;
tour.LastStageTime = 0;
tour.PrizePool = 0;
tour.TotalPlayers = 0;
tour.UpdateTime = DateTime.Now;
long tourId = tblTournament.Add(tour);
if (totalOfLevels > 0 && tourId != -1)
{
int currentStage = 0;
for (int i = 0; i < totalOfLevels; i++)
{
if (i % breakAfterLevel == 0)
{
currentStage++;
BlindsLevel breakLevel = new BlindsLevel();
breakLevel.Stage = 0; breakLevel.Ante = 0; breakLevel.BigBlind = 0; breakLevel.SmallBlind = 0;
breakLevel.TournamentId = tour.Id; breakLevel.Length = breakTime;
tblBlindsSchedule.Add(breakLevel);
}
currentStage++;
BlindsLevel newLevel = new BlindsLevel();
newLevel.Stage = currentStage; newLevel.Ante = datas[i].Small;
newLevel.BigBlind = datas[i].Big; newLevel.SmallBlind = datas[i].Ante;
newLevel.TournamentId = tourId; newLevel.Length = levelTimeLength;
tblBlindsSchedule.Add(newLevel);
}
string cRefreshParent = "<script language='javascript'>" +
" alert('Thêm tournament thành công.');</script>";
string cRefreshParentKey = "RefreshParentKey";
if (!this.Page.ClientScript.IsClientScriptBlockRegistered(cRefreshParentKey))
{
this.Page.ClientScript.RegisterClientScriptBlock(this.GetType(),
cRefreshParentKey, cRefreshParent);
}
}
else
{
string cRefreshParent = "<script language='javascript'>" +
" alert('Thêm tournament bị lỗi.');</script>";
string cRefreshParentKey = "RefreshParentKey";
if (!this.Page.ClientScript.IsClientScriptBlockRegistered(cRefreshParentKey))
{
this.Page.ClientScript.RegisterClientScriptBlock(this.GetType(),
cRefreshParentKey, cRefreshParent);
}
return;
}
}
}
}
