public static void InsertEmployee(Employee employee)
{
var db = new SoftUniEntities();
db.Employees.Add(employee);
db.SaveChanges();
Console.WriteLine(employee.FirstName + " " + employee.LastName + " Inserted!!!");
}
static void ProjectAdderExplicitlyStartTransaction()
{
var db = new SoftUniEntities();
using (var transaction = db.Database.BeginTransaction())
{
var firstEmployee = db.Employees.Find(121);
var lastEmployee = db.Employees.Find(3);
var project = new Project
{
Name = "DatabaseTeamWork2",
StartDate = new DateTime(2015, 2, 15, 0, 0, 0),
EndDate = new DateTime(2015, 3, 20, 0, 0, 0),
Employees = new Collection<Employee>
{
firstEmployee,
lastEmployee
},
Description = "TeamWork2"
};
try
{
db.Projects.Add(project);
db.SaveChanges();
transaction.Commit();
Console.WriteLine("Adding end succesfully => Commit Transaction2");
}
catch (Exception ex)
{
transaction.Rollback();
Console.WriteLine("Adding finish unsuccesfully => Rollback Transaction2");
}
}
}
public static void UpdateEmployeeSalaryByEmployeeId(int id, decimal newSalary)
{
var db = new SoftUniEntities();
var employee = db.Employees.Find(id);
employee.Salary = newSalary;
db.SaveChanges();
Console.WriteLine(employee.FirstName + " " + employee.LastName + " new salary -> " + newSalary);
}
public static void RemoveEmployeeById(int employeeId)
{
var db = new SoftUniEntities();
var employee = db.Employees.Find(employeeId);
db.Employees.Remove(employee);
db.SaveChanges();
Console.WriteLine(employee.FirstName + " " + employee.LastName + " Deleted!!!");
}