public IActionResult CreateImage([FromBody] ImageUploadsDtos imageUploadDto)
{
if (imageUploadDto == null)
{
return(BadRequest(ModelState));
}
var checkImageExist = _imageRepo.ImageUploadExists(imageUploadDto, imageUploadDto.Username);
if (checkImageExist.imageExist.Count > 0)
{
return(StatusCode(StatusCodes.Status302Found, checkImageExist));
}
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var imageRepoObj = _mapper.Map <ImageUploads>(imageUploadDto);
if (!_imageRepo.CreateImage(imageRepoObj))
{
ModelState.AddModelError("", $"Something went wrong when saving the record {imageRepoObj.ImageName}");
return(StatusCode(500, ModelState));
}
//return CreatedAtRoute("GetSingleImage", new { imageId = imageRepoObj.ImageId}, imageRepoObj);
return(Ok());
}
public IActionResult DeleteImage(int imageId, [FromBody] ImageUploadsDtos imageUploadsDtos)
{
if (_imageRepo.ImageUploadExists(imageId))
{
return(BadRequest(ModelState));
}
var imageRepoObj = _mapper.Map <ImageUploads>(imageUploadsDtos);
if (!_imageRepo.DeleteImage(imageRepoObj))
{
ModelState.AddModelError("", $"Something went wrong when deleting the record {imageRepoObj.ImageName}");
return(StatusCode(500, ModelState));
}
return(NoContent());
}
public ImageUploads ImageUploadExists(ImageUploadsDtos image, string username)
{
try
{
string execStatus = "";
var context = _db;
var command = context.Database.GetDbConnection().CreateCommand();
{
command.CommandText = "STP_IMAGE_EXISTS";
command.CommandType = System.Data.CommandType.StoredProcedure;
var value = new ImageUploads();
foreach (var img in image.fileImages)
{
command.Parameters.Add(new SqlParameter("@Images", img.Image));
command.Parameters.Add(new SqlParameter("@Username", username));
command.Parameters.Add(new SqlParameter("@Status", SqlDbType.VarChar, 4000));
command.Parameters["@Status"].Direction = ParameterDirection.Output;
context.Database.OpenConnection();
command.ExecuteNonQuery();
execStatus = Convert.ToString(command.Parameters["@Status"].Value);
command.Parameters.Clear();
if (execStatus != null && execStatus != "")
{
value.imageExist.Add(execStatus);
}
}
return(value);
}
}
catch (Exception ex)
{
throw ex;
}
}
