public List <ModelEmployee> GetListOfEmployeesByDepartment(int departmentId)
{
List <ModelEmployee> myListOfEmployees = new List <ModelEmployee>();
RepositoryManager.ExecuteSqlCommand((command) =>
{
command.CommandText = @"select * from Employee
where DepartmentId = @DepartmentId ";
command.Parameters.Add("@DepartmentId", SqlDbType.Int).Value = departmentId;
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
ModelEmployee employee = new ModelEmployee
{
Id = reader.GetInt32(0),
Title = reader.IsDBNull(1) ? "" : reader.GetString(1),
Name = reader.GetString(2),
Surname = reader.GetString(3),
PhoneNumber = reader.IsDBNull(4) ? "" : reader.GetString(4),
Email = reader.GetString(5),
DepartmentId = reader.IsDBNull(6) ? null : (int?)reader.GetInt32(6)
};
myListOfEmployees.Add(employee);
}
}
});
return(myListOfEmployees);
}
public bool UpdateEmployee(ModelEmployee employee)
{
bool isSuccessful = false;
RepositoryManager.ExecuteSqlCommand((command) =>
{
command.CommandText = @"update Employee
set Name=@Name,Surname=@Surname,Title=@Title,
PhoneNumber=@PhoneNumber,Mail=@Email,DepartmentId=@DepartmentID
where id =@Id";
command.Parameters.Add("@DepartmentID", SqlDbType.Int).Value = employee.DepartmentId ?? (Object)DBNull.Value;
command.Parameters.Add("@Title", SqlDbType.NVarChar).Value = employee.Title;
command.Parameters.Add("@Name", SqlDbType.NVarChar).Value = employee.Name;
command.Parameters.Add("@Surname", SqlDbType.NVarChar).Value = employee.Surname;
command.Parameters.Add("@PhoneNumber", SqlDbType.NVarChar).Value = employee.PhoneNumber;
command.Parameters.Add("@Email", SqlDbType.NVarChar).Value = employee.Email;
command.Parameters.Add("@Id", SqlDbType.Int).Value = employee.Id;
if (command.ExecuteNonQuery() > 0)
{
isSuccessful = true;
}
});
return(isSuccessful);
}
public List <ModelEmployee> GetListOfEmployees()
{
List <ModelEmployee> myListOfEmployees = new List <ModelEmployee>();
RepositoryManager.ExecuteSqlCommand((command) =>
{
command.CommandText = @"select e.*
from Employee as e
left join Department as d on e.DepartmentId=d.Id
where e.DepartmentId is null or not (e.DepartmentId = d.Id and d.DepartmentType='Company') ";
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
ModelEmployee employee = new ModelEmployee
{
Id = reader.GetInt32(0),
Title = reader.IsDBNull(1) ? "" : reader.GetString(1),
Name = reader.GetString(2),
Surname = reader.GetString(3),
PhoneNumber = reader.IsDBNull(4) ? "" : reader.GetString(4),
Email = reader.GetString(5),
DepartmentId = reader.IsDBNull(6) ? null : (int?)reader.GetInt32(6)
};
myListOfEmployees.Add(employee);
}
}
});
return(myListOfEmployees);
}
public ModelEmployee GetEmployee(int employeeId)
{
ModelEmployee employee = new ModelEmployee();
RepositoryManager.ExecuteSqlCommand((command) =>
{
command.CommandText = @"select *
from Employee as e
where e.ID = @Id";
command.Parameters.Add("@Id", SqlDbType.Int).Value = employeeId;
using (SqlDataReader reader = command.ExecuteReader())
{
if (reader.Read())
{
employee.Id = reader.GetInt32(0);
employee.Title = reader.IsDBNull(1) ? "" : reader.GetString(1);
employee.Name = reader.GetString(2);
employee.Surname = reader.GetString(3);
employee.PhoneNumber = reader.IsDBNull(4) ? "" : reader.GetString(4);
employee.Email = reader.GetString(5);
employee.DepartmentId = reader.IsDBNull(6) ? null : (int?)reader.GetInt32(6);
}
}
});
return(employee);
}
public IHttpActionResult Put(int id, ModelEmployee model)
{
try
{
var emp = _unitOfWork.Employees.GetById(id);
if (emp == null)
{
return(NotFound());
}
//(Source,Destination)
_mapper.Map(model, emp);
if (_unitOfWork.Complete() > 0)
{
AppLogger.Info("Update employee successful. From: Employees using Web API");
return(Ok(_mapper.Map <ModelEmployee>(emp)));
}
else
{
AppLogger.Error("Update employee error. From: Employees using Web API");
return(InternalServerError());
}
}
catch (Exception ex)
{
AppLogger.Error("Update employee error. From: Employees using Web API");
return(InternalServerError(ex));
}
}
public FrmCreateEditEmployee(ModelEmployee employee)
{
InitializeComponent();
_employee = employee;
_isCreate = false;
FillTxtBoxes();
}
public bool CreateEmployee(ModelEmployee employee)
{
bool isSuccessful = false;
RepositoryManager.ExecuteSqlCommand((command) =>
{
command.CommandText = @"insert into [dbo].[Employee]
values (@Title,@Name,@Surname,@PhoneNumber,@Mail,@DepartmentID)";
command.Parameters.Add("@DepartmentID", SqlDbType.Int).Value = employee.DepartmentId ?? (Object)DBNull.Value;
command.Parameters.Add("@Title", SqlDbType.NVarChar).Value = employee.Title;
command.Parameters.Add("@Name", SqlDbType.NVarChar).Value = employee.Name;
command.Parameters.Add("@Surname", SqlDbType.NVarChar).Value = employee.Surname;
command.Parameters.Add("@PhoneNumber", SqlDbType.NVarChar).Value = employee.PhoneNumber;
command.Parameters.Add("@Mail", SqlDbType.NVarChar).Value = employee.Email;
if (command.ExecuteNonQuery() > 0)
{
isSuccessful = true;
}
});
return(isSuccessful);
}
public ModelEmployee GetEmployee(int id)
{
Employees employee = repo.Find(x => x.EmployeeID == id);
ModelEmployee modelemployee = new ModelEmployee
{
EmployeeID = employee.EmployeeID,
Extension = employee.Extension,
Address = employee.Address,
City = employee.City,
FirstName = employee.FirstName,
HomePhone = employee.HomePhone,
Region = employee.Region,
PostalCode = employee.PostalCode,
Country = employee.Country,
LastName = employee.LastName,
Title = employee.Title,
TitleOfCourtesy = employee.TitleOfCourtesy,
ReportsTo = employee.ReportsTo
};
return(modelemployee);
}
public ActionResult AddOrEdit(int?id)
{
if (id == null)
{
using (DBModel db = new DBModel())
{
ViewBag.Country = new SelectList(db.Countries.ToList(), "CountryId", "CountryName");
}
return(View());
}
else
{
using (DBModel db = new DBModel())
{
ModelEmployee emp = new ModelEmployee();
ViewBag.Country = new SelectList(db.Countries.ToList(), "CountryId", "CountryName");
emp = db.Employees.Where(x => x.EmployeeId == id).Select(x => new ModelEmployee
{
EmployeeId = x.EmployeeId,
Name = x.Name,
Position = x.Position,
Office = x.Office,
Age = x.Age,
Salary = x.Salary,
CountryId = x.CountryId,
StateId = x.StateId,
CityId = x.CityId
}).FirstOrDefault();
return(View(emp));
}
}
}
private void Button1_Click(object sender, EventArgs e)
{
FrmEmployeesManager employeesOverView = new FrmEmployeesManager();
if (_department != null)
{
_createEditDepartmentViewModel.SetDepartmentForEmployee((int)_department.ManagerEmployeeId, null);
lblBossName.Text = "";
}
employeesOverView.ShowDialog();
if (employeesOverView.DialogResult == DialogResult.OK)
{
_bossId = employeesOverView.SelectedId;
if (_department != null)
{
_department.ManagerEmployeeId = _bossId;
}
ModelEmployee boss = _createEditDepartmentViewModel.GetEmployee(_bossId);
lblBossName.Text = $"{_departmentType.ToString()} Boss Name: {boss.Title} {boss.Name} {boss.Surname}";
btnConfirm.Enabled = true;
}
}
public ActionResult AllIncident()
{
var NumberIncident = Request["searchIncident"];
String serialNumber = TempData["Employee"].ToString();
ModelEmployee employee = new ModelEmployee().SearchEmployeeByNumber(serialNumber);
if (employee.IsTecnic == 1)
{
if (NumberIncident != null && NumberIncident != "")
{
ViewBag.ModelIncidents = new ModelIncidents().SearchIncident(NumberIncident);
}
else
{
ViewBag.ModelIncidents = new ModelIncidents().ListIncident();
}
}
else
{
if (NumberIncident != null && NumberIncident != "")
{
ViewBag.ModelIncidents = new ModelIncidents().SearchIncident(NumberIncident, employee.SeriaNumber);
}
else
{
ViewBag.ModelIncidents = new ModelIncidents().ListIncident(employee.SeriaNumber);
}
}
TempData["Employee"] = serialNumber;
return(View());
}
public List <ModelEmployee> GetEmployeeList()
{
List <Employees> employeelist = repo.List();
List <ModelEmployee> modelemployeelist = new List <ModelEmployee>();
foreach (var employee in employeelist)
{
ModelEmployee modelemployee = new ModelEmployee
{
EmployeeID = employee.EmployeeID,
Extension = employee.Extension,
Address = employee.Address,
City = employee.City,
FirstName = employee.FirstName,
HomePhone = employee.HomePhone,
Region = employee.Region,
PostalCode = employee.PostalCode,
Country = employee.Country,
LastName = employee.LastName,
Title = employee.Title,
TitleOfCourtesy = employee.TitleOfCourtesy,
ReportsTo = employee.ReportsTo
};
modelemployeelist.Add(modelemployee);
}
return(modelemployeelist);
}
//Метод для поиска сотрудника в БД
private IQueryable <Employee> FoundEmployee(ModelEmployee sel, DbSet <Employee> employees)
{
var found = from emp in employees
where emp.SecondName == sel.SecondName && emp.FirstName == sel.FirstName
select emp;
return(found);
}
private void FillTxtBoxes()
{
txtBoxCode.Text = _department.Code;
txtBoxName.Text = _department.Name;
if (_department.ManagerEmployeeId != null)
{
ModelEmployee boss = _createEditDepartmentViewModel.GetEmployee((int)_department.ManagerEmployeeId);
lblBossName.Text = $"{_department.DepartmentType.ToString()} Boss Name: {boss.Title} {boss.Name} {boss.Surname}";
}
}
public frmAddEmployee(ModelEmployee modelEmployee)
{
InitializeComponent();
_modelEmployee = modelEmployee;
txtTitle.Text = _modelEmployee.Title;
txtFirstName.Text = _modelEmployee.FirstName;
txtLastName.Text = _modelEmployee.LastName;
txtPhone.Text = _modelEmployee.Phone;
txtEmail.Text = _modelEmployee.Email;
}
public ActionResult Save()
{
ModelEmployee employee = new ModelEmployee();
employee.Name = Request["Name"];
employee.Departament = Request["Departament"];
employee.SeriaNumber = Request["SerialNumber"];
employee.IsTecnic = Convert.ToInt32(Request["IsTecnic"]);
employee.Password = Request["Password"];
employee.SaveEmployee();
return(RedirectToAction("CreateEmployee"));
}
public bool CreateEmployee(string title, string name, string surname, string phoneNumber, string email, int?departmentId)
{
ModelEmployee employee = new ModelEmployee
{
Title = title,
Name = name,
Surname = surname,
PhoneNumber = phoneNumber,
Email = email,
DepartmentId = departmentId
};
return(RepositoryManager.RepositoryEmployee.CreateEmployee(employee));
}
public object AlterEmployee()
{
ModelEmployee employee = new ModelEmployee();
employee.Name = Request["Name"];
employee.Departament = Request["Departament"];
employee.SeriaNumber = Request["SerialNumber"];
employee.IsTecnic = Convert.ToInt32(Request["IsTecnic"]);
employee.Password = Request["Password"];
employee.AlterEmployeetByNumber();
return(RedirectToAction("AllEmployee"));
}
private void btnAddEmployy_Click(object sender, EventArgs e)
{
frmEmployee employee = new frmEmployee();
if (employee.ShowDialog() == DialogResult.OK)
{
_sectionDirectorId = employee.DirectorId;
}
ModelEmployee employeeModel = new ModelEmployee();
employeeModel = _sectionManagerViewModel.SelectEmployeeById(_sectionDirectorId);
employeeModel.WorkAtDepartmentId = Convert.ToInt32(dgwDepartment.SelectedRows[0].Cells[0].Value);
_sectionManagerViewModel.UpdateEmployee(employeeModel);
dgwDepartment_SelectionChanged(this, new EventArgs());
}
public bool UpdateEmployeeWorkAt(ModelEmployee modelEmployee)
{
bool success = false;
Execute((command) =>
{
command.CommandText = "update employee set WorkAtID= @WorkAt where id=@idEmployee";
command.Parameters.Add("@WorkAt", SqlDbType.Int).Value = modelEmployee.WorkAtDepartmentId;
command.Parameters.Add("@idEmployee", SqlDbType.Int).Value = modelEmployee.Id;
if (command.ExecuteNonQuery() > 0)
{
success = true;
}
});
return(success);
}
private void btnUpdate_Click(object sender, EventArgs e)
{
ModelEmployee modelEmployee = new ModelEmployee();
modelEmployee.Id = Convert.ToInt32(dgwEmployee.SelectedRows[0].Cells[0].Value);
modelEmployee.Title = (dgwEmployee.SelectedRows[0].Cells[1].Value).ToString();
modelEmployee.FirstName = (dgwEmployee.SelectedRows[0].Cells[2].Value).ToString();
modelEmployee.LastName = (dgwEmployee.SelectedRows[0].Cells[3].Value).ToString();
modelEmployee.Phone = (dgwEmployee.SelectedRows[0].Cells[4].Value).ToString();
modelEmployee.Email = (dgwEmployee.SelectedRows[0].Cells[5].Value).ToString();
frmAddEmployee addEmployee = new frmAddEmployee(modelEmployee);
if (addEmployee.ShowDialog() == DialogResult.OK)
{
FillGrid();
}
}
public ActionResult AddOrEdit(ModelEmployee memp)
{
try
{
using (DBModel db = new DBModel())
{
Employee emp = new Employee();
if (memp.EmployeeId == 0)
{
emp.Name = memp.Name;
emp.Position = memp.Position;
emp.Office = memp.Office;
emp.Age = memp.Age;
emp.Salary = memp.Salary;
emp.CountryId = memp.CountryId;
emp.StateId = memp.StateId;
emp.CityId = memp.CityId;
db.Employees.Add(emp);
db.SaveChanges();
return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
var empp = db.Employees.Find(memp.EmployeeId);
empp.Name = memp.Name;
empp.Position = memp.Position;
empp.Office = memp.Office;
empp.Age = memp.Age;
empp.Salary = memp.Salary;
empp.CountryId = memp.CountryId;
empp.StateId = memp.StateId;
empp.CityId = memp.CityId;
db.SaveChanges();
return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet));
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public bool InsertEmployee(ModelEmployee modelEmployee)
{
bool success = false;
Execute((command) =>
{
command.CommandText = @"Insert into employee ([Title], [FirstName], [LastName], [Phone], [Email])
Values(@Title, @First, @Last, @Phone, @Email)";
command.Parameters.Add("@Title", SqlDbType.VarChar).Value = modelEmployee.Title;
command.Parameters.Add("@First", SqlDbType.VarChar).Value = modelEmployee.FirstName;
command.Parameters.Add("@Last", SqlDbType.VarChar).Value = modelEmployee.LastName;
command.Parameters.Add("@Phone", SqlDbType.VarChar).Value = modelEmployee.Phone;
command.Parameters.Add("@Email", SqlDbType.VarChar).Value = modelEmployee.Email;
if (command.ExecuteNonQuery() > 0)
{
success = true;
}
});
return(success);
}
// GET: Employee
public ActionResult Login()
{
var SerialNumber = Request["SerialNumber"];
var Password = Request["Password"];
ModelEmployee employee = new ModelEmployee();
employee = new ModelEmployee().Login(SerialNumber, Password);
if (employee.Name != null)
{
TempData["Employee"] = employee.SeriaNumber;
return(RedirectToAction("Index", "StartView"));
}
else
{
TempData["Erro"] = true;
TempData["Message"] = "Login não possui perfil no sistema!";
return(View());
}
}
public AddLetterViewModel()
{
CatalogueBD = new CatalogueDBContext();
Employees = new ObservableCollection <ModelEmployee>();
//Заполнение списка сотрудников из базы
foreach (Employee emp in CatalogueBD.Employees.Include(x => x.Letters).ToList())
{
Employees.Add(new ModelEmployee()
{
FirstName = emp.FirstName,
SecondName = emp.SecondName,
FullName = emp.FirstName + " " + emp.SecondName
});
}
if (Employees.Count > 0) //Назначаем начальные значения для combobox
{
selectedSender = Employees[0];
selectedRecipient = Employees[0];
}
inputDateTime = DateTime.Now;
}
public bool UpdateEmployee(ModelEmployee modelEmployee)
{
bool success = false;
Execute((command) =>
{
command.CommandText = @"Update employee set [Title] = @Title, [FirstName] = @FirstName, [LastName] = @LastName,
[Phone] = @Phone, [Email] = @Email, [WorkAtID]=@WorkAt where id=@id";
command.Parameters.Add("@id", SqlDbType.Int).Value = modelEmployee.Id;
command.Parameters.Add("@Title", SqlDbType.VarChar).Value = modelEmployee.Title;
command.Parameters.Add("@FirstName", SqlDbType.VarChar).Value = modelEmployee.FirstName;
command.Parameters.Add("@LastName", SqlDbType.VarChar).Value = modelEmployee.LastName;
command.Parameters.Add("@Phone", SqlDbType.VarChar).Value = modelEmployee.Phone;
command.Parameters.Add("@Email", SqlDbType.VarChar).Value = modelEmployee.Email;
command.Parameters.Add("@WorkAt", SqlDbType.Int).Value = modelEmployee.WorkAtDepartmentId;
if (command.ExecuteNonQuery() > 0)
{
success = true;
}
});
return(success);
}
public ModelEmployee SelectEmployeeById(int employeeId)
{
ModelEmployee modelEmployee = new ModelEmployee();
Execute((command) =>
{
command.CommandText = "select [Title], [FirstName], [LastName], [Phone], [Email], [id] " +
" from employee where id=@employeeId";
command.Parameters.Add("@employeeId", SqlDbType.Int).Value = employeeId;
using (SqlDataReader reader = command.ExecuteReader())
{
if (reader.Read())
{
modelEmployee.Title = reader.GetString(0);
modelEmployee.FirstName = reader.GetString(1);
modelEmployee.LastName = reader.GetString(2);
modelEmployee.Phone = reader.GetString(3);
modelEmployee.Email = reader.GetString(4);
modelEmployee.Id = reader.GetInt32(5);
}
}
});
return(modelEmployee);
}
public IHttpActionResult Post(ModelEmployee model)
{
try
{
if (ModelState.IsValid)
{
if (_unitOfWork.Employees.GetById(model.Id) != null)
{
AppLogger.Debug("New employee unsuccessfull. From: Employees using Web API");
ModelState.AddModelError("ID", "Id is in use");
}
else
{
//<Destination>(Source)
var emp = _mapper.Map <Employee>(model);
_unitOfWork.Employees.Add(emp);
if (_unitOfWork.Complete() > 0)
{
var newModel = _mapper.Map <ModelEmployee>(emp);
//CreatedAtRoute("GetEmployee", new { moniker = newModel.Id }, newModel);
AppLogger.Info("New employee successfull. From: Employees using Web API");
return(Ok(newModel));
}
;
}
}
}
catch (Exception ex)
{
AppLogger.Error("New employee error. From: Employees using Web API");
return(InternalServerError(ex));
}
AppLogger.Debug("New employee unsuccessfull. From: Employees using Web API");
return(BadRequest(ModelState));
}
private void btnSaveDirector_Click(object sender, EventArgs e)
{
if (_modelEmployee == null)
{
ModelEmployee model = new ModelEmployee();
model.Title = txtTitle.Text;
model.FirstName = txtFirstName.Text;
model.LastName = txtLastName.Text;
model.Phone = txtPhone.Text;
model.Email = txtEmail.Text;
_addEmployeeViewModel.InsertEmployee(model);
}
else
{
_modelEmployee.Title = txtTitle.Text;
_modelEmployee.FirstName = txtFirstName.Text;
_modelEmployee.LastName = txtLastName.Text;
_modelEmployee.Phone = txtPhone.Text;
_modelEmployee.Email = txtEmail.Text;
_addEmployeeViewModel.UpdateEmployeeBy(_modelEmployee);
}
DialogResult = DialogResult.OK;
Close();
}
public ManForm()
{
InitializeComponent();
m_model = new ModelEmployee();
}
