public ResponseModel <string> CreateTemplate(List <CreateTemplateQuestionInfoModel> req, string username)
{
var response = new ResponseModel <string>();
var keyInfo = _db.CreateTemplateQuestionInfoes.FirstOrDefault();
var refKey = username;
var digitKey = 0;
if (keyInfo != null)
{
digitKey = _db.CreateTemplateQuestionInfoes.Max(x => x.Id) + 1;
}
else
{
digitKey = 1;
}
refKey += digitKey;
var createTemplateQuestionsInfoInsert = new CreateTemplateQuestionInfo
{
buttonText = "NA",
username = username,
title = req[0].title,
visible = "NA",
type = "NA",
creationTime = DateTime.Now.ToString(CultureInfo.InvariantCulture),
referenceId = refKey,
total = "NA",
completed = "NA",
verified = "NA"
};
_db.CreateTemplateQuestionInfoes.Add(createTemplateQuestionsInfoInsert);
try
{
_db.SaveChanges();
CreateSubTemplateByRefKey CreateSubTemplateByRefKey = new CreateSubTemplateByRefKey();
CreateSubTemplateByRefKey.CreateSubTemplateByRefKeyService(req, username, refKey);
response.Status = 200;
response.Message = "success-" + digitKey;
response.Payload = refKey;
}
catch (DbEntityValidationException e)
{
DbContextException.LogDbContextException(e);
response.Status = 500;
response.Message = "Failed";
response.Payload = "Exception Occured";
}
return(response);
}
public ResponseModel <string> CreateTemplateWithId(List <CreateTemplateQuestionInfoModel> req, string username, string id)
{
var response = new ResponseModel <string>();
var refKey = username + id;
var createTemplateQuestionsInfoInsert = new CreateTemplateQuestionInfo
{
buttonText = "NA",
username = username,
title = req[0].title,
visible = "NA",
type = "NA",
creationTime = DateTime.Now.ToString(CultureInfo.InvariantCulture),
referenceId = refKey,
total = "NA",
completed = "NA",
verified = "NA"
};
_db.CreateTemplateQuestionInfoes.Add(createTemplateQuestionsInfoInsert);
try
{
_db.SaveChanges();
CreateSubTemplateByRefKey CreateSubTemplateByRefKey = new CreateSubTemplateByRefKey();
CreateSubTemplateByRefKey.CreateSubTemplateByRefKeyService(req, username, refKey);
response.Status = 200;
response.Message = "Success";
response.Payload = "Successfully Created";
}
catch (DbEntityValidationException e)
{
DbContextException.LogDbContextException(e);
response.Status = 500;
response.Message = "Failed";
response.Payload = "Exception Occured";
}
return(response);
}
public ResponseModel <string> EditTemplateDetailById(List <CreateTemplateQuestionInfoModel> req, string username, long id)
{
var response = new ResponseModel <string>();
try
{
var templateData = _db.CreateTemplateQuestionInfoes.SingleOrDefault(x => x.Id == id && x.username == username);
var createTemplateeditableInstructionsListsCreateResponse = _db.CreateTemplateeditableInstructionsLists.OrderBy(x => x.Id).Where(x => x.referenceKey == templateData.referenceId && x.username == username).ToList();
var createTemplateSingleQuestionsListsCreateResponse = _db.CreateTemplateSingleQuestionsLists.OrderBy(x => x.Id).Where(x => x.referenceKey == templateData.referenceId && x.username == username).ToList();
var createTemplateMultipleQuestionsListsCreateResponse = _db.CreateTemplateMultipleQuestionsLists.OrderBy(x => x.Id).Where(x => x.referenceKey == templateData.referenceId && x.username == username).ToList();
var createTemplateTextBoxQuestionsListsCreateResponse = _db.CreateTemplateTextBoxQuestionsLists.OrderBy(x => x.Id).Where(x => x.referenceKey == templateData.referenceId && x.username == username).ToList();
var createTemplateListBoxQuestionsListsCreateResponse = _db.CreateTemplateListBoxQuestionsLists.OrderBy(x => x.Id).Where(x => x.referenceKey == templateData.referenceId && x.username == username).ToList();
if (createTemplateeditableInstructionsListsCreateResponse != null)
{
foreach (var createTemplateeditableInstructionCreateResponse in createTemplateeditableInstructionsListsCreateResponse)
{
_db.CreateTemplateeditableInstructionsLists.Remove(createTemplateeditableInstructionCreateResponse);
}
}
if (createTemplateSingleQuestionsListsCreateResponse != null)
{
foreach (var createTemplateSingleQuestionCreateResponse in createTemplateSingleQuestionsListsCreateResponse)
{
_db.CreateTemplateSingleQuestionsLists.Remove(createTemplateSingleQuestionCreateResponse);
}
}
if (createTemplateMultipleQuestionsListsCreateResponse != null)
{
foreach (var createTemplateMultipleQuestionCreateResponse in createTemplateMultipleQuestionsListsCreateResponse)
{
_db.CreateTemplateMultipleQuestionsLists.Remove(createTemplateMultipleQuestionCreateResponse);
}
}
if (createTemplateTextBoxQuestionsListsCreateResponse != null)
{
foreach (var createTemplateTextBoxQuestionCreateResponse in createTemplateTextBoxQuestionsListsCreateResponse)
{
_db.CreateTemplateTextBoxQuestionsLists.Remove(createTemplateTextBoxQuestionCreateResponse);
}
}
if (createTemplateListBoxQuestionsListsCreateResponse != null)
{
foreach (var createTemplateListBoxQuestionCreateResponse in createTemplateListBoxQuestionsListsCreateResponse)
{
_db.CreateTemplateListBoxQuestionsLists.Remove(createTemplateListBoxQuestionCreateResponse);
}
}
try
{
templateData.title = req[0].title;
_db.SaveChanges();
CreateSubTemplateByRefKey CreateSubTemplateByRefKey = new CreateSubTemplateByRefKey();
CreateSubTemplateByRefKey.CreateSubTemplateByRefKeyService(req, username, templateData.referenceId);
response.Status = 200;
response.Message = "Success";
response.Payload = "Successfully Edited";
}
catch (DbEntityValidationException e)
{
DbContextException.LogDbContextException(e);
response.Status = 500;
response.Message = "Failed";
response.Payload = "Exception Occured";
}
return(response);
}
catch (Exception)
{
response.Status = 500;
response.Message = "Exception";
return(response);
}
}
