private static void updatePerson()
{
// var person = new Person { Forename = "Paul", Surname = "Kane", NoOfDaysLeft = 30 };
var person2 = new Person {
Forename = "Sam", Surname = "Kane", NoOfDaysLeft = 20
};
Person person;
using (var context = new HCISContext())
{
person = context.Persons.FirstOrDefault();
}
person.Surname = "Test";
using (var context = new HCISContext())
{
context.Persons.Attach(person);
context.Entry(person).State = EntityState.Modified;
context.Database.Log = Console.WriteLine;
context.SaveChanges();
}
}
private static void removePerson2()
{
//use a stored procedure
using (var context = new HCISContext())
{
var person = context.Persons.FirstOrDefault();
context.Entry(person).State = EntityState.Deleted;
int key = 1;
context.Database.ExecuteSqlCommand("exec deletePerson {0}", key);
context.SaveChanges();
}
}
private static void addSomeLeave()
{
using (var context = new HCISContext())
{
context.Database.Log = Console.WriteLine;
var person = context.Persons.FirstOrDefault();
var leave1 = new Leave {
FromDate = new DateTime(2019, 1, 1), ToDate = new DateTime(2019, 1, 3), NoWorkingDays = 1, LeaveTypeId = LeaveType.AnnualLeave
};
var leave2 = new Leave {
FromDate = new DateTime(2019, 3, 1), ToDate = new DateTime(2019, 3, 3), NoWorkingDays = 1, LeaveTypeId = LeaveType.AnnualLeave
};
person.LeaveItems.Add(leave1);
person.LeaveItems.Add(leave2);
context.SaveChanges();
}
}
private static void insertPerson()
{
var person = new Person {
Forename = "Paul", Surname = "Kane", NoOfDaysLeft = 30
};
var person2 = new Person {
Forename = "Sam", Surname = "Kane", NoOfDaysLeft = 20
};
using (var context = new HCISContext())
{
context.Database.Log = Console.WriteLine;
//context.Persons.Add(person);
context.Persons.AddRange(new List <Person> {
person, person2
});
context.SaveChanges();
}
}
