private User GetUserFromRow(MySqlDataReader reader)
{
User user = new User();
UserAccountType accountType = (UserAccountType)Enum.ToObject(typeof(UserAccountType), reader.GetInt32(1));
if (accountType is UserAccountType.Student)
{
Student student = new Student
{
StudyYear = reader.GetInt32(6)
};
int?facultyId = !reader.IsDBNull(7) ? (int?)reader.GetInt32(7) : null;
int?programId = !reader.IsDBNull(8) ? (int?)reader.GetInt32(8) : null;
int?specializationId = !reader.IsDBNull(9) ? (int?)reader.GetInt32(9) : null;
if (facultyId != null)
{
Faculty faculty = ((App)App.Current).faculties.GetFacultyById((int)facultyId);
if (programId != null)
{
StudyProgram program = faculty.StudyPrograms[(int)programId];
student.StudyProgram = program;
if (specializationId != null)
{
StudyProgramSpecialization specialization = program.StudyProgramSpecializations[(int)specializationId];
student.StudyProgramSpecialization = specialization;
}
}
}
user = student;
}
else if (accountType is UserAccountType.FacultyMember)
{
FacultyMember facultyMember = new FacultyMember
{
Faculty = ((App)App.Current).faculties.GetFacultyById(reader.GetInt32(10)),
AcademicRank = (AcademicRank)Enum.ToObject(typeof(AcademicRank), reader.GetInt32(11)),
StudyField = ((App)App.Current).faculties.GetStudyFieldById(reader.GetInt32(12))
};
user = facultyMember;
}
user.UserId = reader.GetInt32(0);
user.FirstName = reader.GetString(2);
user.LastName = reader.GetString(3);
user.PhoneNumber = !reader.IsDBNull(4) ? reader.GetString(4) : null;
user.PhoneFormat = !reader.IsDBNull(4) ? reader.GetString(5) : null;
return(user);
}
static void AddNew()
{
FacultyMember member = new FacultyMember();
member.firstName = "Test";
member.lastName = "Test";
member.email = "test";
member.ext = "test";
member.department = "Test";
memberList.Add(member);
Save();
}
//END GLOBAL HELPERS
//FACULTY HELPERS
private IEnumerator loadFacultyData()
{
StartCoroutine(ShowFacultyLoadAnimation());
faculty_data.SetActive(false);
faculty_job = new LoadFacultyJob();
ThreadSmartQueue._thread_smart_queue.EnqueueItem(faculty_job);
yield return(StartCoroutine(faculty_job.WaitFor()));
List <FacultyMember> faculty_members = new List <FacultyMember>();
foreach (Dictionary <String, String> faculty_member_data in faculty_job.faculty_data)
{
FacultyMember faculty_member = (FacultyMember)Instantiate(Main.main.faculty_member_prefab, Vector3.zero, Quaternion.identity);
faculty_member.init(faculty_member_data["name"], faculty_member_data["title"], faculty_member_data["phone"], faculty_member_data["email"], faculty_member_data["office"], faculty_member_data["link"], faculty_member_data["image"]);
faculty_members.Add(faculty_member);
if (_frame_smart_queue.getFrameTime() >= Main.FRAME_MILLISECONDS)
{
yield return(null);
yield return(null);
}
}
faculty_screen_loader.gameObject.SetActive(false);
faculty_screen_loaded = true;
if (_frame_smart_queue.getFrameTime() >= Main.FRAME_MILLISECONDS)
{
yield return(null);
}
faculty_data.SetActive(true);
if (_frame_smart_queue.getFrameTime() >= Main.FRAME_MILLISECONDS)
{
yield return(null);
}
faculty_data.GetComponent <RectTransform>().anchoredPosition = new Vector2(0, 0);
Vector2 faculty_mask_size = Main.main.faculty_root.GetComponent <SpriteMask>().size;
faculty_mask_size.y = Main.main.faculty_root.GetComponent <RectTransform>().rect.height;
faculty_mask_size.x = Main.main.faculty_root.GetComponent <RectTransform>().rect.width;
faculty_root.GetComponent <SpriteMask>().size = faculty_mask_size;
foreach (FacultyMember faculty_member in faculty_members)
{
StartCoroutine(faculty_member.loadMemberImage());
yield return(null);
}
}
public static void Save()
{
FacultyMember member = new FacultyMember();
member.firstName = Guid.NewGuid().ToString();
member.lastName = "Bar";
member.email = "Email";
member.ext = "Ext";
member.department = "Dept";
List <FacultyMember> existing = new List <FacultyMember>();
existing.AddRange(Load());
existing.Add(member);
String json = JsonConvert.SerializeObject(existing.ToArray());
System.IO.File.WriteAllText(filename, json);
}
