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