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