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

Внимание! Если размещение файла нарушает Ваши авторские права, то обязательно сообщите нам
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
Источник: https://baza.diplomsite.ru/previewfile/2420