public void SaveToDatabaseComputerDetailsData() { DataManager dataManager = new FullDataManager(); var computerSummary = dataManager.GetComputerSummary(); var context1 = new MetricsContext(); ComputerDetail computerDetail = new ComputerDetail() { Name = computerSummary.Name, User = computerSummary.User, Cpu = computerSummary.Cpu, Ram = computerSummary.Ram, VideoCard = computerSummary.VideoCard, Ip = computerSummary.Ip.ToString() }; if (context1.ComputerDetails.Count() != 0) { if (context1.ComputerDetails.Last().Name != computerDetail.Name) { context1.Add(computerDetail); context1.SaveChanges(); } } else { context1.Add(computerDetail); context1.SaveChanges(); } }
public async Task SaveProfileData(string Value) { _context.Add(new Profile { UserName = Value, Id = DateTime.UtcNow.Ticks, PartitionKey = "1" }); await _context.SaveChangesAsync(); }
//Updates static computer data to database public void UpadatStaticeComputerData() { context.Database.EnsureCreated(); bool t = false; // Is the computer already in the list var manager = new FullDataManager(); var summary = manager.GetComputerSummary(); context = new MetricsContext(); computerDetail = new ComputerDetail(); computerDetail.Cpu = summary.Cpu; computerDetail.Ip = summary.Ip.ToString(); computerDetail.Name = summary.Name; computerDetail.Ram = summary.Ram; computerDetail.VideoCard = summary.VideoCard; computerDetail.User = summary.User; //Checks if computer like this already exists in the databae, if it doesnt, it creates a new one foreach (var computerD in context.ComputerDetails) { if (computerD.Name == computerDetail.Name) { t = true; computerDetail = computerD; // } } if (!t) { context.Add(computerDetail); } }
public void AddComputerDetail() { var duplicate = _context.ComputerDetailsSet.FirstOrDefault(a => a.User == ComputerSummary.User); if (duplicate == null) { var computerDetails = new ComputerDetail { Name = ComputerSummary.Name, Cpu = ComputerSummary.Cpu, User = ComputerSummary.User, Ram = ComputerSummary.Ram, VideoCard = ComputerSummary.VideoCard, Ip = ComputerSummary.Ip.ToString() }; _context.Add(computerDetails); _context.SaveChanges(); } var currenComputer = _context.ComputerDetailsSet.FirstOrDefault(c => c.User == ComputerSummary.User); CurrentComputerId = currenComputer.ComputerDetailId; }
public void AddToContext() { var view = new Metric { Id = 1, Value = 5, Date = DateTime.Parse("2020-01-01"), Type = 1, PartitionKey = "0" }; context.Add(view); context.SaveChanges(); Assert.Single(context.Metrics); }