public async Task <bool> Add(TemplateServiceOrder templateServiceOrder)
{
templateServiceOrder.Id = Guid.NewGuid();
_context.Add(templateServiceOrder);
var remark = new TemplateServiceOrderQuestion();
remark.Id = Guid.NewGuid();
remark.TemplateServiceOrderId = templateServiceOrder.Id;
remark.Name = "**รายละเอีดยเพิ่มเติม";
remark.AnswerTypeId = 1;
remark.No = templateServiceOrder.TemplateServiceOrderQuestion.Count() + 1;
templateServiceOrder.TemplateServiceOrderQuestion.Add(remark);
foreach (var templateServiceOrderQuestion in templateServiceOrder.TemplateServiceOrderQuestion)
{
if (templateServiceOrderQuestion.AnswerTypeId != 1) // Type Text
{
foreach (var templateServiceOrderAnswer in templateServiceOrderQuestion.TemplateServiceOrderAnswer)
{
templateServiceOrderAnswer.TemplateServiceOrderQuestionId = templateServiceOrderQuestion.Id;
_context.Add(templateServiceOrderAnswer);
}
}
else
{
templateServiceOrderQuestion.TemplateServiceOrderAnswer?.Clear();
}
_context.Add(templateServiceOrderQuestion);
}
return(await _context.SaveChangesAsync() > 0);
}
public async Task <bool> UpdateTemplateServiceOrder(TemplateServiceOrder templateServiceOrder)
{
var template = await _context.TemplateServiceOrder.FirstOrDefaultAsync(f => f.Id == templateServiceOrder.Id && !f.IsDelete);
template.Name = templateServiceOrder.Name;
var remarkRemove = templateServiceOrder.TemplateServiceOrderQuestion.FirstOrDefault(f => f.Name == "**รายละเอีดยเพิ่มเติม");
templateServiceOrder.TemplateServiceOrderQuestion.Remove(remarkRemove); // remove remark
// remove all
var templateServiceOrderQuestionRemoveItem = await _context.TemplateServiceOrderQuestion.Where(f => f.TemplateServiceOrderId == templateServiceOrder.Id).ToListAsync();
foreach (var question in templateServiceOrderQuestionRemoveItem)
{
var templateServiceOrderAnswerRemoveItem = await _context.TemplateServiceOrderAnswer.Where(f => f.TemplateServiceOrderQuestionId == question.Id).ToListAsync();
_context.TemplateServiceOrderAnswer.RemoveRange(templateServiceOrderAnswerRemoveItem);
_context.TemplateServiceOrderQuestion.Remove(question);
}
var seved = await _context.SaveChangesAsync() > 0;
// re add
var remark = new TemplateServiceOrderQuestion();
remark.Id = Guid.NewGuid();
remark.TemplateServiceOrderId = template.Id;
remark.Name = "**รายละเอีดยเพิ่มเติม";
remark.AnswerTypeId = 1;
remark.No = templateServiceOrder.TemplateServiceOrderQuestion.Count() + 1;
templateServiceOrder.TemplateServiceOrderQuestion.Add(remark);
foreach (var templateServiceOrderQuestion in templateServiceOrder.TemplateServiceOrderQuestion)
{
templateServiceOrderQuestion.TemplateServiceOrderId = template.Id;
if (templateServiceOrderQuestion.AnswerTypeId != 1) // Type Text
{
foreach (var templateServiceOrderAnswer in templateServiceOrderQuestion.TemplateServiceOrderAnswer)
{
templateServiceOrderAnswer.TemplateServiceOrderQuestionId = templateServiceOrderQuestion.Id;
_context.Add(templateServiceOrderAnswer);
}
}
else
{
templateServiceOrderQuestion.TemplateServiceOrderAnswer?.Clear();
}
_context.Add(templateServiceOrderQuestion);
}
return(await _context.SaveChangesAsync() > 0);
}