public static void RemoveEmployee(string name)
{
using (var db = new SoftUniEntities())
{
var customer = db.Employees.Where(x => x.FirstName == name).FirstOrDefault<Employee>();
db.Employees.Remove(customer);
db.SaveChanges();
}
}
public static void ModifyEmployee(string firstName, string newFirstName)
{
using (var db = new SoftUniEntities())
{
Employee employee = db.Employees.Where(x => x.FirstName == firstName).FirstOrDefault<Employee>();
employee.FirstName = newFirstName;
db.SaveChanges();
}
}
public static void InsertProject(string name, string description, DateTime startDate)
{
using( var db = new SoftUniEntities())
{
Project newProject = new Project()
{
Name = name,
Description = description,
StartDate = startDate
};
db.Projects.Add(newProject);
db.SaveChanges();
}
}
static void Main(string[] args)
{
SoftUniEntities dbOne = new SoftUniEntities();
SoftUniEntities1 dbTwo = new SoftUniEntities1();
var empOne = dbOne.Employees.Where(e => e.DepartmentID == 1).ToArray();
var empTwo = dbOne.Employees.Where(e => e.DepartmentID == 1).ToArray();
for (int i = 0; i < empOne.Length; i++)
{
empOne[i].FirstName = "Huhum";
empTwo[i].FirstName = "Zazum";
}
dbOne.SaveChanges();
dbTwo.SaveChanges();
}
public static void InsertEmployee(string firstName, string lastName, string jobTitle,
string departmentName, DateTime hireDate, decimal salary)
{
using (var db = new SoftUniEntities())
{
var employee = new Employee()
{
FirstName = firstName,
LastName = lastName,
JobTitle = jobTitle,
DepartmentID = db.Departments
.Where(d => d.Name == departmentName)
.FirstOrDefault().DepartmentID,
HireDate = hireDate,
Salary = salary
};
db.Employees.Add(employee);
db.SaveChanges();
}
}