public ToyEntity GetOne(int id) { using (SqlConnection c = new SqlConnection(ConfigurationManager.ConnectionStrings["API"].ConnectionString)) { using (SqlCommand cmd = c.CreateCommand()) { cmd.CommandText = "SELECT * FROM Toys WHERE Id = @Id AND Active = 1"; cmd.Parameters.AddWithValue("Id", id); c.Open(); using (SqlDataReader Tab = cmd.ExecuteReader()) { if (Tab.Read()) { ToyEntity S = new ToyEntity() { Id = (int)Tab["Id"], NameEN = Tab["NameEN"].ToString(), NameFR = Tab["NameFR"].ToString(), ImagePath = Tab["ImagePath"].ToString(), Active = (int)Tab["Active"] }; return(S); } else { return(null); } } } } }
public ToyEntity CreateToy(ToyEntity newToy) { var newId = toys.OrderByDescending(r => r.Id).First().Id + 1; newToy.Id = newId; toys.Add(newToy); return(newToy); }
public bool UpdateToy(ToyEntity toy) { var res = GetToy(toy.Id); res.Name = toy.Name ?? res.Name; res.EnterpriseID = toy.EnterpriseID; res.Category = toy.Category ?? res.Category; res.Quantity = toy.Quantity; res.Price = toy.Price; res.CreatedDate = toy.CreatedDate ?? res.CreatedDate; return(true); }
public void Create(ToyEntity T) { using (SqlConnection c = new SqlConnection(ConfigurationManager.ConnectionStrings["API"].ConnectionString)) { using (SqlCommand cmd = c.CreateCommand()) { if (T != null && T.NameEN != null && T.NameFR != null && T.ImagePath != null) { cmd.CommandText = "SP_AddToy"; cmd.CommandType = CommandType.StoredProcedure; SqlParameter NameEN = new SqlParameter("NameEN", T.NameEN); SqlParameter NameFR = new SqlParameter("NameFR", T.NameFR); SqlParameter ImagePath = new SqlParameter("ImagePath", T.ImagePath); cmd.Parameters.Add(NameEN); cmd.Parameters.Add(NameFR); cmd.Parameters.Add(ImagePath); c.Open(); cmd.ExecuteNonQuery(); } } } }
public ToyEntityViewModel(ToyEntity entity) =>
public async Task Initialize(ToyStoreDbContext context) { var random = new Random(); var categories = new List <ToyCategoryEntity>(); var toys = new List <ToyEntity>(); var sales = new List <SaleEntity>(); for (var i = 0; i < 20; i++) { var toyCategory = new ToyCategoryEntity { Age = (uint)random.Next(1, 20), CareRules = Guid.NewGuid() .ToString() .Replace("-", "") .ToUpper(), WarrantyPeriod = (uint)random.Next(1, 128) }; categories.Add(toyCategory); } for (var i = 0; i < 100; i++) { var toy = new ToyEntity { Category = categories[random.Next(0, categories.Count)], Photo = $"photo{i + random.Next(0, 20000)}{Guid.NewGuid()}", Price = (decimal)(random.NextDouble() * random.Next(1, 5000)), Producer = Guid.NewGuid() .ToString() .Substring(0, 7) .Replace("-", ""), WarehouseCount = (uint)random.Next(0, 30) }; toys.Add(toy); } for (var i = 0; i < 1000; i++) { var selectedToy = toys[random.Next(0, toys.Count)]; var discount = random.Next(0, 80); var count = random.Next(1, 100); var price = selectedToy.Price * count * 100 / (discount == 0 ? 1 : discount); var sale = new SaleEntity { Discount = (uint)discount, SaleDate = DateTime.Now, SaleSum = price, Toy = selectedToy, SaleCount = (uint)count }; sales.Add(sale); } await context.ToyCategories.AddRangeAsync(categories); await context.Toys.AddRangeAsync(toys); await context.Sales.AddRangeAsync(sales); await context.SaveChangesAsync(); }
public void TestInitialize() { _instance = new DMC(); _testTV1 = new TVEntity() { Price = 1000.00M, Model = "VERY COOL 1 !", Resolution = "4K" }; _testTV2 = new TVEntity() { Price = 499.99M, Model = "Not so COOL 2 !", Resolution = "1920*1080" }; _testTV3 = new TVEntity() { Price = 199.99M, Model = "Cheap one 3", Resolution = "1024*720" }; _testLaptop1 = new LaptopEntity() { Price = 5000.00M, Model = "SUPER 1", RAM = 128, SSD = 2048, HDD = 4096 }; _testLaptop2 = new LaptopEntity() { Price = 1999.99M, Model = "Middle 2", RAM = 32, SSD = 512, HDD = 1096 }; _testLaptop3 = new LaptopEntity() { Price = 299.99M, Model = "Cheap 2", RAM = 8, SSD = 0, HDD = 512 }; _testToy1 = new ToyEntity() { Name = "Lego My Mind", MinAge = 12, Price = 500.00M }; _testToy2 = new ToyEntity() { Name = "Lego Star Wars", MinAge = 6, Price = 120.00M }; _testToy3 = new ToyEntity() { Name = "Ball", MinAge = 2, Price = 14.99M }; }