public static string SoruCevapla(QuestionAnswers q)
{
try
{
DB_A151C9_beritankEntities db = new DB_A151C9_beritankEntities();
tblQuestionAnswers x = new tblQuestionAnswers()
{
QuestionID = q.QuestionID, AnswerUserID = q.AnswerUserID, AnswerText = q.AnswerText
};
db.tblQuestionAnswers.Add(x);
//var cevap = (from c in db.tblQuestionAnswers//gelen verinin içinde sorunun id sini kullanarak o soruya cevap ekledim
// where c.QuestionID == q.QuestionID
// select c
// ).SingleOrDefault();
//cevap.AnswerText = q.AnswerText;//Yorum kaydettim
//cevap.AnswerUserID = q.AnswerUserID;//yorum yazan kişiyi kaydettim
//cevap.Accuracy = q.Accuracy;
db.SaveChanges();
return("İşlem Başarılı");
}
catch (Exception)
{
return("İşlem Başarılı");
}
}
public ActionResult DeleteConfirmed(long id)
{
tblQuestionAnswers tblQuestionAnswers = db.tblQuestionAnswers.Find(id);
db.tblQuestionAnswers.Remove(tblQuestionAnswers);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "questionAnswerID,questionChoiceID,memberID")] tblQuestionAnswers tblQuestionAnswers)
{
if (ModelState.IsValid)
{
db.Entry(tblQuestionAnswers).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.memberID = new SelectList(db.tblMember, "memberId", "FirstName1", tblQuestionAnswers.memberID);
ViewBag.questionChoiceID = new SelectList(db.tblQuestionChoices, "questionChoiceID", "questionChoiceFull", tblQuestionAnswers.questionChoiceID);
return(View(tblQuestionAnswers));
}
public static tblQuestionAnswers MapData(QuestionAnswers k)
{
tblQuestionAnswers tk = new tblQuestionAnswers()
{
AnswerUserID = k.AnswerUserID,
Accuracy = k.Accuracy,
AnswerText = k.AnswerText,
QuestionAnserwsID = k.QuestionAnserwsID,
QuestionID = k.QuestionID
};
return(tk);//sınıftan gelen veriyi veritabanına gönderiyoruz formatlıyoruz veritabınına göre
}
public static QuestionAnswers MapData(tblQuestionAnswers k)
{
QuestionAnswers qa = new QuestionAnswers()
{
AnswerUserID = k.AnswerUserID,
Accuracy = k.Accuracy,
AnswerText = k.AnswerText,
QuestionAnserwsID = k.QuestionAnserwsID,
QuestionID = k.QuestionID//veritabanından gelen veriyi listeye çevirme
};
return(qa);
}
// GET: tblQuestionAnswers/Details/5
public ActionResult Details(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblQuestionAnswers tblQuestionAnswers = db.tblQuestionAnswers.Find(id);
if (tblQuestionAnswers == null)
{
return(HttpNotFound());
}
return(View(tblQuestionAnswers));
}
// GET: tblQuestionAnswers/Edit/5
public ActionResult Edit(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblQuestionAnswers tblQuestionAnswers = db.tblQuestionAnswers.Find(id);
if (tblQuestionAnswers == null)
{
return(HttpNotFound());
}
ViewBag.memberID = new SelectList(db.tblMember, "memberId", "FirstName1", tblQuestionAnswers.memberID);
ViewBag.questionChoiceID = new SelectList(db.tblQuestionChoices, "questionChoiceID", "questionChoiceFull", tblQuestionAnswers.questionChoiceID);
return(View(tblQuestionAnswers));
}