public JsonResponse<string> DeletePhoto(ApprovedImageModel approveModel) { JsonResponse<string> jsonResponse = new JsonResponse<string>(); string folderName; DirectoryInfo di; folderName = Path.Combine("Resources", "Images"); var pathofImages = Path.Combine(Directory.GetCurrentDirectory(), folderName); di = new DirectoryInfo(pathofImages); FileInfo[] files = di.GetFiles("*.*", SearchOption.AllDirectories); try { using (IDbConnection dbConnection = new NpgsqlConnection(_ConnectionStringService.Value)) { dbConnection.Open(); using (var transaction = dbConnection.BeginTransaction()) { string image_name = dbConnection.Query<string>("select image_name from candidate_image_logger where id = @p0", new { p0 = approveModel.imageLoggedId }).FirstOrDefault(); foreach (FileInfo file in files) { if (file.Name == image_name) { file.Delete(); break; } } dbConnection.Query<CandidateImageLogger>("update candidate_image_logger set is_deleted = true where id = @p0", new { p0 = approveModel.imageLoggedId }); transaction.Commit(); } } jsonResponse.IsSuccess = true; jsonResponse.Message = "success"; return jsonResponse; } catch (Exception e) { jsonResponse.IsSuccess = false; jsonResponse.Message = "fail"; return jsonResponse; } }
public IActionResult DeleteProfilePhoto([FromBody] ApprovedImageModel approveModel) { return(Ok(_fileUploadService.DeletePhoto(approveModel))); }
public JsonResponse<string> updateToApproveProfile(ApprovedImageModel approveModel) { JsonResponse<string> jsonResponse = new JsonResponse<string>(); string folderName; DirectoryInfo di; try { using (IDbConnection dbConnection = new NpgsqlConnection(_ConnectionStringService.Value)) { dbConnection.Open(); using (var transaction = dbConnection.BeginTransaction()) { CandidateImageLogger imageDetails = dbConnection.Query<CandidateImageLogger>("select * from candidate_image_logger where id = @p0", new { p0 = approveModel.imageLoggedId }).FirstOrDefault(); if (imageDetails.is_profile_pic == true) { folderName = Path.Combine("Resources", "Images", "User", imageDetails.user_id.ToString(), "Candidates", imageDetails.candidate_id.ToString(), "Profile Image"); var path = Path.Combine(Directory.GetCurrentDirectory(), folderName); if (Directory.Exists(path)) { di = new DirectoryInfo(path); foreach (FileInfo fi in di.GetFiles()) { if (fi.Name != imageDetails.image_name) { fi.Delete(); } } } dbConnection.Query<CandidateImageLogger>("update candidate_image_logger set is_deleted = true where user_id = @p0 and candidate_id = @p1 and is_approved = true and is_profile_pic = true and is_deleted = false and id != @p2", new { p0 = imageDetails.user_id, @p1 = imageDetails.candidate_id, @p2 = imageDetails.id }); dbConnection.Query<CandidateImageLogger>("update candidate_image_logger set is_approved = true , is_profile_pic = true where id = @p0", new { p0 = approveModel.imageLoggedId }); } else if (imageDetails.is_from_other_three_photos == true) { dbConnection.Query<CandidateImageLogger>("update candidate_image_logger set is_approved = true where id = @p0", new { p0 = approveModel.imageLoggedId }); } transaction.Commit(); } } jsonResponse.IsSuccess = true; jsonResponse.Message = "success"; return jsonResponse; } catch (Exception e) { jsonResponse.IsSuccess = false; jsonResponse.Message = "fail"; return jsonResponse; } }
public IActionResult UpdateToApproveProfile([FromBody] ApprovedImageModel approveModel) { return(Ok(_fileUploadService.updateToApproveProfile(approveModel))); }