private void RemoveRecord()
{
if (MessageBox.Show("Are sure to delete this student ? ", "Confirm", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.No)
{
return;
}
SchoolObjContext context = new SchoolObjContext();
dynamic item = CurrentItem;
EntityDatabase.DomainClasses.Student SelectedStudent = CurrentItem.Student;
EntityDatabase.DomainClasses.Student obj = context.Students.Where(s => s.StudentId == SelectedStudent.StudentId).FirstOrDefault();
if (obj == null)
{
return;
}
context.Students.Remove(obj);
context.SaveChanges();
AllStudents.Remove(CurrentItem);
}
//Call when Editing
public StudentViewModel(int Id)
{
TabTitle = "Edit Students";
ButtonName = "Save Changes";
SchoolObjContext context = new SchoolObjContext();
if (Id > 0)
{
using (var Context = new SchoolObjContext())
{
Student obj = Context.Students.Where(s => s.StudentId == Id).FirstOrDefault();
AllStandards = context.Standards.Where(s => s.StandardId == obj.StandardId).ToList();
if (obj != null)
{
this.FirstName = obj.FirstName;
this.MiddleName = obj.MiddleName;
this.LastName = obj.LastName;
this.Age = obj.Age;
this.City = obj.City;
this.DocFileType = obj.DocType;
this.DocFile = obj.Doc;
SelectedStandard = Context.Standards.Where(s => s.StandardId == obj.StandardId).FirstOrDefault();
for (int i = 0; i < AllStandards.Count; i++)
{
if (AllStandards[i].StandardId == SelectedStandard.StandardId)
{
StdIndex = i;
break;
}
}
}
}
}
//Update edited student
SubmitStudentCommand = new RelayCommand(x =>
{
if (!CheckCanSubmit())
{
MessageBox.Show("Fill all the field properly", "Validation Error", MessageBoxButton.OK, MessageBoxImage.Error);
//CanShowResult = false;
return;
}
//else
// CanShowResult = true;
EntityDatabase.DomainClasses.Student stud = context.Students.Where(s => s.StudentId == Id).FirstOrDefault();
if (stud != null)
{
stud.FirstName = this.FirstName;
stud.MiddleName = this.MiddleName;
stud.LastName = this.LastName;
stud.Age = this.Age;
stud.City = this.City;
stud.StandardId = this.SelectedStandard.StandardId;
stud.Doc = this.DocFile;
stud.DocType = this.DocFileType;
if (context.SaveChanges() > 0)
{
MainViewModel.RefreshView("Show Students");
MainViewModel.RefreshView("Result Report");
MessageBox.Show("Student Edited Successfully", "Edited !", MessageBoxButton.OK, MessageBoxImage.Information);
//CanShowResult = true;
}
//else
//{
// MessageBox.Show("Student not Edited", "Failed !", MessageBoxButton.OK, MessageBoxImage.Error);
// CanShowResult = false;
//}
OnPropertyChanged("SelectedStandard");
this.CloseTabCommand.Execute(null);
MainViewModel.Tabs.Add(new ShowAllStudentViewModel());
}
});
//ShowResultCommand = new RelayCommand(x =>
//{
// this.SubmitStudentCommand.Execute(null);
// if (CanShowResult)
// MainViewModel.Tabs.Add(new ViewModels.ResultViewModel(Id));
//});
UserControl = new UserControls.Student {
DataContext = this
};
}
