Диплом: Автоматизация учета рабочего времени сотрудников в ТОО "Профессиональные охранные системы", страницы 127-136

127

private void label2_Click(object sender, EventArgs e)

{

TimeLog f = new TimeLog();

f.Show();

}

private void label3_Click(object sender, EventArgs e)

{

Salary f = new Salary();

f.Show();

}

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

namespace WorkersTimes

{

public partial class Login : Form

{

Model1 DB = new Model1();

public Login()

{

InitializeComponent();

}

private void label1_Click(object sender, EventArgs e)

{

Global.KeyAvtor = 0;

var login = DB.Admins.ToList();

foreach (var email in login)

{

if (email.email == textBox1.Text && email.Password == textBox2.Text)

{

Global.KeyAvtor = 1;

}

if (Global.KeyAvtor==1)

{

Main f = new Main();

f.Show();

}

else

{

MessageBox.Show("Неправильный логин или пароль!!!");

}

private void checkBox1_CheckedChanged(object sender, EventArgs e)

{

if (checkBox1.Checked == true)

128

{

textBox2.UseSystemPasswordChar = true;

}

else

{

textBox2.UseSystemPasswordChar = false;

}

129

Приложение 3. Скрипт создание БД

CREATE TABLE Admins

(

AdminId integer IDENTITY (1,1) ,

Password varchar(50) NULL ,

email varchar(50) NULL

)

go

ALTER TABLE Admins

ADD CONSTRAINT XPKAdmins PRIMARY KEY CLUSTERED

(AdminId ASC)

go

CREATE TABLE Brigades

(

BrigadeId integer IDENTITY (1,1) ,

Name varchar(50) NULL ,

DepartmentId integer NULL

)

go

ALTER TABLE Brigades

ADD CONSTRAINT XPKBrigades PRIMARY KEY CLUS-

TERED (BrigadeId ASC)

130

go

CREATE TABLE BrigadesOfWorkers

(

BrigadeId integer NOT NULL ,

WorkerId integer NOT NULL

)

go

ALTER TABLE BrigadesOfWorkers

ADD CONSTRAINT XPKBrigadesOfWorkers PRIMARY KEY

CLUSTERED (BrigadeId ASC,WorkerId ASC)

go

CREATE TABLE DepartmentsOfWorkers

(

DepartmentId integer NOT NULL ,

WorkerId integer NOT NULL

)

go

ALTER TABLE DepartmentsOfWorkers

ADD CONSTRAINT XPKDepartmentsOfWorkers PRIMARY

KEY CLUSTERED (DepartmentId ASC,WorkerId ASC)

go

131

CREATE TABLE Visits

(

Date date NOT NULL ,

WorkerId integer NOT NULL ,

Time_out time NULL ,

Time_in time NULL

)

go

ALTER TABLE Visits

ADD CONSTRAINT XPKVisits PRIMARY KEY CLUSTERED

(Date ASC,WorkerId ASC)

go

CREATE TABLE Workers

(

WorkerId integer IDENTITY (1,1) ,

Name varchar(50) NULL ,

Surname varchar(50) NULL ,

Phone varchar(50) NULL ,

Address varchar(50) NULL ,

Position varchar(50) NULL

)

go

ALTER TABLE Workers

132

ADD CONSTRAINT XPKWorkers PRIMARY KEY CLUS-

TERED (WorkerId ASC)

go

CREATE TABLE Отделы

(

DepartmentId integer IDENTITY (1,1) ,

Name nvarchar(100) NULL ,

WorkerId integer NULL

)

go

ALTER TABLE Отделы

ADD CONSTRAINT XPKDepartments PRIMARY KEY CLUS-

TERED (DepartmentId ASC)

go

ALTER TABLE Brigades

ADD CONSTRAINT R_46 FOREIGN KEY (DepartmentId) REF-

ERENCES Отделы(DepartmentId)

ON DELETE NO ACTION

ON UPDATE NO ACTION

go

133

ALTER TABLE BrigadesOfWorkers

ADD CONSTRAINT R_44 FOREIGN KEY (BrigadeId) REFER-

ENCES Brigades(BrigadeId)

ON DELETE NO ACTION

ON UPDATE NO ACTION

go

ALTER TABLE BrigadesOfWorkers

ADD CONSTRAINT R_42 FOREIGN KEY (WorkerId) REFER-

ENCES Workers(WorkerId)

ON DELETE NO ACTION

ON UPDATE NO ACTION

go

ALTER TABLE DepartmentsOfWorkers

ADD CONSTRAINT R_40 FOREIGN KEY (DepartmentId) REF-

ERENCES Отделы(DepartmentId)

ON DELETE NO ACTION

ON UPDATE NO ACTION

go

ALTER TABLE DepartmentsOfWorkers

ADD CONSTRAINT R_41 FOREIGN KEY (WorkerId) REFER-

ENCES Workers(WorkerId)

ON DELETE NO ACTION

ON UPDATE NO ACTION

go

134

ALTER TABLE Visits

ADD CONSTRAINT R_39 FOREIGN KEY (WorkerId) REFER-

ENCES Workers(WorkerId)

ON DELETE NO ACTION

ON UPDATE NO ACTION

go

ALTER TABLE Отделы

ADD CONSTRAINT R_45 FOREIGN KEY (WorkerId) REFER-

ENCES Workers(WorkerId)

ON DELETE NO ACTION

ON UPDATE NO ACTION

go