public EmployeeInterface(EmployeeLevel empLevel)
{
InitializeComponent();
this.adminPanel.Visible = false;
this.Size = new Size(556, 420);
if (empLevel >= EmployeeLevel.MANAGER)
{
this.adminPanel.Visible = true;
this.Size = new Size(677, 420);
}
DataTable dataset = Database.Instance.getNotes();
try
{
BindingSource bSource = new BindingSource();
bSource.DataSource = dataset;
dataView.RowHeadersVisible = false;
dataView.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells;
dataView.DefaultCellStyle.WrapMode = DataGridViewTriState.True;
dataView.DataSource = bSource;
dataView.Columns[1].Width = 178;
dataView.Refresh();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
}
private void addEmployeeButton_Click(object sender, EventArgs e)
{
EmployeeLevel level = EmployeeLevel.EMPLOYEE;
switch (levelBox.Text)
{
case "Employee":
level = EmployeeLevel.EMPLOYEE;
break;
case "Manager":
level = EmployeeLevel.MANAGER;
break;
case "Admin":
level = EmployeeLevel.ADMIN;
break;
}
if (DatabaseInputValidation.mandatoryStringIsValid(newUsernameInput.Text, 3) && newPasswordInput.Text.Length >= 4)
{
bool success = Database.Instance.createEmployee(empFName.Text, empLName.Text, newUsernameInput.Text, newPasswordInput.Text, level);
if (success)
{
MessageBox.Show("User creation succeeded.");
}
else
{
MessageBox.Show("User creaton failed.");
}
}
else
{
MessageBox.Show("Please enter the new employee's username and password (passwords must be at least four characters).");
}
}
private void btnAdd_Click(object sender, RoutedEventArgs e)
{
try
{
using (var db = new LetranIntegratedSystemEntities())
{
if (!String.IsNullOrEmpty(txtEmpLvl.Text))
{
EmployeeLevel el = new EmployeeLevel();
el.EmployeeLevel1 = txtEmpLvl.Text;
db.EmployeeLevels.Add(el);
db.SaveChanges();
MessageBox.Show("Add Successful", "System Success!", MessageBoxButton.OK, MessageBoxImage.Information);
TextClear();
GetLevel();
}
else
{
MessageBox.Show("Required fields cannot be empty.", "System Warning!", MessageBoxButton.OK, MessageBoxImage.Warning);
}
}
}
catch (Exception)
{
MessageBox.Show("Something went wrong.", "System Error!", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private int GetEmployeeStartIndex(EmployeeLevel minEmployeeLevel)
{
var employeeLevel = (int)minEmployeeLevel;
int startIndex = employeeLevel * QuantityPerLevel;
return(startIndex);
}
public ActionResult Create([Bind(Include = "Id,FirstName,LastName,Phone,Address,Email,Gender,Birthday,Username,Password,LevelId,Avatar,LastLogin,IsActive")] Employee employee)
{
if (!employee.Gender.ToLower().Equals("male") && !employee.Gender.ToLower().Equals("female"))
{
return(Content("Gender cant be anything other than male and female"));
}
if (ModelState.IsValid)
{
employee.Password = MySecurity.EncryptPass(employee.Password);
employee.IsActive = false;
employee.IsOnline = false;
db.Employees.Add(employee);
db.SaveChanges();
if (employee.LevelId == 1)
{
for (int i = 1; i <= 3; i++)
{
EmployeeLevel el = new EmployeeLevel()
{
EmployeeId = employee.Id,
LevelId = i
};
db.EmployeeLevels.Add(el);
}
}
if (employee.LevelId == 2)
{
for (int i = 2; i <= 3; i++)
{
EmployeeLevel el = new EmployeeLevel()
{
EmployeeId = employee.Id,
LevelId = i
};
db.EmployeeLevels.Add(el);
}
}
if (employee.LevelId == 3)
{
EmployeeLevel el = new EmployeeLevel()
{
EmployeeId = employee.Id,
LevelId = 3
};
db.EmployeeLevels.Add(el);
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.LevelId = new SelectList(db.Levels, "Id", "LevelName", employee.LevelId);
return(View(employee));
}
public ActionResult getEmployees()
{
var employees = employeeManager.FindList();
string name = Request.QueryString["Name"];
string level = Request.QueryString["Level"];
string cn = Request.QueryString["CertificateNumber"];
string idn = Request.QueryString["IdentificationNumber"];
string cname = Request.QueryString["CompanyName"];
if (name != null && name != "")
{
employees = employees.Where(e => e.Name.Contains(name));
}
if (level != null && level != "-1")
{
EmployeeLevel el = (EmployeeLevel)int.Parse(level);
employees = employees.Where(e => e.Level == el);
}
if (cn != null && cn != "")
{
employees = employees.Where(e => e.CertificateNumber == cn);
}
if (idn != null && idn != "")
{
employees = employees.Where(e => e.IdentificationNumber == idn);
}
if (cname != null && cname != "")
{
employees = employees.Where(e => e.Company != null && e.Company.Name.Contains(cname));
}
employees = employees.Where(e => e.Level == EmployeeLevel.一级注册消防工程师 || e.Level == EmployeeLevel.二级注册消防工程师 || e.Level == EmployeeLevel.临时注册消防工程师);
employees = employees.OrderByDescending(e => e.ID);
var data = employees.Select(e => new
{
ID = e.ID,
Name = e.Name,
Gender = e.Gender.ToString(),
Level = e.Level.ToString(),
CertificateNumber = e.CertificateNumber,
IdentificationNumber = e.IdentificationNumber,
CompanyName = e.Company == null?"无":e.Company.Name
});
return(Json(data, JsonRequestBehavior.AllowGet));
}
public bool login(string username, string password, ref EmployeeLevel empLevel)
{
string cmd_str = "SELECT * FROM climbing_wall.employee WHERE Employee_Username = @username";
MySqlCommand cmd = new MySqlCommand(cmd_str, connection);
cmd.CommandText = cmd_str;
cmd.Parameters.AddWithValue("@username", username);
// Create hasher variable to hash the entered password
var hasher = new PasswordHasher();
// Cross-check hashed password with hashes in database
// If match is found
MySqlDataReader reader;
try
{
reader = cmd.ExecuteReader();
}
catch (MySqlException ex)
{
MessageBox.Show(ex.Message);
return(false);
}
if (reader.HasRows)
{
reader.Read();
if (!hasher.Verify(reader.GetString("Password"), password))
{
reader.Close();
return(false);
}
Globals.empLevel = (EmployeeLevel)reader.GetInt16("Level");
Globals.currEmployeeId = reader.GetInt16("Employee_ID");
Globals.currEmployeeName = reader.GetString("Employee_Username");
}
else
{
reader.Close();
return(false);
}
reader.Close();
return(true);
}
protected Employee(EmployeeLevel employeeLevel)
{
IsWorking = true;
EmployeeLevel = employeeLevel;
}
protected Employee(EmployeeLevel employeeLevel, Dispatcher dispatcher)
{
EmployeeLevel = employeeLevel;
Dispatcher = dispatcher;
}
public bool createEmployee(string firstName, string lastName, string username, string password, EmployeeLevel empLevel)
{
var hasher = new PasswordHasher();
string hashedPassword = hasher.Hash(password);
string cmd_str = "INSERT INTO climbing_wall.employee (Emp_FirstName, Emp_LastName, Employee_Username, Password, Level) VALUES (@firstName, @lastName, @username, @hashedPassword, @level)";
MySqlCommand cmd = new MySqlCommand(cmd_str, connection);
cmd.CommandText = cmd_str;
cmd.Parameters.AddWithValue("@firstName", firstName);
cmd.Parameters.AddWithValue("@lastName", lastName);
cmd.Parameters.AddWithValue("@username", username);
cmd.Parameters.AddWithValue("@hashedPassword", hashedPassword);
cmd.Parameters.AddWithValue("@level", empLevel);
try
{
cmd.ExecuteNonQuery();
}
catch (MySqlException ex)
{
MessageBox.Show(ex.Message);
return(false);
}
return(true);
}
