/// <summary>
/// Конструктор ініціалізації
/// </summary>
/// <param name="newLogin">Логін</param>
/// <param name="newPassword">Пароль</param>
/// <param name="compName">Назва компанії</param>
/// <param name="addr">Адреса компанії</param>
/// /// <param name="dataMaster">Мастер управління базою даних</param>
public Employer(string newLogin, string compName, string addr, DatabaseMaster dataMaster)
{
this.login = newLogin;
this.companyName = compName;
this.address = addr;
this.databaseMaster = dataMaster;
}
public void InicializeUnemployed(string login, DatabaseMaster dataMaster)
{
string fName;
string secName;
string surName;
string cmd1Text = "SELECT `FirstName` FROM `Unemployed` WHERE `AcountID` = " +
"(SELECT `ID` FROM `Users` WHERE `Login` = '" + login + "')";
string cmd2Text = "SELECT `SecondName` FROM `Unemployed` WHERE `AcountID` = " +
"(SELECT `ID` FROM `Users` WHERE `Login` = '" + login + "')";
string cmd3Text = "SELECT `Surname` FROM `Unemployed` WHERE `AcountID` = " +
"(SELECT `ID` FROM `Users` WHERE `Login` = '" + login + "')";
System.Data.OleDb.OleDbCommand cmd1 = new System.Data.OleDb.OleDbCommand();
System.Data.OleDb.OleDbCommand cmd2 = new System.Data.OleDb.OleDbCommand();
System.Data.OleDb.OleDbCommand cmd3 = new System.Data.OleDb.OleDbCommand();
dataMaster.connection.Open();
cmd1.Connection = dataMaster.connection;
cmd2.Connection = dataMaster.connection;
cmd3.Connection = dataMaster.connection;
cmd1.CommandText = cmd1Text;
cmd2.CommandText = cmd2Text;
cmd3.CommandText = cmd3Text;
try
{
fName = (string)cmd1.ExecuteScalar();
secName = (string)cmd2.ExecuteScalar();
surName = (string)cmd3.ExecuteScalar();
this.unemployed = new Unemployed(login, fName, secName, surName, dataMaster);
}
catch
{
MessageBox.Show("Error");
}
dataMaster.connection.Close();
}
public void InicializeEmployer(DatabaseMaster dataMaster, string login)
{
string compName;
string addr;
string cmd1Text = "SELECT `CompanyName` FROM `Employer` WHERE `AcountID` = " +
"(SELECT `ID` FROM `Users` WHERE `Login` = '" + login + "')";
string cmd2Text = "SELECT `Address` FROM `Employer` WHERE `AcountID` = " +
"(SELECT `ID` FROM `Users` WHERE `Login` = '" + login + "')";
System.Data.OleDb.OleDbCommand cmd1 = new System.Data.OleDb.OleDbCommand();
System.Data.OleDb.OleDbCommand cmd2 = new System.Data.OleDb.OleDbCommand();
dataMaster.connection.Open();
cmd1.Connection = dataMaster.connection;
cmd2.Connection = dataMaster.connection;
cmd1.CommandText = cmd1Text;
cmd2.CommandText = cmd2Text;
try
{
compName = (string)cmd1.ExecuteScalar();
addr = (string)cmd2.ExecuteScalar();
this.employer = new Employer(login, compName, addr, dataMaster);
}
catch
{
MessageBox.Show("Error");
}
dataMaster.connection.Close();
}
static void Main()
{
DatabaseMaster databaseMaster = new DatabaseMaster();
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new Start(databaseMaster));
}
public CheckInForm(DatabaseMaster dataMaster)
{
InitializeComponent();
this.databaseMaster = dataMaster;
this.checkInFormUser = new CheckInFormUser(databaseMaster);
checkInFormUser.TopLevel = false;
checkInFormUser.FormBorderStyle = FormBorderStyle.None;
checkInFormUser.Dock = DockStyle.Fill;
checkInFormUser.Visible = true;
this.panel1.Controls.Add(checkInFormUser);
}
public UnemployedRoom(DatabaseMaster dataMaster, string login)
{
this.databaseMaster = dataMaster;
InicializeUnemployed(login, dataMaster);
InitializeComponent();
}
public UnemployedRoom(DatabaseMaster dataMaster)
{
this.databaseMaster = dataMaster;
this.unemployed = new Unemployed(dataMaster);
InitializeComponent();
}
public Authorization(DatabaseMaster dataMaster)
{
InitializeComponent();
this.databaseMaster = dataMaster;
}
public Employer(DatabaseMaster dataMaster)
{
this.databaseMaster = dataMaster;
}
public EmployerRoom(DatabaseMaster dataMaster, string login)
{
InicializeEmployer(dataMaster, login);
InitializeComponent();
}
public EmployerRoom(DatabaseMaster dataMaster)
{
this.employer = new Employer(dataMaster);
InitializeComponent();
}
public Unemployed(DatabaseMaster dataMaster)
{
this.databaseMaster = dataMaster;
}
/// <summary>
/// Конструктор ініціалізації
/// </summary>
/// <param name="newLogin">Логін</param>
/// <param name="newPassword">Пароль</param>
/// <param name="fName">Ім'я</param>
/// <param name="secName">По батькові</param>
/// <param name="surName">Прізвище</param>
/// <param name="dataMaster">Мастер управління базою даних</param>
public Unemployed(string newLogin, string fName, string secName, string surName, DatabaseMaster dataMaster)
{
this.login = newLogin;
this.firstName = fName;
this.secondName = secName;
this.surname = surName;
this.databaseMaster = dataMaster;
}
public Start(DatabaseMaster dataMaster)
{
this.databaseMaster = dataMaster;
InitializeComponent();
}
public CheckInFormUser(DatabaseMaster dataMaster)
{
this.databaseMaster = dataMaster;
InitializeComponent();
}
