public bool updateQuestion(question updateQuest) { bool result = false; try { using (studentlearnEntities1 db = new studentlearnEntities1()) { var uQ = db.questions.Where(w => w.questionName == updateQuest.questionName).FirstOrDefault(); uQ.questionText = updateQuest.questionText; uQ.reply = updateQuest.reply; uQ.reply1 = updateQuest.reply1; uQ.reply2 = updateQuest.reply2; uQ.reply3 = updateQuest.reply3; uQ.reply4 = updateQuest.reply4; uQ.categoryID = updateQuest.categoryID; db.SaveChanges(); result = true; } } catch (Exception e) { MessageBox.Show("İşlem sırasında bir hata meydana geldi." + e); result = false; } return(result); }
public List <questionClass>[] getQuiz() { List <questionClass>[] quiz = new List <questionClass> [5]; int paragraf = 0, dilbilgisi = 0, anlatim = 0, siir = 0, divan = 0, userCount = 0; try { int id = Convert.ToInt32(LoginUser.userID); using (studentlearnEntities1 db = new studentlearnEntities1()) { userrate rateSearch = (from item in db.userrates where item.userID == id orderby item.date descending select item).FirstOrDefault(); if (rateSearch != null) { paragraf = rateSearch.paragraf; dilbilgisi = rateSearch.dilbilgisi; anlatim = rateSearch.anlatim; siir = rateSearch.siir; divan = rateSearch.divan; userCount++; } else { MessageBox.Show("Bu sınava kayıtlı değilsiniz."); } } } catch (Exception e) { MessageBox.Show("İşlem sırasında bir hata meydana geldi." + e); } LoginUser.paragraf = paragraf; LoginUser.dilbilgisi = dilbilgisi; LoginUser.anlatim = anlatim; LoginUser.siir = siir; LoginUser.divan = divan; quiz[0] = getQuestion("notNull", 1, paragraf); quiz[1] = getQuestion("notNull", 2, dilbilgisi); quiz[2] = getQuestion("notNull", 3, anlatim); quiz[3] = getQuestion("notNull", 4, siir); quiz[4] = getQuestion("notNull", 5, divan); return(quiz); }
/* Öğrenci, Öğretmen ve Admin Girişi */ public string[] userLogin(string userName, string pass) { string[] userData = new string[4]; try { Tools appTool = new Tools(); pass = appTool.MD5Convert(pass); int userLoginCount = 0; int id = Convert.ToInt32(LoginUser.userID); using (studentlearnEntities1 db = new studentlearnEntities1()) { user loginCommand = (from item in db.users where item.username == userName select item).FirstOrDefault(); if (loginCommand != null) { if (loginCommand.pass == pass) { userData[0] = loginCommand.id.ToString(); userData[1] = loginCommand.name; userData[2] = loginCommand.username; userData[3] = loginCommand.authority.ToString(); } else { userData[0] = "PAROLA_HATASI"; } userLoginCount++; } } if (userLoginCount != 1) { userData = null; } } catch (Exception) { MessageBox.Show("İşlem sırasında bir hata meydana geldi."); } return(userData); }
public bool deleteQuestion(int qid) { bool result = false; try { using (studentlearnEntities1 db = new studentlearnEntities1()) { var deleteQuestion = db.questions.Where(w => w.id == qid).FirstOrDefault(); db.questions.Remove(deleteQuestion); db.SaveChanges(); result = true; } } catch (Exception e) { MessageBox.Show("İşlem sırasında bir hata meydana geldi." + e); result = false; } return(result); }
public bool addQuestion(question quest) { bool result = false; try { using (studentlearnEntities1 db = new studentlearnEntities1()) { db.questions.Add(quest); db.SaveChanges(); result = true; } } catch (Exception e) { MessageBox.Show("İşlem sırasında bir hata meydana geldi." + e); result = false; mainConnect(); } return(result); }
public void saveQuiz(quiz newQuiz) { try { using (studentlearnEntities1 db = new studentlearnEntities1()) { db.quizs.Add(newQuiz); db.SaveChanges(); } } catch (Exception e) { MessageBox.Show("İşlem sırasında bir hata meydana geldi." + e); } calcRate(); try { userrate newUserRate = new userrate(); newUserRate.userID = Convert.ToInt32(LoginUser.userID); newUserRate.paragraf = LoginUser.paragraf; newUserRate.dilbilgisi = LoginUser.dilbilgisi; newUserRate.anlatim = LoginUser.anlatim; newUserRate.siir = LoginUser.siir; newUserRate.divan = LoginUser.divan; newUserRate.date = DateTime.Now; using (studentlearnEntities1 db = new studentlearnEntities1()) { db.userrates.Add(newUserRate); db.SaveChanges(); } } catch (Exception e) { MessageBox.Show("İşlem sırasında bir hata meydana geldi." + e); } }
public bool quizLoginControl() { bool quizLogin = true; try { int id = Convert.ToInt32(LoginUser.userID); using (studentlearnEntities1 db = new studentlearnEntities1()) { quiz canEnter = (from enter in db.quizs where enter.userID == id && enter.date.Day == DateTime.Today.Day && enter.date.Month == DateTime.Today.Month && enter.date.Year == DateTime.Today.Year select enter).FirstOrDefault(); if (canEnter != null) { quizLogin = false; } } } catch (Exception e) { MessageBox.Show("İşlem sırasında bir hata meydana geldi." + e); } return(quizLogin); }