private void loadimgbtn_Click(object sender, EventArgs e)
{
// Opens File and match extension -> If Extension do not match it shows msg
string json = HelpMe.OpenFileNow("Levels");
// Load Data from Json File Opened
List <Level> css = HelpMe.GetDataFromJson <Level>(json);
AspireDB db = new AspireDB();
db.Levels.SqlQuery(" DBCC CHECKIDENT('Course', RESEED, 0)");
int count = 0;
foreach (Level s in css)
{
// Check for Exsisting Subjects
if (db.Levels.Count(x => x.LevelName == s.LevelName) <= 0)
{
db.Levels.Add(s);
count++;
}
}
string msg;
try
{
db.SaveChanges();
msg = "File Loaded ( " + count + " Rows Added )";
}
catch (Exception ee)
{
count = 0;
msg = "File Not Loaded";
new MsgBox("Invalid File");
MessageBox.Show(ee.Message);
}
//Update list and Show Footer Message
LevelControl.Instance.CreateList();
LevelControl.Instance.FooterMessage(msg);
}
