83
Приложение Б. Листинг программы
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 Salary_Control
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
btnAddPenalty.Visible = false;
btnGetSalary.Visible = false;
btnWorkflow.Visible = false;
btn_AddEmployer.Visible = false;
btn_AddPost.Visible = false;
}
private void Form1_Load(object sender, EventArgs e)
{
}
private void btnAuth_Click(object sender, EventArgs e)
{
if (txtLogin.Text == "User" && txtPassword.Text == "User")
{
btnAddPenalty.Visible = true;
btnGetSalary.Visible = true;
btnWorkflow.Visible = true;
btn_AddEmployer.Visible = false;
btn_AddPost.Visible = false;
}
else if (txtLogin.Text == "Admin" && txtPassword.Text == "Admin")
{
btnAddPenalty.Visible = true;
btnGetSalary.Visible = true;
btnWorkflow.Visible = true;
btn_AddEmployer.Visible = true;
btn_AddPost.Visible = true;
}
}
84
private void btn_AddEmployer_Click(object sender, EventArgs e)
{
Form Emp = new AddEmployer();
Emp.Show();
}
private void btn_AddPost_Click(object sender, EventArgs e)
{
Form Post = new AddPost();
Post.Show();
}
private void btnAddPenalty_Click(object sender, EventArgs e)
{
Form Penalty = new AddPenalty();
Penalty.Show();
}
private void btnWorkflow_Click(object sender, EventArgs e)
{
Form Salary = new SalControl();
Salary.Show();
}
private void btnGetSalary_Click(object sender, EventArgs e)
{
Form Report = new Report();
Report.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;
using System.Data.SqlClient;
namespace Salary_Control
{
public partial class AddEmployer : Form
{
SqlConnection con = new SqlConnection(@"Data
Source=SERENITY\SQLEXPRESS;Initial Catalog=Salary;Integrated Security=True");
public AddEmployer()
85
{
InitializeComponent();
con.Open();
SqlCommand cmdRead = new SqlCommand();
cmdRead.Connection = con;
cmdRead.CommandText = "SELECT p_Name FROM Post";
SqlDataReader reader = cmdRead.ExecuteReader();
while (reader.Read())
{
cmbPost.Items.Add(reader[0].ToString());
}
reader.Close();
con.Close();
}
private void button1_Click(object sender, EventArgs e)
{
if (txtSecondName.Text == "" || txtFirstName.Text == ""
|| txtMidName.Text == "" || txtID.Text == ""
|| txtBurthday.Text == "" || txtAccount.Text == "")
{
MessageBox.Show("Не задано значение");
}
else
{
con.Open();
SqlCommand cmdWrite = new SqlCommand();
cmdWrite.Connection = con;
cmdWrite.CommandText = "INSERT INTO [Employer] (emp_LastName,
emp_FirstName, emp_MidName, emp_Birthday, emp_ID, emp_Account, id_Post) VALUES
(@LastName, @FirstName, @MidName, @Birthday, @ID, @Account, @Post)";
cmdWrite.Parameters.AddWithValue("LastName", txtSecondName.Text);
cmdWrite.Parameters.AddWithValue("FirstName", txtFirstName.Text);
cmdWrite.Parameters.AddWithValue("MidName", txtMidName.Text);
cmdWrite.Parameters.AddWithValue("Birthday", txtBurthday.Text);
cmdWrite.Parameters.AddWithValue("ID", txtID.Text);
cmdWrite.Parameters.AddWithValue("Account", txtAccount.Text);
cmdWrite.Parameters.AddWithValue("Post", cmbPost.SelectedIndex+1);
cmdWrite.ExecuteNonQuery();
con.Close();
}
}
}
}
using System;
86
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;
using System.Data.SqlClient;
namespace Salary_Control
{
public partial class AddPost : Form
{
SqlConnection con = new SqlConnection(@"Data
Source=SERENITY\SQLEXPRESS;Initial Catalog=Salary;Integrated Security=True");
public AddPost()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
if (txtPost.Text == "" || txtSalary.Text == "")
{
MessageBox.Show("Не введены значения");
}
else
{
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "INSERT INTO [Post] (p_Name, p_Salary) VALUES (@Name,
@Salary)";
cmd.Parameters.AddWithValue("Name", txtPost.Text);
cmd.Parameters.AddWithValue("Salary", txtSalary.Text);
cmd.ExecuteNonQuery();
con.Close();
}
}
}
}
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;
87
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Salary_Control
{
public partial class SalControl : Form
{
SqlConnection con = new SqlConnection(@"Data
Source=SERENITY\SQLEXPRESS;Initial Catalog=Salary;Integrated Security=True");
public SalControl()
{
InitializeComponent();
con.Open();
SqlCommand cmdRead = new SqlCommand();
cmdRead.Connection = con;
cmdRead.CommandText = "SELECT emp_LastName FROM Employer";
SqlDataReader reader = cmdRead.ExecuteReader();
while (reader.Read())
{
cmbEmployer.Items.Add(reader[0].ToString());
}
reader.Close();
con.Close();
}
private void button1_Click(object sender, EventArgs e)
{
if (/*mtxtDate.Text == "" || mtxtWorkStart.Text == "" || mtxtWorkStop.Text == ""*/
false)
{
MessageBox.Show("Значения не введены");
}
else
{
Int32 Empindex = 0;
Int32 TSindex = 0;
Double duration = 0;
DateTime time1 = new DateTime();
DateTime time2 = new DateTime();
time1 = Convert.ToDateTime(mtxtWorkStart.Text);
time2 = Convert.ToDateTime(mtxtWorkStop.Text);
TimeSpan ts = time2.Subtract(time1);
duration = ts.TotalHours;
con.Open();
// находим имя в Employer
SqlCommand cmdRead1 = new SqlCommand();
88
cmdRead1.Connection = con;
cmdRead1.CommandText = "SELECT id_Emp FROM Employer WHERE
emp_LastName = '" + cmbEmployer.SelectedItem + "'";
SqlDataReader reader = cmdRead1.ExecuteReader();
while (reader.Read())
{
Empindex = Convert.ToInt32(reader[0]);
}
reader.Close();
MessageBox.Show(Empindex.ToString());
// Находим запись в TimeSheet
SqlCommand cmdRead2 = new SqlCommand();
cmdRead2.Connection = con;
cmdRead2.CommandText = "SELECT id_TimeSheet FROM TimeSheet WHERE
id_Emp=@index";
cmdRead2.Parameters.AddWithValue("index", Empindex);
SqlDataReader reader2 = cmdRead2.ExecuteReader();
while (reader2.Read())
{
TSindex = Convert.ToInt32(reader2[0]);
}
reader2.Close();
MessageBox.Show(TSindex.ToString());
if (TSindex == 0)
{
SqlCommand cmdWrite = new SqlCommand();
cmdWrite.Connection = con;
cmdWrite.CommandText = "INSERT INTO [TimeSheet] (id_Emp, ts_Data,
ts_StartTime, ts_StopTime, ts_Duration) VALUES (@Emp, @Data, @StartTime, @StopTime,
@Duration)";
cmdWrite.Parameters.AddWithValue("Emp", cmbEmployer.SelectedIndex + 1);
cmdWrite.Parameters.AddWithValue("Data", mtxtDate.Text);
cmdWrite.Parameters.AddWithValue("StartTime", mtxtWorkStart.Text);
cmdWrite.Parameters.AddWithValue("StopTime", mtxtWorkStop.Text);
cmdWrite.Parameters.AddWithValue("Duration", duration);
cmdWrite.ExecuteNonQuery();
}
else
{
SqlCommand cmdRead3 = new SqlCommand();
cmdRead3.Connection = con;
cmdRead3.CommandText = "SELECT ts_Duration FROM TimeSheet WHERE
id_Emp=@index";
cmdRead3.Parameters.AddWithValue("index", Empindex);
SqlDataReader reader3 = cmdRead3.ExecuteReader();
while (reader3.Read())
{
duration = duration + Convert.ToDouble(reader3[0]);
}
89
reader3.Close();
MessageBox.Show(Convert.ToString(duration));
SqlCommand cmdWrite = new SqlCommand();
cmdWrite.Connection = con;
cmdWrite.CommandText = "UPDATE TimeSheet SET id_Emp = @Emp, ts_Data =
@Data, ts_StartTime = @StartTime, ts_StopTime = @StopTime, ts_Duration = @Duration
WHERE id_Emp = @Empindex";
cmdWrite.Parameters.AddWithValue("Emp", cmbEmployer.SelectedIndex + 1);
cmdWrite.Parameters.AddWithValue("Data", mtxtDate.Text);
cmdWrite.Parameters.AddWithValue("StartTime", mtxtWorkStart.Text);
cmdWrite.Parameters.AddWithValue("StopTime", mtxtWorkStop.Text);
cmdWrite.Parameters.AddWithValue("Duration", duration);
cmdWrite.ExecuteNonQuery();
}
con.Close();
}
}
}
}