private async Task GetProducts(User user, List <SQLTable> Tables) { List <Task> DataFetchTasks = new List <Task>(); List <Task> TaskCreators = new List <Task>(); TaskCreators.Add(Task.Run(() => { for (int i = 0; i < Tables.Count; i++) { var Table = Tables[i]; DataFetchTasks.Add(Task.Run(async() => { string statement = $"SELECT * FROM {Table.TABLE_NAME}"; List <Product> results = await data.SendQueryAsync <List <Product> >(statement, user); // Deze code was bedoelt als waarschuwing dat iets over de datum is for (int j = 0; j < results.Count; j++) { // Console.WriteLine(results.Count); results[j].naam = Table.TABLE_NAME.Replace('_', ' '); Products.Add(results[j]); // /*string CurrentDate = DateTime.Now.ToString("yyyy-MM-dd")*/ // string CurrentDate = "2021-3-08"; // //Console.WriteLine(CurrentDate == results[j].Uiterste_Datum); // if (CurrentDate == results[j].Uiterste_Datum) // { // OnDateIndexes.Add(Products.Count - 1); // //dataGridView1.Row(j).DefaultCellStyle.BackColor = Color.Yellow; // } } })); } })); TaskCreators.Add(Task.Run(() => { for (int i = 0; i < Tables.Count; i++) { var Table = Tables[i]; DataFetchTasks.Add(Task.Run(async() => { string statement = $"SELECT * FROM {Table.TABLE_NAME}"; List <ExtraInfo> results = await data.SendQueryAsync <List <ExtraInfo> >(statement, user); for (int j = 0; j < results.Count; j++) { ProductExtraInfo.Add(results[j]); } })); } })); await Task.WhenAll(TaskCreators); await Task.WhenAll(DataFetchTasks); OnProductsFetched(); }
public void Update(ProductVM pvm, int id) { Product product = new Product(); product.ProductID = pvm.ProductID; product.ProductName = pvm.ProductName; product.Description = pvm.Description; product.Feature = pvm.Feature; product.ReturnPolicy = pvm.ReturnPolicy; product.WarrentyPolicy = pvm.WarrentyPolicy; product.BarCode = pvm.BarCode; product.QRCode = pvm.QRCode; product.ManufactureDate = pvm.ManufactureDate; product.DisplayOrder = pvm.DisplayOrder; product.InsertdDate = DateTime.Now; product.UpdatedDate = DateTime.Now; product.UserId = pvm.UserId; product.IsActive = pvm.IsActive; product.IsVisiable = pvm.IsVisiable; db.Entry(product).State = EntityState.Modified; db.SaveChanges(); int lastProductId = product.ProductID; string lastUserId = product.UserId; //ProductExtraInfo Entity ProductExtraInfo pxi = new ProductExtraInfo(); pxi.PInfoID = pvm.PInfoID; pxi.RAM = pvm.RAM; pxi.ROM = pvm.ROM; pxi.StoreCapacity = pvm.StoreCapacity; pxi.NumberOFSIM = pvm.NumberOFSIM; pxi.ProcessorType = pvm.ProcessorType; pxi.OperatingSystem = pvm.OperatingSystem; pxi.FCamera = pvm.FCamera; pxi.BCamera = pvm.BCamera; pxi.Display = pvm.Display; pxi.CPUSpeed = pvm.CPUSpeed; pxi.GraphicCard = pvm.GraphicCard; pxi.TvResulation = pvm.TvResulation; pxi.Battery = pvm.Battery; pxi.PowerBankCapacity = pvm.PowerBankCapacity; pxi.HeadPhonFeature = pvm.HeadPhonFeature; pxi.PortableSpeakerFeature = pvm.PortableSpeakerFeature; pxi.AirCapacity = pvm.AirCapacity; pxi.PenConnectorType = pvm.PenConnectorType; pxi.PrintSpeed = pvm.PrintSpeed; pxi.Other = pvm.Other; //Insert ForeignKey Value pxi.ProductID = lastProductId; db.Entry(pxi).State = EntityState.Modified;; db.SaveChanges(); ///ProducColor Entity //pProductColor pc = new pProductColor(); //pc.ColorID = pvm.ColorID; //pc.ProductID = lastProductId; //db.pProductColor.Add(pc); //db.SaveChanges(); //Product stock Entity pStock ps = new pStock(); ps.StockID = pvm.StockID; ps.tQuantity = pvm.tQuantity; ps.mlQuantity = pvm.mlQuantity; ps.InsertdDate = DateTime.Now; ps.UpdatedDate = DateTime.Now; ps.ProductID = lastProductId; ps.UserId = lastUserId; db.Entry(ps).State = EntityState.Modified; db.SaveChanges(); ///Product Unit price Entity pUnitPrice pup = new pUnitPrice(); pup.ID = pvm.ID; pup.MarketPrice = pvm.MarketPrice; pup.SellingPrice = pvm.SellingPrice; pup.InsertdDate = pvm.InsertdDate; pup.UpdatedDate = pvm.UpdatedDate; pup.UserId = lastUserId; pup.ProductID = lastProductId; db.Entry(pup).State = EntityState.Modified; db.SaveChanges(); }