public void DeleteAnswerToCharacteristic(int id) { using (OfficePoll2Entities entities = new OfficePoll2Entities()) { var answerToDelete = entities.Answers_to_the_Characteristics.Find(id); entities.Answers_to_the_Characteristics.Remove(answerToDelete); entities.SaveChanges(); } }
public void DeleteAnswerToTheQuestions(int id) { using (OfficePoll2Entities entities = new OfficePoll2Entities()) { var answerToDelete = entities.Answers_to_the_Questions.Find(id); entities.Answers_to_the_Questions.Remove(answerToDelete); entities.SaveChanges(); } }
public void DeleteCharacteristic(int id) { using (OfficePoll2Entities entities = new OfficePoll2Entities()) { var characteristicToDelete = entities.Characteristics.Find(id); entities.Characteristics.Remove(characteristicToDelete); entities.SaveChanges(); } }
public void CreateQuestion(String txt, DateTime date) { try { using (entities) { entities.Questions.Add(new Questions() { text = txt, date = date }); entities.SaveChanges(); } } catch (Exception ex) { Console.WriteLine(ex.Message); } }
public void UpdateCharacteristic(int id, String text) { using (OfficePoll2Entities entities = new OfficePoll2Entities()) { var characteristicToUpdate = entities.Characteristics.Find(id); characteristicToUpdate.text = text; entities.SaveChanges(); } }
public void DeleteAnswer(int CustomerId) { using (OfficePoll2Entities entities = new OfficePoll2Entities()) { var Answer = entities.Answering_the_Question.Find(CustomerId); entities.Answering_the_Question.Remove(Answer); entities.SaveChanges(); } }
public void UpdateAnswerToTheQuestions(int id, String text) { using (OfficePoll2Entities entities = new OfficePoll2Entities()) { var answerToUpdate = entities.Answers_to_the_Questions.Find(id); answerToUpdate.text = text; entities.SaveChanges(); } }
public void UpdateAnswerToCharacteristic(int id, String text, int char_id) { using (OfficePoll2Entities entities = new OfficePoll2Entities()) { var answerToUpdate = entities.Answers_to_the_Characteristics.Find(id); answerToUpdate.text = text; answerToUpdate.characteristic_id = char_id; entities.SaveChanges(); } }
public void CreateAnswerToTheQuestions(String txt, int question_id) { using (OfficePoll2Entities entities = new OfficePoll2Entities()) { entities.Answers_to_the_Questions.Add(new Answers_to_the_Questions() { text = txt, question_id = question_id }); entities.SaveChanges(); } }
public void CreateCharacteristic(String txt) { using (OfficePoll2Entities entities = new OfficePoll2Entities()) { entities.Characteristics.Add(new Characteristics() { text = txt }); entities.SaveChanges(); } }
public void CreateQuestion(String text, DateTime date) { using (entities) { entities.Questions.Add(new Questions() { text = text, date = date }); entities.SaveChanges(); } }
public void CreateAnswerToTheQuestions(int q_id, String text) { using (OfficePoll2Entities entities = new OfficePoll2Entities()) { entities.Answers_to_the_Questions.Add(new Answers_to_the_Questions() { question_id = q_id, text = text, type = 1 }); entities.SaveChanges(); } }
public void CreateAnswerToCharacteristic(String txt, int char_id) { using (OfficePoll2Entities entities = new OfficePoll2Entities()) { entities.Answers_to_the_Characteristics .Add(new Answers_to_the_Characteristics() { text = txt, characteristic_id = char_id }); entities.SaveChanges(); } }
public void CreateAnswer(int Question_id, int Question_answer_id, int Characteristic_id, int Characteristics_answers_id) { using (OfficePoll2Entities entities = new OfficePoll2Entities()) { entities.Answering_the_Question.Add( new Answering_the_Question() { question_id = Question_id , question_answer_id = Question_answer_id , characteristic_id = Characteristic_id , characteristic_answers_id = Characteristics_answers_id }); entities.SaveChanges(); } }
public void DeleteQuestion(int id) { try { using (OfficePoll2Entities entities = new OfficePoll2Entities()) { var question = entities.Questions.Find(id); IQueryable <Answers_to_the_Questions> answers = entities.Answers_to_the_Questions.Where(item => item.question_id == question.id); foreach (var a in answers) { var ans = entities.Answers_to_the_Questions.Find(a.id); entities.Answers_to_the_Questions.Remove(ans); } entities.Questions.Remove(question); entities.SaveChanges(); } } catch (Exception ex) { Console.WriteLine(ex.Message); } }