static void Main(string[] args)
{
using (BLContext context = new BLContext())
{
//var temp=context.Course.FirstOrDefault();
//context.Course.Add(new Course { Id = 1, Name = "name", Description = "name1" });
//context.Category.Add(new Category { CategoryId = "1", CategoryName = "cname" });
//context.Product.Add(new Product
//{
// ProductId = "1",
// ProductName = "aaa"
//});
// var rstInt= context.SaveChanges();
//context.Category.Add(new Category { CategoryId = "1", CategoryName = "c1", Product = new Product { ProductId = "1", ProductName = "p1" } });
// context.Product.Add(new Product { ProductId = "1", ProductName = "p1" });
context.SaveChanges();
//var category = context.Category.ToList();
//var product = context.Product.ToList();
//context.SignIn.Add(new SignIn
//{
// SignInId = "2",
// Operator = "o2"
//});
//context.Enroll.Add(new Enroll { EnrollId = "2", EnrollName = "e1", SignIn = new SignIn { SignInId = "2", Operator = "o2" } });
//context.SaveChanges();
//XmlWriterSettings settings = new XmlWriterSettings();
//settings.Indent = true;
//using (XmlWriter writer = XmlWriter.Create(@"Model.edmx", settings))
//{
// EdmxWriter.WriteEdmx(context, writer);
//}
}
}
public void Add(Booking booking)
{
using (var ctx = new BLContext())
{
ctx.Bookings.Add(booking);
ctx.Entry(booking.Package).State = System.Data.Entity.EntityState.Unchanged;
ctx.SaveChanges();
}
}
public void Add(Package package)
{
using (var ctx = new BLContext())
{
ctx.Packages.Attach(package);
ctx.Packages.Add(package);
ctx.SaveChanges();
}
}
public void Edit(Package package)
{
using (var ctx = new BLContext())
{
var packageDB = ctx.Packages.FirstOrDefault(x => x.Id == package.Id);
packageDB.name = package.name;
packageDB.price = package.price;
ctx.SaveChanges();
}
}
public void Delete(int id)
{
Booking booking = Find(id);
using (var ctx = new BLContext())
{
ctx.Bookings.Attach(booking);
ctx.Bookings.Remove(booking);
ctx.SaveChanges();
}
}
public void Delete(int id)
{
Package package = Find(id);
using (var ctx = new BLContext())
{
ctx.Packages.Attach(package);
ctx.Packages.Remove(package);
ctx.SaveChanges();
}
}
public void Edit(Booking booking)
{
using (var ctx = new BLContext())
{
var bookingDB = ctx.Bookings.Include("Package").FirstOrDefault(x => x.Id == booking.Id);
ctx.Entry(bookingDB).CurrentValues.SetValues(booking);
if (bookingDB.Package.Id != booking.Package.Id)
{
bookingDB.Package = booking.Package;
ctx.Entry(booking.Package).State = EntityState.Unchanged;
}
ctx.SaveChanges();
}
}
