public JsonResult AddTopicReply(ForumModelView model)
{
int result = -1;
string strMsg = "";
try
{
if (String.IsNullOrEmpty(model.Message) || model.Message.Trim() == "")
{
result = -2;
strMsg = "Message required.";
}
else
{
ForumHelper helper = new ForumHelper();
string msg = helper.AddTopicReply(model);
if (msg == "success")
{
strMsg = "You have replied successfully.";
result = 0;
}
else
{
strMsg = "Error! Try again later.";
result = -3;
}
}
}
catch (Exception ex)
{
strMsg = "Exception: " + ex.Message;
}
return(Json(new { counter = result, msg = strMsg, topicId = model.TopicId }, JsonRequestBehavior.AllowGet));
}
protected void Page_Load(object sender, EventArgs e)
{
MembershipUser currentUser = Membership.GetUser();
if (currentUser != null)
{
if (Registration.AllowEnterGame(currentUser))
{
string gameServers = ConfigurationSettings.AppSettings["SharedWeb.EnterGame.GameServers"];
gameServers = gameServers.Replace(" ", "");
GameServersScript.Text = "<script type=\"text/javascript\">var gameServers = new Array();";
int gameServerID = 0;
foreach (string serverHost in gameServers.Split(','))
{
GameServersScript.Text += string.Format("gameServers[{0}] = \"{1}\";", gameServerID, serverHost);
gameServerID++;
}
GameServersScript.Text += "</script>";
string loginResponse = ForumHelper.CurrentLoginResponse(YafContext.Current.Localization.LanguageCode);
GameLoginDataScript.Text = string.Format("<script type=\"text/javascript\">var LoginData='{0}'</script>", loginResponse);
}
else
{
GameLoginDataScript.Text = "<script type=\"text/javascript\">var LoginData='Unconfirmed'</script>";
BlockedImg.Visible = true;
}
}
}
/// <summary>
/// Load the Forum message listing
/// </summary>
/// <param name="keyword"></param>
/// <param name="sortBy"></param>
/// <param name="pageNo"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public PartialViewResult LoadForumList(string keyword, string sortBy, string pageNo, string pageSize = "10")
{
ForumHelper helper = new ForumHelper();
ForumModel model = new ForumModel();
model.StratasBoardId = ClientSessionData.ClientStrataBoardId;
var forumList = helper.GetForumListing(model);
if (!string.IsNullOrEmpty(keyword))
{
forumList = forumList.Where(x => x.Topic.ToLower().Contains(keyword.ToLower()) || x.TopicContent.ToLower().Contains(keyword.ToLower())).ToList();
}
if (!string.IsNullOrEmpty(sortBy))
{
if (sortBy == "date asc")
{
forumList = forumList.OrderBy(x => x.CreatedOn).ToList();
}
else if (sortBy == "date desc")
{
forumList = forumList.OrderByDescending(x => x.CreatedOn).ToList();
}
else if (sortBy == "title asc")
{
forumList = forumList.OrderBy(x => x.Topic).ToList();
}
else if (sortBy == "title desc")
{
forumList = forumList.OrderByDescending(x => x.Topic).ToList();
}
else
{
forumList = forumList.OrderByDescending(x => x.CreatedOn).ToList();
}
}
int totalRecords = forumList.Count;
ForumModelView forumViewModel = new ForumModelView();
forumViewModel.TotalPages = totalRecords / Convert.ToInt32(pageSize);
if (totalRecords % Convert.ToInt32(pageSize) > 0)
{
forumViewModel.TotalPages++;
}
var skip = Convert.ToInt32(pageSize) * (Convert.ToInt32(pageNo) - 1);
forumViewModel.ListForum = forumList.Skip(skip).Take(Convert.ToInt32(pageSize)).ToList();
return(PartialView("_ForumListPartial", forumViewModel));
}
public JsonResult AddFlagOnTopic(ForumFlaggedModel model)
{
int result = -1;
string strMsg = "";
try
{
if (String.IsNullOrEmpty(model.ForumMessageType) || model.ForumMessageType.Trim() == "")
{
result = -4;
strMsg = "Error! Try again later.";
}
else if (model.AutoId <= 0)
{
result = -5;
strMsg = "Error! Try again later.";
}
else if (String.IsNullOrEmpty(model.Comment) || model.Comment.Trim() == "")
{
result = -2;
strMsg = "Comment required.";
}
else
{
ForumHelper helper = new ForumHelper();
int returnValue = helper.MarkFlagOnForum(model);
if (returnValue == 0)
{
strMsg = "You have flagged it successfully.";
result = 0;
}
else
{
strMsg = "Error! Try again later.";
result = -3;
}
}
}
catch (Exception ex)
{
strMsg = "Exception: " + ex.Message;
}
return(Json(new { counter = result, msg = strMsg, autoid = model.AutoId, type = model.ForumMessageType, userRole = ClientSessionData.ClientRoleName.ToLower() }, JsonRequestBehavior.AllowGet));
}
public JsonResult ReadMessage(long topicId)
{
int result = 0;
try
{
if (topicId > 0)
{
ForumHelper helper = new ForumHelper();
int remainingMessageCount = helper.ReadMessage(topicId, ClientSessionData.UserClientId, ClientSessionData.ClientStrataBoardId);
if (remainingMessageCount > 0)
{
result = remainingMessageCount;
}
}
}
catch {
}
return(Json(new { counter = result }, JsonRequestBehavior.AllowGet));
}
public JsonResult DeleteFlagOnTopic(ForumFlaggedModelView model)
{
int result = -1;
string strMsg = "";
try
{
if (String.IsNullOrEmpty(model.ForumMessageTypeView) || model.ForumMessageTypeView.Trim() == "")
{
result = -4;
strMsg = "Error! Try again later.";
}
else if (model.AutoIdView <= 0)
{
result = -5;
strMsg = "Error! Try again later.";
}
else
{
ForumHelper helper = new ForumHelper();
int returnValue = helper.DeleteForum(model);
if (returnValue == 0)
{
strMsg = "You have deleted it successfully.";
result = 0;
}
else
{
strMsg = "Error! Try again later.";
result = -3;
}
}
}
catch (Exception ex)
{
strMsg = "Exception: " + ex.Message;
}
return(Json(new { counter = result, msg = strMsg, autoid = model.AutoIdView, type = model.ForumMessageTypeView }, JsonRequestBehavior.AllowGet));
}
public void Execute(IServiceProvider serviceProvider)
{
SqlDataAccess sda = null;
try
{
sda = new SqlDataAccess();
sda.openConnection(Globals.ConnectionString);
#region | SERVICE |
IPluginExecutionContext context = (IPluginExecutionContext)serviceProvider.GetService(typeof(IPluginExecutionContext));
#region | Validate Request |
//Target yoksa veya Entity tipinde değilse, devam etme.
if (!context.InputParameters.Contains("Target") || !(context.InputParameters["Target"] is Entity))
{
return;
}
#endregion
IOrganizationServiceFactory serviceFactory = (IOrganizationServiceFactory)serviceProvider.GetService(typeof(IOrganizationServiceFactory));
IOrganizationService service = serviceFactory.CreateOrganizationService(context.UserId);
#endregion
Entity entity = (Entity)context.InputParameters["Target"];
#region |DEFINE IMAGE IF EXISTS|
Entity postImage = null;
if (context.PostEntityImages.Contains("PostImage") && context.PostEntityImages["PostImage"] is Entity)
{
postImage = (Entity)context.PostEntityImages["PostImage"];
}
#endregion
#region | VARIABLES |
List <ScoreLimit> lstLimits = new List <ScoreLimit>();
EntityReference portal = null;
EntityReference user = null;
if (postImage.Contains("new_portalid") && postImage["new_portalid"] != null)
{
portal = (EntityReference)postImage["new_portalid"];
}
if (postImage.Contains("new_userid") && postImage["new_userid"] != null)
{
user = (EntityReference)postImage["new_userid"];
}
#endregion
if (entity.Contains("statuscode") && entity["statuscode"] != null && ((OptionSetValue)entity["statuscode"]).Value == 1)
{
MsCrmResultObject limitRes = ScoreHelper.GetScoreLimitsByType(ScoreType.ForumSubject, sda);
if (limitRes.Success)
{
lstLimits = (List <ScoreLimit>)limitRes.ReturnObject;
for (int i = 0; i < lstLimits.Count; i++)
{
int recCount = 0;
DateTime start = GeneralHelper.GetStartDateByScorePeriod(lstLimits[i].Period);
DateTime end = GeneralHelper.GetEndDateByScorePeriod(lstLimits[i].Period);
recCount = ForumHelper.GetUserForumSubjectCount(portal.Id, user.Id, start, end, sda);
if (lstLimits[i].Frequency >= recCount)
{
Score sc = new Score()
{
Point = lstLimits[i].Point,
Portal = portal,
User = user,
ScoreType = ScoreType.ForumSubject
};
MsCrmResult scoreRes = ScoreHelper.CreateScore(sc, service);
break;
}
}
}
}
}
catch (Exception ex)
{
//LOG
throw new InvalidPluginExecutionException(ex.Message);
}
finally
{
if (sda != null)
{
sda.closeConnection();
}
}
}
public ActionResult ReenableSideBar()
{
ForumHelper.UnpauseConnections();
return(Redirect("/admin"));
}
public JsonResult AddTopic(ForumModel model)
{
int result = 0;
string strMsg = "";
try
{
if (String.IsNullOrEmpty(model.Topic) || model.Topic.Trim() == "")
{
result = -3;
strMsg = "Topic required.";
}
else if (String.IsNullOrEmpty(model.TopicContent) || model.TopicContent.Trim() == "")
{
result = -4;
strMsg = "Comment required.";
}
if (model.ImageType != null)
{
string ext = Path.GetExtension(model.ImageType.FileName).ToLower();
if (ext != ".jpg" && ext != ".jpeg" && ext != ".pdf" && ext != ".png" && ext != ".xlsx" && ext != ".docx" && ext != ".pptx")
{
result = -1;
strMsg = "Please upload only .jpg, .png, .pdf, .pptx, .docx or .xlsx File";
}
else
{
Guid guid = Guid.NewGuid();
model.UploadedFileActualName = model.ImageType.FileName;
model.UploadedFileName = guid.ToString() + ext;
string path = string.Empty;
string initialPath = "~/content/resources/strataboard";
if (!Directory.Exists(Server.MapPath(initialPath)))
{
Directory.CreateDirectory(Server.MapPath(initialPath));
}
initialPath = initialPath + "/" + ClientSessionData.ClientStrataBoardId;
if (!Directory.Exists(Server.MapPath(initialPath)))
{
Directory.CreateDirectory(Server.MapPath(initialPath));
}
initialPath = initialPath + "/myforum";
if (!Directory.Exists(Server.MapPath(initialPath)))
{
Directory.CreateDirectory(Server.MapPath(initialPath));
}
// save the file locally
path = Server.MapPath(Path.Combine(initialPath + "/" + model.UploadedFileName));
model.ImageType.SaveAs(path);
// save the file on s3
int fileMapped = AwsS3Bucket.CreateFile("resources/strataboard/" + ClientSessionData.ClientStrataBoardId + "/myforum/" + model.UploadedFileName, path);
if (fileMapped != 0)
{
result = -2;
strMsg = "Error is uploading file in S3, Try again later.";
}
// delete the file locally
if (System.IO.File.Exists(path))
{
System.IO.File.Delete(path);
}
}
}
if (result == 0)
{
ForumHelper helper = new ForumHelper();
string msg = helper.AddTopic(model);
if (msg != "success")
{
strMsg = "Error: Try again later";
result = -3;
}
}
}
catch (Exception ex)
{
strMsg = "Exception: " + ex.Message;
result = -5;
}
return(Json(new { counter = result, msg = strMsg }, JsonRequestBehavior.AllowGet));
}
protected void InstallWizard_NextButtonClick(object sender, WizardNavigationEventArgs e)
{
bool IsOK = false;
if (e.CurrentStepIndex == 4)
{
//Step 4 - DATABASES
IsOK = false;
ErrorMessagePanel.Visible = false;
SuccMessagePanel.Visible = false;
web_server.Text = web_server.Text.Replace(":", ",");
string websiteCS = "Data Source=" + web_server.Text + "; Initial Catalog=" + web_name.Text +
"; Integrated Security=false; User ID=" + web_username.Text + "; Password="******";";
string forumCS = "Data Source=" + web_server.Text + "; Initial Catalog=" + forum_name.Text +
"; Integrated Security=false; User ID=" + forum_username.Text + "; Password="******";";
string log = "";
try
{
log += "Connecting to Website database...";
//Connect to SQL locally WEBSITE
using (SqlConnection sqlConnection = new SqlConnection(websiteCS))
{
sqlConnection.Open();
log += "OK.<br/>";
log += "Executing Website SQL scripts...";
//Check if already done
bool done = true;
try
{
SqlCommand command = new SqlCommand("SELECT UpgradeProcessorButtonEnabled FROM ApplicationSettings", sqlConnection);
command.ExecuteScalar();
}
catch (Exception ex)
{
done = false;
}
if (done)
{
log += "OK (skipped).<br/>";
}
else
{
//Execute
using (StreamReader sr = new StreamReader(HttpContext.Current.Server.MapPath("~/install/sql/website.txt")))
{
String line = sr.ReadToEnd();
var scripts = SplitSqlStatements(line);
foreach (var splitScript in scripts)
{
try
{
SqlCommand command = new SqlCommand(splitScript, sqlConnection);
command.ExecuteNonQuery();
}
catch (Exception ex) { }
}
}
log += "OK.<br/>";
}
sqlConnection.Close();
}
log += "Connecting to Forum database...";
//Connect to SQL locally FORUM
using (SqlConnection sqlConnection = new SqlConnection(forumCS))
{
sqlConnection.Open();
log += "OK.<br/>";
log += "Executing Forum SQL scripts...";
//Check if already done
bool done = true;
try
{
SqlCommand command = new SqlCommand("SELECT Name FROM yaf_AccessMask", sqlConnection);
command.ExecuteScalar();
}
catch (Exception ex)
{
done = false;
}
if (done)
{
log += "OK (skipped).<br/>";
}
else
{
//Execute
using (StreamReader sr = new StreamReader(HttpContext.Current.Server.MapPath("~/install/sql/forum.txt")))
{
String line = sr.ReadToEnd();
var scripts = SplitSqlStatements(line);
foreach (var splitScript in scripts)
{
try
{
SqlCommand command = new SqlCommand(splitScript, sqlConnection);
command.ExecuteNonQuery();
}
catch (Exception ex) { }
}
}
log += "OK.<br/>";
}
sqlConnection.Close();
}
//Connect to SQL remotely
log += "Checking remote connection to Website...";
using (WebClient client = new WebClient())
{
var response = client.DownloadString("https://usetitan.com/Handlers/cs.ashx?c=" + HttpUtility.UrlEncode(websiteCS));
if (response == "OK")
{
log += "OK.<br/>";
}
else
{
throw new Exception(response);
}
}
log += "Checking remote connection to Forum...";
using (WebClient client = new WebClient())
{
var response = client.DownloadString("https://usetitan.com/Handlers/fcs.ashx?c=" + HttpUtility.UrlEncode(forumCS));
if (response == "OK")
{
log += "OK.<br/>";
}
else
{
throw new Exception(response);
}
}
//Modify Web.config
var configuration = WebConfigurationManager.OpenWebConfiguration("~");
var section = (ConnectionStringsSection)configuration.GetSection("connectionStrings");
section.ConnectionStrings["ClientDbString"].ConnectionString = websiteCS;
section.ConnectionStrings["yafnet"].ConnectionString = forumCS;
configuration.Save();
IsOK = true;
SuccMessagePanel.Visible = true;
SuccMessage.Text = log;
}
catch (Exception ex)
{
SuccMessagePanel.Visible = true;
SuccMessage.Text = log;
ErrorMessagePanel.Visible = true;
ErrorMessage.Text = ex.Message;
}
if (!IsOK)
{
e.Cancel = true;
}
}
if (e.CurrentStepIndex == 5)
{
//Step 5 - EMAILS
IsOK = false;
SuccPanel2.Visible = false;
ErrorPanel2.Visible = false;
string log = "";
try
{
log += "Sending test email message...";
AppSettings.Email.Username = settings_Username.Text.Trim();
AppSettings.Email.Password = settings_Password.Text.Trim();
AppSettings.Email.Host = settings_Host.Text.Trim();
AppSettings.Email.Port = Convert.ToInt32(settings_Port.Text.Trim());
AppSettings.Email.IsSecureMail = settings_Secure.Checked;
AppSettings.Email.Forward = AppSettings.Email.NoReply = settings_ForwardEmail.Text.Trim();
AppSettings.Email.Save();
Mailer.SendEmailToUser("*****@*****.**", "Test server", "Test");
log += "OK.<br/>";
IsOK = true;
ForumHelper.UpdateForumDB(ForumHelper.BDProperty.Email, AppSettings.Email.Forward);
SuccPanel2.Visible = true;
SuccMess2.Text = log;
}
catch (Exception ex)
{
SuccPanel2.Visible = true;
SuccMess2.Text = log;
ErrorPanel2.Visible = true;
ErrorMess2.Text = ex.Message;
}
if (!IsOK)
{
e.Cancel = true;
}
}
if (e.CurrentStepIndex == 6)
{
Commission.UpdateCommissionSystem();
//CRON
IsOK = false;
ErrorPanel3.Visible = false;
bool IsGood = false;
var cronLogs = TableHelper.SelectAllRows <CronEntry>();
foreach (var entry in cronLogs)
{
if (entry.Date.Date == DateTime.Now.Date)
{
IsGood = true;
}
}
if (IsGood)
{
IsOK = true;
AppSettings.Site.Url = BaseUrl;
AppSettings.Site.Save();
ForumHelper.UpdateForumDB(ForumHelper.BDProperty.BaseURL, BaseUrl + "forum");
}
else
{
ErrorPanel3.Visible = true;
ErrorMess3.Text = "The CRON file for today did not trigger successfully. Try again.";
}
if (!IsOK)
{
e.Cancel = true;
}
}
if (e.CurrentStepIndex == 7)
{
//Admin password
IsOK = false;
ErrorPanel4.Visible = false;
if (String.IsNullOrWhiteSpace(adminpassword.Text))
{
ErrorPanel4.Visible = true;
ErrorMess4.Text = "The password cannot be blank.";
}
else
{
Member admin = new Member("admin");
string newPassword = adminpassword.Text;
admin.PrimaryPassword = MemberAuthenticationService.ComputeHash(newPassword);
admin.Save();
IsOK = true;
}
if (!IsOK)
{
e.Cancel = true;
}
}
}
