public RemoveItem RemoveItems(int itemId, int returnedItemQty, string sessionId, int checkedinId) { var connectionString = Startup.connectionstring; using (var con = new ShoppingContext(connectionString)) { var context = con.itemMasterEntity.Where(k => k.Active == true).SingleOrDefault(m => m.ItemId == itemId); context.ReserveQty = context.ReserveQty - returnedItemQty; context.AvailableQty = context.AvailableQty + returnedItemQty; var remove = con.CheckInEntity.Where(m => m.UserSessionId == sessionId && m.id == checkedinId).SingleOrDefault(); remove.Active = false; con.SaveChanges(); var count = con.CheckInEntity.Where(m => m.UserSessionId == sessionId && m.Active == true).Count(); var result = new RemoveItem() { count = count, successs = true }; return(result); } }