/// <summary>
/// Returnerer info om alle Uddannelsesforløb gemt af en bruger specificeret ved UserName
/// og Password.
/// </summary>
/// <param name="Password">Password for nuværende bruger.</param>
/// <param name="UserName">Brugernavn for nuværende bruger.</param>
/// <returns>
/// Liste af Uddannelsesforløb. Listen returneres som en liste af jSon objekter,
/// hvor hver enkelt jSon element indeholder felterne : User_Education_Time_CollectionID,
/// UserInfoID, UserName, EducationName, EducationLineName,
/// CharacterValueCourse, AbsencePercentageCourse, EducationLine, EducationName,
/// WhichCharacterScaleIDEducation, WhichCharacterScaleNameEducation,
/// CharacterValueEducation, EducationStartTime, EducationEndTime, CharacterValueEducation,
/// AbsencePercentageForEducation og CourseCharacterList. Feltet CourseCharacterList indeholder
/// en liste af Liste af F*g/Kursus forløb knyttet til de enkelte uddannelsesforløb. For en
/// beskrivelse af feltet CourseCharacterList henvises til UserEducationCourseCharacter eller klik
/// her : <see cref="UserEducationCourseCharacterController"/>.
/// Flere af de nævnte felter "ID felter", kan have en værdi på -10 (InformationNotProvided),
/// hvis disse felter ikke er udfyldt af brugeren. Er det et tekst felt, vil feltet have værdien :
/// "Information er ikke gemt".
/// Ved fejl vil der returneres et json Objekt med felterne ErrorNumber og ErrorText,
/// hvor ErrorNumber har en værdi mindre end 0. Se en oversigt over return koder i ReturnCodesAndStrings
/// eller klik her : <see cref="ReturnCodeAndReturnString"/>.
/// </returns>
// GET api/<controller>
public List <Object> Get(string UserName, string Password)
{
List <object> jSonList = new List <object>();
List <User_Education_Time_Collection> User_Education_Time_List = new List <User_Education_Time_Collection>();
int UserID = 0;
UserID = UserInfo.FindUserInDatabase(UserName, Password);
if (0 < UserID)
{
User_Education_Time_List = db.User_Education_Time_Collections.Where(u => u.UserInfoID == UserID).ToList();
foreach (User_Education_Time_Collection User_Education_Time_Object in User_Education_Time_List)
{
var ListItem = new
{
User_Education_Time_CollectionID = User_Education_Time_Object.User_Education_Time_CollectionID,
UserInfoID = User_Education_Time_Object.UserInfoID,
UserName = User_Education_Time_Object.UserInfo.UserName,
EducationName = User_Education_Time_Object.EducationLine.Education.EducationName,
EducationLineName = User_Education_Time_Object.EducationLine.EducationLineName,
WhichCharacterScaleIDEducation = (null != User_Education_Time_Object.WhichCharacterScaleID) ?
User_Education_Time_Object.WhichCharacterScaleID :
Const.InformationNotProvided,
WhichCharacterScaleNameEducation = (null != User_Education_Time_Object.WhichCharacterScaleID) ?
User_Education_Time_Object.WhichCharacterScale.WhichCharacterScaleName :
Const.FindReturnString(Const.InformationNotProvided),
CharacterValueEducation = (null != User_Education_Time_Object.CharacterValueEducation) ?
User_Education_Time_Object.CharacterValueEducation :
Const.InformationNotProvided,
EducationStartTime = User_Education_Time_Object.StartDate.ToShortDateString(),
EducationStopTime = User_Education_Time_Object.EndDate.ToShortDateString(),
AbsencePercentageForEducation = (null != User_Education_Time_Object.AbsencePercentageEducation) ?
User_Education_Time_Object.AbsencePercentageEducation :
Const.InformationNotProvided,
CourseCharacterList = new List <VM_User_Education_Character_Course_Collection>()
};
foreach (User_Education_Character_Course_Collection User_Education_Character_Course_Collection_Object in
User_Education_Time_Object.User_Education_Character_Course_Collection)
{
VM_User_Education_Character_Course_Collection VM_User_Education_Character_Course_Collection_Object =
new VM_User_Education_Character_Course_Collection();
VM_User_Education_Character_Course_Collection_Object.User_Education_Character_Course_Collection_Object =
new User_Education_Character_Course_Collection();
VM_User_Education_Character_Course_Collection_Object.User_Education_Character_Course_Collection_Object.User_Education_Character_Course_CollectionID =
User_Education_Character_Course_Collection_Object.User_Education_Character_Course_CollectionID;
VM_User_Education_Character_Course_Collection_Object.User_Education_Character_Course_Collection_Object.User_Education_Time_CollectionID =
User_Education_Character_Course_Collection_Object.User_Education_Time_CollectionID;
VM_User_Education_Character_Course_Collection_Object.User_Education_Character_Course_Collection_Object.CourseID =
User_Education_Character_Course_Collection_Object.CourseID;
VM_User_Education_Character_Course_Collection_Object.CourseName = User_Education_Character_Course_Collection_Object.Course.CourseName;
VM_User_Education_Character_Course_Collection_Object.User_Education_Character_Course_Collection_Object.WhichCharacterScaleID =
(null != User_Education_Character_Course_Collection_Object.WhichCharacterScaleID) ?
User_Education_Character_Course_Collection_Object.WhichCharacterScaleID :
Const.InformationNotProvided;
VM_User_Education_Character_Course_Collection_Object.WhichCharacterScaleName = (null != User_Education_Character_Course_Collection_Object.WhichCharacterScaleID) ?
User_Education_Character_Course_Collection_Object.WhichCharacterScale.WhichCharacterScaleName :
Const.FindReturnString(Const.InformationNotProvided);
VM_User_Education_Character_Course_Collection_Object.User_Education_Character_Course_Collection_Object.CharacterValueCourse =
(null != User_Education_Time_Object.CharacterValueEducation) ?
User_Education_Time_Object.CharacterValueEducation :
Const.InformationNotProvided;
VM_User_Education_Character_Course_Collection_Object.User_Education_Character_Course_Collection_Object.AbsencePercentageCourse =
(null != User_Education_Character_Course_Collection_Object.AbsencePercentageCourse) ?
User_Education_Character_Course_Collection_Object.AbsencePercentageCourse :
Const.InformationNotProvided;
ListItem.CourseCharacterList.Add(VM_User_Education_Character_Course_Collection_Object);
//ListItem.CourseCharacterList.Add(User_Education_Character_Course_Collection_Object);
// Hvis man bruger linjen herover, som vil det være nemmeste, får man jSon self referencing fejl !!!
}
jSonList.Add(ListItem);
}
}
else
{
var ListItem = new
{
ErrorCode = Const.UserNotFound,
ErrorText = Const.FindReturnString(Const.UserNotFound)
};
jSonList.Add(ListItem);
}
return(jSonList);
}
/// <summary>
/// Returnerer info om ét Uddannelsesforløb udfra id gemt af en bruger specificeret ved UserName
/// og Password.
/// </summary>
/// <param name="id">Integer der specificerer id på Bruger-Uddannnelsesforløb samling.</param>
/// <param name="Password">Password for nuværende bruger.</param>
/// <param name="UserName">Brugernavn for nuværende bruger.</param>
/// <returns>Ét Uddannelsesforløb.Uddannelsesforløbet returneres som et jSon objekt,
/// som indeholder felterne : User_Education_Time_CollectionID,
/// UserInfoID, UserName, EducationName, EducationLineName,
/// CharacterValueCourse, AbsencePercentageCourse, EducationLine, EducationName,
/// WhichCharacterScaleIDEducation, WhichCharacterScaleNameEducation,
/// CharacterValueEducation, EducationStartTime, EducationEndTime, CharacterValueEducation,
/// AbsencePercentageForEducation og CourseCharacterList. Feltet CourseCharacterList indeholder
/// en liste af Liste af F*g/Kursus forløb knyttet til de enkelte uddannelsesforløb. For en
/// beskrivelse af feltet CourseCharacterList henvises til UserEducationCourseCharacter eller klik
/// her : <see cref="UserEducationCourseCharacterController"/>.
/// Flere af de nævnte felter "ID felter", kan have en værdi på -10 (InformationNotProvided),
/// hvis disse felter ikke er udfyldt af brugeren. Er det et tekst felt, vil feltet have værdien :
/// "Information er ikke gemt".
/// Ved fejl vil der returneres et json Objekt med felterne ErrorNumber og ErrorText,
/// hvor ErrorNumber har en værdi mindre end 0. Se en oversigt over return koder i ReturnCodesAndStrings
/// eller klik her : <see cref="ReturnCodeAndReturnString"/>.
/// </returns>
// GET api/<controller>/5
public object Get(int id, string UserName, string Password)
{
object jSon_Object = new object();
User_Education_Time_Collection User_Education_Time_Object = new User_Education_Time_Collection();
int UserID = 0;
UserID = UserInfo.FindUserInDatabase(UserName, Password);
if (0 < UserID)
{
if (null != db.User_Education_Time_Collections.FirstOrDefault(u => u.User_Education_Time_CollectionID == id))
{
if (null != db.User_Education_Time_Collections.FirstOrDefault(u => u.UserInfoID == UserID && u.User_Education_Time_CollectionID == id))
{
User_Education_Time_Object = db.User_Education_Time_Collections.First(u => u.UserInfoID == UserID && u.User_Education_Time_CollectionID == id);
var ListItem = new
{
User_Education_Time_CollectionID = User_Education_Time_Object.User_Education_Time_CollectionID,
UserInfoID = User_Education_Time_Object.UserInfoID,
UserName = User_Education_Time_Object.UserInfo.UserName,
EducationName = User_Education_Time_Object.EducationLine.Education.EducationName,
EducationLine = User_Education_Time_Object.EducationLine.EducationLineName,
WhichCharacterScaleIDEducation = (null != User_Education_Time_Object.WhichCharacterScaleID) ?
User_Education_Time_Object.WhichCharacterScaleID :
Const.InformationNotProvided,
WhichCharacterScaleNameEducation = (null != User_Education_Time_Object.WhichCharacterScaleID) ?
User_Education_Time_Object.WhichCharacterScale.WhichCharacterScaleName :
Const.FindReturnString(Const.InformationNotProvided),
CharacterValueEducation = (null != User_Education_Time_Object.CharacterValueEducation) ?
User_Education_Time_Object.CharacterValueEducation :
Const.InformationNotProvided,
EducationStartTime = User_Education_Time_Object.StartDate.ToShortDateString(),
EducationStopTime = User_Education_Time_Object.EndDate.ToShortDateString(),
AbsencePercentageForEducation = (null != User_Education_Time_Object.AbsencePercentageEducation) ?
User_Education_Time_Object.AbsencePercentageEducation :
Const.InformationNotProvided,
CourseCharacterList = new List <VM_User_Education_Character_Course_Collection>()
};
foreach (User_Education_Character_Course_Collection User_Education_Character_Course_Collection_Object in
User_Education_Time_Object.User_Education_Character_Course_Collection)
{
VM_User_Education_Character_Course_Collection VM_User_Education_Character_Course_Collection_Object =
new VM_User_Education_Character_Course_Collection();
VM_User_Education_Character_Course_Collection_Object.User_Education_Character_Course_Collection_Object =
new User_Education_Character_Course_Collection();
VM_User_Education_Character_Course_Collection_Object.User_Education_Character_Course_Collection_Object.User_Education_Character_Course_CollectionID =
User_Education_Character_Course_Collection_Object.User_Education_Character_Course_CollectionID;
VM_User_Education_Character_Course_Collection_Object.User_Education_Character_Course_Collection_Object.User_Education_Time_CollectionID =
User_Education_Character_Course_Collection_Object.User_Education_Time_CollectionID;
VM_User_Education_Character_Course_Collection_Object.User_Education_Character_Course_Collection_Object.CourseID =
User_Education_Character_Course_Collection_Object.CourseID;
VM_User_Education_Character_Course_Collection_Object.CourseName = User_Education_Character_Course_Collection_Object.Course.CourseName;
VM_User_Education_Character_Course_Collection_Object.User_Education_Character_Course_Collection_Object.WhichCharacterScaleID =
(null != User_Education_Character_Course_Collection_Object.WhichCharacterScaleID) ?
User_Education_Character_Course_Collection_Object.WhichCharacterScaleID :
Const.InformationNotProvided;
VM_User_Education_Character_Course_Collection_Object.WhichCharacterScaleName = (null != User_Education_Character_Course_Collection_Object.WhichCharacterScaleID) ?
User_Education_Character_Course_Collection_Object.WhichCharacterScale.WhichCharacterScaleName :
"Ikke Oplyst !!!";
VM_User_Education_Character_Course_Collection_Object.User_Education_Character_Course_Collection_Object.CharacterValueCourse =
(null != User_Education_Time_Object.CharacterValueEducation) ?
User_Education_Time_Object.CharacterValueEducation :
Const.InformationNotProvided;
VM_User_Education_Character_Course_Collection_Object.User_Education_Character_Course_Collection_Object.AbsencePercentageCourse =
(null != User_Education_Character_Course_Collection_Object.AbsencePercentageCourse) ?
User_Education_Character_Course_Collection_Object.AbsencePercentageCourse :
Const.InformationNotProvided;
ListItem.CourseCharacterList.Add(VM_User_Education_Character_Course_Collection_Object);
}
jSon_Object = ListItem;
}
else
{
var ListItem = new
{
ErrorCode = Const.ObjectNotSavedByCurrentUserOriginally,
ErrorText = Const.FindReturnString(Const.ObjectNotSavedByCurrentUserOriginally)
};
jSon_Object = ListItem;
}
}
else
{
var ListItem = new
{
ErrorCode = Const.ObjectNotFound,
ErrorText = Const.FindReturnString(Const.ObjectNotFound)
};
jSon_Object = ListItem;
}
}
else
{
var ListItem = new
{
ErrorCode = Const.UserNotFound,
ErrorText = Const.FindReturnString(Const.UserNotFound)
};
jSon_Object = ListItem;
}
return(jSon_Object);
}
