public static void Add(Employee emlpoyee)
{
var context = new SoftUniEntities();
context.Employees.Add(emlpoyee);
context.SaveChanges();
}
public static void Delete(Employee employee)
{
var context = new SoftUniEntities();
context.Employees.Remove(employee);
context.SaveChanges();
}
public static void Modify(int id, string firstName)
{
var db = new SoftUniEntities();
Employee employee = db.Employees.Find(id);
employee.FirstName=firstName;
db.SaveChanges();
}
public static void Delete(int id)
{
var db = new SoftUniEntities();
Employee employee = db.Employees.Find(id);
db.Employees.Remove(employee);
db.SaveChanges();
}
public static void Delete(Employee employee)
{
var context = new SoftUniEntities();
context.Employees.Remove(employee);
context.SaveChanges();
}
public static void Add(Employee emlpoyee)
{
var context = new SoftUniEntities();
context.Employees.Add(emlpoyee);
context.SaveChanges();
}
public static void DeleteEmployee(SoftUniEntities db, string firstName, string middleName, string lastName)
{
Employee employeeToDelete =
db.Employees.First(e => e.FirstName == firstName && e.MiddleName == middleName && e.LastName == lastName);
db.Employees.Remove(employeeToDelete);
db.SaveChanges();
}
public static void Main()
{
var db1 = new SoftUniEntities();
var db2 = new SoftUniEntities();
db1.Employees.Find(1).FirstName = "Ivan";
db2.Employees.Find(1).FirstName = "Gosho";
db1.SaveChanges();
db2.SaveChanges();
//Gosho has overwritten the first name in Employee Table and Ivan was completely ignored.
}
public static void ModifyEmployee(SoftUniEntities db, int employeeId, string propertyName, object newValue)
{
var employeeToModify = db.Employees.Find(employeeId);
if (employeeToModify != null)
{
employeeToModify.GetType().GetProperty(propertyName).SetValue(employeeToModify, newValue);
db.SaveChanges();
}
else
{
Console.WriteLine("No such employee.");
}
}
public static void Add(string firstName, string lastName, string jobTitle, string department, DateTime hireDate, int salary)
{
var db = new SoftUniEntities();
var depName = db.Departments.First(d => d.Name == department.ToString());
var employee = new Employee()
{
FirstName = firstName,
LastName = lastName,
JobTitle = jobTitle,
DepartmentID = depName.DepartmentID,
HireDate = hireDate,
Salary = salary
};
db.Employees.Add(employee);
db.SaveChanges();
}
static void Main()
{
//step 1
var context = new SoftUniEntities();
var employeeNames = context.Employees
.Where(e => e.Salary > 50000)
.Select(e => e.FirstName);
var employees =
from e in context.Employees
where e.Salary > 50000
select e.FirstName;
foreach (var item in employees)
{
Console.WriteLine(item);
}
// task 3
// task 4
var context = new SoftUniEntities();
var address = new Address()
{
AddressText = "Vitoshka 15",
TownID = 4
};
Employee employee = context.Employees
.Where(e => e.LastName == "Nakov")
.FirstOrDefault();
employee.Address = address;
context.SaveChanges();
var empl = context.Employees.FirstOrDefault(e => e.LastName == "Nakov");
Console.WriteLine(empl.Address.AddressText);
// Task 5- NO
var context = new SoftUniEntities();
var project = context.Projects.Find(2);
var empProjects = project.Employees.ToList();
foreach (var empl in empProjects)
{
if (empl.Projects.Contains(project))
{
context.Employees.Remove(empl);
}
;
}
// context.Projects.Remove(project);
context.SaveChanges();
}
static void Main()
{
//step 1
var context = new SoftUniEntities();
var employeeNames = context.Employees
.Where(e => e.Salary > 50000)
.Select(e => e.FirstName);
var employees =
from e in context.Employees
where e.Salary > 50000
select e.FirstName;
foreach (var item in employees)
{
Console.WriteLine(item);
}
// task 3
// task 4
var context = new SoftUniEntities();
var address = new Address()
{
AddressText = "Vitoshka 15",
TownID = 4
};
Employee employee = context.Employees
.Where(e => e.LastName == "Nakov")
.FirstOrDefault();
employee.Address = address;
context.SaveChanges();
var empl = context.Employees.FirstOrDefault(e => e.LastName == "Nakov");
Console.WriteLine(empl.Address.AddressText);
// Task 5- NO
var context = new SoftUniEntities();
var project = context.Projects.Find(2);
var empProjects = project.Employees.ToList();
foreach (var empl in empProjects)
{
if (empl.Projects.Contains(project))
{
context.Employees.Remove(empl);
};
}
// context.Projects.Remove(project);
context.SaveChanges();
}
public static void InsertEmployee(SoftUniEntities db, Employee employee)
{
db.Employees.Add(employee);
db.SaveChanges();
}
