public ActionResult ChangeMail(User model)
{
ModelState.Remove("UserName");
ModelState.Remove("Password");
ModelState.Remove("Name");
ModelState.Remove("SurName");
if (ModelState.IsValid)
{
using (QuestionBankDbContext Db = new QuestionBankDbContext())
{
List <User> lst = Db.User.ToList();
User user = lst.SingleOrDefault(x => x.UserName.Equals(User.Identity.Name));
if (lst.SingleOrDefault(x => x.Mail.Equals(model.Mail) && x.ID != user.ID) == null)
{
user.Mail = model.Mail;
Db.Entry(user).State = System.Data.Entity.EntityState.Modified;
Db.SaveChanges();
TempData["Message"] = $"<div class='alert alert-success'><strong>Başarılı!</strong> Bilgileriniz Başarıyla Güncellendi... </div>";
}
else
{
TempData["Message"] = $"<div class='alert alert-danger'><strong>Hata!</strong> Mail adresi kullanılıyor... </div>";
}
}
}
return(Redirect("Profil#tab_1_4"));
}
public string Delete(int ID)
{
string message = string.Empty;
using (QuestionBankDbContext Db = new QuestionBankDbContext())
{
Question question = Db.Question.SingleOrDefault(x => x.ID.Equals(ID));
if (question != null)
{
ExamQuestions LstQuestionInExam = Db.ExamQuestions.SingleOrDefault(x => x.QuestionID.Equals(ID));
if (LstQuestionInExam != null)
{
Db.ExamQuestions.Remove(LstQuestionInExam);
}
List <Answers> lstquestionanswers = Db.Answers.RemoveRange(Db.Answers.Where(x => x.QuestionID.Equals(ID))).ToList();
Db.Question.Remove(question);
Db.SaveChanges();
message = JsonConvert.SerializeObject(new { durum = "OK", mesaj = "Soru Silindi" });
}
else
{
message = JsonConvert.SerializeObject(new { durum = "No", mesaj = "Soru Silinemedi" });
}
}
return(message);
}
public ActionResult Login(User model, string ReturnUrl)
{
ModelState.Remove("UserName");
ModelState.Remove("Name");
ModelState.Remove("SurName");
if (ModelState.IsValid)
{
using (QuestionBankDbContext db = new QuestionBankDbContext())
{
User user = db.User.SingleOrDefault(x => x.Mail == model.Mail && x.Password == model.Password);
if (user != null)
{
FormsAuthentication.SetAuthCookie(user.UserName, true);
if (!string.IsNullOrWhiteSpace(ReturnUrl))
{
return(Redirect(ReturnUrl));
}
return(RedirectToRoute("Home"));
}
}
ViewBag.Message = "<div class='alert alert-danger display'><button class='close' data-close='alert'></button><span> Böyle bir kullanıcı yoktur... </span></div>";
}
return(View(model));
}
// GET: Topic
public ActionResult Index()
{
QuestionBankDbContext db = new QuestionBankDbContext();
List <UserLesson> ders = db.UserLesson.Where(x => x.User.UserName.Equals(User.Identity.Name)).ToList();
return(View(ders));
}
public ActionResult ChangePassword(User model)
{
ModelState.Remove("UserName");
ModelState.Remove("Name");
ModelState.Remove("SurName");
ModelState.Remove("Mail");
if (ModelState.IsValid)
{
using (QuestionBankDbContext Db = new QuestionBankDbContext())
{
User user = Db.User.SingleOrDefault(x => x.UserName.Equals(User.Identity.Name));
if (user.Password.Equals(model.Password))
{
user.Password = model.NewPassword;
Db.Entry(user).State = System.Data.Entity.EntityState.Modified;
Db.SaveChanges();
TempData["Message"] = $"<div class='alert alert-success'><strong>Başarılı!</strong> Şifreniz Başarıyla Güncellendi... </div>";
}
else
{
TempData["Message"] = $"<div class='alert alert-danger'><strong>Hata!</strong> MEvcut Şifreniz yanlış... </div>";
}
}
}
else
{
TempData["Message"] = $"<div class='alert alert-danger'><strong>Hata!</strong> Şifre Bilgilerinde hata oluştu... </div>";
}
return(Redirect("Profil#tab_1_3"));
}
public string Delete(int ID)
{
string message = string.Empty;
using (QuestionBankDbContext Db = new QuestionBankDbContext())
{
Lesson ders = Db.Lesson.SingleOrDefault(x => x.ID.Equals(ID));
if (ders != null)
{
IEnumerable <UserLesson> dersles = Db.UserLesson.RemoveRange(Db.UserLesson.Where(x => x.LessonID.Equals(ID)));
List <Topic> LstLessonTopics = new List <Topic>();
foreach (var item in ders.Topic)
{
foreach (var lstquestion in item.Questions)
{
List <Answers> LstTopicQuestionsAnswers = Db.Answers.RemoveRange(Db.Answers.Where(x => x.QuestionID.Equals(lstquestion.ID))).ToList();
ExamQuestions LstQuestionInExam = Db.ExamQuestions.Remove(Db.ExamQuestions.SingleOrDefault(x => x.QuestionID.Equals(lstquestion.ID)));
}
List <Question> DeleteTopicQuestions = Db.Question.RemoveRange(Db.Question.Where(x => x.TopicID.Equals(item.ID))).ToList();
List <TopicQuestionPeriod> periods = Db.TopicQuestionPeriod.RemoveRange(Db.TopicQuestionPeriod.Where(x => x.TopicID.Equals(item.ID))).ToList();
LstLessonTopics.Add(item);
}
Db.Topic.RemoveRange(LstLessonTopics);
Db.Lesson.Remove(ders);
Db.SaveChanges();
message = JsonConvert.SerializeObject(new { durum = "OK", mesaj = "Ders Silindi" });
}
else
{
message = JsonConvert.SerializeObject(new { durum = "No", mesaj = "Ders Silinemedi" });
}
}
return(message);
}
private void PostUserLessonAndPeriod()
{
QuestionBankDbContext db = new QuestionBankDbContext();
ViewBag.UserLessons = db.UserLesson.Where(x => x.User.UserName.Equals(User.Identity.Name)).ToList();
ViewBag.QuestionPeriod = db.QuestionPeriod.ToList();
}
// GET: Users
public ActionResult Index()
{
using (QuestionBankDbContext Db = new QuestionBankDbContext())
{
return(View(Db.User.ToList()));
}
}
public string AddQuestion(QuestionAddViewModel model)
{
Question question = new Question
{
Question1 = model.Question,
QuestionTypeID = model.QuestionTypeID,
QuestionPeriodID = model.PeriodID,
Point = model.SoruPuan,
Time = model.SoruSure,
TopicID = model.TopicID
};
QuestionBankDbContext Db = new QuestionBankDbContext();
Db.Question.Add(question);
Db.SaveChanges();
List <Answers> lst = new List <Answers>();
foreach (var item in model.Answers)
{
Answers answers = new Answers
{
QuestionID = question.ID,
Answer = item.AnswerContent,
IsItTrue = item.Val
};
lst.Add(answers);
}
Db.Answers.AddRange(lst);
Db.SaveChanges();
return(JsonConvert.SerializeObject(new { durum = "OK", mesaj = "Soru başarıyla eklendi" }));
}
public ActionResult Edit(Topic topic, int[] periods)
{
if (ModelState.IsValid && periods != null)
{
QuestionBankDbContext Db = new QuestionBankDbContext();
Topic konu = Db.Topic.SingleOrDefault(x => x.ID.Equals(topic.ID));
konu.TopicName = topic.TopicName;
List <TopicQuestionPeriod> Silinecekler = Db.TopicQuestionPeriod.Where(x => x.TopicID.Equals(topic.ID)).ToList();
Db.TopicQuestionPeriod.RemoveRange(Silinecekler);
foreach (var item in periods)
{
Db.TopicQuestionPeriod.Add(new TopicQuestionPeriod()
{
QuestionPeriodID = item, TopicID = konu.ID
});
}
Db.SaveChanges();
var model = new TopicEditViewModel(konu.ID);
ViewBag.Message = $"<div class='alert alert-success'><strong>Konu Başarıyla güncellendi...</strong> </div>";
return(View(model));
}
else
{
ViewBag.Message = $"<div class='alert alert-danger'><strong>Hata!</strong> Konunun en az bir dönemi olmalı... </div>";
return(View());
}
}
public string Delete(int ID)
{
string message = string.Empty;
using (QuestionBankDbContext Db = new QuestionBankDbContext())
{
Topic topic = Db.Topic.SingleOrDefault(x => x.ID.Equals(ID));
if (topic != null)
{
foreach (var item in topic.Questions)
{
List <Answers> LstTopicQuestionsAnswers = Db.Answers.RemoveRange(Db.Answers.Where(x => x.QuestionID.Equals(item.ID))).ToList();
ExamQuestions LstQuestionInExam = Db.ExamQuestions.Remove(Db.ExamQuestions.SingleOrDefault(x => x.QuestionID.Equals(item.ID)));
}
List <Question> LstTopicQuestions = Db.Question.RemoveRange(Db.Question.Where(x => x.TopicID.Equals(ID))).ToList();
List <TopicQuestionPeriod> periods = Db.TopicQuestionPeriod.RemoveRange(Db.TopicQuestionPeriod.Where(x => x.TopicID.Equals(ID))).ToList();
Db.Topic.Remove(topic);
Db.SaveChanges();
message = JsonConvert.SerializeObject(new { durum = "OK", mesaj = "Konu Silindi" });
}
else
{
message = JsonConvert.SerializeObject(new { durum = "No", mesaj = "Konu Silinemedi" });
}
}
return(message);
}
private void PostUserLessons()
{
QuestionBankDbContext Db = new QuestionBankDbContext();
User user = Db.User.SingleOrDefault(x => x.UserName.Equals(User.Identity.Name));
ViewBag.UserLessons = Db.UserLesson.Where(x => x.UserID.Equals(user.ID)).ToList();
}
public ActionResult ExamShow(int ID)
{
QuestionBankDbContext Db = new QuestionBankDbContext();
var model = Db.ExamQuestions.Where(x => x.ExamID.Equals(ID)).ToList();
return(View(Db.ExamQuestions.Where(x => x.ExamID.Equals(ID)).ToList()
));
}
public ActionResult Add()
{
using (QuestionBankDbContext Db = new QuestionBankDbContext())
{
ViewBag.Lessons = Db.Lesson.ToList();
}
return(View());
}
public ActionResult Index()
{
QuestionBankDbContext Db = new QuestionBankDbContext();
List <Question> questions = Db.Question.ToList();
User user = Db.User.SingleOrDefault(x => x.UserName.Equals(User.Identity.Name));
int[] userLessons = Db.UserLesson.Where(x => x.UserID.Equals(user.ID)).Select(x => x.LessonID).ToArray();
questions = questions.Where(x => userLessons.Contains(x.Topic.LessonID)).ToList();
return(View(questions));
}
public ActionResult Add()
{
QuestionBankDbContext Db = new QuestionBankDbContext();
List <Lesson> lst = Db.Lesson.ToList();
int[] userLessons = Db.UserLesson.Where(x => x.User.UserName.Equals(User.Identity.Name)).Select(x => x.LessonID).ToArray();
lst = Db.Lesson.Where(x => userLessons.Contains(x.ID)).ToList();
return(View(lst));
}
public ActionResult Edit(int ID)
{
using (QuestionBankDbContext db = new QuestionBankDbContext())
{
Lesson ders = db.Lesson.SingleOrDefault(x => x.ID.Equals(ID));
if (ders != null)
{
return(View(ders));
}
}
return(RedirectToRoute("Lessons"));
}
public ActionResult ProfileDetail()
{
using (QuestionBankDbContext Db = new QuestionBankDbContext())
{
if (TempData["Message"] != null)
{
ViewBag.Message = TempData["Message"].ToString();
}
return(View(Db.User.SingleOrDefault(x => x.UserName.Equals(User.Identity.Name))));
}
}
public ActionResult Edit(int ID)
{
QuestionBankDbContext Db = new QuestionBankDbContext();
User user = Db.User.SingleOrDefault(x => x.ID.Equals(ID));
ViewBag.UserLessons = user.UserLesson.Select(x => x.LessonID).ToList <int>();
ViewBag.Lessons = Db.Lesson.ToList();
if (user != null)
{
return(View(user));
}
return(RedirectToAction("Users"));
}
public ActionResult LessonTopicsList(int LessonID)
{
QuestionBankDbContext Db = new QuestionBankDbContext();
List <Topic> lsttopics = Db.Topic.ToList();
if (LessonID == 0)
{
lsttopics = null;
}
else
{
lsttopics = Db.Topic.Where(x => x.LessonID == LessonID).ToList();
}
return(PartialView(lsttopics));
}
public ActionResult ChangePhoto(HttpPostedFileBase image)
{
if (image != null)
{
using (QuestionBankDbContext Db = new QuestionBankDbContext())
{
User user = Db.User.SingleOrDefault(x => x.UserName.Equals(User.Identity.Name));
user.Photo = FileUpload.FileName(image, FileUpload.UploadFolder.Profile);
Db.Entry(user).State = System.Data.Entity.EntityState.Modified;
Db.SaveChanges();
TempData["Message"] = $"<div class='alert alert-success'><strong>Başarılı!</strong> Profil Fotoğrafınız Başarıyla Güncellendi... </div>";
}
}
return(Redirect("Profil#tab_1_2"));
}
public ActionResult Add(User model, int[] lessonsIDs)
{
if (ModelState.IsValid)
{
using (QuestionBankDbContext Db = new QuestionBankDbContext())
{
if (Db.User.ToList().SingleOrDefault(x => x.Mail.Equals(model.Mail)) == null)
{
if (Db.User.ToList().SingleOrDefault(x => x.UserName.Equals(model.UserName)) == null)
{
Db.Entry(model).State = System.Data.Entity.EntityState.Added;
foreach (int item in lessonsIDs)
{
UserLesson UserLes = new UserLesson {
LessonID = item, UserID = model.ID
};
Db.Entry(UserLes).State = System.Data.Entity.EntityState.Added;
}
Db.SaveChanges();
ViewBag.Message = $"<div class='alert alert-success'><strong>Başarılı!</strong> Kullanıcı Başarıyla Eklendi... </div>";
ModelState.Clear();
}
else
{
ViewBag.Message = $"<div class='alert alert-danger'><strong>Hata!</strong> Bu kullanıcı adı zaten kullanılıyor... </div>";
}
}
else
{
ViewBag.Message = $"<div class='alert alert-danger'><strong>Hata!</strong> Bu mail zaten kullanılıyor... </div>";
}
}
using (QuestionBankDbContext Db = new QuestionBankDbContext())
{
ViewBag.Lessons = Db.Lesson.ToList();
}
}
return(View());
}
public ActionResult Edit(Lesson model)
{
if (ModelState.IsValid)
{
using (QuestionBankDbContext db = new QuestionBankDbContext())
{
if (db.Lesson.SingleOrDefault(x => x.LessonName.Equals(model.LessonName) && x.ID != model.ID) == null)
{
db.Entry(model).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
ViewBag.Message = $"<div class='alert alert-success'><strong>Başarılı! </strong>{model.LessonName} Dersi Başarıyla Güncellendi... </div>";
ModelState.Clear();
}
else
{
ViewBag.Message = $"<div class='alert alert-danger'><strong>Hata! </strong>{model.LessonName} dersi zaten mevcuttur... </div>";
}
}
}
return(View(model));
}
public ActionResult Add(ExamPrepareViewModel model)
{
QuestionBankDbContext Db = new QuestionBankDbContext();
PostUserLessonAndPeriod();
if (string.IsNullOrWhiteSpace(model.SinavAdi) || model.SeciliSorular == null)
{
if (Db.Exam.SingleOrDefault(x => x.ExamName.Equals(model.SinavAdi)) == null)
{
ViewBag.ErrorMessage = "Bu isimde sınav mevcuttur lütfen başka sınav ismi giriniz.";
return(View());
}
ViewBag.ErrorMessage = "Lütfen Sınav adı belirleyin veya soru seçiniz...";
return(View());
}
else
{
Exam exam = new Exam()
{
ExamName = model.SinavAdi
};
Db.Exam.Add(exam);
List <ExamQuestions> lstQuestions = new List <ExamQuestions>();
foreach (var item in model.SeciliSorular)
{
ExamQuestions examquestions = new ExamQuestions()
{
QuestionID = item,
ExamID = exam.ID,
};
lstQuestions.Add(examquestions);
}
Db.ExamQuestions.AddRange(lstQuestions);
Db.SaveChanges();
ViewBag.Message = exam.ExamName + " Sınavı başarıyla oluşturulmuştur...";
}
return(View());
}
public string GetLessonsTopic(int ID)
{
QuestionBankDbContext db = new QuestionBankDbContext();
List <Topic> lst = db.Topic.Where(x => x.LessonID.Equals(ID)).ToList();
List <QuestionAddJsonModel> jsonLst = new List <QuestionAddJsonModel>();
foreach (var lesson in lst)
{
QuestionAddJsonModel model = new QuestionAddJsonModel();
model.TopicID = lesson.ID;
model.TopicName = lesson.TopicName;
foreach (var item in lesson.TopicQuestionPeriod)
{
PeriodJson periodJson = new PeriodJson();
periodJson.PeriodID = item.QuestionPeriod.ID;
periodJson.PeriodName = item.QuestionPeriod.QuestionPeriodName;
model.Period.Add(periodJson);
}
jsonLst.Add(model);
}
return(JsonConvert.SerializeObject(jsonLst));
}
public ActionResult LessonPeriodQuestions(ExamPrepareViewModel model)
{
if (model.DersID == 0 || model.DonemID == 0)
{
PostUserLessonAndPeriod();
ViewBag.ErrorMessage = "Hata! Lütfen ders ve soru dönemini seçiniz ";
return(View("Add"));
}
else
{
PostUserLessonAndPeriod();
QuestionBankDbContext Db = new QuestionBankDbContext();
List <ExamPrepareViewModel> lstquestions = new List <ExamPrepareViewModel>();
foreach (var item in Db.Question.Where(x => x.Topic.LessonID.Equals(model.DersID) && x.QuestionPeriodID.Equals(model.DonemID)).ToList())
{
ExamPrepareViewModel newquestions = new ExamPrepareViewModel();
newquestions.questions = item;
lstquestions.Add(newquestions);
}
return(View("Add", lstquestions));
}
}
public string Delete(int ID)
{
string message = string.Empty;
using (QuestionBankDbContext Db = new QuestionBankDbContext())
{
User user = Db.User.SingleOrDefault(x => x.ID.Equals(ID) && !x.UserName.Equals(User.Identity.Name));
if (user != null)
{
List <UserLesson> userles = Db.UserLesson.RemoveRange(Db.UserLesson.Where(x => x.UserID == ID)).ToList();
Db.User.Remove(user);
Db.SaveChanges();
message = JsonConvert.SerializeObject(new { durum = "OK", mesaj = "Kullanıcı Silindi" });
}
else
{
message = JsonConvert.SerializeObject(new { durum = "No", mesaj = "Kullanıcı Silinemedi" });
}
}
return(message);
}
public String Delete(int ID)
{
string message = string.Empty;
using (QuestionBankDbContext Db = new QuestionBankDbContext())
{
Exam exam = Db.Exam.SingleOrDefault(x => x.ID.Equals(ID));
if (exam != null)
{
List <ExamQuestions> examquestions = Db.ExamQuestions.RemoveRange(Db.ExamQuestions.Where(x => x.ExamID.Equals(ID))).ToList();
Db.Exam.Remove(exam);
Db.SaveChanges();
message = JsonConvert.SerializeObject(new { durum = "OK", mesaj = "Sınav Silindi" });
}
else
{
message = JsonConvert.SerializeObject(new { durum = "No", mesaj = "Sınav Silinemedi" });
}
}
return(message);
}
public ActionResult Add(Topic model, int[] periods)
{
QuestionBankDbContext db = new QuestionBankDbContext();
if (ModelState.IsValid)
{
if (db.Topic.SingleOrDefault(x => x.TopicName.Equals(model.TopicName)) == null)
{
db.Topic.Add(model);
db.SaveChanges();
List <TopicQuestionPeriod> lst = new List <TopicQuestionPeriod>();
foreach (int item in periods)
{
TopicQuestionPeriod konuSoruDonemi = new TopicQuestionPeriod
{
TopicID = model.ID,
QuestionPeriodID = item
};
lst.Add(konuSoruDonemi);
}
db.TopicQuestionPeriod.AddRange(lst);
db.SaveChanges();
ViewBag.Message = $"<div class='alert alert-success'><strong>Başarılı!</strong> Konu Başarıyla Eklendi... </div>";
ModelState.Clear();
}
else
{
ViewBag.Message = $"<div class='alert alert-danger'><strong>Hata! </strong>{model.TopicName} konusu zaten mevcuttur... </div>";
}
}
PostQuestionPeriod();
PostUserLessons();
return(View(model));
}
public ActionResult Edit(QuestionAddViewModel model)
{
QuestionBankDbContext Db = new QuestionBankDbContext();
Question soru = Db.Question.SingleOrDefault(x => x.ID.Equals(model.QuestionID));
soru.TopicID = model.TopicID;
soru.QuestionTypeID = model.QuestionTypeID;
soru.Question1 = model.Question;
soru.Point = model.SoruPuan;
soru.Time = model.SoruSure;
List <Answers> Silinecekler = Db.Answers.Where(x => x.QuestionID.Equals(model.QuestionID)).ToList();
Db.Answers.RemoveRange(Silinecekler);
List <Answers> lst = new List <Answers>();
foreach (var item in model.Answers)
{
Answers answers = new Answers
{
QuestionID = model.QuestionID,
Answer = item.AnswerContent,
IsItTrue = item.Val
};
lst.Add(answers);
}
Db.Answers.AddRange(lst);
Db.SaveChanges();
var modelview = new QuestionEditViewModel(soru.ID);
ViewBag.Message = $"<div class='alert alert-success'><strong> Soru Başarıyla güncellendi...</strong> </div>";
return(View(modelview));
}
