private void btnViewTicketTemplate_Click(object sender, EventArgs e)
{
try
{
DbBehavior.DbConnectionString = txtDbConnectionString.Text;
var query = string.Format(
"SELECT \r\n" +
"[TicketTemplateId] \r\n" +
",[PlayTypeId] \r\n" +
",[Name] \r\n" +
",[Value] \r\n" +
",[TourneyTemplateIdList] \r\n" +
",[Refundable] \r\n" +
"FROM [rb_crm_dev].[dbo].[TicketTemplates] \r\n");
var form = new FrmViewFromQuery(query);
form.Show();
}
catch (Exception ex)
{
AddLog("ViewPlayers Exception : ", ex.ToString());
}
}
private void btnViewPlayers_Click(object sender, EventArgs e)
{
try
{
DbBehavior.DbConnectionString = txtDbConnectionString.Text;
var query = string.Format(
"SELECT \r\n" +
"[UserName] \r\n" +
",[AccountId] \r\n" +
",[NickName] \r\n" +
"--,[ServiceProviderId] \r\n" +
"--,[Rank] \r\n" +
"--,[Name] \r\n" +
"--,[Email] \r\n" +
"--,[RegistrationDate] \r\n" +
"--,[RegistrationIP] \r\n" +
"--,[Address1] \r\n" +
"--,[Address2] \r\n" +
"--,[City] \r\n" +
"--,[State] \r\n" +
"--,[ZipCode] \r\n" +
"--,[Country] \r\n" +
"--,[Phone] \r\n" +
"--,[ChatLocked] \r\n" +
"--,[ChatLockExpireDays] \r\n" +
"--,[PlayLocked] \r\n" +
"--,[PlayLockExpireDays] \r\n" +
"--,[AccountLocked] \r\n" +
"--,[AccountLockExpireDays] \r\n" +
"--,[GGPoint] \r\n" +
"--,[TourneyMoney] \r\n" +
"--,[ImageLocked] \r\n" +
"--,[SuperUser] \r\n" +
"--,[LoginName] \r\n" +
"FROM [rb_crm_dev].[dbo].[Players] \r\n" +
"WHERE 1=1 \r\n" +
"AND [ServiceProviderId] = '1432EEC3-7431-EFCF-8B58-BBF351EB0E40' \r\n" +
"ORDER BY SUBSTRING(NickName, 1, 1), LEN(NickName), NickName \r\n");
var form = new FrmViewFromQuery(query);
form.Show();
}
catch (Exception ex)
{
AddLog("ViewPlayers Exception : ", ex.ToString());
}
}
