public int AddPrices( establishment_brand model, int establishmentId, int beerId ) { model.brand_id = beerId; model.establishment_id = establishmentId; if (Database.establishment_brands.Where( x => x.size == model.size && x.price == model.price && x.establishment_id == establishmentId && x.brand_id == beerId && x.deleted == false).Count() == 0) { Database.establishment_brands.InsertOnSubmit( model ); Database.SubmitChanges(); } DeleteNullPriceRecord( beerId, establishmentId ); return model.id; }
public void Add_A_New_Price() { var estId = 807; var brandId = 3; var model = new establishment_brand(); model.brand_id = brandId; model.deleted = false; model.establishment_id = estId; model.price = "60"; model.size = "large"; var e = _service.AddPrices( model, estId, brandId ); //remember to change values that match something existing in the DB Assert.IsTrue( _service.GetPrices( estId, brandId ).EstablishmentBrands.Count == 3 ); }