/// <summary>
/// Add a program package to the database via Entityframework
/// </summary>
/// <param name="val"></param>
/// <param name="db"></param>
private static void AddProgramPackageToDatabase(XMLClasses.feedEntry val, ProgramContext db)
{
var program = new EF_Program {
ProgramName = val.title.Value
};
if (program.ProgramVersions == null)
{
program.ProgramVersions = new List <EF_ProgramVersion>();
}
program.ProgramVersions.Add(new EF_ProgramVersion {
Program = program, Version = val.properties.Version
});
db.Programs.Add(program);
}
private static IOrderedQueryable <EF_Program> GetStoredProgramPackagesFromDatabase(ProgramContext db, XMLClasses.feedEntry val)
{
var queryProgram = from p in db.Programs
where p.ProgramName == val.title.Value
orderby p.ProgramName
select p;
return(queryProgram);
}
/// <summary>
/// Add Program Package Version To the Database via Entityframework.
/// The Program package version is allways linked to a Program package.
/// </summary>
/// <param name="queryProgram"></param>
/// <param name="db"></param>
/// <param name="val"></param>
private static void AddProgramPackageVersionToDatabase(IOrderedQueryable <EF_Program> queryProgram, ProgramContext db, XMLClasses.feedEntry val)
{
var program = queryProgram.First();
db.ProgramVersions.Add(new EF_ProgramVersion {
Program = program, Version = val.properties.Version
});
}
private static IQueryable <EF_ProgramVersion> GetStoredProgramPackageVersionsFromDatabase(ProgramContext db, XMLClasses.feedEntry val)
{
var queryProgramVersion = from p in db.ProgramVersions
where p.Version == val.properties.Version
select p;
return(queryProgramVersion);
}