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> ForgetPasswordService(string id, HttpRequestBase request) { var response = new ResponseModel <string>(); if (_db.Users.Any(x => x.Username == id)) { var user = _db.Users.SingleOrDefault(x => x.Username == id); if (user != null && (user.isActive.Equals("false", StringComparison.InvariantCulture))) { // User account has not validated yet response.Status = 402; response.Message = "warning"; return(response); } var forgetPasswordDataAlreadyExists = _db.ForgetPasswords.SingleOrDefault(x => x.Username == id); if (forgetPasswordDataAlreadyExists != null) { _db.ForgetPasswords.Remove(forgetPasswordDataAlreadyExists); } var guid = Guid.NewGuid().ToString(); var forgetPasswordData = new ForgetPassword { Username = id, guid = guid }; _db.ForgetPasswords.Add(forgetPasswordData); try { _db.SaveChanges(); var forgetPasswordValidationEmail = new ForgetPasswordValidationEmail(); forgetPasswordValidationEmail.SendForgetPasswordValidationEmailMessage(id, guid, request, DateTime.Now.Ticks.ToString(CultureInfo.InvariantCulture)); } catch (DbEntityValidationException e) { DbContextException.LogDbContextException(e); response.Status = 500; response.Message = "Internal Server Error"; return(response); } } else { // User doesn't exist response.Status = 404; response.Message = "warning"; return(response); } response.Status = 200; response.Message = "Success"; return(response); }
public ResponseModel <String> ResendValidationCodeService(ValidateAccountRequest req, HttpRequestBase request) { var response = new ResponseModel <string>(); if (_db.Users.Any(x => x.Username == req.userName)) { var user = _db.Users.SingleOrDefault(x => x.Username == req.userName); if (user != null && (user.isActive == "true")) { // Account has been already validated. response.Status = 402; response.Message = "warning"; return(response); } var guidAlreadyExist = _db.ValidateUserKeys.SingleOrDefault(x => x.Username == req.userName); if (guidAlreadyExist != null) { _db.ValidateUserKeys.Remove(guidAlreadyExist); } var dbValidateUserKey = new ValidateUserKey { guid = Guid.NewGuid().ToString(), Username = req.userName }; _db.ValidateUserKeys.Add(dbValidateUserKey); try { _db.SaveChanges(); SendAccountCreationValidationEmail.SendAccountCreationValidationEmailMessage(req.userName, dbValidateUserKey.guid, request); } catch (DbEntityValidationException e) { DbContextException.LogDbContextException(e); response.Status = 500; response.Message = "Internal Server Error !!!"; return(response); } response.Status = 200; response.Message = "success"; return(response); } // User Doesn't Exist response.Status = 404; response.Message = "warning"; return(response); }
public ResponseModel <string> ImgurImagesSaveToDatabaseWithTemplateId(List <imgurUploadImageResponse> ImgurList, string username, string id) { var response = new ResponseModel <string>(); var refKey = id; foreach (var imageInfo in ImgurList) { var CreateTemplateImgurImagesListInsert = new CreateTemplateImgurImagesList { assignedTo = "NA", assignTime = "NA", completedAt = "NA", referenceKey = refKey, status = "open", username = username, verified = "No", imgurId = imageInfo.data.id, imgurDeleteHash = imageInfo.data.deletehash, imgurLink = imageInfo.data.link }; _db.CreateTemplateImgurImagesLists.Add(CreateTemplateImgurImagesListInsert); } try { _db.SaveChanges(); response.Status = 200; response.Message = "Success"; response.Payload = "Successfully Added"; } 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> DeleteTemplateImgurImageById(string username, long id) { var response = new ResponseModel <string>(); try { var createTemplateImgurImagesListsCreateResponse = _db.CreateTemplateImgurImagesLists.OrderBy(x => x.Id).Where(x => x.Id == id && x.username == username).ToList(); if (createTemplateImgurImagesListsCreateResponse != null) { foreach (var createTemplateImgurImageCreateResponse in createTemplateImgurImagesListsCreateResponse) { _db.CreateTemplateImgurImagesLists.Remove(createTemplateImgurImageCreateResponse); } } try { _db.SaveChanges(); response.Status = 200; response.Message = "Success"; response.Payload = "Successfully Deleted"; } 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> ValidateAccountService(ValidateAccountRequest req) { var response = new ResponseModel <string>(); if (_db.ValidateUserKeys.Any(x => x.Username == req.userName && x.guid == req.guid)) { var user = _db.Users.SingleOrDefault(x => x.Username == req.userName); if (user == null) { response.Status = 500; response.Message = "Internal Server Error"; Logger.Info("Validate Account : " + req.userName); return(response); } if (user.isActive == "true") { response.Status = 402; response.Message = "link expired"; return(response); } user.isActive = "true"; try { _db.SaveChanges(); } catch (DbEntityValidationException e) { DbContextException.LogDbContextException(e); response.Status = 500; response.Message = "Internal Server Error"; return(response); } response.Status = 200; response.Message = "validated"; return(response); } response.Status = 402; response.Message = "link expired"; return(response); }
public LoginResponse Login(string userName, string passwrod, string returnUrl, string keepMeSignedIn) { var userData = new LoginResponse(); if (_db.Users.Any(x => x.Username == userName && x.Password == passwrod)) { var user = _db.Users.SingleOrDefault(x => x.Username == userName && x.isActive == "true"); if (user != null) { string Authkey = ConfigurationManager.AppSettings["AuthKey"]; userData.UTMZK = EncryptionClass.GetEncryptionKey(user.Username, Authkey); userData.UTMZV = EncryptionClass.GetEncryptionKey(user.Password, Authkey); userData.TimeStamp = DateTime.Now.ToString(CultureInfo.InvariantCulture); userData.Code = "200"; try { user.KeepMeSignedIn = keepMeSignedIn.Equals("true", StringComparison.OrdinalIgnoreCase)? "true" : "false"; _db.SaveChanges(); } catch (DbEntityValidationException e) { DbContextException.LogDbContextException(e); userData.Code = "500"; return(userData); } } else { userData.Code = "403"; } } else { userData.Code = "401"; } return(userData); }
public ResponseModel <String> ResetPasswordService(ResetPasswordRequest req) { var response = new ResponseModel <string>(); //EncryptionClass.GetDecryptionValue(req.Username, ConfigurationManager.AppSettings["AuthKey"]); if (_db.ForgetPasswords.Any(x => x.guid == req.Guid)) { var removeForgetPasswordData = _db.ForgetPasswords.SingleOrDefault(x => x.guid == req.Guid); _db.ForgetPasswords.Remove(removeForgetPasswordData); var userData = _db.Users.SingleOrDefault(x => x.Username == removeForgetPasswordData.Username); if (userData != null) { var password = EncryptionClass.Md5Hash(req.Password); userData.Password = password; userData.Locked = "false"; } try { _db.SaveChanges(); } catch (DbEntityValidationException e) { DbContextException.LogDbContextException(e); response.Status = 500; response.Message = "Internal Server Error."; Logger.Info("Save new Reseted Password : "******"Success"; return(response); } response.Status = 402; response.Message = "link expired"; 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> WebRegisterService(RegisterationRequest req, HttpRequestBase request) { var response = new ResponseModel <String>(); if (_db.Users.Any(x => x.Username == req.Username)) { response.Status = 409; response.Message = "conflict"; return(response); } var guid = Guid.NewGuid().ToString(); var user = new User { Username = req.Username, Password = EncryptionClass.Md5Hash(req.Password), Source = req.Source, isActive = "false", Type = req.Type, guid = Guid.NewGuid().ToString(), FirstName = req.FirstName, LastName = req.LastName, gender = "NA", ImageUrl = "NA" }; _db.Users.Add(user); if (!string.IsNullOrEmpty(req.Referral)) { var dbRecommedBy = new RecommendedBy { RecommendedFrom = req.Referral, RecommendedTo = req.Username }; _db.RecommendedBies.Add(dbRecommedBy); } if (req.Type == "client") { var dbClientDetails = new ClientDetail { Username = req.Username, CompanyName = req.CompanyName }; _db.ClientDetails.Add(dbClientDetails); } var dbValidateUserKey = new ValidateUserKey { Username = req.Username, guid = guid }; _db.ValidateUserKeys.Add(dbValidateUserKey); try { _db.SaveChanges(); SendAccountCreationValidationEmail.SendAccountCreationValidationEmailMessage(req.Username, guid, request); } catch (DbEntityValidationException e) { DbContextException.LogDbContextException(e); response.Status = 500; response.Message = "Internal Server Error !!!"; return(response); } response.Status = 200; response.Message = "success"; response.Payload = "Account Created"; return(response); }
public ResponseModel <string> CreateSubTemplateByRefKeyService(List <CreateTemplateQuestionInfoModel> req, string username, string refKey) { var response = new ResponseModel <string>(); foreach (var templateQuestions in req) { if (templateQuestions.visible == false) { continue; } switch (templateQuestions.type) { case "AddInstructions": foreach (var instructionsList in templateQuestions.editableInstructionsList) { var createTemplateeditableInstructionsListInsert = new CreateTemplateeditableInstructionsList { username = username, Number = instructionsList.Number, Text = instructionsList.Text, assignTime = DateTime.Now.ToString(CultureInfo.InvariantCulture), assignedTo = "NA", completedAt = "NA", referenceKey = refKey, status = "Open", verified = "NA" }; _db.CreateTemplateeditableInstructionsLists.Add(createTemplateeditableInstructionsListInsert); } break; case "AddSingleQuestionsList": foreach (var singleQuestionList in templateQuestions.singleQuestionsList) { var createTemplateSingleQuestionsListInsert = new CreateTemplateSingleQuestionsList { username = username, Number = singleQuestionList.Number, Question = singleQuestionList.Question, Options = singleQuestionList.Options, assignTime = DateTime.Now.ToString(CultureInfo.InvariantCulture), assignedTo = "NA", completedAt = "NA", referenceKey = refKey, status = "Open", verified = "NA" }; _db.CreateTemplateSingleQuestionsLists.Add(createTemplateSingleQuestionsListInsert); } break; case "AddMultipleQuestionsList": foreach (var multipleQuestionsList in templateQuestions.multipleQuestionsList) { var createTemplateMultipleQuestionsListInsert = new CreateTemplateMultipleQuestionsList { username = username, Number = multipleQuestionsList.Number, Question = multipleQuestionsList.Question, Options = multipleQuestionsList.Options, assignTime = DateTime.Now.ToString(CultureInfo.InvariantCulture), assignedTo = "NA", completedAt = "NA", referenceKey = refKey, status = "Open", verified = "NA" }; _db.CreateTemplateMultipleQuestionsLists.Add(createTemplateMultipleQuestionsListInsert); } break; case "AddTextBoxQuestionsList": foreach (var textBoxQuestionsList in templateQuestions.textBoxQuestionsList) { var createTemplateTextBoxQuestionsListInsert = new CreateTemplateTextBoxQuestionsList { username = username, Number = textBoxQuestionsList.Number, Question = textBoxQuestionsList.Question, Options = textBoxQuestionsList.Options, assignTime = DateTime.Now.ToString(CultureInfo.InvariantCulture), assignedTo = "NA", completedAt = "NA", referenceKey = refKey, status = "Open", verified = "NA" }; _db.CreateTemplateTextBoxQuestionsLists.Add(createTemplateTextBoxQuestionsListInsert); } break; case "AddListBoxQuestionsList": foreach (var listBoxQuestionsList in templateQuestions.listBoxQuestionsList) { var createTemplateListBoxQuestionsListInsert = new CreateTemplateListBoxQuestionsList { username = username, Number = listBoxQuestionsList.Number, Question = listBoxQuestionsList.Question, Options = listBoxQuestionsList.Options, assignTime = DateTime.Now.ToString(CultureInfo.InvariantCulture), assignedTo = "NA", completedAt = "NA", referenceKey = refKey, status = "Open", verified = "NA" }; _db.CreateTemplateListBoxQuestionsLists.Add(createTemplateListBoxQuestionsListInsert); } break; } } try { _db.SaveChanges(); 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); }