private void ShowFields(string indexName)
{
this.currentIndexDbo = CfcWebService.GetIndexDescription(this.currentTable, this.currentIndex);
this.lstFieldList4.DataSource = this.currentIndexDbo.IndexedColumns;
this.lstFieldList4.DataBind();
this.chkCompactLargeObjects4.Checked = currentIndexDbo.CompactLargeObjects; // 1
this.chkDisallowPageLocks4.Checked = currentIndexDbo.DisallowPageLocks; // 2
this.chkDisallowRowLocks4.Checked = currentIndexDbo.DisallowRowLocks; // 3
this.txtFillFactor4.Text = currentIndexDbo.FillFactor.ToString(); // 4
this.txtFilterDefinition4.Text = currentIndexDbo.FilterDefinition; // 5
this.chkIgnoreDuplicateKeys4.Checked = currentIndexDbo.IgnoreDuplicateKeys; // 6
string tmp = currentIndexDbo.IndexKeyType.ToString();
int i = ddlIndexKeyType4.Items.Count - 1;
while (i > 0)
{
if (String.Compare(ddlIndexKeyType4.Items[i].Value, tmp, true) == 0)
{
break;
}
else
{
i--;
}
}
ddlIndexKeyType4.SelectedIndex = i; // 7
this.chkIsClustered4.Checked = currentIndexDbo.IsClustered; // 8
this.chkIsDisabled4.Checked = currentIndexDbo.IsDisabled; // 9
this.chkIsUnique4.Checked = currentIndexDbo.IsUnique; // 10
}
public void SetupPage()
{
this.txtServerName2.Text = CfcWebService.SqlServerName;
this.txtDatabaseName2.Text = CfcWebService.DatabaseName;
CfcDbChangesDbo dbo = CfcWebService.GetFirstCfcDbChanges();
txtMajorDbVersion2.Text = Math.Max((short)1, dbo.CFC_DB_Major_Version).ToString();
txtMinorDbVersion2.Text = dbo.CFC_DB_Minor_Version.ToString();
txtTable2.Text = dbo.Table_Name;
}
public void SetupPage()
{
this.txtServerName4.Text = CfcWebService.SqlServerName;
this.txtDatabaseName4.Text = currentDatabase = CfcWebService.DatabaseName;
this.lstTableList4.DataSource = tableList = CfcWebService.GetAllTables();
this.lblErrorMessage4.Text = String.Empty;
this.lstTableList4.DataBind();
CfcDbChangesDbo dbo = CfcWebService.GetFirstCfcDbChanges();
txtMajorDbVersion4.Text = Math.Max((short)1, dbo.CFC_DB_Major_Version).ToString();
txtMinorDbVersion4.Text = dbo.CFC_DB_Minor_Version.ToString();
}
private void ShowForeignKeys()
{
this.foreignKeys = CfcWebService.GetForeignKeys(this.currentTable);
var fKeyNames = new List <string>();
foreach (ForeignKeyDbo dbo in foreignKeys)
{
fKeyNames.Add(dbo.Name);
}
lstForeignKeyList6.DataSource = fKeyNames;
lstForeignKeyList6.DataBind();
}
public UsrNamePassword(string encUsername, string encPassword)
{
CspParameters cspParams = new CspParameters();
cspParams.Flags = CspProviderFlags.UseMachineKeyStore;
var myRSA = new RSACryptoServiceProvider(cspParams);
if (HttpContext.Current.Session == null || HttpContext.Current.Session[CfcWebService.CertificateKey] == null)
{
this.UserName = this.Password = null;
}
else
{
myRSA.FromXmlString((string)HttpContext.Current.Session[CfcWebService.CertificateKey]);
this.UserName = Encoding.UTF8.GetString(myRSA.Decrypt(CfcWebService.ToHexByte(encUsername), false));
this.Password = Encoding.UTF8.GetString(myRSA.Decrypt(CfcWebService.ToHexByte(encPassword), false));
}
}
protected void Wizard1_OnActiveStepChanged(Object sender, EventArgs e)
{
var wizard = (Wizard)sender;
Func <List <string>, string> ulItems = delegate(List <string> options)
{
var sb = new StringBuilder();
options.ForEach(x => { sb.AppendFormat("<li>{0}</li>", x); });
return(sb.ToString());
};
bool noSession = HttpContext.Current.Session == null || String.IsNullOrEmpty(HttpContext.Current.Session.SessionID);
List <string> roles = noSession ? new List <string>() : CfcWebService.GetUsersRoles();
if (roles == null || roles.Count < 1)
{
wizard.ActiveStepIndex = 0;
this.StartPageContent.setDefaultLoginText();
}
else
{
switch (wizard.ActiveStepIndex)// == 0)
{
case 0:
this.StartPageContent.setConnectedLoginText(roles);
break;
case 1:
this.BackupPageContent.SetDefaultFileName();
break;
case 2:
this.ModifyTablePageContent.SetupPage();
break;
case 3:
this.ModifyIndexesContent.SetupPage();
break;
case 4:
this.ModifyForeignKeysContent.SetupPage();
break;
}
}
}
private void ShowIndexes()
{
lstIndexList4.DataSource = indexList = CfcWebService.GetAllIndexes(this.currentTable);
lstIndexList4.DataBind();
}
protected void _Default_PreInit(object sender, EventArgs e)
{
rsaParam = CfcWebService.GetPublicKey();
}