public SpecialFaultCodesDetails GetSpecialFaultCodesDetailsById(long id)
{
SpecialFaultCodesDetails details = null;
details = _SpecialFaultCodesRepository.GetSpecialFaultCodesDetailsById(id);
return(details);
}
public SpecialFaultCodesDetails GetSpecialFaultCodesDetailsById(long id)
{
SpecialFaultCodesDetails details = new SpecialFaultCodesDetails();
string spName = MIDDerivationLibrary.Models.Constants.spGetSpecialFaultCodesDetailsById;
List <SqlParameter> allParams = new List <SqlParameter>()
{
new SqlParameter($"@{MIDDerivationLibrary.Models.Constants.Id}", id)
};
DataSet result = sqlRepository.ExecuteQuery(spName, allParams);
if (result != null && result.Tables[0].Rows.Count > 0)
{
details = result.Tables[0].AsEnumerable().Select(dataRow => new SpecialFaultCodesDetails
{
id = dataRow.Field <long>("id"),
specialfaultcodetype = dataRow.Field <string>("specialfaultcodetype"),
specialcode = dataRow.Field <string>("specialcode"),
specialmultiple = dataRow.Field <int?>("specialmultiple"),
componentType = dataRow.Field <string>("componentType"),
componentTypeSub1 = dataRow.Field <string>("componentTypeSub1"),
componentTypeSub2 = dataRow.Field <string>("componentTypeSub2")
}).FirstOrDefault();
}
return(details);
}
public ActionResult GetSpecialFaultCodesDetailsById(long id)
{
try
{
if (id <= 0)
{
return(BadRequest(new ApiBadRequestResponse()));
}
else
{
bool isExist = _service.CheckIsSpecialFaultCodesDetailsExist(id);
if (isExist == false)
{
return(StatusCode(StatusCodes.Status404NotFound, new ApiResponse(404, Constants.recordNotFound)));
}
SpecialFaultCodesDetails details = _service.GetSpecialFaultCodesDetailsById(id);
if (details != null)
{
return(Ok(new ApiOkResponse(details)));
}
else
{
return(StatusCode(StatusCodes.Status500InternalServerError, new ApiResponse(500, null)));
}
}
}
catch (Exception ex)
{
ex.ToString();
return(StatusCode(StatusCodes.Status500InternalServerError, new ApiResponse(500, null)));
}
}
public bool CheckIsSpecialFaultCodesDetailsExist(string xmlContent)
{
bool flag = false;
SpecialFaultCodesDetails details = null;
details = _SpecialFaultCodesRepository.GetSpecialFaultCodesDetails(xmlContent);
if (details != null && details.id > 0)
{
flag = true;
}
return(flag);
}
public bool CheckIsSpecialFaultCodesDetailsExist(long id)
{
bool flag = true;
SpecialFaultCodesDetails details = null;
details = _SpecialFaultCodesRepository.GetSpecialFaultCodesDetailsById(id);
if (details != null && details.id == 0)
{
flag = false;
}
return(flag);
}
public ActionResult UpdateSpecialFaultCodesDetails(SpecialFaultCodesDetails model)
{
long id = 0;
ModelStateDictionary ModelState = new ModelStateDictionary();
SpecialFaultCodeValidationHelper.ValidateSpecialFaultCodeInput(ref ModelState, ref model);
if (model.id == 0)
{
ModelState.AddModelError(nameof(SpecialFaultCodesDetails.id), Constants.idValidationMessage);
}
if (ModelState.IsValid)
{
try
{
string xmlString = XmlHelper.ConvertObjectToXML(model);
XElement xElement = XElement.Parse(xmlString);
bool isExist = _service.CheckIsSpecialFaultCodesDetailsExist(xmlString);
if (isExist == true)
{
return(StatusCode(StatusCodes.Status409Conflict, new ApiResponse(404, Constants.recordExist)));
}
else
{
id = _service.AddOrUpdateSpecialFaultCodesDetails(xElement.ToString());
if (id > 0)
{
return(Ok(new ApiOkResponse(id, Constants.recordSaved)));
}
else
{
return(StatusCode(StatusCodes.Status500InternalServerError, new ApiResponse(500, null)));
}
}
}
catch (Exception ex)
{
ex.ToString();
return(StatusCode(StatusCodes.Status500InternalServerError, new ApiResponse(500, null)));
}
}
else
{
return(BadRequest(new ApiBadRequestResponse(ModelState)));
}
}
public static void ValidateSpecialFaultCodeInput(ref ModelStateDictionary modelState, ref SpecialFaultCodesDetails model)
{
//Validations for Special Fault Codes
if (model != null)
{
//specialfaultcodetype
if (string.IsNullOrEmpty(model.specialfaultcodetype))
{
modelState.AddModelError(nameof(SpecialFaultCodesDetails.specialfaultcodetype), Constants.specialFaultCodeTypeRequired);
}
//specialmultiple
if (model.specialmultiple == null)
{
modelState.AddModelError(nameof(SpecialFaultCodesDetails.specialmultiple), Constants.specialMultipleRequired);
}
//specialcode
if (string.IsNullOrEmpty(model.specialcode))
{
modelState.AddModelError(nameof(SpecialFaultCodesDetails.specialcode), Constants.specialCodeRequired);
}
}
}
