// public string getBaseURL()
//{
// cmd.CommandText = "SELECT BaseUrl FROM Brafton WHERE content='1'";
// string baseURL = cmd.ExecuteScalar().ToString();
// return baseURL;
//}
#endregion Base URL
#region Updated Feed Content
///////////////////GET AND SET Checkbox for Updated Content//////////////////////////
protected void setUpdateContent_Click()
{
connection2 = new SqlConnection(ConfigurationManager.ConnectionStrings["SiteSqlServer"].ToString());
connection2.Open();
cmd.Connection = connection2;
cmd.CommandText = "IF OBJECT_ID('Brafton') IS NOT NULL(SELECT count(*) as total_record FROM Brafton WHERE content='1') ELSE SELECT 0";
int updateContent = (int)cmd.ExecuteScalar();
Brafton.DotNetNuke.BraftonSchedule B1 = new Brafton.DotNetNuke.BraftonSchedule();
int checkForUpdatedCheck = B1.getUpdatedContent();
//Check what is set in the db
Brafton.DotNetNuke.BraftonSchedule B2 = new Brafton.DotNetNuke.BraftonSchedule();
int checkForUpdatedCheckDB = B2.getUpdatedContent();
if (InclUpdatedFeedContent.Checked == true)
{
MyGlobals.IncludeUpdatedFeedContent = 1;
cmd.CommandText = "UPDATE Brafton SET IncUpdatedFeedContentValue = 1 WHERE Content = '1'";
cmd.ExecuteNonQuery();
//checkedStatusLabel.Text = "The after click value in the db =" + checkForUpdatedCheckDB + " and the value in globals is " + MyGlobals.IncludeUpdatedFeedContent+"And should be checked";
//checkedStatusLabel.Text = "CLICKED";
}
else if (InclUpdatedFeedContent.Checked == false)
{
MyGlobals.IncludeUpdatedFeedContent = 0;
cmd.CommandText = "UPDATE Brafton SET IncUpdatedFeedContentValue = 0 WHERE Content = '1'";
cmd.ExecuteNonQuery();
//checkedStatusLabel.Text = "The afet click value in the db =" + checkForUpdatedCheckDB + " and the value in globals is " + MyGlobals.IncludeUpdatedFeedContent+"And should not be checked";
//checkedStatusLabel.Text = "NOT CLICKED";
}
else
{
checkedStatusLabel.Text = "SOMETHING ELSE HAPPENED";
}
//connection2.Close();
try
{
}
catch (Exception ex)
{
labelError.Text = "Generic exception: " + ex.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
//connection.Open();
//cmd.Connection = connection;
//cmd2.Connection = connection;
//cmd2.CommandText = "Select Title From Blog_Entries where EntryID = 2";
//string apiTest = cmd2.ExecuteScalar().ToString();
// apiURLLabel.Text = apiTest;
//connection.Close();
//********************************************************************
//TODO check for Brafton Table
//cmd2.CommandText = "CREATE TABLE [dbo].Brafton(Id int IDENTITY(1,1) NOT NULL,Content nvarchar(MAX) NULL,Api nvarchar(MAX) NULL,BaseUrl nvarchar(MAX) NULL, BlogId int NULL,PortalId int NULL,TabId int NULL,DomainName nvarchar(MAX) NULL, Limit int NULL)";
//cmd2.ExecuteNonQuery();
//********************************************************************
try
{
//Get current directory for style sheets and images
appPath = HttpRuntime.AppDomainAppVirtualPath == "/" ? appPath = "" : appPath = HttpRuntime.AppDomainAppVirtualPath;
connection.Open();
cmd.Connection = connection;
//Showing your current portal ID
intPortalID = PortalSettings.PortalId;
currentPortalID.Text = intPortalID.ToString();
//Showing your current TabID
PageTabId = PortalSettings.ActiveTab.TabID;
currentTabID.Text = PortalSettings.ActiveTab.TabID.ToString();
//Get your current domain to insert into database for error checking
checkDomain = HttpContext.Current.Request.Url.Host;
//MyGlobals.MyGlobalError = MyGlobals.MyGlobalError + "Check Domain:" + checkDomain;
Dictionary <string, int> checkAll = checks();
//Sets the current PortalID in the Brafton Table
cmd.CommandText = "IF Exists (SELECT * FROM Brafton WHERE content='1') UPDATE Brafton SET PortalId = " + intPortalID + " WHERE Content = '1' else INSERT INTO Brafton (Content, PortalId) VALUES (1, '" + intPortalID + "')";
cmd.ExecuteNonQuery();
//Sets the current TabID in the Brafton Table
cmd.CommandText = "IF Exists (SELECT * FROM Brafton WHERE content='1') UPDATE Brafton SET TabId = " + PageTabId + " WHERE Content = '1' else INSERT INTO Brafton (Content, TabId) VALUES (1, '" + PageTabId + "')";
cmd.ExecuteNonQuery();
//Sets the current domain in the Brafton Table
cmd.CommandText = "IF Exists (SELECT * FROM Brafton WHERE content='1') UPDATE Brafton SET DomainName = 'http://" + checkDomain + "' WHERE Content = '1' else INSERT INTO Brafton (Content, DomainName) VALUES (1, 'http://" + checkDomain + "')";
cmd.ExecuteNonQuery();
//HERE WE SET THE GLOBAL VARIABLES
//This fills all the relevant fields with values from the database if they exist
//All the prior queries have been left intact for the time being but can eventually be phased out
MyGlobals.PopGlobals();
checkedStatusLabel.Text = MyGlobals.MyGlobalError; //For debugging it is a global text field you pass errors into
if (checkAll["Friendly Urls"] == 1)
{
boolFriendURL.Text = "True";
boolFriendURL.CssClass = "boolTrue";
}
else
{
boolFriendURL.Text = "False";
boolFriendURL.CssClass = "boolFalse";
}
if (checkAll["Blog Module"] == 1)
{
boolBlogModule.Text = "True";
boolBlogModule.CssClass = "boolTrue";
cmd.CommandText = "IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='Blog_Entries' AND column_name='BraftonID') BEGIN ALTER TABLE Blog_Entries ADD BraftonID nvarchar(255) END";
cmd.ExecuteNonQuery();
}
else
{
boolBlogModule.Text = "False";
boolBlogModule.CssClass = "boolFalse";
}
if (checkAll["Blog"] == 1)
{
boolBlogCreated.Text = "True";
boolBlogCreated.CssClass = "boolTrue";
cmd.CommandText = "Select Title From Blog_Blogs where PortalID = '" + intPortalID + "'";
SqlDataReader blogOptions = cmd.ExecuteReader();
if (!IsPostBack && blogOptions.HasRows)
{
while (blogOptions.Read())
{
blogIdDrpDwn.Items.Add(new ListItem(blogOptions.GetString(0)));
}
}
blogOptions.Close();
setAPIPH.Visible = true;
}
else
{
boolBlogCreated.Text = "False";
boolBlogCreated.CssClass = "boolFalse";
}
if (checkAll["News API"] == 0)
{
boolCheckAPI.Text = "False";
boolCheckAPI.CssClass = "boolFalse";
nextStep.Visible = false;
}
else
{
cmd.CommandText = "SELECT Api FROM Brafton WHERE content='1'";
string newsAPI = (string)cmd.ExecuteScalar();
boolCheckAPI.Text = "<span class='boolTrue'>True</span>";
//apiURLLabel.Text = newsAPI;
apiURL.Text = newsAPI;
if (checkAll["Base Url"] == 1)
{
nextStep.Visible = true;
}
}
if (checkAll["Base Url"] == 0)
{
boolCheckUrl.Text = "False";
boolCheckUrl.CssClass = "boolFalse";
}
else
{
cmd.CommandText = "SELECT BaseUrl FROM Brafton WHERE content='1'";
string newsAPI = (string)cmd.ExecuteScalar();
boolCheckUrl.Text = "<span class='boolTrue'>True</span>";
//baseURLLabel.Text = newsAPI;
baseURL.Text = newsAPI;
}
//if (checkAll["Limit"] == 1)
//{
// cmd.CommandText = "SELECT Limit FROM Brafton WHERE content='1'";
// limitLabel.Text = cmd.ExecuteScalar().ToString();
//}
if (checkAll["Blog ID"] == 0)
{
boolCheckBlogID.Text = "<span class='boolFalse'>False</span>";
}
else
{
boolCheckBlogID.Text = "<span class='boolTrue'>True</span>";
cmd.CommandText = "Select Title From Blog_Blogs Where BlogID = " + getBlogID();
string blogTitle = (string)cmd.ExecuteScalar();
currentBlogID.Text = blogTitle;
}
//check for video settings if there fill fields and make visible
if (checkAll["Vid ID"] == 1)
{
if (Page.IsPostBack == false)
{
VideoSettings.Visible = true;
//InclVideo.Checked = true;
updateVidSettings.Visible = true;
MyGlobals.IncludeVideo = 1;
setVidSettings.Visible = false;
CurrentVidSetting1.Visible = true;
CurrentVidSetting2.Visible = false;
//CurrentVidSetting3.Visible = true;
VideoBaseURL.Text = MyGlobals.VideoBaseURL;
VideoPhotoURL.Text = MyGlobals.VideoPhotoURL;
VideoPublicKey.Text = MyGlobals.VideoPublicKey;
VideoSecretKey.Text = MyGlobals.VideoSecretKey;
VideoFeedNumber.Text = MyGlobals.VideoFeedNumber.ToString();
RadioButtonList1.SelectedValue = "video";
VideoSettings.Visible = true;
VideoPlaceHolder.Visible = true;
Import.Visible = true;
}
}
if (checkAll["Vid ID"] == 1 && checkAll["Base Url"] == 1)
{
Import.Visible = true;
if (Page.IsPostBack == false)
{
RadioButtonList1.SelectedValue = "both";
ArticlePlaceHolder.Visible = true;
VideoSettings.Visible = true;
ArticlePlaceHolder.Visible = true;
VideoPlaceHolder.Visible = true;
}
}
if (checkAll.Values.Sum() == 6)
{
Import.Visible = true;
if (Page.IsPostBack == false)
{
ArticlePlaceHolder.Visible = true;
RadioButtonList1.SelectedValue = "articles";
MyGlobals.MyGlobalError = "Should be show Articles";
}
}
else
{
int sumnum = checkAll.Values.Sum();
MyGlobals.MyGlobalError = "Here is the problem" + sumnum;
}
//Check what the value of IncUpdatedFeedContentValue is in the db 1 is checked 0 is not checked
Brafton.DotNetNuke.BraftonSchedule B1 = new Brafton.DotNetNuke.BraftonSchedule();
int checkForUpdatedCheck = B1.getUpdatedContent();
//int checkForUpdatedCheck = 1;
if (Page.IsPostBack == false)
{
if (checkForUpdatedCheck == 1)
{
InclUpdatedFeedContent.Checked = true;
MyGlobals.IncludeUpdatedFeedContent = 1;
cmd.CommandText = "IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='Blog_Entries' AND column_name='LastUpdatedOn') BEGIN ALTER TABLE Blog_Entries ADD LastUpdatedOn DATETIME NULL END";
cmd.ExecuteNonQuery();
//checkedStatusLabel.Text = "The value in the db =" + checkForUpdatedCheck + " and the value in globals is " + MyGlobals.IncludeUpdatedFeedContent +"Means it should be checked";
}
else
{
InclUpdatedFeedContent.Checked = false;
MyGlobals.IncludeUpdatedFeedContent = 0;
//checkedStatusLabel.Text = "The value in the db =" + checkForUpdatedCheck + " and the value in globals is " + MyGlobals.IncludeUpdatedFeedContent+" Means it should not be checked";
}
}
connection.Close();
cmd.Dispose();
}
catch (Exception ex)
{
labelError.Text = "Generic exception: " + ex.ToString();
connection.Close();
cmd.Dispose();
}
}