public static void ClearDatabase(LINQDatabase db)
{
// Pending Mail Table
var mrows = from row in db.PendingMail
select row;
foreach (var row in mrows)
db.PendingMail.DeleteOnSubmit(row);
db.SubmitChanges();
// Users Table
var urows = from row in db.Users
select row;
foreach (var row in urows)
db.Users.DeleteOnSubmit(row);
db.SubmitChanges();
// Tags Table
var trows = from row in db.Tags
select row;
foreach (var row in trows)
db.Tags.DeleteOnSubmit(row);
db.SubmitChanges();
// Files Table
var frows = from row in db.Files
select row;
foreach (var row in frows)
db.Files.DeleteOnSubmit(row);
db.SubmitChanges();
// TagName Table
var tnrows = from row in db.Files
select row;
foreach (var row in tnrows)
db.Files.DeleteOnSubmit(row);
db.SubmitChanges();
}
public static LINQDatabase PopulatedDatabase()
{
LINQDatabase db = new LINQDatabase();
ClearDatabase(db);
CaesFile music = new CaesFile();
music.Path = musicFile;
db.Files.InsertOnSubmit(music);
CaesFile sound = new CaesFile();
sound.Path = soundFile;
db.Files.InsertOnSubmit(sound);
CaesFile anime = new CaesFile();
anime.Path = animeFile;
db.Files.InsertOnSubmit(anime);
CaesFile video = new CaesFile();
video.Path = videoFile;
db.Files.InsertOnSubmit(video);
db.SubmitChanges();
// Music File
Tag m1 = new Tag();
m1.FilePath = musicFile;
m1.TagName = "audio";
db.Tags.InsertOnSubmit(m1);
Tag m2 = new Tag();
m2.FilePath = musicFile;
m2.TagName = "mp3";
db.Tags.InsertOnSubmit(m2);
// Sound File
Tag s1 = new Tag();
s1.FilePath = soundFile;
s1.TagName = "audio";
db.Tags.InsertOnSubmit(s1);
Tag s2 = new Tag();
s2.FilePath = soundFile;
s2.TagName = "wav";
db.Tags.InsertOnSubmit(s2);
// Anime File
Tag a1 = new Tag();
a1.FilePath = animeFile;
a1.TagName = "anime";
db.Tags.InsertOnSubmit(a1);
Tag a2 = new Tag();
a2.FilePath = animeFile;
a2.TagName = "video";
db.Tags.InsertOnSubmit(a2);
Tag a3 = new Tag();
a3.FilePath = animeFile;
a3.TagName = "mkv";
db.Tags.InsertOnSubmit(a3);
// Video File
Tag v1 = new Tag();
v1.FilePath = videoFile;
v1.TagName = "video";
db.Tags.InsertOnSubmit(v1);
Tag v2 = new Tag();
v2.FilePath = videoFile;
v2.TagName = "avi";
db.Tags.InsertOnSubmit(v2);
db.SubmitChanges();
return db;
}