public static void Update(Entity.Customer obj)
{
using (var model = new Entity.SeguroEntities1())
{
model.Entry <Entity.Customer>(obj).State = EntityState.Modified;
model.SaveChanges();
}
}
public static List <Entity.City> GetByAll()
{
using (var model = new Entity.SeguroEntities1())
{
var result = (from c in model.Cities select c);
return(result.ToList());
}
}
public static Entity.City GetById(int id)
{
using (var model = new Entity.SeguroEntities1())
{
var result = (from c in model.Cities where c.CityId == id select c);
return(result.FirstOrDefault());
}
}
public static void Insert(Entity.CustomerAddress obj)
{
using (var model = new Entity.SeguroEntities1())
{
model.Entry <Entity.CustomerAddress>(obj).State = System.Data.Entity.EntityState.Added;
model.SaveChanges();
}
}
public static Entity.Customer GetById(Guid id)
{
using (var model = new Entity.SeguroEntities1())
{
model.Configuration.ProxyCreationEnabled = false;
var result = (from c in model.Customers
.Include(c => c.CustomerAddresses) where c.ID == id select c);
return(result.FirstOrDefault());
}
}
