/// <summary>
/// Sletter ét specifikt F*g/Kursus udfra id. Ved kald af denne funktionalitet skal man
/// angive Brugernavn og Passsword. Kun brugere kendt af systemet kan udnytte denne
/// funktionalitet.
/// </summary>
/// <param name="id">F*g/Kursus ID</param>
/// <param name="Password">Password for nuværende bruger.</param>
/// <param name="UserName">Brugernavn for nuværende bruger.</param>
/// <returns>
/// DeleteOperationOk (værdien 3) hvis F*g/Kursus er slettet ok.
/// Eller en retur kode med en værdi mindre end 0, hvis noget gik galt.
/// Se en oversigt over return koder i ReturnCodesAndStrings eller klik
/// her : <see cref="ReturnCodeAndReturnString"/>
/// </returns>
// DELETE api/<controller>/5
public int Delete(int id, string UserName, string Password)
{
Course Course_Object = new Course();
int NumberOfCoursesDeleted;
int UserID = 0;
UserID = UserInfo.FindUserInDatabase(UserName, Password);
if (Const.UserNotFound < UserID)
{
Course_Object = db.Courses.Find(id);
if (null != Course_Object)
{
if (0 == User_Education_Character_Course_Collection.FindEducation_Course_Character_Collection_With_Specified_CourseID(id))
{
db.Courses.Remove(Course_Object);
NumberOfCoursesDeleted = db.SaveChanges();
if (1 == NumberOfCoursesDeleted)
{
LogData.LogDataToDatabase(UserName, DataBaseOperation.DeleteData_Enum, ModelDatabaseNumber.Course_Enum);
return(Const.DeleteOperationOk);
}
else
{
return(Const.DeleteOperationFailed);
}
}
else
{
return(Const.SpecifiedContentStillInUseInTablesBelow);
}
}
else
{
return(Const.ObjectNotFound);
}
}
else
{
return(Const.UserNotFound);
}
}
/// <summary>
/// Sletter F*g/Kursus forløb hørende til bruger specificeret ved id, UserName og Password.
/// </summary>
/// <remarks>
/// UserName og Password skal være gemt i Web API'ets database for at være gyldige. Og
/// Uddannelsesforløb med specificeret id, skal være gemt af nuværende bruger før.
/// </remarks>
/// <param name="id">Integer der specificerer id på Bruger-F*g/Kursus samling.</param>
/// <param name="Password">Password for nuværende bruger.</param>
/// <param name="UserName">Brugernavn for nuværende bruger.</param>
/// <returns>
/// DeleteOperationOk (værdien 3) hvis F*g/Kursus forløb er slettet ok.
/// Eller en retur kode med en værdi mindre end 0, hvis noget gik galt.
/// Se en oversigt over return koder i ReturnCodesAndStrings eller klik
/// her : <see cref="ReturnCodeAndReturnString"/>
/// </returns>
// DELETE api/<controller>/5
public int Delete(int id, string UserName, string Password)
{
User_Education_Character_Course_Collection User_Education_Character_Course_Collection_Object =
new User_Education_Character_Course_Collection();
int NumberOfCourseCharactersDeleted;
int UserID = 0;
UserID = UserInfo.FindUserInDatabase(UserName, Password);
if (Const.UserNotFound < UserID)
{
User_Education_Character_Course_Collection_Object = db.User_Education_Character_Course_Collections.Find(id);
if (null != User_Education_Character_Course_Collection_Object)
{
if (User_Education_Character_Course_Collection_Object.User_Education_Time_Collection.UserInfoID != UserID)
{
return(Const.ObjectNotSavedByCurrentUserOriginally);
}
db.User_Education_Character_Course_Collections.Remove(User_Education_Character_Course_Collection_Object);
NumberOfCourseCharactersDeleted = db.SaveChanges();
if (1 == NumberOfCourseCharactersDeleted)
{
LogData.LogDataToDatabase(UserName, DataBaseOperation.DeleteData_Enum, ModelDatabaseNumber.User_Education_Character_Course_Collection_Enum);
return(Const.DeleteOperationOk);
}
else
{
return(Const.DeleteOperationFailed);
}
}
else
{
return(Const.ObjectNotFound);
}
}
else
{
return(Const.UserNotFound);
}
}
/// <summary>
/// Opdaterer F*g/Kursus forløb hørende til ét uddannelsesforløb specificeret ved id, UserName og
/// Password.
/// </summary>
/// <remarks>
/// UserName og Password skal være gemt i Web API'ets database for at være gyldige.
/// </remarks>
/// <param name="json_Object">json_Objekt er et objekt i jSon format. Det skal indeholde
/// data til funktionen med følgende felter specificeret : User_Education_Time_CollectionID,
/// CourseID.
/// Optionalt kan følgende felter også angives : WhichCharacterScaleID, CharacterValueCourse og
/// AbsencePercentageCourse
/// </param>
/// <param name="id">Integer der specificerer id på Bruger-F*g/Kursus samling.</param>
/// <param name="Password">Password for nuværende bruger.</param>
/// <param name="UserName">Brugernavn for nuværende bruger.</param>
/// <returns>
/// UpdateOperationOk (værdien 1) hvis F*g/Kursus forløb er gemt ok.
/// Eller en retur kode med en værdi mindre end 0, hvis noget gik galt.
/// Se en oversigt over return koder i ReturnCodesAndStrings eller klik
/// her : <see cref="ReturnCodeAndReturnString"/>
/// </returns>
// PUT api/<controller>/5
public int Put(int id, dynamic json_Object, string UserName, string Password)
{
User_Education_Character_Course_Collection User_Education_Character_Course_Collection_Object =
new User_Education_Character_Course_Collection();
WhichCharacterScale WhichCharacterScale_Object = new WhichCharacterScale();
int NumberOfCourseCharactersSaved;
int UserID = 0;
UserID = UserInfo.FindUserInDatabase(UserName, Password);
if (Const.UserNotFound < UserID)
{
if ((null == json_Object.User_Education_Time_CollectionID) ||
(null == json_Object.CourseID))
{
return(Const.WrongjSonObjectParameters);
}
else
{
User_Education_Character_Course_Collection_Object = db.User_Education_Character_Course_Collections.Find(id);
if (null != User_Education_Character_Course_Collection_Object)
{
if (User_Education_Character_Course_Collection_Object.User_Education_Time_Collection.UserInfoID != UserID)
{
return(Const.ObjectNotSavedByCurrentUserOriginally);
}
User_Education_Character_Course_Collection_Object.User_Education_Time_CollectionID =
json_Object.User_Education_Time_CollectionID;
User_Education_Character_Course_Collection_Object.CourseID =
json_Object.CourseID;
if (null != json_Object.WhichCharacterScaleID)
{
WhichCharacterScale_Object = db.WhichCharacterScales.Find((int)json_Object.WhichCharacterScaleID);
if (null == WhichCharacterScale_Object)
{
return(Const.WrongCharacterScaleProvided);
}
User_Education_Character_Course_Collection_Object.WhichCharacterScaleID = json_Object.WhichCharacterScaleID;
}
else
{
User_Education_Character_Course_Collection_Object.WhichCharacterScaleID = null;
}
if (null != json_Object.CharacterValueCourse)
{
if (null == json_Object.WhichCharacterScaleID)
{
return(Const.CharacterProvidedButNoCharacterScaleProvided);
}
else
{
int WhichCharacterScale = WhichCharacterScale_Object.WhichCharacterScaleID;
int CharacterValueCourse = json_Object.CharacterValueCourse;
switch (WhichCharacterScale)
{
case (int)WhichCharacterScaleENUM.Character_7_ENUM:
Character7Scale Character7Scale_Object = db.Character7Scales.FirstOrDefault(c => c.Character7ScaleValue == CharacterValueCourse);
if (null == Character7Scale_Object)
{
return(Const.WrongCharacterProvided);
}
break;
case (int)WhichCharacterScaleENUM.Character_13_ENUM:
Character13Scale Character13Scale_Object = db.Character13Scales.FirstOrDefault(c => c.Character13ScaleValue == CharacterValueCourse);
if (null == Character13Scale_Object)
{
return(Const.WrongCharacterProvided);
}
break;
}
}
User_Education_Character_Course_Collection_Object.CharacterValueCourse = json_Object.CharacterValueCourse;
}
else
{
if (null != json_Object.WhichCharacterScaleID)
{
return(Const.NoCharacterProvidedButCharacterScaleProvided);
}
User_Education_Character_Course_Collection_Object.CharacterValueCourse = null;
}
if (null != json_Object.AbsencePercentageCourse)
{
User_Education_Character_Course_Collection_Object.AbsencePercentageCourse = json_Object.AbsencePercentageCourse;
}
else
{
User_Education_Character_Course_Collection_Object.AbsencePercentageCourse = null;
}
NumberOfCourseCharactersSaved = db.SaveChanges();
if (1 == NumberOfCourseCharactersSaved)
{
LogData.LogDataToDatabase(UserName, DataBaseOperation.UpdateData_Enum, ModelDatabaseNumber.User_Education_Character_Course_Collection_Enum);
return(Const.UpdateOperationOk);
}
else
{
return(Const.UpdateOperationFailed);
}
}
else
{
return(Const.ObjectNotFound);
}
}
}
else
{
return(Const.UserNotFound);
}
}
/// <summary>
/// Returnerer info om ét F*g/Kursus på ét specifikt Uddannelsesforløb udfra ID gemt af en bruger
/// specificeret ved UserName og Password.
/// </summary>
/// <param name="id">Integer der specificerer id på Bruger-F*g/Kursus samling.</param>
/// <param name="Password">Password for nuværende bruger.</param>
/// <param name="UserName">Brugernavn for nuværende bruger.</param>
/// <returns>Ét F*g/Kursus forløb. F*g/Kursus forløbet returneres som et jSon objekt,
/// som indeholder felterne : User_Education_Character_Course_CollectionID,
/// CourseID, CourseName, WhichCharacterScaleIDCourse, WhichCharacterScaleNameCourse,
/// CharacterValueCourse, AbsencePercentageCourse, EducationLine, EducationName,
/// EducationStartTime, EducationEndTime, CharacterValueEducation og
/// AbsencePercentageForEducation. 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_Character_Course_Collection User_Education_Character_Course_Collection_Object =
new User_Education_Character_Course_Collection();
int UserID = 0;
UserID = UserInfo.FindUserInDatabase(UserName, Password);
if (Const.UserNotFound < UserID)
{
User_Education_Character_Course_Collection_Object = db.User_Education_Character_Course_Collections.Find(id);
if (null != User_Education_Character_Course_Collection_Object)
{
if (UserID == User_Education_Character_Course_Collection_Object.User_Education_Time_Collection.UserInfoID)
{
var ListItemCourseCharacter = new
{
User_Education_Character_Course_CollectionID =
User_Education_Character_Course_Collection_Object.User_Education_Character_Course_CollectionID,
CourseID = User_Education_Character_Course_Collection_Object.CourseID,
CourseName = User_Education_Character_Course_Collection_Object.Course.CourseName,
WhichCharacterScaleIDCourse = (null != User_Education_Character_Course_Collection_Object.WhichCharacterScaleID) ?
User_Education_Character_Course_Collection_Object.WhichCharacterScaleID :
Const.InformationNotProvided,
WhichCharacterScaleNameCourse = (null != User_Education_Character_Course_Collection_Object.WhichCharacterScaleID) ?
User_Education_Character_Course_Collection_Object.WhichCharacterScale.WhichCharacterScaleName :
Const.FindReturnString(Const.InformationNotProvided),
CharacterValueCourse = (null != User_Education_Character_Course_Collection_Object.CharacterValueCourse) ?
User_Education_Character_Course_Collection_Object.CharacterValueCourse :
Const.InformationNotProvided,
AbsencePercentageCourse = (null != User_Education_Character_Course_Collection_Object.AbsencePercentageCourse) ?
User_Education_Character_Course_Collection_Object.AbsencePercentageCourse :
Const.InformationNotProvided,
EducationLine = User_Education_Character_Course_Collection_Object.User_Education_Time_Collection.EducationLine.EducationLineName,
EducationName = User_Education_Character_Course_Collection_Object.User_Education_Time_Collection.EducationLine.Education.EducationName,
EducationStartTime = User_Education_Character_Course_Collection_Object.User_Education_Time_Collection.StartDate,
EducationEndTime = User_Education_Character_Course_Collection_Object.User_Education_Time_Collection.EndDate,
CharacterValueEducation = (null != User_Education_Character_Course_Collection_Object.User_Education_Time_Collection.CharacterValueEducation) ?
User_Education_Character_Course_Collection_Object.User_Education_Time_Collection.CharacterValueEducation :
Const.InformationNotProvided,
AbsencePercentageForEducation = (null != User_Education_Character_Course_Collection_Object.User_Education_Time_Collection.AbsencePercentageEducation) ?
User_Education_Character_Course_Collection_Object.User_Education_Time_Collection.AbsencePercentageEducation :
Const.InformationNotProvided
};
jSon_Object = ListItemCourseCharacter;
}
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);
}