public static void AddNewProject(
string projectName,
DateTime startDate,
DateTime? endDate = null,
string projectDescription = null,
params int[] employeesId
)
{
var project = new Project
{
Name = projectName,
Description = projectDescription,
StartDate = startDate,
EndDate = endDate,
};
using (var db = new SoftUniEntities())
{
foreach (var id in employeesId)
{
project.Employees.Add(db.Employees.Find(id));
}
db.Projects.Add(project);
db.SaveChanges();
}
}
//06.Adding a new address and updating Employee
private static void AddAddress(SoftUniEntities context)
{
//var address = new Address()
//{
// AddressText = "Vitoshka 15",
// TownID = 4
//};
//context.Addresses.Add(address);
//context.SaveChanges();
//Employee emp = context.Employees.FirstOrDefault(e => e.LastName == "Nakov");
//emp.Address = address;
//context.SaveChanges();
var address = new Address()
{
AddressText = "Vitoshka 15",
TownID = 4
};
Employee emp = context.Employees.FirstOrDefault(e => e.LastName == "Nakov");
emp.Address = address;
context.SaveChanges();
var addresses = context.Employees.OrderByDescending(e => e.AddressID).Take(10).ToList();
foreach (var e in addresses)
{
Console.WriteLine(e.Address.AddressText);
}
}
public static void DeleteEmployee(int employeeId)
{
using (var db = new SoftUniEntities())
{
db.Employees.Remove(db.Employees.Find(employeeId));
db.SaveChanges();
}
}
public static void Add(Employee employee)
{
var context = new SoftUniEntities();
context.Employees.Add(employee);
context.SaveChanges();
}
public static void Delete(Employee employee)
{
var context = new SoftUniEntities();
context.Employees.Remove(employee);
context.SaveChanges();
}
public static void Modify(Employee employee)
{
var context = new SoftUniEntities();
context.Employees.Attach(employee);
context.Entry(employee).State = EntityState.Modified;
context.SaveChanges();
}
//15.Delete project by ID
private static void DeletProject(SoftUniEntities context)
{
var projects = context.Projects.Find(2);
foreach (var emp in projects.Employees)
{
emp.Projects.Remove(projects);
}
context.Projects.Remove(projects);
context.SaveChanges();
var result = context.Projects.Take(10);
foreach (var pr in result)
{
Console.WriteLine(pr.Name);
}
}
//12.Increase Salary
private static void IncreaseSalary(SoftUniEntities context)
{
IEnumerable <Employee> employees = context.Employees
.Where(
e => e.Department.Name == "Engineering" ||
e.Department.Name == "Tool Design" ||
e.Department.Name == "Marketing" ||
e.Department.Name == "Information Services");
foreach (Employee e in employees)
{
e.Salary += e.Salary * 0.12M;
Console.WriteLine($"{e.FirstName} {e.LastName} (${e.Salary})");
}
context.SaveChanges();
}
public static void ModifyEmployee(
Employee employee,
string FirstName = null,
string MiddleName = null,
string LastName = null,
string JobTitle = null,
int? DepartmentID = null,
int? ManagerID = null,
DateTime? HireDate = null,
decimal? Salary = null,
int? AddressID = null
)
{
using (var db = new SoftUniEntities())
{
var emp = db.Employees.Find(employee.EmployeeID);
if (FirstName != null)
{
emp.FirstName = FirstName;
}
if (MiddleName != null)
{
emp.MiddleName = MiddleName;
}
if (LastName != null)
{
emp.LastName = LastName;
}
if (JobTitle != null)
{
emp.JobTitle = JobTitle;
}
if (DepartmentID != null)
{
emp.DepartmentID = (int)DepartmentID;
}
if (ManagerID != null)
{
emp.ManagerID = ManagerID;
}
if (HireDate != null)
{
emp.HireDate = (DateTime)HireDate;
}
if (Salary != null)
{
emp.Salary = (decimal)Salary;
}
if (AddressID != null)
{
emp.AddressID = AddressID;
}
db.SaveChanges();
}
}
public static void InsertEmployee(Employee employee)
{
using (var db = new SoftUniEntities())
{
db.Employees.Add(employee);
db.SaveChanges();
}
}