public async Task <DatabaseResponse> UpdateContentStatus(CommunityContentStatus contentUpdate) { try { SqlParameter[] parameters = { new SqlParameter("@UserId", SqlDbType.Int), new SqlParameter("@ContentId", SqlDbType.Int), new SqlParameter("@ContentType", SqlDbType.Int), new SqlParameter("@Status", SqlDbType.Bit), new SqlParameter("@Comments", SqlDbType.VarChar) }; parameters[0].Value = contentUpdate.UserId; parameters[1].Value = contentUpdate.ContentId; parameters[2].Value = contentUpdate.ContentType; parameters[3].Value = contentUpdate.Status; parameters[4].Value = contentUpdate.comments; _DataHelper = new DataAccessHelper("spi_CommunityApproveReject", parameters, _configuration); DataSet dt = new DataSet(); int result = await _DataHelper.RunAsync(dt); if (dt.Tables.Count > 0 && dt.Tables[0] != null && dt.Tables[0].Rows.Count > 0) { if (result == (int)DbReturnValue.Published) { if (contentUpdate.ContentType == 1) { ContentMediaController controller = new ContentMediaController(_configuration, _converter); await controller.GeneratePdf(contentUpdate.ContentId, 1); } else { ContentMediaController controller = new ContentMediaController(_configuration, _converter); await controller.GeneratePdf(contentUpdate.ContentId, 2); } UserEmail userEmail = new UserEmail(); userEmail.Email = Convert.ToString(dt.Tables[0].Rows[0]["Email"]); int portalLanguageId = Convert.ToInt32(dt.Tables[0].Rows[0]["PortalLanguageId"]); string text = string.Empty; string buttonText = string.Empty; if (portalLanguageId == 2) { text = "Your Content has been published during community check."; buttonText = "View Content"; userEmail.Subject = "Content has been published"; } else { text = "تم نشر المصدر المحتوى الخاص بك، يمكنك الضغط على الرابط أدناه للعرض"; buttonText = "عرض المحتوى"; userEmail.Subject = "تم نشر المحتوى"; } userEmail.Body = Emailer.CreateEmailBody(Convert.ToString(dt.Tables[0].Rows[0]["UserName"]), contentUpdate.EmailUrl, text, buttonText, dt.Tables[0].Rows[0]["PortalLanguageId"] == null ? 0 : Convert.ToInt32(dt.Tables[0].Rows[0]["PortalLanguageId"]), _configuration); await Emailer.SendEmailAsync(userEmail, _configuration); } else if (result == (int)DbReturnValue.Rejected) { UserEmail userEmail = new UserEmail(); int portalLanguageId = Convert.ToInt32(dt.Tables[0].Rows[0]["PortalLanguageId"]); userEmail.Email = Convert.ToString(dt.Tables[0].Rows[0]["Email"]); string text = string.Empty; string buttonText = string.Empty; if (portalLanguageId == 2) { if (dt.Tables[1] != null && dt.Tables[1].Rows.Count > 0) { text = "Your Content has been rejected during Community Check. Click below button to view. Reason(s) : "; StringBuilder builder = new StringBuilder(); builder.Append("<br/>"); builder.Append("<ol>"); foreach (string reason in dt.Tables[1].Rows[0]["Comments"].ToString().Remove(dt.Tables[1].Rows[0]["Comments"].ToString().Length - 2).Split(";;")) { builder.Append("<li>" + reason + "</li>"); } builder.Append("</ol>"); text += builder.ToString(); } else { text = "Your Content has been rejected during community check. Click below button to view. Reason : " + contentUpdate.comments; } buttonText = "View Content"; userEmail.Subject = "Your course or resource has been rejected."; userEmail.Body = Emailer.CreateEmailBody(Convert.ToString(dt.Tables[0].Rows[0]["UserName"]), contentUpdate.EmailUrl, text, buttonText, dt.Tables[0].Rows[0]["PortalLanguageId"] == null ? 0 : Convert.ToInt32(dt.Tables[0].Rows[0]["PortalLanguageId"]), _configuration); await Emailer.SendEmailAsync(userEmail, _configuration); } else { if (dt.Tables[1] != null && dt.Tables[1].Rows.Count > 0) { text = "بعد المراجعة، تم رفض المحتوى المقدم من قبلك يمكنك الضغط على الرابط أدناه لعرض المحتوى .<br><br>"; buttonText = "عرض المحتوى"; StringBuilder builder = new StringBuilder(); builder.Append("<br/>"); builder.Append("<ol>"); foreach (string reason in dt.Tables[1].Rows[0]["Comments"].ToString().Remove(dt.Tables[1].Rows[0]["Comments"].ToString().Length - 2).Split(";;")) { builder.Append("<li>" + reason + "</li>"); } builder.Append("</ol>"); text += builder.ToString(); } else { text = "بعد المراجعة، تم رفض المحتوى المقدم من قبلك يمكنك الضغط على الرابط أدناه لعرض المحتوى .<br><br>" + contentUpdate.comments + ":الأسباب"; buttonText = "عرض المحتوى"; } userEmail.Subject = "بعد المراجعة، تم رفض المحتوى المقدم من قبلك."; userEmail.Body = Emailer.CreateEmailBody(Convert.ToString(dt.Tables[0].Rows[0]["UserName"]), contentUpdate.EmailUrl, text, buttonText, dt.Tables[0].Rows[0]["PortalLanguageId"] == null ? 0 : Convert.ToInt32(dt.Tables[0].Rows[0]["PortalLanguageId"]), _configuration); await Emailer.SendEmailAsync(userEmail, _configuration); } } } return(new DatabaseResponse { ResponseCode = result, Results = null }); } catch (Exception ex) { Log.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); throw; } finally { _DataHelper.Dispose(); } }
public async Task <IActionResult> UpdateContentStatus(CommunityContentStatus contentUpdate) { try { CommunityCheckDataAccess communityCheckDataAccess = new CommunityCheckDataAccess(_configuration, _converter); DatabaseResponse response = await communityCheckDataAccess.UpdateContentStatus(contentUpdate); if (response.ResponseCode == (int)DbReturnValue.Published) { return(Ok(new OperationResponse { HasSucceeded = true, IsDomainValidationErrors = false, Message = EnumExtensions.GetDescription(DbReturnValue.Published), ReturnedObject = response.Results })); } else if (response.ResponseCode == (int)DbReturnValue.Approved) { return(Ok(new OperationResponse { HasSucceeded = true, IsDomainValidationErrors = false, Message = EnumExtensions.GetDescription(DbReturnValue.Approved), ReturnedObject = response.Results })); } else if (response.ResponseCode == (int)DbReturnValue.Rejected) { return(Ok(new OperationResponse { HasSucceeded = true, IsDomainValidationErrors = false, Message = EnumExtensions.GetDescription(DbReturnValue.Rejected), ReturnedObject = response.Results })); } else if (response.ResponseCode == (int)DbReturnValue.RejectedAndSentToDrafts) { return(Ok(new OperationResponse { HasSucceeded = true, IsDomainValidationErrors = false, Message = EnumExtensions.GetDescription(DbReturnValue.RejectedAndSentToDrafts), ReturnedObject = response.Results })); } else { return(Ok(new OperationResponse { HasSucceeded = false, IsDomainValidationErrors = false, Message = EnumExtensions.GetDescription(DbReturnValue.ActionAlreadyTaken), ReturnedObject = response.Results })); } } catch (Exception ex) { Log.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); return(Ok(new OperationResponse { HasSucceeded = false, Message = StatusMessages.ServerError, StatusCode = ((int)ResponseStatus.ServerError).ToString(), IsDomainValidationErrors = false })); } }