private void vGrid_UpdateCommand(object source, DataGridCommandEventArgs e)
{
DBase.ExecuteReturnInt(Config.DBSaveBotChatVariant, "@ID", int.Parse(e.Item.Cells[2].Text),
"@postvariant", ((TextBox)e.Item.Cells[3].Controls[0]).Text, "@mapid", MapID);
vGrid.EditItemIndex = -1;
GridBindVariant();
}
protected void btnDecline_Click(object sender, System.EventArgs e)
{
ArrayList sIDs = GetCheckedValuesToArray(Config.MainCheckboxName);
if (sIDs.Count <= 0)
{
return;
}
DataTable dt = (DataTable)Session["Avatars_DT"];
dt.Constraints.Clear();
dt.Constraints.Add("cnst_ID_Avatars", dt.Columns["ID"], true);
string fPath = Config.GetConfigValue("AvatarUploadPath");
foreach (string sr in sIDs)
{
int id = int.Parse(sr);
int ret = DBase.ExecuteReturnInt(Config.DbDeleteAvatar, "@id", id);
DataRow dr = dt.Rows.Find(id);
fPath += ("\\" + dr["LoginName"] + "\\" + dr["File"]);
if (File.Exists(fPath))
{
File.Delete(fPath);
}
}
Bind_Grid();
}
protected void btnAddVarinats_Click(object sender, EventArgs e)
{
if (MapID < 0)
{
return;
}
DBase.ExecuteReturnInt(Config.DBSaveBotChatVariant, "@ID", -1, "@mapid", MapID);
GridBindVariant();
}
private void oGrid_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
int ID = Utils.GetInt(e.Item.Cells[0].Text);
ID = DBase.ExecuteReturnInt(Config.DbSaveActionDispatcher, "@ID", ID, "@IP", ((TextBox)e.Item.Cells[1].Controls[0]).Text, "@Port",
Utils.GetInt(((TextBox)e.Item.Cells[2].Controls[0]).Text));
oGrid.EditItemIndex = -1;
DoBindData();
}
protected void btnAccept_Click(object sender, System.EventArgs e)
{
string sIDs = GetCheckedValues(Config.MainCheckboxName);
if (sIDs == String.Empty)
{
return;
}
DBase.ExecuteReturnInt(Config.DbAcceptAvatar, "@ids", sIDs);
Bind_Grid();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
ArrayList lIDs = GetCheckedValuesToArray(Config.MainCheckboxName);
foreach (string s in lIDs)
{
DBase.ExecuteReturnInt(Config.DbSavePushingContentProcesses, "@id", -1, "@PushingContentID", ContentID,
"@ProcessID", Utils.GetInt(s));
}
GridBind();
}
protected void btnSave_Click(object sender, System.EventArgs e)
{
int nRes = 0;
SqlCommand oCmd = DBase.GetCommand(Config.DbSaveUserDetails);
SqlParameterCollection oParams = oCmd.Parameters;
//user Data
oParams.Add("@ID", nUserID);
oParams.Add("@FirstName", txtFirstName.Text);
oParams.Add("@LastName", txtLastName.Text);
oParams.Add("@Email", txtEmail.Text);
oParams.Add("@Location", txtLocation.Text);
oParams.Add("@StatusID", Core.GetSelectedValueInt(comboStatus));
oParams.Add("@SexID", Core.GetSelectedValueInt(comboSex));
oParams.Add("@LoginName", txtLogin.Text);
oParams.Add("@Password", txtPassword.Text);
//Mailing Address data
oParams.Add("@Address", txtAddress.Text);
oParams.Add("@City", txtCity.Text);
oParams.Add("@Zip", txtZip.Text);
oParams.Add("@Phone", txtPhone.Text);
oParams.Add("@StateID", Core.GetSelectedValueInt(comboState));
oParams.Add("@CountryID", Core.GetSelectedValueInt(comboCountry));
oParams.Add("@ChatAccess", (ChatCheck.Checked ? 1: 0));
nRes = DBase.ExecuteReturnInt(oCmd);
if (nRes > 0)
{
nUserID = nRes;
hdnUserID.Value = nRes.ToString();
StoreBackID(nRes);
lblInfo.Text = "User has been saved";
lblInfo.ForeColor = Color.Green;
Response.Redirect(GetGoBackUrl());
ShowControls();
}
else
{
switch (nRes)
{
case -1:
lblInfo.Text = "Such login name already exists";
break;
default:
lblInfo.Text = "Database error occured";
break;
}
}
}
private void oGrid_UpdateCommand(object source, DataGridCommandEventArgs e)
{
DropDownList CustomDDL = ( DropDownList)e.Item.Cells[3].Controls[0];
int idx = Utils.GetInt(CustomDDL.SelectedValue);
//int ret=
DBase.ExecuteReturnInt(Config.DBSaveBotChatListMap, "@ID", int.Parse(e.Item.Cells[2].Text),
"@keywords", ((TextBox)e.Item.Cells[4].Controls[0]).Text,
"@actiontypeid", idx);
oGrid.EditItemIndex = -1;
GridBind();
}
protected void btnSaveBet_Click(object sender, System.EventArgs e)
{
string xml = String.Format("<tsbettings tournamentid=\"{0}\" coefficient=\"{1}\">", 0, txtCoeff.Text);
foreach (DataRow dr in tbBlind.Rows)
{
xml += String.Format("<level num=\"{0}\" blind=\"{1}\" ante=\"{2}\"/>", dr["level"], dr["blind"], dr["ante"]);
}
xml += "</tsbettings>";
BID = DBase.ExecuteReturnInt(Config.DbSaveTournamentBettingsXMLTmpl, "@ID", BID, "@Name", txtName.Text, "@Data", xml);
Response.Redirect(Session["TournamentBettingsMaintenanceUrl"].ToString());
}
protected void SavePrize()
{
if (cbPrizeValueType.SelectedValue != Config.PrizeValueAny)
{
string stat = prData.CheckPercent();
if (stat != String.Empty)
{
lblInfo.Text = stat;
lblInfo.Visible = true;
return;
}
}
string xml = prData.DataSetToXML(nPrizeNumber, Utils.GetInt(cbCurrency.SelectedValue), Utils.GetInt(cbPrizeValueType.SelectedValue));
hdnTournamentPrizeXML.Value = xml;
xmlTournamentPrize = xml;
//Save values to DB
int nRes = 0;
nRes = DBase.ExecuteReturnInt(Config.DbSaveTournamentPrizeDetails, "@ID", nTournamentPrizeID,
"@name", txtName.Text, "@PrizeXml", xmlTournamentPrize,
"@CurrencyTypeID", Utils.GetInt(cbCurrency.SelectedValue),
"@PrizeValueType", Utils.GetInt(cbPrizeValueType.SelectedValue));
if (nRes > 0)
{
nTournamentPrizeID = nRes;
hdnTournamentPrizeID.Value = nTournamentPrizeID.ToString();
StoreBackID(nTournamentPrizeID);
lblInfo.Text = "Tournament Prize Table was saved";
lblInfo.ForeColor = Color.Green;
lblInfo.Visible = true;
Response.Redirect(GetGoBackUrl());
}
else
{
if (nRes == -1)
{
ShowError("Such tournament prize name already exists");
}
else
{
ShowError("Database error occured");
}
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
int ret = DBase.ExecuteReturnInt(Config.DbSavePushingContentUsers, "@ID", -1,
"@PushingContentID", ContentID, "@UserLoginname", txtLoginName.Text);
if (ret == -1)
{
lbStatus.Text = "User does not exists";
}
else if (ret == -2)
{
lbStatus.Text = "User already exists in this content";
}
GridBind();
}
/// <summary>
/// Process saved file
/// </summary>
public string ProcessFile(string filePath, string fileName, int fileSize, string OrigFile)
{
int rez = DBase.ExecuteReturnInt("admSaveAvatar", "@File", OrigFile, "@Path",
Config.GetConfigValue("AvatarUploadURL") + hdnLoginName.Value, "@Size", fileSize,
"@UserID", nUserID);
if (rez <= 0)
{
try
{
File.Delete(filePath);
}
catch (Exception oEx)
{
Log.Write(this, "Fail to delete file. Error description: " + oEx.Message);
}
return("Error uploading file " + OrigFile);
}
//rename uploaded file to permanent name
try
{
string cDir = Config.GetConfigValue("AvatarUploadPath");
string chPath = cDir + "\\" + hdnLoginName.Value;
string filePathNew = chPath + "\\" + OrigFile;
if (!Directory.Exists(chPath))
{
Directory.CreateDirectory(chPath);
}
if (File.Exists(filePathNew))
{
File.Delete(filePathNew);
}
File.Move(filePath, filePathNew);
}
catch (Exception oEx)
{
try
{
DBase.Execute("admDeleteAvatar", "@ID", rez);
File.Delete(filePath);
}
catch {}
Log.Write(this, "Fail to move file. Error description: " + oEx.Message);
return("Error occured during moving file " + fileName + ". ");
}
return("");
}
protected void btnTransfer_click(object sender, System.EventArgs e)
{
int nTrgAccountID = 0;
if (Utils.GetDecimal(hdnBalance.Value) < Utils.GetDecimal(txtAmountTr.Text))
{
return;
}
if (Utils.GetDecimal(txtAmountTr.Text) == 0)
{
return;
}
int UserID = DBase.ExecuteReturnInt(Config.DbGetUserID, new object[] { "@LoginName", txtUser.Text });
if (UserID <= 0)
{
lblInfo.Text = "Invalid Login name";
return;
}
DataRow oDR = GetFirstRow(Config.DbGetUserDetailsAccount, new object[] { "@UserID", UserID, "@CurrencyID", nCurrencyID });
if (oDR != null)
{
nTrgAccountID = Utils.GetInt(oDR["AccountID"]);
}
else
{
return;
}
DBase.BeginTransaction("TransferAmmount");
if (!SaveMoney(nAccountID, (0 - Utils.GetDecimal(txtAmountTr.Text)), txtReasonTr.Text))
{
DBase.RollbackTransaction();
return;
}
if (!SaveMoney(nTrgAccountID, Utils.GetDecimal(txtAmountTr.Text), txtReasonTr.Text))
{
DBase.RollbackTransaction();
return;
}
DBase.CommitTransaction();
lblInfo.Text = "User balance was changed";
lblInfo.ForeColor = Color.Green;
GetData();
}
private void dgPeriod_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
if (e.CommandName == "Report")
{
try
{
lbStatus.Text = "";
DateTime dtb = DateTime.Parse(e.Item.Cells[1].Text);
DateTime dte = DateTime.Parse(e.Item.Cells[2].Text);
CreateReport(dtb, dte, Reports.cpReportType.PlayPeriod, chAsResendTB.Checked);
}
catch
{
lbStatus.Text = "Error Parameters";
lbStatus.ForeColor = Color.Red;
}
}
else if (e.CommandName == "Reset")
{
try
{
lbStatus.Text = "";
int PerID = Utils.GetInt(e.Item.Cells[0].Text);
if (PerID <= 0)
{
return;
}
if (DBase.ExecuteReturnInt(Config.DbClosePeriod, new object[] { "@PeriodID", PerID }) != 0)
{
lbStatus.Text = "Error Execute";
lbStatus.ForeColor = Color.Red;
}
else
{
DBase.Execute("accUpdatePlayMoneyBalances");
lbStatus.Text = "Period Closed";
lbStatus.ForeColor = Color.Green;
DoDataBind();
}
}
catch
{
lbStatus.Text = "Error Execute";
lbStatus.ForeColor = Color.Red;
}
}
}
protected void btnSave_Click(object sender, System.EventArgs e)
{
int nRes = DBase.ExecuteReturnInt(Config.DbSaveEmailTemplate, "@ID", nTemplateID,
"@Subject", txtSubject.Text, "@Body", Server.HtmlDecode(txtBody.Value),
"@TemplateBody", templateLetterBody, "@TemplatePath", templateImageUrl,
"@TemplatePathValue", Config.FileEmailTemplateUrl);
if (nRes > 0)
{
Redirect(GetGoBackUrl());
}
else
{
lblError.Text = "Database error occured";
lblError.ForeColor = Color.Red;
}
}
public void btnAddUser_Click(object sender, EventArgs e)
{
int ret = DBase.ExecuteReturnInt(Config.DbAddInvitedUser, "@processid", mProcessID, "@loginname", txtUserName.Text,
"@ISTournament", mIsTournament);
if (ret == -2)
{
lbMessage.Text = "User does not exists";
return;
}
if (ret == -1)
{
lbMessage.Text = "User already exists";
return;
}
BindGrid();
}
private void oGrid_UpdateCommand(object source, DataGridCommandEventArgs e)
{
CultureInfo ci = new CultureInfo("en-US");
DateTime dt;
try
{
dt = DateTime.Parse(((TextBox)e.Item.Cells[4].Controls[0]).Text, ci);
}
catch { return; }
int ret = DBase.ExecuteReturnInt(Config.DbSavePushingContentList, "@ID", int.Parse(e.Item.Cells[2].Text),
"@Name", ((TextBox)e.Item.Cells[3].Controls[0]).Text,
"@ActivateDate", dt);
oGrid.EditItemIndex = -1;
GridBind();
}
private void oGrid_UpdateCommand(object source, DataGridCommandEventArgs e)
{
DateTime dt;
decimal dc;
try
{
dt = DateTime.Parse(((TextBox)e.Item.Cells[3].Controls[0]).Text, new CultureInfo("en-US"));
}
catch { return; }
try
{
dc = Decimal.Parse(((TextBox)e.Item.Cells[6].Controls[0]).Text, new CultureInfo("en-US"));
}
catch { return; }
DBase.ExecuteReturnInt(Config.DbSaveForcedExits, "@ID", int.Parse(e.Item.Cells[2].Text),
"@DateExit", dt,
"@Message", ((TextBox)e.Item.Cells[4].Controls[0]).Text,
"@AmountReset", dc,
"@WarningTimes", ((TextBox)e.Item.Cells[5].Controls[0]).Text);
oGrid.EditItemIndex = -1;
GridBind();
}
private int GetTournamentNextId()
{
int mxInt = DBase.ExecuteReturnInt(Config.DbGetTournamentMaxID, null);
return(mxInt + 1);
}
protected void btnSave_Click(object sender, System.EventArgs e)
{
string tranName = "SaveAffiliate";
DBase.BeginTransaction(tranName);
bool rez = false;
lblInfo.Text = "";
lblInfo.ForeColor = Color.Red;
try
{
if (chDeny.Checked)
{
DBase.Execute(Config.DbDeleteAffiliate, new object[] { "@IDs", nAffiliateID.ToString() });
btnReturn_Click(null, null);
return;
}
//1. Save/Update affiliate in DB
int nRes = DBase.ExecuteReturnInt(Config.DbSaveAffiliateDetails,
"@ID", nAffiliateID, "@Name", txtName.Text, "@EmailFrom", txtEmail.Text, "@StatusID", int.Parse(ddStatus.SelectedValue),
"@SkinsID", int.Parse(ddSkins.SelectedValue), "@Password", txtPassword.Text, "@BeneficiaryName", txtBeneficiaryName.Text, "@MailingAddress",
txtAddress.Text, "@City", txtCity.Text, "@StateID", int.Parse(ddState.SelectedValue), "@Zip", txtZip.Text,
"@CountryID", int.Parse(ddCountry.SelectedValue), "@FirstName", txtFirstName.Text,
"@LastName", txtLastName.Text, "@Title", txtTitle.Text, "@Phone", txtPhone.Text, "@Fax", txtFax.Text);
if (nRes <= 0)
{
switch (nRes)
{
case -1:
lblInfo.Text = "Such Affiliate name already exists";
break;
default:
lblInfo.Text = "Database error occured";
break;
}
DBase.RollbackTransaction(tranName);
return;
}
// Everything is Ok
DBase.CommitTransaction(tranName);
nAffiliateID = nRes;
hdnAffiliateID.Value = nRes.ToString();
StoreBackID(nRes);
lblInfo.Text = "Affiliate has been saved";
lblInfo.ForeColor = Color.Green;
if (hdnState.Value != ddStatus.SelectedValue && ddStatus.SelectedValue == "4")
{
string val = Config.GetDbConfigValue(DBase, 18); //Template name for affiliates
if (val == String.Empty)
{
rez = true;
return;
}
DataTable tb = DBase.GetDataTable(Config.DbGetEmailTemplateDetailsByName, "@Name", val);
if (tb == null)
{
rez = true;
return;
}
if (tb.Rows.Count <= 0)
{
rez = true;
return;
}
val = Config.GetDbConfigValue(DBase, 1); // Admin Email
if (val == String.Empty)
{
rez = true;
return;
}
CommonUse.CSentMail.Send(DBase, txtEmail.Text, val, tb.Rows[0]["subject"].ToString(), //Send message as autoresponder
tb.Rows[0]["body"].ToString().Replace("<BR>", "\n").Replace("<br>", "\n").Replace(" ", " "), 3, MailFormat.Text);
}
}
catch (Exception ex)
{
Common.Log.Write(this, ex);
DBase.RollbackTransaction(tranName);
lblInfo.Text = "Error occured";
lblInfo.ForeColor = Color.Red;
}
finally
{
if (rez)
{
lblInfo.Text += " Error send Email";
lblInfo.ForeColor = Color.Red;
}
if (lblInfo.ForeColor != Color.Red)
{
btnReturn_Click(null, null);
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
//1. Create new xml
string xmlString = "";
ApiControl oEngine = Config.GetApIEngine();
try
{
DateTime actTime;
try
{
actTime = DateTime.Parse(txtActivatedTime.Text, new CultureInfo("en-US"));
}
catch
{
lblInfo.Text = "Incorrect value for Activated Time. Please enter valid date.";
return;
}
nEngineID = Core.GetSelectedValueInt(comboEngine);
xmlString = oEngine.GetDefaultProperty(nEngineID, ApiMsg.enProcessFormTarget.Process);
xmlString = oCom.getFormXml(xmlString, "gameengine/properties/property", Page);
xmlString = oCom.setAttributeValue(xmlString, "gameengine/properties/property", "Tournament Type", (string)Session["Tournament Type Process"]);
if (xmlString == null)
{
return;
}
//2. Save values in DB
nCurrencyID = Core.GetSelectedValueInt(comboCurrency);
nSubCategoryID = Core.GetSelectedValueInt(comboSubCategory);
nActDispID = Core.GetSelectedValueInt(comboActDisp);
SqlCommand oCmd = DBase.GetCommand(Config.DbCreateFirstGameProcess);
SqlParameterCollection oParams = oCmd.Parameters;
oParams.Add("@Name", txtName.Text);
oParams.Add("@GameEngineID", nEngineID);
oParams.Add("@CurrencyTypeID", nCurrencyID);
oParams.Add("@SubCategoryID", nSubCategoryID);
oParams.Add("@SettingsXml", xmlString);
oParams.Add("@ActionDispatcherID", nActDispID);
oParams.Add("@ActivatedTime", actTime);
oParams.Add("@ProtectedCode", txtProtCode.Text);
oParams.Add("@RewardID", txtReward.Text);
oParams.Add("@Visible", chVisible.Checked ? 1:0);
oParams.Add("@CreatorUserID", SqlDbType.Int);
oParams["@CreatorUserID"].Value = 0;
oParams.Add("@ProtectedMode", Utils.GetInt(ddProtectedM.SelectedValue));
oParams.Add("@IsHighlighted", Utils.GetInt(ddHighlightedM.SelectedValue));
oParams.Add("@IsMassWatchingAllowed", Utils.GetInt(ddMassWatchingAllowed.SelectedValue));
SqlParameter oParam = new SqlParameter("@GameProcessID", SqlDbType.Int);
oParam.Direction = ParameterDirection.Output;
oParams.Add(oParam);
int Return = DBase.ExecuteReturnInt(oCmd);
if (Return <= 0)
{
if (Return < 0)
{
lblInfo.Text = "Such game process name already exists. Please try another one.";
}
else
{
lblInfo.Text = "Database error occured";
}
oCom.FillTable(xmlString, "gameengine/properties/property", true, ref table);
return;
}
int processID = Utils.GetInt(oParams["@GameProcessID"].Value);
//3. Call InitGameProcess method of Com
int pID = processID;
if (!oEngine.InitGameProcess(nEngineID, (int)ApiMsg.enProcessFormTarget.Process, ref pID, xmlString, nActDispID))
{
Log.Write(this, "Init game process error");
ShowError("Error occured. Game process wasn't created.");
oCom.FillTable(xmlString, "gameengine/properties/property", true, ref table);
return;
}
//4. Success message
nGameProcessID = processID;
hdnGameProcessID.Value = nGameProcessID.ToString();
lblInfo.Text = "Game process was created";
lblInfo.ForeColor = Color.Green;
oCom.FillTable(xmlString, "gameengine/properties/property", false, ref table);
ShowControls();
}
finally
{ oEngine = null; }
}
protected void btnSave_Click(object sender, System.EventArgs e)
{
int nRes = nSubCategoryID;
string tranName = "SaveSubcategory";
DBase.BeginTransaction(tranName);
//1. Save subcategory info
if (nSubCategoryID <= 0)
{
nRes = DBase.ExecuteReturnInt(Config.DbSaveSBSubCategory,
new object[] { "@id", nSubCategoryID,
"@CategoryID", Core.GetSelectedValueInt(comboCategory),
"@name", txtName.Text,
"@SpreadFrom", txtSpreadFrom.Text,
"@SpreadTo", txtSpreadTo.Text,
"@SpreadStep", txtSpreadStep.Text,
"@OuFrom", txtOuFrom.Text,
"@OuTo", txtOuTo.Text,
"@OuStep", txtOuStep.Text });
if (nRes <= 0)
{
lblInfo.ForeColor = Color.Red;
switch (nRes)
{
case -1:
lblInfo.Text = "Typed subcategory name already exists";
break;
case 0:
lblInfo.Text = "Database error occured";
break;
default:
lblInfo.Text = "Unknown error occured";
break;
}
DBase.RollbackTransaction(tranName);
return;
}
}
//2. Update Team info
int nRes2 = DBase.ExecuteNonQuery(Config.DbSaveTeamTable, "@SubcategoryID", nRes,
"@TeamValues", hdnTeamCSV.Value);
if (nRes2 < 0)
{
DBase.RollbackTransaction(tranName);
lblInfo.Text = "DB erors occured during processing Team Table";
lblInfo.ForeColor = Color.Red;
return;
}
DBase.CommitTransaction(tranName);
lblInfo.ForeColor = Color.Green;
lblInfo.Text = "SubCategory details have been saved";
StoreBackID(nRes);
hdnID.Value = nRes.ToString();
//BindTeam();
Response.Redirect(GetGoBackUrl());
}
/// <summary>
/// Save event handler.
/// </summary>
protected void btnSave_Click(object sender, System.EventArgs e)
{
//1. Get XML
sXML = hdnXML.Value;
oPrize.FillTable(ref sXML, ref table, true, false); //fill table from xml
//2. Save category in DB
string tranNameTotal = "admSaveSBCategoryDetails";
DBase.BeginTransaction(tranNameTotal);
int nRes = DBase.ExecuteReturnInt(Config.DbSaveSBCategoryDetails, new object[] { "@id", nCategoryID, "@Name", txtName.Text });
if (nRes <= 0)
{
DBase.RollbackTransaction(tranNameTotal);
lblInfo.ForeColor = Color.Red;
switch (nRes)
{
case -1:
lblInfo.Text = "Typed category name already exists";
break;
case 0:
lblInfo.Text = "Database error occured";
break;
default:
lblInfo.Text = "Unknown error occured";
break;
}
return;
}
//3. Batch upload of Teaser Table
try
{
DataTable xmlDT = oPrize.getDataTable(sXML); //DataTable from xml
DataColumn[] PrimaryKeyArray = new DataColumn[3];
PrimaryKeyArray[0] = xmlDT.Columns[PrizeTable.tblColName];
PrimaryKeyArray[1] = xmlDT.Columns[PrizeTable.tblRowName];
PrimaryKeyArray[2] = xmlDT.Columns[PrizeTable.tblValueName];
xmlDT.PrimaryKey = PrimaryKeyArray;
//using primary key we can update only recods that were changed
DataTable oDT = DBase.GetDataTableBatch("select id, Points, BetCount, Rate, CategoryID from Teaser where categoryID = " + nRes.ToString() + " order by Points, BetCount"); //dataTable from SQL
//clear all old data
foreach (DataRow oDR in oDT.Rows)
{
DataRow oRow = xmlDT.Rows.Find(new object[3] {
oDR["Points"].ToString(), oDR["BetCount"].ToString(), oDR["Rate"].ToString()
});
if (oRow != null)
{
oRow.Delete();
}
else
{
oDR.Delete();
}
}
//do we have any records to add
bool hasRecords = true;
if (xmlDT.Rows.Count < 1)
{
hasRecords = false;
}
if ((xmlDT.Rows.Count == 1) && (xmlDT.Rows[0][PrizeTable.tblValueName].ToString() == ""))
{
hasRecords = false; //one record, but value is empty
}
if (hasRecords)
{
//add new data
foreach (DataRow oDR in xmlDT.Rows)
{
DataRow row = oDT.NewRow();
row["Points"] = oDR[PrizeTable.tblColName];
row["BetCount"] = oDR[PrizeTable.tblRowName];
row["Rate"] = Utils.GetDecimal(oDR[PrizeTable.tblValueName]);
row["CategoryID"] = nRes;
oDT.Rows.Add(row);
}
}
bool bRes = DBase.Update(oDT);
if (!bRes)
{
DBase.RollbackTransaction(tranNameTotal);
ShowError("DB error occured during Teaser data update.");
return;
}
}
catch (Exception oEx)
{
DBase.RollbackTransaction(tranNameTotal);
ShowError("DB error occured during Teaser data update block.");
Log.Write(this, oEx);
return;
}
//End of Batch upload of Teaser Table
//4. Sucess message
DBase.CommitTransaction(tranNameTotal);
nCategoryID = nRes;
StoreBackID(nRes);
hdnID.Value = nRes.ToString();
lblInfo.ForeColor = Color.Green;
lblInfo.Text = "Category details have been saved";
Response.Redirect(GetGoBackUrl());
}
private bool SaveData(int stateID)
{
string tranName = "SaveEvent";
DBase.BeginTransaction(tranName);
//1. Save/Update Event
object StartDate = Utils.GetDbDate(Request["comboDate"] + " " + Request["comboTime"] + ":00");
int nRes = DBase.ExecuteReturnInt(Config.DbSaveEvent,
"@EventID", nEventID,
"@StateID", stateID,
"@StartSchedule", sGuid,
"@SubCategoryID", Request["comboSubCategory"],
"@AwayTeamID", Request["comboAway"],
"@HomeTeamID", Request["comboHome"],
"@StartDate", StartDate);
if (nRes <= 0)
{
ShowError("Database error occured");
DBase.RollbackTransaction(tranName);
return(false);
}
//2. Update Outcomes
decimal Rate = 0;
decimal Point = 0;
bool isSave = false;
string sPoint = "";
DataTable oDT = DBase.GetDataTableBatch(string.Format(Config.DbUpdateOutcome, nRes));
DataColumn[] PrimaryKeyArray = new DataColumn[4];
PrimaryKeyArray[0] = oDT.Columns["EventID"];
PrimaryKeyArray[1] = oDT.Columns["BetTypeID"];
PrimaryKeyArray[2] = oDT.Columns["isHome"];
PrimaryKeyArray[3] = oDT.Columns["PeriodID"];
oDT.PrimaryKey = PrimaryKeyArray;
//Home Spread
Rate = Utils.GetDecimal(txtHomeSpread.Text);
sPoint = Request["comboHomeSpread"];
Point = Utils.GetDecimal(sPoint);
isSave = isNumber(sPoint);
UpdateRow(oDT, nRes, typeSpread, againstHome, periodFull, Rate, Point, isSave);
UpdateRow(oDT, nRes, typeSpread, againstAway, periodFull, -Rate, -Point, isSave);
Rate = Utils.GetDecimal(txtHomeSpreadHalf.Text);
sPoint = Request["comboHomeSpreadHalf"];
Point = Utils.GetDecimal(sPoint);
isSave = isNumber(sPoint);
UpdateRow(oDT, nRes, typeSpread, againstHome, periodHalf, Rate, Point, isSave);
UpdateRow(oDT, nRes, typeSpread, againstAway, periodHalf, -Rate, -Point, isSave);
//Over Under
Rate = Utils.GetDecimal(txtTotalOU.Text);
sPoint = Request["comboTotalOU"];
Point = Utils.GetDecimal(sPoint);
isSave = isNumber(sPoint);
UpdateRow(oDT, nRes, typeOu, againstHome, periodFull, Rate, Point, isSave);
UpdateRow(oDT, nRes, typeOu, againstAway, periodFull, -Rate, -Point, isSave);
Rate = Utils.GetDecimal(txtTotalOUHalf.Text);
sPoint = Request["comboTotalOUHalf"];
Point = Utils.GetDecimal(sPoint);
isSave = isNumber(sPoint);
UpdateRow(oDT, nRes, typeOu, againstHome, periodHalf, Rate, Point, isSave);
UpdateRow(oDT, nRes, typeOu, againstAway, periodHalf, -Rate, -Point, isSave);
//ML
Rate = Utils.GetDecimal(txtHomeTeam.Text);
sPoint = Request["comboHomeTeam"];
Point = Utils.GetDecimal(sPoint);
isSave = isNumber(sPoint);
UpdateRow(oDT, nRes, typeML, againstHome, periodFull, Rate, Point, isSave);
UpdateRow(oDT, nRes, typeML, againstAway, periodFull, -Rate, -Point, isSave);
bool bRes = DBase.Update(oDT);
if (!bRes)
{
ShowError("DataBase error occured during saving Outcomes");
DBase.RollbackTransaction(tranName);
return(false);
}
// Everything is Ok
DBase.CommitTransaction(tranName);
nEventID = nRes;
StoreBackID(nRes);
hdnEventID.Value = nRes.ToString();
return(true);
}
protected override void btnAdd_Click(object sender, EventArgs e)
{
//int ret=
DBase.ExecuteReturnInt(Config.DBSaveBotChatListMap, "@ID", -1);
GridBind();
}
protected void btnSave_Click(object sender, System.EventArgs e)
{
string tranName = "UpdateSubCategoryStats";
DBase.BeginTransaction(tranName);
//1. Save/update Subcategory details
SqlCommand oCmd = DBase.GetCommand(Config.DbSaveSubCategoryDetails);
SqlParameterCollection oParams = oCmd.Parameters;
oParams.Add("@ID", nSubCategoryID);
oParams.Add("@Name", txtName.Text);
oParams.Add("@StatusID", Core.GetSelectedValueInt(comboStatus));
oParams.Add("@CategoryID", Core.GetSelectedValueInt(comboCategory));
int nRes = DBase.ExecuteReturnInt(oCmd);
if (nRes <= 0)
{
lblInfo.ForeColor = Color.Red;
switch (nRes)
{
case -1:
lblInfo.Text = "Typed category name already exists";
break;
default:
lblInfo.Text = "Database error occured";
break;
}
DBase.RollbackTransaction(tranName);
return;
}
//2. update SubCategoryStats table
DataTable oDT = DBase.GetDataTableBatch(string.Format(Config.DbUpdateSubCategoryStats, nRes));
DataColumn[] PrimaryKeyArray = new DataColumn[2];
PrimaryKeyArray[0] = oDT.Columns["SubCategoryID"];
PrimaryKeyArray[1] = oDT.Columns["StatsTypeID"];
oDT.PrimaryKey = PrimaryKeyArray;
try
{
//a. Delete rows that are not any more in the list
string[] statsList = hdnStatsList.Value.Split(',');
int statsLen = statsList.Length;
if (hdnStatsList.Value == "")
{
statsLen = 0;
}
int k = 0;
while (k < oDT.Rows.Count)
{
DataRow oRow = oDT.Rows[k];
bool bFind = false;
for (int i = 0; i < statsLen; i++)
{
if (oRow["StatsTypeID"].ToString() == statsList[i])
{
bFind = true;
}
}
if (!bFind)
{
oRow.Delete();
}
k++;
}
//b. Add/update order for the list
for (int i = 0; i < statsLen; i++)
{
DataRow oRow = oDT.Rows.Find(new object[] { nRes, statsList[i] });
if (oRow == null)
{
oDT.Rows.Add(new object[] { nSubCategoryID, statsList[i], i + 1 });
}
else
{
if (Convert.ToInt32(oRow["Order"]) != i + 1)
{
oRow["Order"] = i + 1;
}
}
}
}
catch (Exception oEx)
{
Log.Write(this, "DataTable operations Error: " + oEx.Message);
DBase.RollbackTransaction(tranName);
lblInfo.Text = "DataBase error occured during updating table";
lblInfo.ForeColor = Color.Red;
return;
}
bool bRes = DBase.Update(oDT);
if (bRes)
{
DBase.CommitTransaction(tranName);
hdnSubCategoryID.Value = nRes.ToString();
StoreBackID(nRes);
lblInfo.Text = "Category details have been saved";
lblInfo.ForeColor = Color.Green;
Response.Redirect(GetGoBackUrl());
nSubCategoryID = nRes;
BindStatsList();
rowRelatedProcesses.Visible = true;
BindRelatedProcessList();
}
else
{
DBase.RollbackTransaction(tranName);
lblInfo.Text = "DataBase error occured during updating table";
lblInfo.ForeColor = Color.Red;
}
}
protected void btnCreateReport_Click(object sender, System.EventArgs e)
{
try
{
if (ddReport.Value == "0")
{
Reports_PreRender(null, null);
return;
}
ItemSelected();
Session["RepDs_" + ddReport.Value] = null;
Session["CrystalRepPrm_" + ddReport.Value] = null;
int ret = OnLineReport(Utils.GetInt(ddReport.Value));
if (ret >= 0)
{
return;
}
ArrayList ar = new ArrayList();
ar.Add(new String[] { "valueaslist", chValueAsList.Checked.ToString() });
if (txdtFrom.Disabled == false)
{
ar.Add(new String[] { "db", txdtFrom.Value.Trim() });
ar.Add(new String[] { "de", txdtTo.Value.Trim() });
}
if (chMoney.Disabled == false)
{
ar.Add(new String[] { "chm", chMoney.Checked.ToString() });
ar.Add(new String[] { "chn_m", chPlayMoney.Checked.ToString() });
}
if (txPID.Disabled == false)
{
if (chValueAsList.Checked == false)
{
int uID = Utils.GetInt(txPID.Value);
if (uID == 0 && txLoginName.Value != String.Empty)
{
uID = DBase.ExecuteReturnInt("wntGetUserID", new object[] { "@LoginName", txLoginName.Value });
}
ar.Add(new String[] { "uid", uID.ToString() });
}
else
{
ar.Add(new String[] { "uid", txPID.Value });
ar.Add(new String[] { "loginname", CheckStringPrm(txLoginName.Value) });
}
}
if (txtMACAddress.Disabled == false)
{
ar.Add(new String[] { "macaddress", CheckStringPrm(txtMACAddress.Value) });
}
ar.Add(new String[] { "nobots", (chnoBots.Checked?"1":"0") });
Session["CrystalRepPrm_" + ddReport.Value] = ar;
String scriptString = "<script language=JavaScript>";
scriptString += " window.open('" + Config.SiteBaseUrl + "Reports/ViewForm.aspx?RepID=" + ddReport.Value + "');ItemSelected();</script>";
if (!this.IsStartupScriptRegistered("clientScript"))
{
this.RegisterStartupScript("clientScript", scriptString);
}
}
catch (Exception ex)
{
Log.Write(this, ex);
}
}
private int OnLineReport(int mID)
{
int ret = -1;
DateTime m_dtb = DateTime.Now;
DateTime m_dte = DateTime.Now;
DataSet ds;
lbResult.Text = "";
int uID = 0;
string dtPref = "From " + txdtFrom.Value + " to " + txdtTo.Value;
try
{
if (txdtFrom.Disabled == false)
{
m_dtb = DateTime.Parse(txdtFrom.Value.Trim());
m_dte = DateTime.Parse(txdtTo.Value.Trim());
}
if (txPID.Disabled == false)
{
uID = Utils.GetInt(txPID.Value);
if (uID == 0 && txLoginName.Value != String.Empty)
{
uID = DBase.ExecuteReturnInt("wntGetUserID", new object[] { "@LoginName", txLoginName.Value });
}
}
}
catch (Exception ex)
{
Log.Write(this, ex);
return(1);
}
ReportDoc rdc = new ReportDoc(Config.DbConnectionString, 600, DBase);
switch (mID)
{
case 3:
int Intr = Utils.GetInt(txDiscretCount.Value);
if (Intr <= 0)
{
return(2);
}
int iType = Utils.GetInt(slIntrType.Value);
ds = rdc.CreateReportSource("wntConcurrentPlayers", "ConcurrentPlayers", new object[] { "@dtBegin", m_dtb, "@dtEnd", m_dte,
"@Interval", Intr, "@IntervalType", iType, "@NoBots", chnoBots.Checked?1:0 });
if (ds.Tables[0].Rows.Count > 0)
{
lbResult.Text = dtPref + "<br>Maximum concurrent players: " +
ds.Tables[0].Rows[0]["Maximum"].ToString() + "<br>Minimum concurrent players: " + ds.Tables[0].Rows[0]["Minimum"].ToString();
}
else
{
lbResult.Text = dtPref + " No data";
}
ret = 0;
break;
case 5:
ds = rdc.CreateReportSource("wntBiggestHand", "BiggestHand", new object[] { "@dtBegin", m_dtb, "@dtEnd", m_dte, "@NoBots", chnoBots.Checked?1:0 });
if (ds.Tables[0].Rows.Count > 0)
{
lbResult.Text = dtPref + "<br>Biggest Chip Hand ID: " +
ds.Tables[0].Rows[0]["HandID"].ToString() + "<br>Amount: " + ds.Tables[0].Rows[0]["Amount"].ToString();
}
else
{
lbResult.Text = dtPref + " Biggest Chip Hand ID: 0 , Amount: 0";
}
ret = 0;
break;
case 6:
ds = rdc.CreateReportSource("wntUsersSignupAndPlay", "UsersSignupAndPlay", new object[] { "@dtBegin", m_dtb, "@dtEnd", m_dte, "@NoBots", chnoBots.Checked?1:0 });
if (ds.Tables[0].Rows.Count > 0)
{
lbResult.Text = dtPref + "<br>Players registered: " +
ds.Tables[0].Rows[0]["Registered"].ToString() + "<br>Played a game: " + ds.Tables[0].Rows[0]["Played"].ToString();
}
else
{
lbResult.Text = dtPref + " Registered: 0 , Played a game: 0";
}
ret = 0;
break;
case 8:
ds = rdc.CreateReportSource("wntTimeSpendByUser", "TimeSpendByUser",
new object[] { "@dtBegin", m_dtb, "@dtEnd", m_dte, "@UserID", uID, "@NoBots", chnoBots.Checked?1:0 });
if (ds.Tables[0].Rows.Count > 0)
{
lbResult.Text = dtPref + "<br>Average Time Spent on the System is " + ds.Tables[0].Rows[0]["SpentTime"].ToString() + " minutes per user ";
}
else
{
lbResult.Text = dtPref + "<br>Average Time Spent on the System is 0";
}
ret = 0;
break;
}
return(ret);
}
/* public string GetBannerURL()
* {
* return Config.GetConfigValue("SkinsBannerURL")+"/Skin_"+ nSkinID.ToString()+"/Banner/"+Config.GetConfigValue("ImageBannerName");
* }*/
private void btnSignUp_Click(object sender, System.EventArgs e)
{
int nSkinID = 0;
nSkinID = Common.Utils.GetInt(ddSkins.SelectedValue);
if (nSkinID <= 0)
{
return;
}
if (!chAgree.Checked)
{
lblInfo.Text = "You must agree to the Affiliate Agreement";
return;
}
if (txtPassword.Text != txtPasswordRet.Text)
{
lblInfo.Text = "Re-Typed password not equal to Password";
return;
}
string tranName = "SaveAffiliate";
try
{
DBase.BeginTransaction(tranName);
//1. Save/Update affiliate in DB
int nRes = DBase.ExecuteReturnInt(Config.DbSaveAffiliateDetails,
"@ID", -1, "@Name", txtName.Text, "@EmailFrom", txtEmail.Text, "@StatusID", 5, "@SkinsID", nSkinID
, "@Password", txtPassword.Text, "@BeneficiaryName", txtBeneficiaryName.Text, "@MailingAddress",
txtAddress.Text, "@City", txtCity.Text, "@StateID", int.Parse(ddState.SelectedValue), "@Zip", txtZip.Text,
"@CountryID", int.Parse(ddCountry.SelectedValue), "@FirstName", txtFirstName.Text,
"@LastName", txtLastName.Text, "@Title", txtTitle.Text, "@Phone", txtPhone.Text, "@Fax", txtFax.Text);
if (nRes <= 0)
{
switch (nRes)
{
case -1:
lblInfo.Text = "Such Affiliate Login already exists";
break;
default:
lblInfo.Text = "Database error occured";
break;
}
DBase.RollbackTransaction(tranName);
return;
}
// Everything is Ok
DBase.CommitTransaction(tranName);
lblInfo.Text = "Affiliate has been saved";
lblInfo.ForeColor = Color.Green;
Response.Redirect("Signupcomplete.aspx?SkinsID=" + nSkinID.ToString());
}
catch (Exception ex)
{
Log.Write(this, ex);
DBase.RollbackTransaction(tranName);
lblInfo.Text = "Error occured during save data";
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
//int ret=
DBase.ExecuteReturnInt(Config.DbSavePushingContentList, "@ID", -1);
GridBind();
}