public static void Main()
{
var context = new SoftUniEntities();
var newEmployee = new Employee
{
FirstName = "Ivan",
LastName = "Ivanov",
JobTitle = "Database administrator",
DepartmentID = context.Departments
.Where(d => d.Name == "Research and Development")
.Select(a => a.DepartmentID)
.First(),
HireDate = DateTime.Now,
Salary = 15000
};
Console.WriteLine("1. Add new employee");
Console.WriteLine(" -- {0} with Id: {1}", DataAccessObject.Add(newEmployee), newEmployee.EmployeeID);
Console.WriteLine("2. Find employee by key");
var employee = DataAccessObject.FindByKey(newEmployee.EmployeeID);
Console.WriteLine(" -- {0} {1}", employee.FirstName, employee.LastName);
Console.WriteLine("3. Edit employee first name");
employee.FirstName = "Todor";
Console.WriteLine(" -- " + DataAccessObject.Modify(employee));
Console.WriteLine(" -- New name: {0} {1}", employee.FirstName, employee.LastName);
Console.WriteLine("4. Delete employee");
Console.WriteLine(" -- {0}", DataAccessObject.Delete(employee));
}
public static void Delete(Employee employee)
{
var context = new SoftUniEntities();
var deletedEmp = context.Employees.Remove(employee);
var name = deletedEmp.FirstName == "Guy";
context.SaveChanges();
Console.WriteLine("The deleted employee's name is {0}", name);
}
public static void Modify(Employee employee)
{
var context = new SoftUniEntities();
var foundEmp = context.Employees.Find(3);
foundEmp.FirstName = "Vyara";
foundEmp.LastName = "Georgieva";
context.SaveChanges();
Console.WriteLine("The employee's with Id {0} name now is {1} {2}",foundEmp.EmployeeID, foundEmp.FirstName, foundEmp.LastName);
}
public static string Add(Employee employee)
{
using (var context = new SoftUniEntities())
{
context.Employees.Add(employee);
context.SaveChanges();
return "Employee added";
}
}
public static string Modify(Employee employee)
{
using (var context = new SoftUniEntities())
{
var original = context.Employees.Find(employee.EmployeeID);
context.Entry(original).CurrentValues.SetValues(employee);
context.SaveChanges();
return "Employee modified";
}
}
public static void Add(Employee employee)
{
var context = new SoftUniEntities();
context.Employees.Add(employee);
employee.FirstName = "Peter";
employee.LastName = "Petrov";
employee.JobTitle = "Senior JS";
employee.DepartmentID = 2;
employee.HireDate = DateTime.Now;
employee.Salary = 60000;
context.SaveChanges();
Console.WriteLine("Employee added: First Name: {0}, Last Name {1}", employee.FirstName, employee.LastName);
}
static void Main(string[] args)
{
var context = new SoftUniEntities();
Employee newEmployee = new Employee
{
FirstName = "Goshko",
LastName = "Dendimonov",
JobTitle = "Gamer",
DepartmentID = 2,
HireDate = DateTime.Now,
Salary = 10000
};
DAOClass.Add(newEmployee);
var primaryKey = newEmployee.EmployeeID;
Console.WriteLine("{0}'s ID Key is {1}", newEmployee.FirstName, primaryKey);
DAOClass.Modify(newEmployee, "Toshko");
Console.WriteLine("{0}'s ID Key is {1}", newEmployee.FirstName, primaryKey);
DAOClass.Delete(newEmployee);
}
public static string Delete(Employee employee)
{
using (var context = new SoftUniEntities())
{
//var itemToRemove = context.Employees.SingleOrDefault(e => e.EmployeeID == employee.EmployeeID);
context.Entry(employee).State = EntityState.Deleted;
context.SaveChanges();
//
// if (itemToRemove != null)
// {
// context.Employees.Remove(itemToRemove);
// context.SaveChanges();
return "Employee deleted";
//}
return "Delete failed!";
}
}
