public QuoteDTO SaveQuote(QuoteDTO dto)
{
using (var context = new QuestionnaireEntities())
{
Quote dao = null;
if (dto.QuoteID != 0)
{
dao = context.Quotes.Where(q => q.Quote_ID == dto.QuoteID).FirstOrDefault();
}
else
{
dao = new Quote();
context.Quotes.Add(dao);
}
dao.Scheme_ID = dto.SchemeID;
dao.Reference = dto.Reference;
dao.QuoteDate = dto.QuoteDate;
context.SaveChanges();
QuestionnaireCacheManager.Instance.ClearListQuotesForDisplayFromCache();
dto.QuoteID = dao.Quote_ID;
}
return(dto);
}
public List <QuoteQuestionAnswerDTO> SaveAnswers(List <QuoteQuestionAnswerDTO> dtos)
{
using (var context = new QuestionnaireEntities())
{
Quote_Question_Answer dao = null;
foreach (QuoteQuestionAnswerDTO dto in dtos)
{
if (dto.QuoteQuestionAnswerID > 0)
{
//existing answer - load it
dao = context.Quote_Question_Answer.Find(dto.QuoteQuestionAnswerID);
}
else
{
//new answer
dao = new Quote_Question_Answer()
{
Quote_ID = dto.QuoteID,
Question_ID = dto.QuestionID
};
context.Quote_Question_Answer.Add(dao);
}
dao.Question_Possible_Answer_ID = dto.QuestionPossibleAnswerID;
dao.Answer = dto.Answer;
dto.QuoteQuestionAnswerID = dao.Quote_Question_Answer_ID;
}
context.SaveChanges();
//re-load questions to get question id's
dtos = ListAnswersByQuote(dtos[0].QuoteID);
}
return(dtos);
}
public QuestionTemplateDTO SaveQuestionTemplate(QuestionTemplateDTO dto)
{
using (var context = new QuestionnaireEntities())
{
Question_Template dao = null;
if (dto.QuestionTemplateID > 0)
{
dao = context.Question_Template.Find(dto.QuestionTemplateID);
}
else
{
dao = new Question_Template()
{
LastRenderDate = DateTime.Now
};
context.Question_Template.Add(dao);
}
dao.Name = dto.Name;
dao.Template = dto.Template;
dao.Question_Type_ID = dto.QuestionTypeID;
dao.LastRenderDate = dto.LastRenderDate;
context.SaveChanges();
dto.QuestionTemplateID = dao.Question_Template_ID;
QuestionnaireCacheManager.Instance.ClearQuestion(dto.QuestionTemplateID);
}
return(dto);
}
public void SaveQuestion(IQuestionDTO questionDTO)
{
var portalDb = new QuestionnaireEntities();
Question questionE = null;
if (questionDTO.QuestionId == -1)
{
questionE = new Question();
questionE.Text = questionDTO.Text;
questionE.Marks = questionDTO.Marks;
questionE.QuestionPaperNo = questionDTO.QuestionPaperNo;
portalDb.Questions.Add(questionE);
}
else
{
questionE = portalDb.Questions.SingleOrDefault(n => n.Id == questionDTO.QuestionId);
questionE.Text = questionDTO.Text;
questionE.Marks = questionDTO.Marks;
questionE.QuestionPaperNo = questionDTO.QuestionPaperNo;
}
portalDb.SaveChanges();
questionDTO.QuestionId = questionE.Id;
}
public void SavePaper(IPaperDTO paperDTO)
{
var portalDb = new QuestionnaireEntities();
QuestionPaper paperE = null;
if (paperDTO.PaperId == -1)
{
paperE = new QuestionPaper();
paperE.Name = paperDTO.Name;
paperE.Description = paperDTO.Description;
paperE.Duration = paperDTO.Duration;
portalDb.QuestionPapers.Add(paperE);
}
else
{
paperE = portalDb.QuestionPapers.SingleOrDefault(n => n.Id == paperDTO.PaperId);
paperE.Name = paperDTO.Name;
paperE.Description = paperDTO.Description;
paperE.Duration = paperDTO.Duration;
}
portalDb.SaveChanges();
paperDTO.PaperId = paperE.Id;
}
public void DeleteQuestion(int questionId)
{
var portalDb = new QuestionnaireEntities();
var questionE = portalDb.Questions.SingleOrDefault(n => n.Id == questionId);
portalDb.Questions.Remove(questionE);
portalDb.SaveChanges();
}
public void DeleteAnswers(List <QuoteQuestionAnswerDTO> dtos)
{
using (var context = new QuestionnaireEntities())
{
foreach (QuoteQuestionAnswerDTO dto in dtos)
{
var dao = context.Quote_Question_Answer.Find(dto.QuoteQuestionAnswerID);
if (dao != null)
{
context.Quote_Question_Answer.Remove(dao);
}
}
context.SaveChanges();
}
}
public bool DeletePaper(int paperId)
{
var portalDb = new QuestionnaireEntities();
var paperE = portalDb.QuestionPapers.SingleOrDefault(n => n.Id == paperId);
bool rv = false;
if (paperE.Questions.Count == 0)
{
portalDb.QuestionPapers.Remove(paperE);
rv = true;
}
portalDb.SaveChanges();
return(rv);
}
public RenderedPageDTO SaveRenderedPage(RenderedPageDTO dto)
{
using (var context = new QuestionnaireEntities())
{
Rendered_Page dao = null;
if (dto.RenderedPageID > 0)
{
//existing rendered page
dao = context.Rendered_Page.Find(dto.RenderedPageID);
}
else if (dto.PageID > 0 && context.Rendered_Page.Any(rp => rp.Page_ID == dto.PageID))
{
dao = context.Rendered_Page.Where(rp => rp.Page_ID == dto.PageID).FirstOrDefault();
}
else
{
dao = context.Rendered_Page.Where(rp => rp.Page_ID == dto.PageID).FirstOrDefault();
if (dao == null)
{
dao = new Rendered_Page()
{
Page_ID = dto.PageID
};
}
context.Rendered_Page.Add(dao);
}
dao.PageContent = dto.PageContent;
dao.LastRenderDate = dto.LastRenderDate;
context.SaveChanges();
int schemeId = (from s in context.Schemes
join p in context.Pages on s.Scheme_ID equals p.Scheme_ID
where p.Page_ID == dto.PageID
select s.Scheme_ID).First();
QuestionnaireCacheManager.Instance.ClearPage(dto.PageID, schemeId);
dto.RenderedPageID = dao.Rendered_Page_ID;
}
return(dto);
}
public PageTemplateDTO SavePageTemplate(PageTemplateDTO dto)
{
using (var context = new QuestionnaireEntities())
{
Page_Template dao = null;
if (dto.PageTemplateID > 0)
{
dao = context.Page_Template.Find(dto.PageTemplateID);
}
else
{
dao = new Page_Template();
context.Page_Template.Add(dao);
}
dao.Name = dto.Name;
dao.TemplateContent = dto.TemplateContent;
context.SaveChanges();
}
return(dto);
}
