//***** TA DB *****
public static TeachersAssistant TA_ModelToDB(Models.TAModel TA_Model)
{
TeachersAssistant TA_DB = new TeachersAssistant();
using (TAhubContext db = new TAhubContext())
{
try
{
TA_DB.StudentId = Int32.Parse(TA_Model.StudentId);
TA_DB.FirstName = TA_Model.FirstName;
TA_DB.LastName = TA_Model.LastName;
TA_DB.Email = TA_Model.Login.Username;
TA_DB.Password = TA_Model.Login.Password;
TA_DB.Credits = Int32.Parse(TA_Model.Credits);
TA_DB.GPA = TA_Model.GPA;
TA_DB.HasExperience = Models.EnumValues.Bools[(int)TA_Model.HasExperience];
TA_DB.Lab = TA_Model.Lab;
TA_DB.Gender = Models.EnumValues.Genders[(int)TA_Model.Gender];
TA_DB.Major = Models.EnumValues.Majors[(int)TA_Model.Major];
TA_DB.WeeklySchedule = TA_Model.WeeklySchedule;
int count = TA_Model.CoursePreferences != null ? TA_Model.CoursePreferences.Count : 0;
for (int i = 0; i < count; i++)
{
switch (i)
{
case 0:
TA_DB.Preference1 = TA_Model.CoursePreferences[i];
break;
case 1:
TA_DB.Preference2 = TA_Model.CoursePreferences[i];
break;
case 2:
TA_DB.Preference3 = TA_Model.CoursePreferences[i];
break;
default: break;
}
}
TA_DB.Course = TA_Model.CourseAssignment;
TA_DB.Messages = TA_Model.Messages;
}
catch (Exception)
{
TA_DB = null;
}
}
return(TA_DB);
}
//***** TA Model *****
public static Models.TAModel TA_DBToModel(DB.TeachersAssistant TA_DB)
{
Models.TAModel TA_Model = new Models.TAModel();
using (TAhubContext db = new TAhubContext())
{
try
{
TA_Model.Id = TA_DB.Id;
TA_Model.StudentId = TA_DB.StudentId.ToString();
TA_Model.FirstName = TA_DB.FirstName;
TA_Model.LastName = TA_DB.LastName;
TA_Model.Login.Username = TA_DB.Email;
TA_Model.Login.Password = TA_DB.Password;
TA_Model.Credits = TA_DB.Credits.ToString();
TA_Model.GPA = TA_DB.GPA;
TA_Model.HasExperience = (Models.Bools)Convert.ToInt32(TA_DB.HasExperience);
TA_Model.Lab = TA_DB.Lab;
TA_Model.Gender = (Models.GenderType)Models.EnumValues.Genders.IndexOf(TA_DB.Gender);
TA_Model.Major = (Models.MajorType)Models.EnumValues.Majors.IndexOf(TA_DB.Major);
TA_Model.CoursePreferences = new List <string>()
{
TA_DB.Preference1, TA_DB.Preference2, TA_DB.Preference3
};
try
{
TA_Model.WeeklySchedule = TA_DB.WeeklySchedule.ToList();
TA_Model.CourseAssignment = TA_DB.Course;
TA_Model.Messages = TA_DB.Messages.ToList();
}
catch (Exception) { }
}
catch (Exception)
{
TA_Model = null;
}
}
return(TA_Model);
}
