/// <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(); }