static void Main(string[] args) { AnimalsList zooAnimals = AnimalsList.Animals(); animalsList.ShowAnimals(); Animal animalsactivity = new ConcreteAnimal(); IAnimalsActivity horse = animalsactivity.GetAnimal("Horse"); Horse.Drive(10); IAnimalsActivity dog = animalsactivity.GetAnimal("Dog"); dog.Drive(5); Console.ReadKey(); AnimalsList.Instance.Show(); AnimalsList.Instance.Show(); Console.ReadKey(); SpecialOffer offer = new SpecialOffer(car); offer.DiscountPercentage = 25; offer.Offer = "25 % discount"; Console.WriteLine("{1} @ Zoo Special Offer and price are : {0} ", offer.Price, offer.Offer); Console.ReadKey(); }
public ActionResult Create() { SpecialOffer specialOffer = new SpecialOffer(); specialOffer.hotels = new List <HotelSpecialOffer>(); return(View(specialOffer)); }
/// <summary> /// Test Find using the Query class /// </summary> private void Step_30_TestFindByQuery_Generated() { using (TransactionManager tm = CreateTransaction()) { //Insert Mock Instance SpecialOffer mock = CreateMockInstance(tm); bool result = DataRepository.SpecialOfferProvider.Insert(tm, mock); Assert.IsTrue(result, "Could Not Test FindByQuery, Insert Failed"); SpecialOfferQuery query = new SpecialOfferQuery(); query.AppendEquals(SpecialOfferColumn.SpecialOfferId, mock.SpecialOfferId.ToString()); query.AppendEquals(SpecialOfferColumn.Description, mock.Description.ToString()); query.AppendEquals(SpecialOfferColumn.DiscountPct, mock.DiscountPct.ToString()); query.AppendEquals(SpecialOfferColumn.Type, mock.Type.ToString()); query.AppendEquals(SpecialOfferColumn.Category, mock.Category.ToString()); query.AppendEquals(SpecialOfferColumn.StartDate, mock.StartDate.ToString()); query.AppendEquals(SpecialOfferColumn.EndDate, mock.EndDate.ToString()); query.AppendEquals(SpecialOfferColumn.MinQty, mock.MinQty.ToString()); if (mock.MaxQty != null) { query.AppendEquals(SpecialOfferColumn.MaxQty, mock.MaxQty.ToString()); } query.AppendEquals(SpecialOfferColumn.Rowguid, mock.Rowguid.ToString()); query.AppendEquals(SpecialOfferColumn.ModifiedDate, mock.ModifiedDate.ToString()); TList <SpecialOffer> results = DataRepository.SpecialOfferProvider.Find(tm, query); Assert.IsTrue(results.Count == 1, "Find is not working correctly. Failed to find the mock instance"); } }
public async Task <IActionResult> PutSpecialOffer(int id, SpecialOffer specialOffer) { if (id != specialOffer.SpecOfferId) { return(BadRequest()); } _context.Entry(specialOffer).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!SpecialOfferExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
///<summary> /// Returns a Typed SpecialOfferProduct Entity with mock values. ///</summary> static public SpecialOfferProduct CreateMockInstance_Generated(TransactionManager tm) { SpecialOfferProduct mock = new SpecialOfferProduct(); mock.ModifiedDate = TestUtility.Instance.RandomDateTime(); //OneToOneRelationship Product mockProductByProductId = ProductTest.CreateMockInstance(tm); DataRepository.ProductProvider.Insert(tm, mockProductByProductId); mock.ProductId = mockProductByProductId.ProductId; //OneToOneRelationship SpecialOffer mockSpecialOfferBySpecialOfferId = SpecialOfferTest.CreateMockInstance(tm); DataRepository.SpecialOfferProvider.Insert(tm, mockSpecialOfferBySpecialOfferId); mock.SpecialOfferId = mockSpecialOfferBySpecialOfferId.SpecialOfferId; // create a temporary collection and add the item to it TList <SpecialOfferProduct> tempMockCollection = new TList <SpecialOfferProduct>(); tempMockCollection.Add(mock); tempMockCollection.Remove(mock); return((SpecialOfferProduct)mock); }
public bool UpdateSpecialOffer(SpecialOffer SO) { IDBManager dbm = new DBManager(); try { dbm.CreateParameters(10); dbm.AddParameters(0, "@SpecialOfferID", SO.SpecialOfferID); dbm.AddParameters(1, "@Description", SO.Description); dbm.AddParameters(2, "@DiscountPct", SO.DiscountPct); dbm.AddParameters(3, "@Type", SO.Type); dbm.AddParameters(4, "@Category", SO.Category); dbm.AddParameters(5, "@StartDate", SO.StartDate); dbm.AddParameters(6, "@EndDate", SO.EndDate); dbm.AddParameters(7, "@MaxQty", SO.MaxQty); dbm.AddParameters(8, "@MinQty", SO.MinQty); dbm.AddParameters(9, "@ModifiedDate", DateTime.Now); dbm.ExecuteNonQuery(CommandType.StoredProcedure, "UpdateSpecialOffer"); } catch (Exception ex) { log.Write(ex.Message, "UpdateSpecialOffer"); throw (ex); } finally { dbm.Dispose(); } return(true); }
public async Task CreateAllAsync_ShouldReturnCorrectResult() { var errorMessage = "SpecialOffersService CreateAllAsync() method does not work properly."; // Arrange MapperInitializer.InitializeMapper(); var context = HotelDbContextInMemoryFactory.InitializeContext(); var seeder = new SpecialOffersServiceTestsSeeder(); await seeder.SeedHotelAsync(context); var specialOfferRepository = new EfDeletableEntityRepository <SpecialOffer>(context); var specialOffersService = this.GetSpecialOffersService(specialOfferRepository, context); // Act var specialOffer = new SpecialOffer { Title = "Title1", Content = "Content1", ShortContent = "ShortContenr1", HotelDataId = context.Hotels.FirstOrDefault().Id, }; await specialOffersService.CreateAllAsync(new List <SpecialOffer> { specialOffer }); var actualResult = specialOfferRepository.All().First(); var expectedResult = specialOffer; // Assert Assert.True(expectedResult.Title == actualResult.Title, errorMessage + " " + "Title is not returned properly."); Assert.True(expectedResult.Content == actualResult.Content, errorMessage + " " + "Content is not returned properly."); Assert.True(expectedResult.ShortContent == actualResult.ShortContent, errorMessage + " " + "Short content is not returned properly."); Assert.True(expectedResult.HotelDataId == actualResult.HotelDataId, errorMessage + " " + "Hotel is not returned properly."); }
public async Task <IActionResult> PutSpecialOffer(int id, SpecialOffer specialOffer) { var claimsIdentity = this.User.Identity as ClaimsIdentity; // Calling User Data From Users Controller var Myusername = claimsIdentity.FindFirst(ClaimTypes.Surname)?.Value; // Finding Current User if (id != specialOffer.SpecialOfferId) { return(BadRequest()); } specialOffer.SpecialOfferId = id; specialOffer.ModifiedUserId = int.Parse(User.Identity.Name); // Auto Update specialOffer.ModifiedBy = Myusername; // Auto Update specialOffer.ModifiedDate = DateTime.Now; // Auto Update _context.Entry(specialOffer).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!SpecialOfferExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
/// <summary> /// Edit offer in system /// </summary> /// <param name="model">ProductViewModel</param> /// <param name="p">Product</param> public void Update(ProductViewModel model, Product p) { if (model.OfferPrice == 0) { Delete(p); } else { List <SpecialOffer> allOffers = offerRepo.RetrieveAllOffers(); if (allOffers.Where(x => x.RetrieveProductId() == p.RetrieveProductId()).FirstOrDefault() != null) { foreach (var singleOffer in allOffers) { if (singleOffer.RetrieveProductId() == p.RetrieveProductId()) { var specialOffer = new SpecialOffer(singleOffer.RetrieveOfferId(), model.OfferPrice, p.RetrieveProductId(), p.ProductName); specialOffer.StartTime = model.OfferStart; specialOffer.EndTime = model.OfferEnd; offerRepo.UpdateOfferById(specialOffer); } } } else { Add(model, p); } } }
public async Task CreateAllAsync_ShouldShouldSuccessfullyCreate() { var errorMessagePrefix = "SpecialOffersService CreateAllAsync() method does not work properly."; // Arrange MapperInitializer.InitializeMapper(); var context = HotelDbContextInMemoryFactory.InitializeContext(); var seeder = new SpecialOffersServiceTestsSeeder(); await seeder.SeedHotelAsync(context); var specialOfferRepository = new EfDeletableEntityRepository <SpecialOffer>(context); var specialOffersService = this.GetSpecialOffersService(specialOfferRepository, context); // Act var specialOffer = new SpecialOffer { Title = "Title1", Content = "Content1", ShortContent = "ShortContenr1", HotelDataId = context.Hotels.FirstOrDefault().Id, }; var result = await specialOffersService.CreateAllAsync(new List <SpecialOffer> { specialOffer }); // Assert Assert.True(result, errorMessagePrefix + " " + "Returns false."); }
public SpecialOffer GetSpecialOffer(int SpecialOfferID) { IDBManager dbm = new DBManager(); SpecialOffer SO = new SpecialOffer(); try { dbm.CreateParameters(1); dbm.AddParameters(0, "@SpecialOfferID", SpecialOfferID); IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectSpecialOffer"); while (reader.Read()) { SO.SpecialOfferID = Int32.Parse(reader["SpecialOfferID"].ToString()); SO.Description = reader["Description"].ToString(); SO.Category = reader["Category"].ToString(); SO.DiscountPct = decimal.Parse(reader["DiscountPct"].ToString()); SO.EndDate = DateTime.Parse(reader["EndDate"].ToString()); SO.MaxQty = Int32.Parse(reader["MaxQty"].ToString()); SO.MinQty = Int32.Parse(reader["MinQty"].ToString()); SO.StartDate = DateTime.Parse(reader["StartDate"].ToString()); SO.Type = reader["Type"].ToString(); SO.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); } } catch (Exception ex) { log.Write(ex.Message, "GetSpecialOffer"); throw (ex);; } finally { dbm.Dispose(); } return(SO); }
public int AddSpecialOffer(SpecialOffer SO) { IDBManager dbm = new DBManager(); try { dbm.CreateParameters(10); dbm.AddParameters(0, "@Description", SO.Description); dbm.AddParameters(1, "@DiscountPct", SO.DiscountPct); dbm.AddParameters(2, "@Type", SO.Type); dbm.AddParameters(3, "@Category", SO.Category); dbm.AddParameters(4, "@StartDate", SO.StartDate); dbm.AddParameters(5, "@EndDate", SO.EndDate); dbm.AddParameters(6, "@MinQty", SO.MinQty); dbm.AddParameters(7, "@MaxQty", SO.MaxQty); dbm.AddParameters(8, "@ModifiedDate", DateTime.Now); dbm.AddParameters(9, "@SpecialOfferID", SO.SpecialOfferID); dbm.Parameters[9].Direction = ParameterDirection.Output; dbm.ExecuteNonQuery(CommandType.StoredProcedure, "InsertSpecialOffer"); SO.SpecialOfferID = Int32.Parse(dbm.Parameters[9].Value.ToString()); } catch (Exception ex) { log.Write(ex.Message, "InsertSpecialOffer"); throw (ex); } finally { dbm.Dispose(); } return(SO.SpecialOfferID); }
public bool SpecialOfferUpdate(SpecialOffer specialoffer) { return(Execute <bool>(dal => { SpecialOffer specialofferUpdate = dal.SpecialOffer.Where(x => x.SpecialOfferID == specialoffer.SpecialOfferID).FirstOrDefault(); if (specialofferUpdate != null) { specialofferUpdate.SpecialOfferID = specialoffer.SpecialOfferID; specialofferUpdate.Description = specialoffer.Description; specialofferUpdate.DiscountPct = specialoffer.DiscountPct; specialofferUpdate.Type = specialoffer.Type; specialofferUpdate.Category = specialoffer.Category; specialofferUpdate.StartDate = specialoffer.StartDate; specialofferUpdate.EndDate = specialoffer.EndDate; specialofferUpdate.MinQty = specialoffer.MinQty; specialofferUpdate.MaxQty = specialoffer.MaxQty; specialofferUpdate.rowguid = specialoffer.rowguid; specialofferUpdate.ModifiedDate = specialoffer.ModifiedDate; dal.SubmitChanges(); return true; } return false; })); }
private static void CalculateTotalWithSpecialOffer(BasketItem basketItem, SpecialOffer itemSpecialOffer, ref int basketItemQty, ref decimal total) { while (true) { if (basketItemQty == itemSpecialOffer.Quantity) { total += itemSpecialOffer.Price; } else { if (basketItemQty > itemSpecialOffer.Quantity) { basketItemQty -= itemSpecialOffer.Quantity; total += itemSpecialOffer.Price; continue; } else { total += basketItem.Price * basketItemQty; } } break; } }
public async Task AddSpecialOfferAsync_WithIncorrectProperty_ShouldThrowArgumentNullException() { // Arrange MapperInitializer.InitializeMapper(); var context = HotelDbContextInMemoryFactory.InitializeContext(); var seeder = new SpecialOffersServiceTestsSeeder(); await seeder.SeedSpecialOfferAsync(context); var specialOfferRepository = new EfDeletableEntityRepository <SpecialOffer>(context); var specialOffersService = this.GetSpecialOffersService(specialOfferRepository, context); var specialOffer = new SpecialOffer { Title = null, Content = null, ShortContent = "ShortContenr1", HotelDataId = context.Hotels.FirstOrDefault().Id, }; // Act // Assert await Assert.ThrowsAsync <ArgumentNullException>(async() => { await specialOffersService.AddSpecialOfferAsync(specialOffer); }); }
private void PopulateGrids() { //special offer SpecialOffer so = new SpecialOffer(); try { DataSet ds = new DataSet(); ds = so.GetAllSpecialOffersDataSet(); dgSpecialOffers.DataSource = ds.Tables[0]; dgSpecialOffers.Columns["specialofferid"].HeaderText = "ID"; dgSpecialOffers.Columns["specialofferid"].Width = 60; dgSpecialOffers.Columns["description"].Width = 250; dgSpecialOffers.Columns["type"].Width = 40; dgSpecialOffers.Columns["startdate"].Width = 150; dgSpecialOffers.Columns["enddate"].Width = 150; dgSpecialOffers.Columns["startdate"].HeaderText = "Start Date/Time"; dgSpecialOffers.Columns["enddate"].HeaderText = "End Date/Time"; dgSpecialOffers.Columns["MinQty"].Width = 70; dgSpecialOffers.Columns["MaxQty"].Width = 70; dgSpecialOffers.Columns["modifieddate"].Visible = false; //dgSpecialOffers.Columns[ } catch (Exception ex) { MessageBox.Show(ex.Message, "MICS", MessageBoxButtons.OK, MessageBoxIcon.Information); } finally { so = null; } }
public void CanTotalMultipleSpecialOffersAndNonQualifyingItems() { var item1 = new ItemBuilder().WithSku("A99").WithPrice(0.50m).Build(); var item2 = new ItemBuilder().WithSku("B15").WithPrice(0.30m).Build(); var item3 = new ItemBuilder().WithSku("B15").WithPrice(0.30m).Build(); var item4 = new ItemBuilder().WithSku("B15").WithPrice(0.30m).Build(); var item5 = new ItemBuilder().WithSku("C40").WithPrice(0.60m).Build(); var item6 = new ItemBuilder().WithSku("A99").WithPrice(0.50m).Build(); var item7 = new ItemBuilder().WithSku("A99").WithPrice(0.50m).Build(); var offer = new SpecialOffer { Sku = "B15", Price = 0.45m, Quantity = 2 }; var offer2 = new SpecialOffer { Sku = "A99", Price = 1.30m, Quantity = 3 }; // this does require the offer to be added before scanning. // However gives flexibility that you can add offers rather than them being set in the Checkout itself. _itemUnderTest.AddSpecialOffer(offer); _itemUnderTest.AddSpecialOffer(offer2); _itemUnderTest.Scan(item1); _itemUnderTest.Scan(item2); _itemUnderTest.Scan(item3); _itemUnderTest.Scan(item4); _itemUnderTest.Scan(item5); _itemUnderTest.Scan(item6); _itemUnderTest.Scan(item7); _itemUnderTest.Total().ShouldEqual(2.65m); }
public override void DiscountSale(SpecialOffer specialOffer, Game game) { double discount; discount = game.Price - (specialOffer.DiscountPercent / 100 * game.Price); Console.WriteLine("{0} on {1} reduced the price to {2}TL with a {3}% discount rate.", specialOffer.NameOfOffer, game.NameOfGame, discount, specialOffer.DiscountPercent); }
public async Task <ActionResult <SpecialOffer> > PostSpecialOffer(SpecialOffer specialOffer) { _context.specialOffers.Add(specialOffer); await _context.SaveChangesAsync(); return(CreatedAtAction("GetSpecialOffer", new { id = specialOffer.SpecOfferId }, specialOffer)); }
public SpecialOffer RetrieveOfferByProductID(int productId) { var offer = new SpecialOffer(-1, 1, 1, null); try { SqlConnection cnn = ReturnSQLConnection(); string query = "SELECT * FROM dbo.[SpecialOffer] where ProductID = @ProductID"; SqlCommand cmd = CreateSQLCommandText(query, cnn); cmd.Parameters.AddWithValue("@ProductID", productId); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { var id = Convert.ToInt32(dr["Id"]); var start = Convert.ToDateTime(dr["Startdate"]); var end = Convert.ToDateTime(dr["Enddate"]); var offerPrice = Convert.ToDecimal(dr["OfferPrice"]); var productRep = new ProductRepository(new ProductMssqlContext()); var product = productRep.RetrieveProductById(productId); offer = new SpecialOffer(id, offerPrice, product.RetrieveProductId(), product.ProductName); offer.StartTime = start; offer.EndTime = end; } cnn.Close(); } catch (NullReferenceException e) { Console.WriteLine(e.Message); } return(offer); }
private void PopulateSpecialOfferGrid(int productID) { SpecialOfferProduct sop = new SpecialOfferProduct(); SpecialOffer so = new SpecialOffer(); try { SetupSpecialOfferGrid(); string where = string.Format("startDate <= getdate() and endDate >= getdate() and exists(select 1 from SpecialOfferProduct where specialofferid=SpecialOffer.specialofferid and productID={0})", productID); string orderBy = "enddate"; SpecialOfferCollection soc = so.GetSpecialOffersCollection(where, orderBy); DataTable dt = new DataTable(); foreach (SpecialOffer s in soc) { DataRow dr = dsSpeicalOffer.Tables[0].NewRow(); dr[0] = s.Description; dr[1] = s.DiscountPct; dsSpeicalOffer.Tables[0].Rows.Add(dr); } } catch (Exception ex) { MessageBox.Show("Error. Failed to load Speical Offers for this product"); MessageBox.Show(ex.ToString()); } }
static void Main(string[] args) { Customer customer = new Customer { CustomerID = 1, FirstName = "Tarık", LastName = "Göl", IdentityNumber = "12345", DateOfBirth = new DateTime(1997, 9, 8) }; SpecialOffer specialOffer = new SpecialOffer() { SpecialOfferID = 1, SpecialOfferType = "25% Discount", isSpecialOfferActive = true }; SpecialOfferManager specialOfferManager = new SpecialOfferManager(); specialOfferManager.AddSpecialOffer(specialOffer); CustomerManager customerManager = new CustomerManager(new CustomerValidationManager()); customerManager.SignUp(customer); GameStoreManager gameStoreManager = new GameStoreManager(); gameStoreManager.BuyGames(specialOffer); specialOfferManager.RemoveSpecialOffer(specialOffer); gameStoreManager.BuyGames(specialOffer); }
static void Main(string[] args) { Customer customer = new Customer { CustomerID = 1, FirstName = "Hasan", LastName = "Bozkurt", IdentityNumber = "2728562645", DateOfBirth = new DateTime(1996, 9, 5) }; SpecialOffer specialOffer = new SpecialOffer() { SpecialOfferID = 1, SpecialOfferType = "25% İndirimle", SpecialOfferActive = true }; SpecialOfferManager specialOfferManager = new SpecialOfferManager(); specialOfferManager.AddSpecialOffer(specialOffer); CustomerManager customerManager = new CustomerManager(new CustomerValidationManager()); customerManager.SignUp(customer); GameStoreManager gameStoreManager = new GameStoreManager(); gameStoreManager.BuyGames(specialOffer); specialOfferManager.RemoveSpecialOffer(specialOffer); gameStoreManager.BuyGames(specialOffer); }
/// <summary> /// Deep load all SpecialOffer children. /// </summary> private void Step_03_DeepLoad_Generated() { using (TransactionManager tm = CreateTransaction()) { int count = -1; mock = CreateMockInstance(tm); mockCollection = DataRepository.SpecialOfferProvider.GetPaged(tm, 0, 10, out count); DataRepository.SpecialOfferProvider.DeepLoading += new EntityProviderBaseCore <SpecialOffer, SpecialOfferKey> .DeepLoadingEventHandler( delegate(object sender, DeepSessionEventArgs e) { if (e.DeepSession.Count > 3) { e.Cancel = true; } } ); if (mockCollection.Count > 0) { DataRepository.SpecialOfferProvider.DeepLoad(tm, mockCollection[0]); System.Console.WriteLine("SpecialOffer instance correctly deep loaded at 1 level."); mockCollection.Add(mock); // DataRepository.SpecialOfferProvider.DeepSave(tm, mockCollection); } //normally one would commit here //tm.Commit(); //IDisposable will Rollback Transaction since it's left uncommitted } }
// GET: SpecialOffers/Delete/5 public ActionResult Delete(int?id) { SpecialOffer specialOffer = db.SpecialOffers.Find(id); specialOffer.IsDeleted = true; db.SaveChanges(); return(RedirectToAction("Index")); }
public void Add(SpecialOffer specialOffer) { var offerId = _database.Keys.Any() ? _database.Keys.Max() + 1 : 1; specialOffer.Id = offerId; _database.Add(offerId, specialOffer); _eventStore.Raise("NewSpecialOffer", specialOffer); }
public ActionResult DeleteConfirmed(int id) { SpecialOffer specialOffer = db.SpecialOffers.Find(id); db.SpecialOffers.Remove(specialOffer); db.SaveChanges(); return(RedirectToAction("Index")); }
///<summary> /// Update the Typed SpecialOffer Entity with modified mock values. ///</summary> static public void UpdateMockInstance(TransactionManager tm, SpecialOffer mock) { SpecialOfferTest.UpdateMockInstance_Generated(tm, mock); // make any alterations necessary // (i.e. for DB check constraints, special test cases, etc.) SetSpecialTestData(mock); }
public double CalculateDiscount(Game game, SpecialOffer offer) { double _gamePrice = game.GamePrice; double _discountRate = offer.DiscountRate; double _discount = (_gamePrice - ((_gamePrice * _discountRate) / 100)); return(_discount); }
public ActionResult AddHotelToDestination(AddHotelSpecialOffer model) { SpecialOffer specialOffer = db.SpecialOffers.Include(s => s.hotels).FirstOrDefault(s => s.Id == model.SpecialOfferId); HotelSpecialOffer hotel = db.HotelSpecialOffers.Include(s => s.arrangementPrices).Include(s => s.specialOffer).FirstOrDefault(h => h.Id == model.HotelId); specialOffer.hotels.Add(hotel); db.SaveChanges(); return(RedirectToAction("Details", new { id = model.SpecialOfferId })); }
// PUT api/awbuildversion/5 public void Put(SpecialOffer value) { var GetActionType = Request.Headers.Where(x => x.Key.Equals("ActionType")).FirstOrDefault(); if (GetActionType.Key != null) { if (GetActionType.Value.ToList()[0].Equals("DELETE")) adventureWorks_BC.SpecialOfferDelete(value); if (GetActionType.Value.ToList()[0].Equals("UPDATE")) adventureWorks_BC.SpecialOfferUpdate(value); } }
public void Navigation_fixup_is_non_destructive_to_existing_graphs() { using (var context = new FixupContext()) { var category11 = new Category { Id = 11 }; var category12 = new Category { Id = 12 }; var category13 = new Category { Id = 13 }; var product21 = new Product { Id = 21, CategoryId = 11, Category = category11 }; var product22 = new Product { Id = 22, CategoryId = 11, Category = category11 }; var product23 = new Product { Id = 23, CategoryId = 11, Category = category11 }; var product24 = new Product { Id = 24, CategoryId = 12, Category = category12 }; var product25 = new Product { Id = 25, CategoryId = 12, Category = category12 }; category11.Products.Add(product21); category11.Products.Add(product22); category11.Products.Add(product23); category12.Products.Add(product24); category12.Products.Add(product25); var specialOffer31 = new SpecialOffer { Id = 31, ProductId = 22, Product = product22 }; var specialOffer32 = new SpecialOffer { Id = 32, ProductId = 22, Product = product22 }; var specialOffer33 = new SpecialOffer { Id = 33, ProductId = 24, Product = product24 }; var specialOffer34 = new SpecialOffer { Id = 34, ProductId = 24, Product = product24 }; var specialOffer35 = new SpecialOffer { Id = 35, ProductId = 24, Product = product24 }; product22.SpecialOffers.Add(specialOffer31); product22.SpecialOffers.Add(specialOffer32); product24.SpecialOffers.Add(specialOffer33); product24.SpecialOffers.Add(specialOffer34); product24.SpecialOffers.Add(specialOffer35); context.Add(category11); AssertAllFixedUp(context); context.Add(category12); AssertAllFixedUp(context); context.Add(category13); AssertAllFixedUp(context); context.Add(product21); AssertAllFixedUp(context); context.Add(product22); AssertAllFixedUp(context); context.Add(product23); AssertAllFixedUp(context); context.Add(product24); AssertAllFixedUp(context); context.Add(product25); AssertAllFixedUp(context); context.Add(specialOffer31); AssertAllFixedUp(context); context.Add(specialOffer32); AssertAllFixedUp(context); context.Add(specialOffer33); AssertAllFixedUp(context); context.Add(specialOffer34); AssertAllFixedUp(context); context.Add(specialOffer35); AssertAllFixedUp(context); Assert.Equal(3, category11.Products.Count); Assert.Equal(2, category12.Products.Count); Assert.Equal(0, category13.Products.Count); Assert.Equal(0, product21.SpecialOffers.Count); Assert.Equal(2, product22.SpecialOffers.Count); Assert.Equal(0, product23.SpecialOffers.Count); Assert.Equal(3, product24.SpecialOffers.Count); Assert.Equal(0, product25.SpecialOffers.Count); Assert.Equal(3, context.ChangeTracker.Entries<Category>().Count()); Assert.Equal(5, context.ChangeTracker.Entries<Product>().Count()); Assert.Equal(5, context.ChangeTracker.Entries<SpecialOffer>().Count()); } }
// POST api/awbuildversion public void Post(SpecialOffer value) { adventureWorks_BC.SpecialOfferAdd(value); }
/// <summary> /// There are no comments for SpecialOffer in the schema. /// </summary> public void AddToSpecialOffer(SpecialOffer specialOffer) { base.AddObject("SpecialOffer", specialOffer); }
/// <summary> /// Create a new SpecialOffer object. /// </summary> /// <param name="specialOfferID">Initial value of SpecialOfferID.</param> /// <param name="description">Initial value of Description.</param> /// <param name="discountPct">Initial value of DiscountPct.</param> /// <param name="type">Initial value of Type.</param> /// <param name="category">Initial value of Category.</param> /// <param name="startDate">Initial value of StartDate.</param> /// <param name="endDate">Initial value of EndDate.</param> /// <param name="minQty">Initial value of MinQty.</param> /// <param name="rowguid">Initial value of rowguid.</param> /// <param name="modifiedDate">Initial value of ModifiedDate.</param> public static SpecialOffer CreateSpecialOffer(int specialOfferID, string description, decimal discountPct, string type, string category, global::System.DateTime startDate, global::System.DateTime endDate, int minQty, global::System.Guid rowguid, global::System.DateTime modifiedDate) { SpecialOffer specialOffer = new SpecialOffer(); specialOffer.SpecialOfferID = specialOfferID; specialOffer.Description = description; specialOffer.DiscountPct = discountPct; specialOffer.Type = type; specialOffer.Category = category; specialOffer.StartDate = startDate; specialOffer.EndDate = endDate; specialOffer.MinQty = minQty; specialOffer.rowguid = rowguid; specialOffer.ModifiedDate = modifiedDate; return specialOffer; }