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