public static void AddProject(
string name,
string description,
DateTime startDate,
List<int> employeesId = null,
DateTime? endDate = null)
{
var db = new SoftUniEntities1();
var employees = new List<Employee>();
foreach (var employeeId in employeesId)
{
var employee = db.Employees
.Where(e => e.EmployeeID == employeeId)
.FirstOrDefault();
if (employee != null)
{
employees.Add(employee);
}
}
var project = new Project
{
Name = name,
Description = description,
StartDate = startDate,
EndDate = endDate,
Employees = employees
};
db.Projects.Add(project);
db.SaveChanges();
Console.WriteLine("Project added");
}
public static void ModifyEmployee(
int employeeId,
string firstName = null,
string lastName = null,
string jobTitle = null,
string department = null,
DateTime? hireDate = null,
decimal? salary = null,
string middleName = null,
string manager = null,
string address = null,
string town = null)
{
var db = new SoftUniEntities1();
var employee = db.Employees.Where(e => e.EmployeeID == employeeId).FirstOrDefault();
if (!string.IsNullOrEmpty(firstName))
{
employee.FirstName = firstName;
db.SaveChanges();
}
if (!string.IsNullOrEmpty(lastName))
{
employee.LastName = lastName;
db.SaveChanges();
}
if (!string.IsNullOrEmpty(jobTitle))
{
employee.JobTitle = jobTitle;
db.SaveChanges();
}
if (!string.IsNullOrEmpty(department))
{
int newDepartmentId = db.Departments
.Where(d => d.Name == department)
.Select(d => d.DepartmentID)
.FirstOrDefault();
employee.DepartmentID = newDepartmentId;
db.SaveChanges();
}
if (hireDate != null)
{
employee.HireDate = (DateTime)hireDate;
db.SaveChanges();
}
if (salary != null)
{
employee.Salary = (decimal)salary;
db.SaveChanges();
}
if (!string.IsNullOrEmpty(middleName))
{
employee.MiddleName = middleName;
db.SaveChanges();
}
if (!string.IsNullOrEmpty(manager))
{
int newManagerId = db.Employees
.Where(e => e.FirstName + " " + e.LastName == manager)
.Select(e => e.EmployeeID)
.FirstOrDefault();
employee.ManagerID = newManagerId;
db.SaveChanges();
}
if (!string.IsNullOrEmpty(address))
{
employee.Address.AddressText = address;
db.SaveChanges();
}
if (!string.IsNullOrEmpty(town))
{
int newTownId = db.Towns
.Where(t => t.Name == town)
.Select(t => t.TownID)
.FirstOrDefault();
employee.Address.TownID = newTownId;
db.SaveChanges();
}
Console.WriteLine("Employee modifyng");
}
public static void AddNewEmployee(
string firstName,
string lastName,
string jobTitle,
string department,
DateTime hireDate,
decimal salary,
string middleName = null,
string manager = null,
string address = null,
string town = null)
{
var db = new SoftUniEntities1();
int newEmployeeDepartmentId = db.Departments
.Where(d => d.Name == department)
.Select(d => d.DepartmentID)
.FirstOrDefault();
int? employeeManagerId = null;
int? employeeAddressId = null;
int? employeeTownId = null;
if (!string.IsNullOrEmpty(manager))
{
employeeManagerId = db.Employees
.Where(e => e.FirstName + " " + e.LastName == manager)
.Select(e => e.EmployeeID)
.FirstOrDefault();
}
if (!string.IsNullOrEmpty(address))
{
if (!string.IsNullOrEmpty(town))
{
employeeTownId = db.Towns
.Where(t => t.Name == town)
.Select(t => t.TownID)
.FirstOrDefault();
}
var employeeAddress = new Address
{
AddressText = address,
TownID = employeeTownId
};
db.Addresses.Add(employeeAddress);
db.SaveChanges();
employeeAddressId = db.Addresses
.Max(a => a.AddressID);
}
var newEmployee = new Employee
{
FirstName = firstName,
LastName = lastName,
MiddleName = middleName,
JobTitle = jobTitle,
DepartmentID = newEmployeeDepartmentId,
ManagerID = employeeManagerId,
HireDate = hireDate,
Salary = salary,
AddressID = employeeAddressId
};
db.Employees.Add(newEmployee);
db.SaveChanges();
Console.WriteLine("Employee added");
}
public static void RemoveEmployee(int employeeId)
{
var db = new SoftUniEntities1();
var employee = db.Employees
.Where(e => e.EmployeeID == employeeId)
.FirstOrDefault();
var address = db.Addresses
.Where(a => a.AddressID == employee.AddressID)
.FirstOrDefault();
db.Addresses.Remove(address);
db.Employees.Remove(employee);
db.SaveChanges();
Console.WriteLine("Employee deleted");
}