private InstanceInfo CreateFromRow(ServerInstanceRow instanceRow) { long loginId = instanceRow.LoginId; LoginRow loginRow = this._loginManager.GetLogin(loginId); AuthenticationInfo authInfo = new AuthenticationInfo { Username = loginRow.Login, Password = loginRow.Password, IsWindows = loginRow.IsWinAuth }; string conName = instanceRow.ConnectionName; InstanceInfo instanceInfo = new InstanceInfo(instanceRow.IsDynamicConnection) { Authentication = authInfo, IsODBC = instanceRow.IsOdbc, DbType = instanceRow.DbType, IsEnabled = true, Name = conName, Instance = conName }; instanceInfo.SetServerProperties( new ServerProperties( new InstanceVersion(instanceRow.ServerInstanceVersion), instanceRow.ServerInstanceName, DateTime.Now ) ); return(instanceInfo); }
private static string DisplayLogin(LoginRow row) { if (row.IsWinAuth) { return("[WinAuth]"); } string login = string.IsNullOrEmpty(row.Login) ? "[No login]" : row.Login; if (row.Password.Length > 0) { return(string.Format( "{0} (pwd: {1}{2})", login, row.Password[0], new string('*', row.Password.Length - 1) )); } return(login); }
public LoginRowChangeEvent(LoginRow row, global::System.Data.DataRowAction action) { this.eventRow = row; this.eventAction = action; }
public void RemoveLoginRow(LoginRow row) { this.Rows.Remove(row); }
public void AddLoginRow(LoginRow row) { this.Rows.Add(row); }
private void buttonNextProgress_Click(object sender, EventArgs e) //next button action { if (listboxindex < 6) //if not to finalize { if (MessageBox.Show("Are you sure that you need to advance the progress?", "Please confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { if (listboxindex == 1) //to enter estimate { string value = ""; if (InputBox("Estimate Summary", "Please enter the summary of estimate:", ref value) == DialogResult.OK) { appToProgress.estimateSummary = value; if (value == "") { MessageBox.Show("Please enter the summary of estimate. Otherwise considered as not progressed", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { string summary = value; dbprog.updateMany(new string[] { "estimateSummary", "progress" }, listViewInProgress.SelectedItems[0].Text, new string[] { summary, "Estimated" }); listboxindex++; draw(); } } } else { listboxindex++; draw(); } } } //create an account and add to 'account' database, create bill database for each user else if (listboxindex == 6) { if (MessageBox.Show("Are you sure that you need to advance the progress? This will create an account", "Please confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { int accountno; if (dbmap.hasEntry("account")) { accountno = int.Parse(dbmap.get("no", "account")); dbmap.update("no", "account", (accountno + 1).ToString()); } else { accountno = 1000000; dbmap.insert(new MapnoRow("account", 1000001)); } String[] row = dbprog.getRow(listViewInProgress.SelectedItems[0].Text); dbprog.delete(listViewInProgress.SelectedItems[0].Text); AccountRow accrow = new AccountRow(accountno, row[0], textBoxInProgressName.Text, row[2], row[3], row[4], row[5], row[6], row[7], textBoxInProgressAddress.Text, row[9], int.Parse(textBoxInProgressContact.Text), row[11], row[16], row[17], int.Parse(listViewInProgress.SelectedItems[0].Text)); dbacc.insert(accrow); dbbill.createBillingTable(accountno); string password = createRandomPassword(10); LoginRow logrow = new LoginRow(accountno.ToString(), password, 1); dblogin.insert(logrow); MailRow mrow = new MailRow(accountno, textBoxInProgressName.Text, textBoxInProgressAddress.Text, "Your username for the user account: " + accountno + ", password: "******"Assigned Account No (Username) is: " + accountno + "\nLogin Password is: " + password, "Account Number and Login Password", MessageBoxButtons.OK); clrprog(); } else { dbprog.update("progress", listViewInProgress.SelectedItems[0].Text, "Connection Established"); } } }