public static UserDTO GetPostUser(UserDTO userDto, ref string mass)
{
using (TeacherForStudentEntities db = new TeacherForStudentEntities())
{
User IsExitsUserName = db.User.ToList().FirstOrDefault(u => u.UserName == userDto.UserName);
User IsExitsUserMail = db.User.ToList().FirstOrDefault(u => u.UserMail == userDto.UserMail);
if (IsExitsUserMail != null && IsExitsUserName != null)
{
mass = "קיים שם משתמש וכתובת אמייל זהים במערכת, אנא הזן פרטים יחודיים";
return(null);
}
if (IsExitsUserName != null)
{
mass = "קיים שם משתמש זהה במערכת, אנא הקש שם משתמש יחודי";
return(null);
}
if (IsExitsUserMail != null)
{
mass = "קיימת כתובת אמייל זהה במערכת, אנא הקש כתובת אמייל יחודית";
return(null);
}
db.User.Add(Convertion.userConvertion.ConvertToUser(userDto));
db.SaveChanges();
return(Convertion.userConvertion.ConvertToDto(Convertion.userConvertion.ConvertToUser(userDto)));
}
}
public static UserDTO Login(string password, string name)
{
using (TeacherForStudentEntities db = new TeacherForStudentEntities())
{
User userf = new User();
userf = db.User.ToList().FirstOrDefault(x => x.UserPassword == password || x.UserName == name);
return(Convertion.userConvertion.ConvertToDto(userf));
}
}
public static ProffestionsDTO GetProffestion(int id)
{
Proffestions pro = new Proffestions();
using (TeacherForStudentEntities db = new TeacherForStudentEntities())
{
pro = db.Proffestions.ToList().FirstOrDefault(p => p.ProffestionId == id);
}
return(Convertion.ProffestionConvertion.ConvertToDTO(pro));
}
public static List <ProffestionsDTO> GetAllQuestions()
{
List <ProffestionsDTO> proffestions = new List <ProffestionsDTO>();
using (TeacherForStudentEntities db = new TeacherForStudentEntities())
{
db.Proffestions.ToList().ForEach(pro =>
proffestions.Add(Convertion.ProffestionConvertion.ConvertToDTO(pro)));
}
return(proffestions);
}
public static UserQuestionDTO GetQuestionById(int id)
{
using (TeacherForStudentEntities db = new TeacherForStudentEntities())
{
UserQuestionDTO question = new UserQuestionDTO();
db.Questions.ToList().ForEach(x =>
{
if (x.QuestionId == id)
{
question = Convertion.QuestionConvertion.ConvertToUserQuestionDTO(x);
}
});
return(question);
}
}
public static List <UserQuestionDTO> GetAllQuestion()
{
using (TeacherForStudentEntities db = new TeacherForStudentEntities())
{
List <UserQuestionDTO> questions = new List <UserQuestionDTO>();
db.Questions.ToList().ForEach(x =>
{
if (x.Answers.Count() == 0)
{
questions.Add(Convertion.QuestionConvertion.ConvertToUserQuestionDTO(x));
}
});
return(questions);
}
}
//public static AnswerDTO GetPostAnswer(AnswerDTO answerdto)
//{
// try
// {
// using (TeacherForStudentEntities db = new TeacherForStudentEntities())
// {
// db.Answers.Add(Convertion.AnswerConvertion.ConvertToAnswer(answerdto));
// db.SaveChanges();
// return Convertion.AnswerConvertion.ConvertToDTO(Convertion.AnswerConvertion.ConvertToAnswer(answerdto));
// }
// }
// catch (Exception)
// {
// return null;
// }
//}
public static QuestionsDTO GetPostQuestion(QuestionsDTO questiondto)
{
try
{
using (TeacherForStudentEntities db = new TeacherForStudentEntities())
{
db.Questions.Add(Convertion.QuestionConvertion.ConvertToQustion(questiondto));
db.SaveChanges();
return(Convertion.QuestionConvertion.ConvertToDTO(Convertion.QuestionConvertion.ConvertToQustion(questiondto)));
}
}
catch (Exception)
{
return(null);
}
}
public static bool PutAddClassToTeacher(List <UserToClassDTO_> classes)
{
try
{
using (TeacherForStudentEntities db = new TeacherForStudentEntities())
{
foreach (var item in classes)
{
db.UserToClass.Add(Convertion.UserToClassConvertion.ConvertToUserToClass(item));
}
}
return(true);
}
catch (Exception)
{
return(false);
}
}
public static UserDTO Put(int id, UserDTO userdto)
{
try
{
using (TeacherForStudentEntities db = new TeacherForStudentEntities())
{
///////////האם משנה באמת
User user = db.User.FirstOrDefault(u => u.UserId == id);
user.UserMail = userdto.UserMail;
db.SaveChanges();
return(Convertion.userConvertion.ConvertToDto(user));
}
}
catch (Exception)
{
return(null);
}
}
public static UserQuestionDTO ConvertToUserQuestionDTO(Questions question)
{
using (TeacherForStudentEntities db = new TeacherForStudentEntities())
{
UserQuestionDTO userQuestion = new UserQuestionDTO();
userQuestion.OuestionTitle = question.OuestionTitle;
userQuestion.QuestionId = question.QuestionId;
userQuestion.QuestionContent = question.QuestionContent;
userQuestion.QuestionDate = question.QuestionDate;
userQuestion.QuestionView = question.QuestionView;
userQuestion.ProffestionName = (db.Proffestions.FirstOrDefault(p => p.ProffestionId == question.ProffestionId)).ProffestionName;
User user = db.User.FirstOrDefault(u => u.UserId == question.UserId);
userQuestion.UserKind = user.UserKind;
userQuestion.UserMail = user.UserMail;
userQuestion.UserName = user.UserName;
userQuestion.UserId = user.UserId;
return(userQuestion);
}
}
public static bool PutAddProfestionToTeacher(int id, List <ProffestionsDTO> proffestions)
{
try
{
using (TeacherForStudentEntities db = new TeacherForStudentEntities())
{
db.User.ToList().ForEach(x =>
{
if (x.UserId == id)
{
foreach (var item in proffestions)
{
x.Proffestions.Add(Convertion.ProffestionConvertion.ConvertToProffestion(item));
}
}
});
}
return(true);
}
catch (Exception)
{
return(false);
}
}
