public void CreateTest() { Y = new Yeast(); Y.ProductId = "EE101RED"; Y.MinTemp = 2.0; Y.MaxTemp = 44.22; Y.Form = "Non-Newtonian"; Y.Laboratory = "S.T.A.R. Labs"; Y.Flocculation = "I'm not giggling you are.."; Y.Attenuation = 1.21; Y.MaxReuse = Int32.MaxValue; Y.Type = "Flux Capacitance"; Y.BestFor = "Time travel"; I = new Ingredient(); I.Name = "The Time Traveler"; I.IngredientTypeId = 4; I.Version = 1; I.OnHandQuantity = 0; I.UnitCost = 0.00m; I.UnitTypeId = 2; I.Notes = "A swirling mass of wibbly wobbly colourful time stuff"; dbContext.Ingredient.Add(I); dbContext.SaveChanges(); Y.IngredientId = I.IngredientId; dbContext.Yeast.Add(Y); dbContext.SaveChanges(); List <Ingredient> myIngredient = dbContext.Ingredient.Where(I => I.Name == "The Time Traveler").ToList(); Assert.IsNotNull(dbContext.Ingredient.Find(I.IngredientId)); List <Yeast> myyeast = dbContext.Yeast.Where(Y => Y.ProductId == "EE101RED").ToList(); Assert.IsNotNull(dbContext.Yeast.Find(Y.IngredientId)); }
public async Task <int> UpdateAsync(Yeast yeast) { using (DbConnection connection = new NpgsqlConnection(_databaseSettings.DbConnection)) { connection.Open(); using (var transaction = connection.BeginTransaction()) { try { var result = await connection.ExecuteAsync( "UPDATE Yeasts set name = @Name,temperature_high = @TemperatureHigh,temperature_low = @TemperatureLow,flocculation = @Flocculation," + "alcohol_tolerance = @AlcoholTolerance,product_code = @ProductCode, notes = @Notes, type = @Type, brewery_source = @BrewerySource, species = @Species," + "attenution_range = @AttenuationRange, pitching_fermentation_notes = @PitchingFermentationNotes, supplier_id = @SupplierId, custom = @Custom, " + "flocculation_low = @FlocculationLow, flocculation_high = @FlocculationHigh, attenution_low = @AttenuationLow, attenution_high = @AttenuationHigh, alcohol_tolerance_low = @AlcoholToleranceLow, alcohol_tolerance_high = @AlcoholToleranceHigh " + "WHERE yeast_id = @YeastId;", yeast, transaction); await UpdateYeastSources(yeast, connection, transaction); await InsertYeastFlavours(yeast, connection, transaction); transaction.Commit(); return(result); } catch (Exception exception) { _logger.LogError(exception.ToString()); transaction.Rollback(); throw; } } } }
protected override void OnTarget(Mobile from, object targeted) { if (targeted is Yeast) { Yeast yeast = targeted as Yeast; if (yeast.IsChildOf(from.Backpack)) { if (!m_Context.YeastInUse(yeast)) { m_Context.SelectedYeast[m_Index] = yeast; from.SendLocalizedMessage(1150740); // You have chosen the yeast. } else { from.SendLocalizedMessage(1150742); // You have already chosen other yeast. } } else { from.SendLocalizedMessage(1054107); // This item must be in your backpack. } } else { from.SendLocalizedMessage(1150741); // That is not yeast. } from.SendGump(new DistillationGump(from)); }
public async Task AddAsync(Yeast yeast) { using (DbConnection connection = new NpgsqlConnection(_databaseSettings.DbConnection)) { connection.Open(); using (var transaction = connection.BeginTransaction()) { try { var result = await connection.ExecuteAsync("INSERT INTO yeasts(name,temperature_high,temperature_low,flocculation,alcohol_tolerance,product_code,notes,type,brewery_source,species,attenution_range,pitching_fermentation_notes,supplier_id,custom, flocculation_low,flocculation_high,attenution_low,attenution_high,alcohol_tolerance_low,alcohol_tolerance_high) VALUES (@Name,@TemperatureHigh,@TemperatureLow,@Flocculation,@AlcoholTolerance,@ProductCode,@Notes,@Type,@BrewerySource,@Species,@AttenuationRange,@PitchingFermentationNotes, @SupplierId, @Custom, @FlocculationLow,@FlocculationHigh,@AttenuationLow,@AttenuationHigh,@AlcoholToleranceLow,@AlcoholToleranceHigh);", yeast, transaction); var yeastId = await connection.QueryAsync <int>("SELECT last_value FROM yeasts_seq;"); yeast.YeastId = yeastId.SingleOrDefault(); await InsertYeastSources(yeast, connection, transaction); await InsertYeastFlavours(yeast, connection, transaction); transaction.Commit(); } catch (Exception e) { _logger.LogError(e.ToString()); transaction.Rollback(); } } } }
public void GetByPrimaryKeyTest() { Y = dbContext.Yeast.Find(272); Assert.IsNotNull(Y); Assert.AreEqual("White Labs", Y.Laboratory); Console.WriteLine(Y); }
private async Task InsertYeastSources(Yeast yeast, DbConnection connection, DbTransaction transaction) { foreach (var source in yeast?.Sources) { await connection.ExecuteAsync("INSERT INTO yeast_sources (yeast_id, social_id, site, url) VALUES(@YeastId,@SocialId,@Site,@Url);", new { yeast.YeastId, source.SocialId, source.Site, source.Url }, transaction); } }
public void Add(Yeast yeast) { using (var context = new MicrobrewitContext()) { if (yeast.Supplier != null) { yeast.Supplier = null; } context.Entry(yeast).State = EntityState.Added; try { context.SaveChanges(); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); Log.DebugFormat("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } } } }
public async Task <IActionResult> Edit(Guid id, [Bind("Id,Name,AmountIsWeight")] Yeast yeast) { if (id != yeast.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(yeast); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!YeastExists(yeast.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(yeast)); }
public Yeast SaveYeast(Yeast yeast, string userEmail) { var collection = GetYeastCollection(userEmail); var usersYeastList = GetYeastCollectionForUser(collection, userEmail); if (usersYeastList == null) { //this should not happen CreateNewYeastCollection(userEmail, collection); return(SaveYeast(yeast, userEmail)); } var yeastToUpdate = usersYeastList.Yeast.SingleOrDefault(y => y.Id == yeast.Id); if (yeastToUpdate == null) { yeast.Id = Guid.NewGuid(); } else { usersYeastList.Yeast.Remove(yeastToUpdate); } usersYeastList.Yeast.Add(yeast); var collectionId = usersYeastList.Id; var filter = Builders <YeastCollection> .Filter.Eq(f => f.Id, collectionId); collection.ReplaceOne(filter, usersYeastList); return(yeast); }
public async Task <IActionResult> PutYeast(int id, Yeast yeast) { if (id != yeast.IngredientId) { return(BadRequest()); } _context.Entry(yeast).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!YeastExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <Yeast> Update(Yeast yeast) { var entityEntry = _dataContext.Yeasts.Update(yeast); await _dataContext.SaveChangesAsync(); return(entityEntry.Entity); }
public IHttpActionResult PutYeast(int id, Yeast yeast) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != yeast.Id) { return(BadRequest()); } db.Entry(yeast).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!YeastExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
private bool HasTotal(Mobile from, double percentage) { for (int i = 0; i < m_Def.Ingredients.Length; i++) { Type type = m_Def.Ingredients[i]; int toConsume = m_Def.Amounts[i]; if (i == 0 && type == typeof(Yeast)) { for (int j = 0; j < toConsume; j++) { Yeast yeast = m_Context.SelectedYeast[j]; if (yeast == null || !yeast.IsChildOf(from.Backpack)) { return(false); } } } else { toConsume = (int)((double)toConsume * percentage); if (GetAmount(from, type, m_Def.Liquor) < toConsume) { return(false); } } } return(true); }
private async Task UpdateYeastSources(Yeast yeast, DbConnection connection, DbTransaction transaction) { foreach (var source in yeast?.Sources) { await connection.ExecuteAsync("UPDATE yeast_sources SET site = @Site, url = @Url WHERE yeast_id = @YeastId AND social_id = @SocialId;", new { yeast.YeastId, source.SocialId, source.Site, source.Url }, transaction); } }
public virtual async Task AddAsync(Yeast yeast) { using (var context = new MicrobrewitContext()) { if (yeast.Supplier != null) { yeast.Supplier = null; } context.Entry(yeast).State = EntityState.Added; try { await context.SaveChangesAsync(); } catch (DbEntityValidationException dbEx) { //foreach (var validationErrors in dbEx.EntityValidationErrors) //{ // foreach (var validationError in validationErrors.ValidationErrors) // { // Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); // Log.DebugFormat("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); // throw dbEx; // } //} throw; } catch (Exception ex) { throw; } } }
public async void CreateYeast_WithInvalidYeast_ReturnsBadRequest() { var yeast = new Yeast(); var accessToken = AuthHelper.GetAccessToken(); var response = await Client.PostJsonAsync(YeastBaseUrl, yeast, accessToken, isContentCreator : true); response.StatusCode.Should().Be(HttpStatusCode.BadRequest); }
public virtual void Remove(Yeast yeast) { using (var context = new MicrobrewitContext()) { context.Entry(yeast).State = EntityState.Deleted; context.SaveChanges(); } }
public virtual void Update(Yeast yeast) { using (var context = new MicrobrewitContext()) { context.Entry(yeast).State = EntityState.Modified; context.SaveChanges(); } }
public void OnTransferWortIn(Recipe recipeIn) { recipe = recipeIn; Yeast yeast = GameObject.Find("CompanyController").GetComponent <CompanyController>().inventory.availableYeasts[recipe.yeastIndex]; gravityDropPerTimeStep = (yeast.speed / (float)dayLength); currentGravity = recipe.startingGravity; fermenting = true; }
public Beer(List <Hops> hops, Malt malt, Barley barley, Water water, Yeast yeast, List <Extras> extras) { this.hops = hops; this.malt = malt; this.barley = barley; base.water = water; this.yeast = yeast; this.extras = extras; }
public Beer(List<Hops> hops, Malt malt, Barley barley, Water water, Yeast yeast, List<Extras> extras ) { this.hops = hops; this.malt = malt; this.barley = barley; base.water = water; this.yeast = yeast; this.extras = extras; }
public void Yeast_Valid() { Yeast yeast = new Yeast( YeastType.Ale, YeastForm.Culture, 3, "Test"); Assert.IsTrue(yeast.IsValid()); }
public async void CreateYeast_WithoutAuthHeader_ReturnsUnauthorized() { var yeast = new Yeast { Name = "SafAle American Ale", }; var response = await Client.PostJsonAsync(YeastBaseUrl, yeast); response.StatusCode.Should().Be(HttpStatusCode.Unauthorized); }
private void ChangeYeast(Yeast yeastInfo) { if (CurrentRecipe.YeastIngredient == null) { CurrentRecipe.YeastIngredient = YeastUtility.CreateYeastIngredient(); } CurrentRecipe.YeastIngredient.YeastInfo = yeastInfo; CurrentRecipe.UpdateRecipeOutcome(); }
public ActionResult CreateYeast(Yeast yeast) { if (!IsContentCreator()) { return(new ForbidResult()); } _logger.LogInformation("Creating yeast '{name}'", yeast.Name); _homebrewingDbService.CreateYeast(yeast); return(new OkResult()); }
public void Add_YeastId_Gets_Set() { var newYeast = new Yeast { Name = "newYeast" + DateTime.Now.Ticks, ProductCode = "AAA", Type = "Liquid", Custom = true }; _yeastRepository.Add(newYeast); var yeast = _yeastRepository.GetSingle(newYeast.YeastId); Assert.NotNull(yeast); }
public void Add_Gets_Added() { var newYeast = new Yeast { Name = "newYeast" + DateTime.Now.Ticks, ProductCode = "AAA", Type = "Liquid", Custom = true }; _yeastRepository.Add(newYeast); var yeasts = _yeastRepository.GetAll(); Assert.True(yeasts.Any(o => o.Name == newYeast.Name)); }
public IHttpActionResult GetYeast(int id) { Yeast yeast = db.Yeasts.Find(id); if (yeast == null) { return(NotFound()); } return(Ok(yeast)); }
public async void CreateYeast_SuccessfullyCreatesYeast() { var yeast = new Yeast { Name = "SafAle American Ale", }; var accessToken = AuthHelper.GetAccessToken(); var response = await Client.PostJsonAsync(YeastBaseUrl, yeast, accessToken, isContentCreator : true); response.StatusCode.Should().Be(HttpStatusCode.OK); }
public async void CreateYeast_WithEndUserCredential_ReturnsForbidden() { var yeast = new Yeast { Name = "SafAle American Ale", }; var accessToken = AuthHelper.GetAccessToken(); var response = await Client.PostJsonAsync(YeastBaseUrl, yeast, accessToken); response.StatusCode.Should().Be(HttpStatusCode.Forbidden); }
public async Task <IHttpActionResult> GetYeast(int id) { Yeast yeast = await db.Yeasts.FindAsync(id); if (yeast == null) { return(NotFound()); } return(Ok(yeast)); }
public void CheckQuest() { List<DamageStore> rights = BaseCreature.GetLootingRights( this.DamageEntries, this.HitsMax ); ArrayList mobile = new ArrayList(); for ( int i = rights.Count - 1; i >= 0; --i ) { DamageStore ds = rights[i]; if ( ds.m_HasRight ) { if ( ds.m_Mobile is PlayerMobile ) { PlayerMobile pm = (PlayerMobile)ds.m_Mobile; QuestSystem qs = pm.Quest; if ( qs is TheGraveDiggerQuest ) { mobile.Add( ds.m_Mobile ); } } } } for ( int i = 0; i < mobile.Count; ++i ) { PlayerMobile pm = (PlayerMobile)mobile[i % mobile.Count]; QuestSystem qs = pm.Quest; QuestObjective obj = qs.FindObjective( typeof( FindYeastObjective ) ); if ( obj != null && !obj.Completed ) { Item yeast = new Yeast(); if ( !pm.PlaceInBackpack( yeast ) ) { yeast.Delete(); pm.SendLocalizedMessage( 1046260 ); // You need to clear some space in your inventory to continue with the quest. Come back here when you have more space in your inventory. } else { obj.Complete(); pm.SendMessage( "You loot the yeast off the farmers corpse." ); } } } }
internal static YeastIngredientDataModel GetYeastIngredientForRecipe(int recipeId, SQLiteConnection connection) { using (SQLiteCommand selectIngredientsCommand = connection.CreateCommand()) { selectIngredientsCommand.CommandText = "SELECT YeastIngredients.id, YeastIngredients.weight, YeastIngredients.volume, Yeasts.id, Yeasts.name, Yeasts.type, Yeasts.form, Yeasts.laboratory, Yeasts.productId, Yeasts.minTemperature, Yeasts.maxTemperature, Yeasts.flocculation, Yeasts.attenuation, Yeasts.notes FROM YeastIngredients " + "JOIN Recipes ON Recipes.yeastIngredientInfo = YeastIngredients.id AND Recipes.id = @recipeId " + "JOIN Yeasts ON Yeasts.id = YeastIngredients.yeastInfo " + "LIMIT 1"; selectIngredientsCommand.Parameters.AddWithValue("recipeId", recipeId); using (SQLiteDataReader reader = selectIngredientsCommand.ExecuteReader()) { while (reader.Read()) { YeastCharacteristics characteristics = new YeastCharacteristics(reader.GetString(5), reader.GetString(11), reader.GetString(6)) { Attenuation = reader.GetFloat(12), MinTemperature = reader.GetFloat(9), MaxTemperature = reader.GetFloat(10) }; Yeast yeastInfo = new Yeast(reader.GetString(4), characteristics, reader.GetString(13), reader.GetString(7), reader.GetString(8)); return new YeastIngredientDataModel(yeastInfo, reader.GetInt32(0)) { Volume = reader.GetFloat(2), Weight = reader.GetFloat(1) }; } } } return null; }
public YeastIngredient(Yeast yeastInfo) { m_yeastInfo = yeastInfo; }