private void LoadStudents()
{
using (UniversityDataContext context = new UniversityDataContext(App.UniversityconnectionString))
{
IQueryable <Student> StudentList = from Students in context.Students select Students;
List <Student> StudentItems = StudentList.ToList();
StudentListBox.ItemsSource = StudentItems;
}
}
private void LoadStudents()
{
using (UniversityDataContext context = new UniversityDataContext(App.UniversityconnectionString))
{
IQueryable<Student> StudentList = from Students in context.Students select Students;
List<Student> StudentItems = StudentList.ToList();
StudentListBox.ItemsSource = StudentItems;
}
}
private void Submit(object sender, EventArgs e)
{
using (UniversityDataContext context = new UniversityDataContext(App.UniversityconnectionString))
{
Student st = new Student() { ID = Int32.Parse(ID_text.Text), Name = Name_text.Text, LastName = LastName_text.Text };
context.Students.InsertOnSubmit(st);
context.SubmitChanges();
MessageBox.Show("Student Added Successfully");
}
}
private void Submit(object sender, EventArgs e)
{
using (UniversityDataContext context = new UniversityDataContext(App.UniversityconnectionString))
{
Student st = new Student()
{
ID = Int32.Parse(ID_text.Text), Name = Name_text.Text, LastName = LastName_text.Text
};
context.Students.InsertOnSubmit(st);
context.SubmitChanges();
MessageBox.Show("Student Added Successfully");
}
}
protected override void OnNavigatedFrom(NavigationEventArgs e)
{
using (UniversityDataContext context = new UniversityDataContext(App.UniversityconnectionString))
{
var StudentLoaded = (from Stud in context.Students where Stud.ID == Int32.Parse(ID_txt.Text) select Stud).FirstOrDefault();
if (StudentLoaded != null)
{
StudentLoaded.Name = Name_txt.Text;
StudentLoaded.LastName = LastName_txt.Text;
context.SubmitChanges();
}
}
}
protected override void OnNavigatedFrom(NavigationEventArgs e)
{
using (UniversityDataContext context = new UniversityDataContext(App.UniversityconnectionString))
{
var StudentLoaded = (from Stud in context.Students where Stud.ID == Int32.Parse(ID_txt.Text) select Stud).FirstOrDefault();
if (StudentLoaded != null)
{
StudentLoaded.Name = Name_txt.Text;
StudentLoaded.LastName = LastName_txt.Text;
context.SubmitChanges();
}
}
}
protected override void OnNavigatedTo(NavigationEventArgs e)
{
String id = NavigationContext.QueryString["id"];
using (UniversityDataContext context = new UniversityDataContext(App.UniversityconnectionString))
{
var StudentLoaded = (from Stud in context.Students where Stud.ID == Int32.Parse(id) select Stud).FirstOrDefault();
if (StudentLoaded!=null)
{
ID_txt.Text = StudentLoaded.ID.ToString();
Name_txt.Text = StudentLoaded.Name;
LastName_txt.Text = StudentLoaded.LastName;
}
}
}
protected override void OnNavigatedTo(NavigationEventArgs e)
{
String id = NavigationContext.QueryString["id"];
using (UniversityDataContext context = new UniversityDataContext(App.UniversityconnectionString))
{
var StudentLoaded = (from Stud in context.Students where Stud.ID == Int32.Parse(id) select Stud).FirstOrDefault();
if (StudentLoaded != null)
{
ID_txt.Text = StudentLoaded.ID.ToString();
Name_txt.Text = StudentLoaded.Name;
LastName_txt.Text = StudentLoaded.LastName;
}
}
}
// Constructor
public MainPage()
{
InitializeComponent();
using (UniversityDataContext context = new UniversityDataContext(App.UniversityconnectionString))
{
if (!context.DatabaseExists())
{
context.CreateDatabase();
MessageBox.Show("University Database created successfully");
}
else
{
MessageBox.Show("University already Exists");
}
}
}
// Constructor
public MainPage()
{
InitializeComponent();
using (UniversityDataContext context = new UniversityDataContext(App.UniversityconnectionString))
{
if (!context.DatabaseExists())
{
context.CreateDatabase();
MessageBox.Show("University Database created successfully");
}
else
{
MessageBox.Show("University already Exists");
}
}
}
private void DeleteRegister(object sender, EventArgs e)
{
if (StudentListBox.SelectedIndex!=-1)
{
Student st = (Student)StudentListBox.SelectedItem;
using (UniversityDataContext context = new UniversityDataContext(App.UniversityconnectionString))
{
context.Students.Attach(st);
context.Students.DeleteOnSubmit(st);
context.SubmitChanges();
MessageBox.Show("Student Deleted Successfully");
StudentListBox.ItemsSource = null;
LoadStudents();
}
}
else
{
MessageBox.Show("A Student must be selected in order to delete it!");
}
}
private void DeleteRegister(object sender, EventArgs e)
{
if (StudentListBox.SelectedIndex != -1)
{
Student st = (Student)StudentListBox.SelectedItem;
using (UniversityDataContext context = new UniversityDataContext(App.UniversityconnectionString))
{
context.Students.Attach(st);
context.Students.DeleteOnSubmit(st);
context.SubmitChanges();
MessageBox.Show("Student Deleted Successfully");
StudentListBox.ItemsSource = null;
LoadStudents();
}
}
else
{
MessageBox.Show("A Student must be selected in order to delete it!");
}
}