private void ConfigureValidationRules()
{
Validator.AddRequiredRule(() => LRN, "LRN is required");
Validator.AddAsyncRule(nameof(LRN),
async() =>
{
var _context = new MorenoContext();
var result = await _context.Students.FirstOrDefaultAsync(e => e.LRN == LRN);
bool isAvailable = result == null;
return(RuleResult.Assert(isAvailable,
string.Format("LRN {0} is taken. Please choose a different one.", LRN)));
});
Validator.AddRequiredRule(() => FirstName, "First Name is required");
Validator.AddRequiredRule(() => LastName, "Last Name is required");
Validator.AddRequiredRule(() => MiddleName, "Middle Name is required");
Validator.AddRequiredRule(() => Gender, "Gender is required");
Validator.AddRequiredRule(() => Contact, "Contact is required");
Validator.AddRequiredRule(() => Birthdate, "Birthdate is required");
Validator.AddRequiredRule(() => Address, "Address is required");
Validator.AddRequiredRule(() => SchoolYear, "School Year is required");
Validator.AddRequiredRule(() => SelectedSection, "Section is required");
Validator.AddRequiredRule(() => SelectedYearLevel, "Year Level is required");
}
private void ConfigureValidationRules()
{
Validator.AddRequiredRule(() => Title, "Title is required");
Validator.AddRequiredRule(() => Author, "Author is required");
Validator.AddRequiredRule(() => Publisher, "Publisher is required");
Validator.AddRequiredRule(() => Category, "Category is required");
Validator.AddRequiredRule(() => PublisedYear, "PublisedYear is required : example (2017)");
//Validator.AddRequiredRule(() => AvailableQuantity, "Available Quantity is required");
Validator.AddRequiredRule(() => Quantity, "Quantity is required");
Validator.AddRule(nameof(Title),
() =>
{
//var _context = new MorenoContext();
//string name = $"{LastName}, {FirstName} {MiddleName}";
using (var context = new MorenoContext())
{
var result = context.Books.FirstOrDefault(e => e.Title == Title);
bool isAvailable = result == null;
return(RuleResult.Assert(isAvailable,
"Book Title already exisists"));
}
});
}
public TeacherListViewModel(ref MorenoContext context)
{
_context = context;
LoadData();
ConfigureValidationRules();
Validator.ResultChanged += OnValidationResultChanged;
GenderList = Enum.GetNames(typeof(EnumGender)).ToList();
}
public BookListViewModel(ref MorenoContext context)
{
_context = context;
LoadData();
ConfigureValidationRules();
Validator.ResultChanged += OnValidationResultChanged;
Messenger.Default.Register <NewBookUpdate>(this, OnUpdateRecieve);
}
public StudentViewModel(ref MorenoContext context)
{
_context = context;
LoadStudents();
ConfigureValidationRules();
Validator.ResultChanged += OnValidationResultChanged;
}
private void LoadData()
{
//Requirements = _context.Requirements.ToObservableCollection();
using (var context = new MorenoContext())
{
Requirements = context.Requirements.ToObservableCollection();
}
}
public ElectionVoteViewModel(MorenoContext context, Student student)
{
_context = context;
CurrentStudent = student;
CouncilPositions = _context.CouncilPositions.ToList();
CurrentPosition = CouncilPositions.FirstOrDefault();
StudentVotes = new ObservableCollection <StudentVote>();
IsNotFinish = true;
}
public StudentReportViewModel(ref MorenoContext context)
{
_context = context;
//var report = new StudentListReport();
////report.DataSource = _context.Students.ToList();
//ReportDocument = report;
//ReportTypes = Enum.GetNames(typeof(StudentReportType)).ToList();
LoadData();
}
public VoterProfileViewModel(ref MorenoContext context, Student student)
{
_context = context;
CurrentStudent = student;
_studentVotes = new List <StudentVote>();
CouncilPositions = _context.CouncilPositions.ToList();
StudentVotes = new ObservableCollection <StudentVote>();
AddRequirementsToStudent(student);
Requirements = student?.RequirementStudents.ToObservableCollection();
Messenger.Default.Register <SubmitVoteMessage>(this, OnSubmitVote);
}
public void AddRequirementsToStudent(Student student)
{
//var listOfId = _context.RequirementStudents
// .Where(c => c.StudentId == student.Id)
// .Select(c => c.RequirementId);
//var listRequirement = _context.Requirements
// .Where(c => !listOfId.Contains(c.Id));
//if (!listRequirement.Any())
//{
// return;
//}
//foreach (var req in listRequirement)
//{
// var newReq = new RequirementStudents
// {
// RequirementId = req.Id,
// StudentId = student.Id,
// Status = false,
// };
// _context.RequirementStudents.Add(newReq);
//}
//_context.SaveChangesAsync();
using (var context = new MorenoContext())
{
var listOfId = context.RequirementStudents
.Where(c => c.StudentId == student.Id)
.Select(c => c.RequirementId);
var listRequirement = context.Requirements
.Where(c => !listOfId.Contains(c.Id));
if (!listRequirement.Any())
{
return;
}
foreach (var req in listRequirement)
{
var newReq = new RequirementStudents
{
RequirementId = req.Id,
StudentId = student.Id,
Status = false,
};
context.RequirementStudents.Add(newReq);
}
context.SaveChangesAsync();
}
}
public VoteResultViewModel(ref MorenoContext context)
{
_context = context;
CouncilPositions = _context.CouncilPositions.ToList();
}
private async void DoAddRequirement()
{
await DialogHost.Show(new FieldMessageDialog()
{
DataContext = "Add New Requirement"
}, "RequirementDialog",
delegate(object sender, DialogClosingEventArgs args)
{
bool result = false;
if (Equals(args.Parameter, false))
{
return;
}
if (args.Parameter is TextBox)
{
args.Session.UpdateContent(new PleaseWaitView());
TextBox txtName = (TextBox)args.Parameter;
string name = txtName.Text.Trim();
var requirement = new Requirement()
{
Name = name
};
if (string.IsNullOrEmpty(name) || string.IsNullOrWhiteSpace(name))
{
args.Cancel();
args.Session.UpdateContent(new OkMessageDialog()
{
DataContext = "Null entry"
});
return;
}
using (var context = new MorenoContext())
{
var duplicate = context.Requirements.FirstOrDefault(c => c.Name == name);
if (duplicate != null)
{
args.Cancel();
args.Session.UpdateContent(new OkMessageDialog()
{
DataContext = "Duplicate Name"
});
return;
}
}
Task.Run(() =>
{
try
{
//_context.Entry(requirement).State = EntityState.Added;
using (var context = new MorenoContext())
{
context.Requirements.Add(requirement);
context.SaveChanges();
result = true;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
result = false;
}
}).ContinueWith((t, _) =>
{
if (!result)
{
args.Cancel();
args.Session.UpdateContent(new OkMessageDialog()
{
DataContext = "Failed to add"
});
}
else
{
Requirements.Add(requirement);
}
}, null, TaskScheduler.FromCurrentSynchronizationContext());
}
});
}
public RequirementsViewModel(ref MorenoContext context)
{
_context = context;
LoadData();
}
public ManagePositionViewModel(ref MorenoContext context)
{
_context = context;
LoadData();
}
public StudentAddViewModel(MorenoContext context)
{
_context = context;
}
public PartyListViewModel(ref MorenoContext context)
{
_context = context;
LoadData();
//PartyLists = new List<PartyList>();
}
private async void DoDeleteRequirement()
{
await DialogHost.Show(new OkCancelMessageDialog()
{
DataContext = $"Delete {SelectedRequirement.Name}?"
},
"RequirementDialog",
delegate(object sender, DialogClosingEventArgs args)
{
bool result = false;
if (Equals(args.Parameter, "Cancel"))
{
return;
}
if (_isOkMessageOpen)
{
_isOkMessageOpen = false;
return;
}
if (Equals(args.Parameter, "Ok"))
{
args.Session.UpdateContent(new PleaseWaitView());
Task.Run(() =>
{
try
{
//_context.Entry(SelectedRequirement).State = EntityState.Deleted;
//var students = _context.Students.ToList();
//foreach (var student in students)
//{
// student.RequirementStudents.FirstOrDefault(
// c => c.RequirementId == SelectedRequirement.Id);
//}
//var entity = _context.Requirements.FirstOrDefault(c => c.Id == SelectedRequirement.Id);
//if (entity != null) _context.Requirements.Remove(entity);
using (var context = new MorenoContext())
{
var entity =
context.Requirements.FirstOrDefault(c => c.Id == SelectedRequirement.Id);
if (entity != null)
{
context.Requirements.Remove(entity);
}
context.SaveChanges();
result = true;
}
//_context.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
result = false;
}
}).ContinueWith((t, _) =>
{
if (!result)
{
args.Cancel();
_isOkMessageOpen = true;
args.Session.UpdateContent(new OkMessageDialog()
{
DataContext = "Failed to Delete"
});
}
else
{
Requirements.Remove(SelectedRequirement);
}
}, null, TaskScheduler.FromCurrentSynchronizationContext());
}
});
}
public AdministratorViewModel(ref MorenoContext context)
{
_context = context;
LoadData();
}
public MainViewModel(MorenoContext context)
{
_context = context;
Messenger.Default.Register <StartLoginDialog>(this, OnRenderedMainView);
Messenger.Default.Register <SetNavigation>(this, SetCurrenNavigation);
}
public CategoryViewModel(ref MorenoContext context)
{
_context = context;
LoadData();
}
public AdviserViewModel(ref MorenoContext context)
{
_context = context;
LoadData();
Messenger.Default.Register <UpdateTeacherMessage>(this, OnUpdateRecieve);
}
public LibraryReportViewModel(ref MorenoContext context)
{
_context = context;
LoadData();
}
public ElectionHistoryViewModel(ref MorenoContext context)
{
_context = context;
LoadData();
Messenger.Default.Register <EndElectionMessage>(this, EndElection);
}
public YearSectionViewModel(ref MorenoContext context)
{
_context = context;
LoadData();
}
