public IActionResult DeleteDatasetSubcategoryMappingValidation(DatasetSubcategoryMappingValidation _datasetSubcategoryMappingValidation) { try { var datasetSubcategoryMappingValidation = _CLRCP_MASTERContext.DatasetSubcategoryMappingValidation.Where(e => e.AutoId == _datasetSubcategoryMappingValidation.AutoId).FirstOrDefault(); _CLRCP_MASTERContext.DatasetSubcategoryMappingValidation.Remove(datasetSubcategoryMappingValidation); _CLRCP_MASTERContext.SaveChanges(); return(Ok(true)); } catch (Exception) { return(BadRequest(false)); } }
public IActionResult AddDatasetSubcategoryMappingValidation(DatasetSubcategoryMappingValidation _datasetSubcategoryMappingValidation) { try { DatasetSubcategoryMappingValidation datasetSubcategoryMappingValidation = new DatasetSubcategoryMappingValidation { DatasetId = _datasetSubcategoryMappingValidation.DatasetId, DestinationSubcategoryId = _datasetSubcategoryMappingValidation.DestinationSubcategoryId }; _CLRCP_MASTERContext.DatasetSubcategoryMappingValidation.Add(datasetSubcategoryMappingValidation); _CLRCP_MASTERContext.SaveChanges(); return(Ok(true)); } catch (Exception) { return(BadRequest(false)); } }
public IActionResult SetValidationData_TextText(int UserId, int DestAutoId, int DatasetId, int IsMatch) { DatasetSubcategoryMappingValidation datasetSubcategoryMappingValidation = _MasterContext.DatasetSubcategoryMappingValidation .Where(x => x.DatasetId == DatasetId) .SingleOrDefault(); if (datasetSubcategoryMappingValidation != null) { SubCategories destTableNameValidation = _MasterContext.SubCategories.Find(datasetSubcategoryMappingValidation.DestinationSubcategoryId); if (destTableNameValidation.Name == "TEXTTEXT_VALIDATION_RESPONSE_DETAIL") { int IsValidFlag = 0; if (IsMatch == 1 /*&& NoCrossTalk == 1 && IsClear == 1*/) { IsValidFlag = 1; } _validationInfoContext.TexttextValidationResponseDetail.Add(new TexttextValidationResponseDetail { UserId = UserId, RefAutoid = DestAutoId, IsMatch = IsMatch, ValidationFlag = IsValidFlag }); ///set count DatasetSubcategoryMapping datasetSubcategoryMapping = _MasterContext.DatasetSubcategoryMapping .Where(x => x.DatasetId == DatasetId) .SingleOrDefault(); if (datasetSubcategoryMapping != null) { SubCategories destTableName = _MasterContext.SubCategories.Find(datasetSubcategoryMapping.DestinationSubcategoryId); if (destTableName.Name == "TextText") { TextText imageText = _textToTextContext.TextText.Where(x => x.AutoId == DestAutoId).Select(x => x).SingleOrDefault(); if (imageText != null) { imageText.TotalValidationUsersCount += 1; if (IsMatch == 1 /*&& NoCrossTalk == 1 && IsClear == 1*/) { //imageText.VoteCount += 1; if (imageText.VoteCount == null) { imageText.VoteCount = 1; } else { imageText.VoteCount += 1; } } int?maxValidationUsers = _MasterContext.Datasets.Where(x => x.DatasetId == DatasetId) .Select(x => x.MaxValidationUsers) .FirstOrDefault(); if (maxValidationUsers != null) { if (maxValidationUsers * 0.5 < imageText.VoteCount) { imageText.IsValid = 1; } else if (maxValidationUsers * 0.5 < (imageText.TotalValidationUsersCount - imageText.VoteCount)) { imageText.IsValid = 0; } try { _validationInfoContext.SaveChangesAsync(); _textToTextContext.SaveChangesAsync(); } catch (Exception) { _jsonResponse.Response = "Internal Exception"; return(BadRequest(_jsonResponse)); } _jsonResponse.IsSuccessful = true; _jsonResponse.Response = "Saved"; return(Ok(_jsonResponse)); } } } } } } _jsonResponse.IsSuccessful = false; _jsonResponse.Response = "Details not match"; return(NotFound(_jsonResponse)); }
public IActionResult SetValidationData_TextSpeech(int UserId, int DestAutoId, int DatasetId, int IsMatch, int NoCrossTalk, int IsClear) { DatasetSubcategoryMappingValidation datasetSubcategoryMappingValidation = context.DatasetSubcategoryMappingValidation .Where(x => x.DatasetId == DatasetId) .SingleOrDefault(); if (datasetSubcategoryMappingValidation != null) { SubCategories destTableNameValidation = context.SubCategories.Find(datasetSubcategoryMappingValidation.DestinationSubcategoryId); if (destTableNameValidation.Name == "TEXTSPEECH_VALIDATION_RESPONSE_DETAIL") { int IsValidFlag = 0; if (IsMatch == 1 && NoCrossTalk == 1 && IsClear == 1) { IsValidFlag = 1; } validationInfoContext.TextspeechValidationResponseDetail.Add(new TextspeechValidationResponseDetail { UserId = UserId, RefAutoid = DestAutoId, IsMatch = IsMatch, NoCrossTalk = NoCrossTalk, IsClear = IsClear, ValidationFlag = IsValidFlag }); ///set count DatasetSubcategoryMapping datasetSubcategoryMapping = context.DatasetSubcategoryMapping .Where(x => x.DatasetId == DatasetId) .SingleOrDefault(); if (datasetSubcategoryMapping != null) { SubCategories destTableName = context.SubCategories.Find(datasetSubcategoryMapping.DestinationSubcategoryId); if (destTableName.Name == "TextSpeech") { TextSpeech textSpeech = textToSpeech.TextSpeech.Where(x => x.AutoId == DestAutoId).Select(x => x).SingleOrDefault(); if (textSpeech != null) { textSpeech.TotalValidationUsersCount += 1; if (IsMatch == 1 && NoCrossTalk == 1 && IsClear == 1) { textSpeech.VoteCount += 1; } int?maxValidationUsers = context.Datasets.Where(x => x.DatasetId == DatasetId) .Select(x => x.MaxValidationUsers) .FirstOrDefault(); if (maxValidationUsers != null) { if (maxValidationUsers * 0.5 < textSpeech.VoteCount) { textSpeech.IsValid = 1; } else if (maxValidationUsers * 0.5 < (textSpeech.TotalValidationUsersCount - textSpeech.VoteCount)) { textSpeech.IsValid = 0; } try { validationInfoContext.SaveChangesAsync(); textToSpeech.SaveChangesAsync(); } catch (Exception) { jsonResponse.Response = "Internal Exception"; return(BadRequest(jsonResponse)); } jsonResponse.IsSuccessful = true; jsonResponse.Response = "Saved"; return(Ok(jsonResponse)); } } } } } } jsonResponse.IsSuccessful = false; jsonResponse.Response = "Details not match"; return(NotFound(jsonResponse)); }