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