public static void DeleteById(Entity.Client obj)
{
using (var model = new Entity.DbContextEntity())
{
model.Entry <Entity.Client>(obj).State = EntityState.Deleted;
model.SaveChanges();
}
}
public static void Update(Entity.Client obj)
{
using (var model = new Entity.DbContextEntity())
{
model.Entry <Entity.Client>(obj).State = EntityState.Modified;
model.SaveChanges();
}
}
public static void Insert(Entity.Client obj)
{
using (var model = new Entity.DbContextEntity())
{
model.Entry <Entity.Client>(obj).State = EntityState.Added;
model.SaveChanges();
}
}
public static List <Entity.City> GetAll()
{
using (var model = new Entity.DbContextEntity())
{
model.Configuration.ProxyCreationEnabled = false;
var result = (from c in model.Cities
select c).ToList();
return(result);
}
}
public static Entity.City GetById(int id)
{
using (var model = new Entity.DbContextEntity())
{
model.Configuration.ProxyCreationEnabled = false;
var result = (from c in model.Cities
where c.CityId == id
select c);
return(result.FirstOrDefault());
}
}
public static Entity.Client GetById(int id)
{
using (var model = new Entity.DbContextEntity())
{
model.Configuration.ProxyCreationEnabled = false;
var result = (from c in model.Clients
where c.Id == id
select c);
//Cuando añadí el Include, se cambio el campo de CityId en el View de Editor a DropdownList
// .Include(c => c.City)
return(result.FirstOrDefault());
}
}
