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);
}