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; } }
public ResponseModel<string> CreateTemplate(List<CreateTemplateQuestionInfoModel> req,string username,TemplateInfoModel TemplateInfo) { var response = new ResponseModel<string>(); var keyInfo = _db.CreateTemplateQuestionInfoes.FirstOrDefault(); var refKey = _db.Users.SingleOrDefault(x=>x.Username == username).guid; var digitKey = 0; Random rnd = new Random(); int randomValue = rnd.Next(1, 10000); if (keyInfo != null) { digitKey = _db.CreateTemplateQuestionInfoes.Max(x => x.Id) + 1; } else { digitKey = 1; } refKey += digitKey + randomValue; if (TemplateInfo.type == Constants.type_Ads && TemplateInfo.subType == Constants.subType_facebookLike) { var facebookFindPageId = TemplateInfo.pageId.Split('/'); var createTemplateFacebookLikeInsert = new CreateTemplateFacebookLike { username = username, title = req[0].title, type = TemplateInfo.type, subType = TemplateInfo.subType, creationTime = DateTime.Now.ToString(CultureInfo.InvariantCulture), referenceId = refKey, totalThreads = TemplateInfo.totalThreads, completed = Constants.NA, verified = Constants.NA, payPerUser = TemplateInfo.amountEachThread, DateTime = DateTime.Now, description = (req[3].textBoxQuestionsList[0].Question) == null ? Constants.NA : req[3].textBoxQuestionsList[0].Question, pageId = facebookFindPageId[facebookFindPageId.Length-1], pageUrl = TemplateInfo.pageUrl }; _db.CreateTemplateFacebookLikes.Add(createTemplateFacebookLikeInsert); try { _db.SaveChanges(); var signalRHub = new SignalRHub(); string totalProjects = new ProjectDAO().totalAvailableProjects(); string successRate = ""; string totalUsers = ""; string projectCategories = ""; var hubContext = GlobalHost.ConnectionManager.GetHubContext<SignalRHub>(); hubContext.Clients.All.updateBeforeLoginUserProjectDetails(totalProjects, successRate, totalUsers, projectCategories); 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"; } } else { var createTemplateQuestionsInfoInsert = new CreateTemplateQuestionInfo { description = TemplateInfo.description != null ? TemplateInfo.description : Constants.NA, username = username, title = req[0].title, visible = Constants.NA, type = TemplateInfo.type, subType = TemplateInfo.subType, creationTime = DateTime.Now.ToString(CultureInfo.InvariantCulture), referenceId = refKey, totalThreads = TemplateInfo.totalThreads, completed = Constants.NA, verified = Constants.NA, payPerUser = TemplateInfo.amountEachThread }; _db.CreateTemplateQuestionInfoes.Add(createTemplateQuestionsInfoInsert); try { _db.SaveChanges(); CreateSubTemplateByRefKey CreateSubTemplateByRefKey = new CreateSubTemplateByRefKey(); CreateSubTemplateByRefKey.CreateSubTemplateByRefKeyService(req, username, refKey); var signalRHub = new SignalRHub(); string totalProjects = new ProjectDAO().totalAvailableProjects(); string successRate = ""; string totalUsers = ""; string projectCategories = ""; var hubContext = GlobalHost.ConnectionManager.GetHubContext<SignalRHub>(); hubContext.Clients.All.updateBeforeLoginUserProjectDetails(totalProjects, successRate, totalUsers, projectCategories); new SendNewTaskService().SendUserTaskNotificationToAllAsync(createTemplateQuestionsInfoInsert.title, "Total " + createTemplateQuestionsInfoInsert.totalThreads+" available",DateTime.Now); 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; }