public void Add(BookedItem entity) { using (var dbContext = new PoREntities(ConnectionString)) { dbContext.BookedItems.Add(entity); dbContext.SaveChanges(); } }
public void Add(Client entity) { using (var dbContext = new PoREntities(ConnectionString)) { dbContext.Clients.Add(entity); dbContext.SaveChanges(); } }
public void Update(BookedItem entity) { using (var dbContext = new PoREntities(ConnectionString)) { // We could turn this into an upsert dbContext.BookedItems.Attach(entity); dbContext.Entry(entity).State = EntityState.Modified; dbContext.SaveChanges(); } }
public BookedItem GetBookedItem(int id) { using (var dbContext = new PoREntities(ConnectionString)) { var item = from itm in dbContext.BookedItems where itm.BookedItemId == id select itm; return(item.First()); } }
public void DeleteBookedItem(int itemId) { using (var dbContext = new PoREntities(ConnectionString)) { var item = from itm in dbContext.BookedItems where itm.BookedItemId == itemId select itm; dbContext.BookedItems.Remove(item.First()); } }
public Client GetClient(int id) { using (var dbContext = new PoREntities(ConnectionString)) { var entity = from client in dbContext.Clients where client.ClientId == id select client; return(entity.First()); } }
public void DeleteClient(int id) { using (var dbContext = new PoREntities(ConnectionString)) { var entity = from client in dbContext.Clients where client.ClientId == id select client; dbContext.Clients.Remove(entity.First()); } }
public int GetItemCount() { using (var dbContext = new PoREntities(ConnectionString)) { var result = from itm in dbContext.Items select itm; //The IQueryable isn't registered to the last second, so this isn't executed on the list, // but rather at the database level as a select statement so long as we're using mssql or a // driver that supports Entity framework properly. return(result.Count()); } }
public List <Item> GetItems() { using (var dbContext = new PoREntities(ConnectionString)) { var items = from itm in dbContext.Items select itm; // Calling the tolist here forces the DB call. Potentially you could do something fancy // and add additional parameters if you returned it as an IQueryable. You do however // Run into issue with how EF populates the navigation properties. return(items.ToList()); } }
public void Update(Item entity) { using (var dbContext = new PoREntities(ConnectionString)) { // We could turn this into an upsert dbContext.Items.Attach(entity); dbContext.Entry(entity).State = EntityState.Modified; // This Could cause problems. You could approach this like and upsert and do something like // AddOrUpdate(i=> i.id == entity.Id). Additionally you may want to set certain properties // of the entity to 'not modified' if they're null so as not to update the DB. dbContext.SaveChanges(); } }
public Item GetItem(int id) { // In a perfect wold we would not be using the auto-incremented id here but some from of generated // id so that we would not expose the inner workings of the DB to the world. using (var dbContext = new PoREntities(ConnectionString)) { var item = from itm in dbContext.Items where itm.ItemId == id select itm; return(item.First()); } }