/// <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); }