//{
/*
* if (busProc.dbSession.activeConn.State == ConnectionState.Closed)
* {
* busProc.dbSession.activeConn.Open();
* }
* SqlCommand command = new SqlCommand();
* command.Connection.ConnectionString = LoginForm.busProc.dbSession.activeConn.ConnectionString;
* //command.Connection.Open();
* command.CommandText = "SELECT COUNT(*) FROM customers";
* int count = (int)command.ExecuteScalar();
* //command.Connection.Close();
* return count;
*/
//}
public DataTable getRecords(BusinessLayer busProc, string tableName)
{
try
{
SqlCommand command = new SqlCommand();
SqlConnection connection = new SqlConnection(Program.connString);
command.Connection = connection;
command.CommandText = "SELECT * FROM " + tableName;
SqlDataAdapter da = new SqlDataAdapter(command);
DataTable dt = new DataTable();
da.Fill(dt);
//command.Connection.Close();
return(dt);
}
catch (SqlException ex)
{
string message = "You do not have permission to view this table.";
string caption = "Access Denied";
MessageBoxButtons button = MessageBoxButtons.OK;
DialogResult messageBox;
messageBox = MessageBox.Show(message, caption, button);
Console.WriteLine("Error " + ex);
return(null);
}
}
public int CountRecords(BusinessLayer busProc, string tableName)
{
try
{
SqlCommand command = new SqlCommand();
SqlConnection connection = new SqlConnection(Program.connString);
command.Connection = connection;
command.Connection.Open();
command.CommandText = "SELECT COUNT(*) FROM " + tableName;
int count = (int)command.ExecuteScalar();
command.Connection.Close();
//busProc.dbSession.activeConn.Close();
return(count);
}
catch (SqlException ex)
{
string message = "You do not have permission to view this table.";
string caption = "Access Denied";
MessageBoxButtons button = MessageBoxButtons.OK;
DialogResult messageBox;
messageBox = MessageBox.Show(message, caption, button);
Console.WriteLine("Error " + ex);
return(0);
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
{
string datasource = boxServerList.Text;
string database = boxDatabaseList.Text;
string username = txtUserName.Text;
string password = txtPassword.Text;
LoginForm.busProc = new BusinessLayer(datasource, database, username, password);
Program.connString = busProc.generateConnString(datasource, database, username, password);
if (LoginForm.busProc.isLoggedIn == true)
{
this.Hide();
Form1 mainForm = new Form1();
mainForm.MdiParent = this.MdiParent;
mainForm.Show();
}
else
{
Console.WriteLine("Unable to login.");
}
}
}
public int CountRecords(BusinessLayer busProc, string tableName)
{
return(busProc.dbSession.CountRecords(busProc, tableName));
}
public DataTable getRecords(BusinessLayer busProc, string tableName)
{
return(busProc.dbSession.getRecords(busProc, tableName));
}
