public void InsertData(List <ProductData> products, TransmissionsummaryData transmissionsummary)
{
using (var db = new ProcessFileDataContext())
{
var strategy = db.Database.CreateExecutionStrategy();
strategy.Execute(() =>
{
using (var context = new ProcessFileDataContext())
{
using (var transaction = context.Database.BeginTransaction())
{
// Creates the database if not exists
context.Database.EnsureCreated();
foreach (ProductData p in products)
{
context.ProductData.Add(p);
}
context.TransmissionsummaryData.Add(transmissionsummary);
// Saves changes
context.SaveChanges();
transaction.Commit();
}
}
});
}
}
public List <StatisticData> DisplayStatistics()
{
// Gets and prints all books in database
using (var context = new ProcessFileDataContext())
{
var commandText = @"Select IF(l3 like ""%Tools%"",""Power Tools"",l3) as l3, location, Sum(qty) as total from ProductData group by location, l3;";
var result = context.StatisticData.FromSqlRaw(commandText).ToList();
return(result);
}
}
public bool CheckTransmissionsummaryDataExist(string Id)
{
// Gets and prints all books in database
using (var context = new ProcessFileDataContext())
{
TransmissionsummaryData ts = context.TransmissionsummaryData.Find(Id);
if (ts == null)
{
return(false);
}
}
return(true);
}
