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