private bool confirm(MdlStudent student)
{
student.Confirmed = true;
DbStudent dbStudentObj = new DbStudent();
return(dbStudentObj.UpdateProfile(student));
}
public async Task <ActionResult <DbStudent> > PostDbStudent(DbStudent dbStudent)
{
_context.DbStudents.Add(dbStudent);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetDbStudent", new { id = dbStudent.Id }, dbStudent));
}
protected override void OnStart()
{
DbStudent dbStudent = new DbStudent();
Student student = dbStudent.GetStudent();
// Comment out the 4 lines under to deactive the GoToLogin at
if (student == null || student.accessToken == null)
{
Authenticater.Authorized = false;
}
NavPage = new NavigationPage(new MainPage());
//NavPage = new NavigationPage(new LoginPage());
MainPage = NavPage;
//NavPage.BarBackgroundColor = Color.FromHex("ec7a08");
//NavPage.BarTextColor = Color.White;
if (student != null)
{
DeleteOutdatedData();
UpdateAllFilters();
DbDevice dbDevice = new DbDevice();
if (dbDevice.GetDevice() != null && !dbDevice.GetDevice().tokenSent)
{
DevicesController dc = new DevicesController();
dc.UpdateServersDb();
}
}
}
public async Task ShouldUpdateStudent()
{
//Given
var updateStudentRequest = _fixture.Build <UpdateStudentRequest>()
.With(p => p.Gender, Gender.Male)
.Create();
var dbStudent = new DbStudent();
_unitOfWorkMock
.Setup(r => r.StudentRepository.UpdateAsync(It.IsAny <DbStudent>()))
.Callback((DbStudent s) =>
{
dbStudent = s;
})
.Returns(Task.CompletedTask).Verifiable();
var sut = CreateSut();
//When
await sut.UpdateStudentAsync(updateStudentRequest);
//Then
_unitOfWorkMock.VerifyAll();
dbStudent.Gender.Should().Be((int)updateStudentRequest.Gender);
dbStudent.FirstName.Should().Be((updateStudentRequest.FirstName));
dbStudent.LastName.Should().Be(updateStudentRequest.LastName);
dbStudent.Patronymic.Should().Be(updateStudentRequest.Patronymic);
dbStudent.UId.Should().Be(updateStudentRequest.UId);
}
public bool checkCodeExist(string code)
{
//DB find, student update confirmed
MdlStudent studentObj = new MdlStudent();
studentObj.ConfirmationCode = code;
DbStudent dbStudent = new DbStudent();
using (TransactionScope scope = new TransactionScope())
{
//get student by confirmation code
studentObj = dbStudent.GetStudentData(studentObj.ConfirmationCode, "code");
scope.Complete();
}
if (studentObj != null)
{
return(confirm(studentObj));
}
else
{
return(false);
}
}
private static void VoegStudentToeMetVakken(DbSchool dbSchool, DbStudent dbStudent, params DbVak[] vakken)
{
using (SchoolDbContext db = new SchoolDbContext())
{
using (IDbContextTransaction transaction = db.Database.BeginTransaction())
{
try {
dbStudent.Vakken = new List <DbVak>();
foreach (DbVak dbVak in vakken)
{
dbStudent.Vakken.Add(dbVak);
}
db.DbStudenten.Add(dbStudent);
dbSchool.Studenten = new List <DbStudent>();
dbSchool.Studenten.Add(dbStudent);
db.DbScholen.Update(dbSchool);
db.SaveChanges();
transaction.Commit();
}catch (Exception e) {
Console.WriteLine("Kon student niet toevoegen:" + e.Message);
transaction.Rollback();
}
}
}
}
public ViewResult Edit(string StudentName)
{
context = new DbStudent();
IEnumerable <Student> s = context.Student;
Student currentstudent = s.FirstOrDefault(p => p.StudentName == StudentName);
return(View("Index", currentstudent));
}
public ViewResult Display()
{
// Display
context = new DbStudent();
IEnumerable <Student> s = context.Student;
return(View(s));
}
/// <summary>
/// Gets the Students StudyGroups used for push notifications from the server.
/// </summary>
/// <returns></returns>
public async Task <List <StudyGroup> > GetStudentsStudyGroupFromServer()
{
DbStudent db = new DbStudent();
Student student = db.GetStudent();
if (student == null)
{
Authenticater.Authorized = false;
return(null);
}
string encodedUsername = Hasher.Base64Encode(student.username);
Uri url = new Uri(Adress + "/" + encodedUsername);
System.Diagnostics.Debug.WriteLine("StudentsController - UpdateStudyGroupStudent uri: " + url.ToString());
string accessToken = db.GetStudentAccessToken();
if (accessToken == null)
{
Authenticater.Authorized = false;
return(null);
}
var client = new HttpClient();
client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("bearer", accessToken);
string jsonString = null;
try
{
var response = await client.GetAsync(url).ConfigureAwait(false);
if (response.StatusCode == HttpStatusCode.Unauthorized)
{
System.Diagnostics.Debug.WriteLine("StudentsController - UpdateStudyGroupStudent failed due to lack of Authorization");
Authenticater.Authorized = false;
return(null);
}
System.Diagnostics.Debug.WriteLine("UpdateStudyGroupStudent response " + response.StatusCode.ToString());
jsonString = await response.Content.ReadAsStringAsync();
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine("StudentsController - UpdateStudyGroupStudent: await client.GetAsync(\"url\") Failed");
System.Diagnostics.Debug.WriteLine("StudentsController - UpdateStudyGroupStudent: Exception msg: " + e.Message);
System.Diagnostics.Debug.WriteLine("StudentsController - UpdateStudyGroupStudent: Stack Trace: \n" + e.StackTrace);
System.Diagnostics.Debug.WriteLine("StudentsController - UpdateStudyGroupStudent: End Of Stack Trace");
return(null);
}
if (jsonString != null)
{
return(ExtractStudyGroupsFromJson(jsonString));
//DeleteAllStudyGroupStudent();
//CreateStudyGroupStudents(student.username, studyGroupIds);
}
return(null);
}
public bool UpdateProfile(string email, int numberOfChildren, bool pet, int numberOfCohabitors, bool disabled,
string name, string surname, string address, string postCode, string city, string country, string phone)
{
DbStudent dbStudentObj = new DbStudent();
MdlStudent mdlStudentObj = GetStudent(email, numberOfChildren, pet, numberOfCohabitors,
disabled, name, surname, address, postCode, city, country, phone);
mdlStudentObj = CalculateProfileScore(mdlStudentObj);
return(dbStudentObj.UpdateProfile(mdlStudentObj));
}
private static DbStudent ZoekStudent(string voornaam, string familienaam, DateTime geboorteDatum)
{
using (SchoolDbContext db = new SchoolDbContext())
{
DbStudent dbStudent = db.DbStudenten.Include(s => s.Vakken).Where(s => s.Voornaam.ToLower() == voornaam.ToLower() &&
s.Familienaam.ToLower() == familienaam.ToLower() &&
s.GeboorteDatum == geboorteDatum).FirstOrDefault();
return(dbStudent);
}
}
static void Main(string[] args)
{
//VoegSchoolToe("Syntra-West");
DbSchool dbSchool = ZoekSchoolOpNaam("Syntra-West");
if (dbSchool == null)
{
Console.WriteLine("School 'Syntra-West' niet gevonden");
return;
}
DbVak vak1 = ZoekVakOpNaam("C#");
if (vak1 == null)
{
vak1 = new DbVak()
{
Naam = "C#", AantalLesuren = 100
};
}
else
{
Console.WriteLine($"Vak {vak1.Naam} gevonden met Id= {vak1.VakId} Aantal ingeschreven studenten: {vak1.Studenten.Count}");
}
DbVak vak2 = ZoekVakOpNaam("DataBase");
if (vak2 == null)
{
vak2 = new DbVak()
{
Naam = "DataBase", AantalLesuren = 80
}
}
;
else
{
Console.WriteLine($"Vak {vak2.Naam} gevonden met Id= {vak2.VakId} Aantal ingeschreven studenten: {vak2.Studenten.Count}");
}
DbStudent dbStudent = ZoekStudent("Jan", "Jansens", new DateTime(1990, 1, 1));
if (dbStudent == null)
{
dbStudent = new DbStudent()
{
Voornaam = "Jan",
Familienaam = "Jansens",
GeboorteDatum = new DateTime(1990, 1, 1)
};
}
else
{
Console.WriteLine($"Student {dbStudent.Voornaam} {dbStudent.Familienaam} gevonden, aantal vakken: {dbStudent.Vakken.Count}");
}
//VoegStudentToeMetVakken(dbSchool, dbStudent,vak1,vak2);
Console.ReadKey();
}
/// <summary>
/// Updates the students notification preferances.
/// </summary>
/// <param name="receiveNotifications"></param>
/// <param name="receiveProjectNotifications"></param>
/// <param name="receiveJobNotifications"></param>
public void UpdateStudentsNotificationsPref(bool receiveNotifications,
bool receiveProjectNotifications, bool receiveJobNotifications)
{
DbStudent db = new DbStudent();
Student student = db.GetStudent();
student.receiveNotifications = receiveNotifications;
student.receiveProjectNotifications = receiveProjectNotifications;
student.receiveJobNotifications = receiveJobNotifications;
db.UpdateStudent(student);
}
/// <summary>
/// Active to logout.
/// </summary>
async void Logout(object sender, EventArgs e)
{
var logout = await DisplayAlert("Logg ut", "Ønsker du å logge ut?", "Ja", "Nei");
if (logout == true)
{
DbStudent dbStudent = new DbStudent();
dbStudent.DeleteAllStudents();
GoToLogin();
}
}
public ViewResult Index(Student student)
{
context = new DbStudent();
context.Student.Add(student);
context.SaveChanges();
// Display
context = new DbStudent();
IEnumerable <Student> s = context.Student;
return(View("Display", s));
}
/// <summary>
/// Inserts or update the device with the given fields.
/// </summary>
/// <param name="gcmToken"></param>
/// <param name="deviceId"></param>
/// <param name="deviceType"></param>
/// <returns></returns>
public async Task InsertOrUpdateDevice(string gcmToken, string deviceId, string deviceType)
{
DbDevice db = new DbDevice();
DbStudent dbStudent = new DbStudent();
Student student = dbStudent.GetStudent();
Device device = db.GetDevice();
if (device == null)
{
device = new Device();
device.id = deviceId;
device.token = gcmToken;
device.tokenSent = false;
device.deviceType = deviceType;
if (student != null)
{
device.username = student.username;
}
db.InsertDevice(device);
if (student != null)
{
UpdateServersDb();
}
return;
}
if (device.token != gcmToken)
{
device.token = gcmToken;
device.tokenSent = false;
if (student != null)
{
device.username = student.username;
}
db.UpdateDevice(device);
if (student != null)
{
UpdateServersDb();
}
return;
}
if (!device.tokenSent && student != null)
{
if (device.username != student.username)
{
device.username = student.username;
db.UpdateDevice(device);
}
UpdateServersDb();
}
}
public ActionResult Delete(string StudentName)
{
context = new DbStudent();
IEnumerable <Student> s = context.Student;
Student currentstudent = s.FirstOrDefault(p => p.StudentName == StudentName);
context.Student.Remove(currentstudent);
context.SaveChanges();
//IEnumerable<Student> ss = context.Student;
return(RedirectToAction("Display"));
}
public void SetNavPageToNotificationList()
{
DbStudent dbStudent = new DbStudent();
Student student = dbStudent.GetStudent();
if (student == null || student.accessToken == null)
{
Authenticater.Authorized = false;
}
UpdateAllFilters();
NavPage = new NavigationPage(new CarouselVarsler());
}
/// <summary>
/// Gets all StudyGroups from the servers REST Api.
/// </summary>
public async Task UpdateStudyGroupsFromServer()
{
DbStudyGroup db = new DbStudyGroup();
System.Diagnostics.Debug.WriteLine("StudyGroupsController - GetStudyGroupsFromServer: initiated");
DbStudent dbStudent = new DbStudent();
string accessToken = dbStudent.GetStudentAccessToken();
if (accessToken == null)
{
Authenticater.Authorized = false;
return;
}
Uri url = new Uri(Adress);
System.Diagnostics.Debug.WriteLine("StudyGroupsController - url " + url.ToString());
var client = new HttpClient();
client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("bearer", accessToken);
try
{
var response = await client.GetAsync(url);
if (response.StatusCode == HttpStatusCode.OK)
{
System.Diagnostics.Debug.WriteLine("GetStudyGroupsFromServer response " + response.StatusCode.ToString());
var results = await response.Content.ReadAsAsync <IEnumerable <StudyGroup> >();
db.DeleteAllStudyGroups();
foreach (var studygroup in results)
{
// ugly gui filter hack
studygroup.filterChecked = false;
db.InsertStudyGroup(studygroup);
}
}
if (response.StatusCode == HttpStatusCode.Unauthorized)
{
Authenticater.Authorized = false;
}
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine("StudyGroupsController - GetStudyGroupsFromServer: await client.GetAsync(\"url\") Failed");
System.Diagnostics.Debug.WriteLine("StudyGroupsController - GetStudyGroupsFromServer: Exception msg: " + e.Message);
System.Diagnostics.Debug.WriteLine("StudyGroupsController - GetStudyGroupsFromServer: Stack Trace: \n" + e.StackTrace);
System.Diagnostics.Debug.WriteLine("StudyGroupsController - GetStudyGroupsFromServer: End Of Stack Trace");
}
}
public override DbBase GetDbModel()
{
DbStudent stud = new DbStudent()
{
id = this.id,
favTeachers = this.favTeachers,
facebookId = this.facebookId,
name = this.name,
email = this.email
};
return(stud);
}
/// <summary>
/// Gets all Courses from the servers REST Api.
/// </summary>
public async Task UpdateCoursesFromServer()
{
DbCourse db = new DbCourse();
System.Diagnostics.Debug.WriteLine("CoursesController - UpdateCoursesFromServer: initiated");
DbStudent dbStudent = new DbStudent();
string accessToken = dbStudent.GetStudentAccessToken();
if (accessToken == null)
{
Authenticater.Authorized = false;
return;
}
Uri url = new Uri(Adress);
System.Diagnostics.Debug.WriteLine("CoursesController - url " + url.ToString());
var client = new HttpClient();
client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("bearer", accessToken);
try
{
var response = await client.GetAsync(url);
if (response.StatusCode == HttpStatusCode.OK)
{
System.Diagnostics.Debug.WriteLine("UpdateCoursesFromServer response " + response.StatusCode.ToString());
var newCourses = await response.Content.ReadAsAsync <IEnumerable <Course> >();
db.DeleteAllCourses();
db.InsertCourses(newCourses);
}
if (response.StatusCode == HttpStatusCode.Unauthorized)
{
Authenticater.Authorized = false;
}
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine("CoursesController - UpdateCoursesFromServer: await client.GetAsync(\"url\") Failed");
System.Diagnostics.Debug.WriteLine("CoursesController - UpdateCoursesFromServer: Exception msg: " + e.Message);
System.Diagnostics.Debug.WriteLine("CoursesController - UpdateCoursesFromServer: Stack Trace: \n" + e.StackTrace);
System.Diagnostics.Debug.WriteLine("CoursesController - UpdateCoursesFromServer: End Of Stack Trace");
}
}
/// <summary>
/// Receives a Message from GCM. The method exctracts a message from the Bundle data,
/// and calls SendNotification.
///
/// If the students have enabled receiveNotifications, but
/// disabled receiveProjectNotifications and receiveJobNotifications
/// The student can still receive more general messages sent as push notifications
/// however these notifications will only be displayed once and won't be displayed in the
/// notification list.
/// </summary>
public override async void OnMessageReceived(string from, Bundle data)
{
DbStudent dbStudent = new DbStudent();
var message = data.GetString("message");
Log.Debug("MyGcmListenerService", "From: " + from);
Log.Debug("MyGcmListenerService", "Message: " + message);
var type = data.GetString("type");
var uuid = data.GetString("uuid");
Student student = dbStudent.GetStudent();
if (student != null && student.receiveNotifications)
{
DbNotification dbNotification = new DbNotification();
if (type == "project")
{
if (student.receiveProjectNotifications)
{
SendNotification(message);
Log.Debug("MyGcmListenerService", "type: " + type);
Log.Debug("MyGcmListenerService", "uuid: " + uuid);
// type = job or project
Log.Debug("MyGcmListenerService", "After New NotificationController, but before use of method.");
dbNotification.InsertNotification(type, uuid);
}
}
else if (type == "job")
{
if (student.receiveJobNotifications)
{
SendNotification(message);
Log.Debug("MyGcmListenerService", "type: " + type);
Log.Debug("MyGcmListenerService", "uuid: " + uuid);
// type = job or project
Log.Debug("MyGcmListenerService", "After New NotificationController, but before use of method.");
dbNotification.InsertNotification(type, uuid);
}
}
else
{
SendNotification(message);
}
}
}
public async Task CompareServerHash()
{
DbStudent dbStudent = new DbStudent();
string accessToken = dbStudent.GetStudentAccessToken();
if (accessToken == null)
{
Authenticater.Authorized = false;
return;
}
Uri url = new Uri(Adress + "/hash");
System.Diagnostics.Debug.WriteLine("JobTypesController - url " + url.ToString());
var client = new HttpClient();
client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("bearer", accessToken);
try
{
var response = await client.GetAsync(url);
if (response.StatusCode == HttpStatusCode.OK)
{
System.Diagnostics.Debug.WriteLine("CompareServerHash response " + response.StatusCode.ToString());
string json = await response.Content.ReadAsStringAsync();
string hash = ExtractServersHash(json);
string localHash = CreateLocalHash();
if (hash != localHash)
{
await UpdateJobTypesFromServer();
}
}
if (response.StatusCode == HttpStatusCode.Unauthorized)
{
Authenticater.Authorized = false;
}
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine("JobTypesController - CompareServerHash: await client.GetAsync(\"url\") Failed");
System.Diagnostics.Debug.WriteLine("JobTypesController - CompareServerHash: Exception msg: " + e.Message);
System.Diagnostics.Debug.WriteLine("JobTypesController - CompareServerHash: Stack Trace: \n" + e.StackTrace);
System.Diagnostics.Debug.WriteLine("JobTypesController - CompareServerHash: End Of Stack Trace");
}
}
void GetStudentNotificationsPref()
{
DbStudent dbStudent = new DbStudent();
Student student = dbStudent.GetStudent();
if (student != null)
{
oppgaveSwitch.IsToggled = student.receiveProjectNotifications;
stillingSwitch.IsToggled = student.receiveJobNotifications;
varselSwitch.IsToggled = student.receiveNotifications;
}
else
{
oppgaveSwitch.IsToggled = false;
stillingSwitch.IsToggled = false;
varselSwitch.IsToggled = false;
}
}
/// <summary>
/// Updates the Job from the servers REST Api.
///
/// This implementation also get the minimum data from the related
/// Companies to build a proper notification list.
/// </summary>
/// <param name="uuid"></param>
public async Task UpdateJobFromServer(string uuid)
{
System.Diagnostics.Debug.WriteLine("JobController - UpdateJobFromServer(string uuid): initiated");
string adress = Adress + "/" + uuid;
System.Diagnostics.Debug.WriteLine("UpdateJobFromServer: var url = " + adress);
Uri url = new Uri(adress);
var client = new HttpClient();
System.Diagnostics.Debug.WriteLine("JobController - UpdateJobFromServer: HttpClient created");
DbStudent dbStudent = new DbStudent();
string accessToken = dbStudent.GetStudentAccessToken();
if (string.IsNullOrWhiteSpace(accessToken))
{
Authenticater.Authorized = false;
return;
}
client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("bearer", accessToken);
string jsonString = null;
try
{
var response = await client.GetAsync(url);
System.Diagnostics.Debug.WriteLine("UpdateJobFromServer response " + response.StatusCode.ToString());
//results = await response.Content.ReadAsAsync<IEnumerable<Job>>();
jsonString = await response.Content.ReadAsStringAsync();
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine(
"JobController - UpdateJobFromServer: await client.GetAsync(\"url\") Failed");
System.Diagnostics.Debug.WriteLine("JobController - UpdateJobFromServer: Exception msg: " + e.Message);
System.Diagnostics.Debug.WriteLine("JobController - UpdateJobFromServer: Stack Trace: \n" + e.StackTrace);
System.Diagnostics.Debug.WriteLine("JobController - UpdateJobFromServer: End Of Stack Trace");
return;
}
Deserialize(jsonString);
}
public string AddStudent(MdlStudent mdlStudentObj)
{
DbStudent dbStudentObj = new DbStudent();
CtrEmail ctrEmailObj = new CtrEmail();
mdlStudentObj.Salt = CreateSalt(10);
mdlStudentObj.Password = CreateHash(mdlStudentObj.Password, mdlStudentObj.Salt);
//mdlStudentObj.ConfirmationCode = ctrEmailObj.getCode();
mdlStudentObj.ConfirmationCode = "none";
string Feedback = dbStudentObj.AddStudent(mdlStudentObj);
if (Feedback == "Error")
{
return(Feedback);
}
//ctrEmailObj.send();
return(Feedback);
}
public static Student Convert(this DbStudent student, DbUser user = null)
{
var res = new Student()
{
Id = student.StudentId,
EntryYear = student.EnteringYear,
Name = student.Name,
Surname = student.Surname,
Middlename = student.Middlename,
};
if (user != null)
{
res.Login = user.Login;
res.UserId = user.UserId;
res.Password = user.Password;
res.LastActivityDate = user.LastActivityDate ?? DateTime.Now;
res.RegistredDate = user.RegDate;
}
return(res);
}
private void StudentFetched(DbStudent loggedIn)
{
if (loggedIn == null)
{
MessagePopupManager.Instance.
SetUpperText(Strings.GetString(Strings.Account.student_doesnt_exist)).
SetLeftButtonText(Strings.GetString(Strings.UI.OK)).
OnlyRightButton(true).EnablePopup();
MessagePopupManager.Instance.StopLoader();
}
else
{
UserPreferences.CurrentUserId = loggedIn.id;
LoadMainMenu();
if ((string.IsNullOrEmpty(loggedIn.messagingToken) && !string.IsNullOrEmpty(UserPreferences.MessagingToken)) ||
loggedIn.messagingToken != UserPreferences.MessagingToken)
{
loggedIn.messagingToken = UserPreferences.MessagingToken;
FirebaseManager.Instance.PushToCloud <DbStudent>(loggedIn);
}
}
}
public int AddStudent(string login, string password, string fname, string lname, string mname, int entryYear)
{
if (string.IsNullOrEmpty(login) || string.IsNullOrEmpty(password))
{
return(-1);
}
if (Context.Users.Any(x => x.Login == login))
{
return(-1);
}
var newUser = new DbUser();
newUser.RegDate = DateTime.Now;
newUser.Login = login;
newUser.Password = password;
Context.Users.Add(newUser);
var student = new DbStudent();
student.UserId = newUser.UserId;
student.Name = fname;
student.Surname = lname;
student.Middlename = mname;
student.EnteringYear = entryYear;
Context.Students.Add(student);
try
{
Context.SaveChanges();
}
catch (Exception ex)
{
Debug.WriteLine($"Exception:{ex.Message}");
return(-1);
}
return(student.StudentId);
}
public async Task <IActionResult> PutDbStudent(int id, DbStudent dbStudent)
{
dbStudent.Id = id;
_context.Entry(dbStudent).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!DbStudentExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
