private void btnMakeCoreLoginUsers_Click(object sender, EventArgs e)
{
try
{
if (String.IsNullOrEmpty(txtCoreAccountss.Text.ToString()) || string.IsNullOrEmpty(cmbDatabases.Text.ToString()))
{
MessageBox.Show(" Please select Account and Coredatabase");
return;
}
string SQL;
//Check whether Database exists on the SQL Server
if (!(ClassCoreUtility.checkIfDatabaseExistsOnSQL(cmbDatabases.Text.ToString(), this.server.ToString(), txtUserID.Text.ToString(), txtPasswordsss.Text.ToString())))
{
MessageBox.Show("Database does not exist on SQL Server");
return;
}
//Check whether database is Core Database
if (!(ClassCoreUtility.checkIfCoreDatabase(cmbDatabases.Text.ToString(), this.server.ToString(), txtUserID.Text.ToString(), txtPasswordsss.Text.ToString())))
{
MessageBox.Show("Selected Database not a Core Database!!");
return;
}
//Check whether account present in CORE
if (!(ClassCoreUtility.checkIfAccountPresentInCore(txtCoreAccountss.Text.ToString(), this.server.ToString(), txtUserID.Text.ToString(), txtPasswordsss.Text.ToString(), cmbDatabases.Text.ToString())))
{
MessageBox.Show("Account does not exist in Core! Please give correct Account");
return;
}
//Check whether database has full access security employee
if (!(ClassCoreUtility.checkIfCoreDBHasFullAccessUser(cmbDatabases.Text.ToString(), this.server.ToString(), txtUserID.Text.ToString(), txtPasswordsss.Text.ToString())))
{
MessageBox.Show("No Employee with full access security/Set the security manually");
return;
}
//Make selected user as Core login User
SQL = "UPDATE [" + cmbDatabases.Text + "]. dbo.Employee SET HostAccount_ID=NULL WHERE HostAccount_ID IS NOT NULL; UPDATE [" + cmbDatabases.Text + "]. dbo.Employee SET HostAccount_ID = (SELECT ID FROM BQECoreHost.dbo.Account WHERE Email= '" + txtCoreAccountss.Text + "'), Password = (SELECT Password FROM BQECoreHost.dbo.Account WHERE Email= '" + txtCoreAccountss.Text + "') WHERE EmployeeID = '" + cmbFullAccessUser.Text + "'; ";
int count = ClassCoreUtility.executeSQLInsertUpdate(SQL, this.server, txtUserID.Text, txtPasswordsss.Text);
if (count > 0)
{
MessageBox.Show("Selected Employee made as Core Login User sucessfully!!");
}
else
{
MessageBox.Show("Opeartion not sucessful!!");
}
//Get current login Core User
string st = ClassCoreUtility.getCurrentCoreLoginUser(cmbDatabases.Text, txtCoreAccountss.Text, this.server, txtUserID.Text, txtPasswordsss.Text);
txtCurrentCoreLoginUsersss.Text = st;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void btlLoadFullAccessUsers_Click(object sender, EventArgs e)
{
try
{
if (!(ClassCoreUtility.checkIfDatabaseAlreadyAddedToCore(cmbDatabases.Text.ToString(), this.server.ToString(), txtUserID.Text.ToString(), txtPasswordsss.Text.ToString())))
{
MessageBox.Show("Database does not exist in CORE!!");
return;
}
if (String.IsNullOrEmpty(txtCoreAccountss.Text.ToString()) || string.IsNullOrEmpty(cmbDatabases.Text.ToString()))
{
MessageBox.Show(" Please select Account and Coredatabase");
return;
}
string SQL, connectString;
List <string> lstFullAccessUsers = new List <string>();
//Check whether Database exists on the SQL Server
if (!(ClassCoreUtility.checkIfDatabaseExistsOnSQL(cmbDatabases.Text.ToString(), this.server.ToString(), txtUserID.Text.ToString(), txtPasswordsss.Text.ToString())))
{
MessageBox.Show("Database does not exist on SQL Server");
return;
}
//Check whether database is Core Database
if (!(ClassCoreUtility.checkIfCoreDatabase(cmbDatabases.Text.ToString(), this.server.ToString(), txtUserID.Text.ToString(), txtPasswordsss.Text.ToString())))
{
MessageBox.Show("Selected Database not a Core Database!!");
return;
}
//Check whether account present in CORE
if (!(ClassCoreUtility.checkIfAccountPresentInCore(txtCoreAccountss.Text.ToString(), this.server.ToString(), txtUserID.Text.ToString(), txtPasswordsss.Text.ToString(), cmbDatabases.Text.ToString())))
{
MessageBox.Show("Account does not exist in Core! Please give correct Account");
return;
}
//Check whether database has full access security employee
if (!(ClassCoreUtility.checkIfCoreDBHasFullAccessUser(cmbDatabases.Text.ToString(), this.server.ToString(), txtUserID.Text.ToString(), txtPasswordsss.Text.ToString())))
{
MessageBox.Show("No Employee with full access security/Set the security manually");
return;
}
// Set connection string with selected server and integrated security
connectString = "Data Source=" + this.server + ";Integrated Security=false;Initial Catalog=master;User ID=" +
txtUserID.Text + ";Password="******";";
using (System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(connectString))
{
// Open connection
con.Open();
//Get list of full access users
SQL = "SELECT EmployeeID FROM [" + cmbDatabases.Text + "].dbo.Employee WHERE Employee_ID IN (SELECT Employee_ID FROM [" + cmbDatabases.Text + "].dbo.Security WHERE SecurityTemplate_ID IN(SELECT SecurityTemplate_ID FROM [" + cmbDatabases.Text + "]. dbo.SecurityTemplate WHERE SecurityTemplateName = 'Full Access'));";
SqlCommand com =
new SqlCommand(SQL, con);
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
lstFullAccessUsers.Add(dr[0].ToString());
}
// Set databases list as combobox’s datasource
this.cmbFullAccessUser.DataSource = lstFullAccessUsers;
//Get current login Core User
string st = ClassCoreUtility.getCurrentCoreLoginUser(cmbDatabases.Text, txtCoreAccountss.Text, this.server, txtUserID.Text, txtPasswordsss.Text);
txtCurrentCoreLoginUsersss.Text = st;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}