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