private void LoadFields()
{
try
{
CMSBL cmsBL = new CMSBL();
DataTable pageDT = cmsBL.GetPage(hdnSiteID.Value, hdnChildPageID.Value);
foreach (DataRow pageDR in pageDT.Rows)
{
txtPageName.Text = pageDR["PAGE_NAME"].ToString();
txtPageCaption.Text = pageDR["PAGE_CAPTION"].ToString();
txtMetaTitle.Text = pageDR["META_TITLE"].ToString();
txtMetaKeywords.Text = pageDR["META_KEYWORDS"].ToString();
txtMetaDescription.Text = pageDR["META_DESC"].ToString();
ddlSortNumber.SelectedValue = pageDR["CHILD_SORT_PAGE_NUM"].ToString();
string isPublished = pageDR["IS_PUBLISHED"].ToString();
hdnMaxSortNum.Value = pageDR["CHILD_SORT_PAGE_NUM"].ToString();
if (isPublished == "1")
rbYes.Checked = true;
else
rbNo.Checked = true;
}
}
catch (Exception ex)
{
}
}
private void LoadTreeView()
{
try
{
CMSBL cmsBL = new CMSBL();
DataSet dsTreeView = cmsBL.GetClientTreeview(hdnSiteID.Value);
DataTable dtOutline = new DataTable();
DataTable dtTree = new DataTable();
dtOutline = dsTreeView.Tables[0];
dtTree = dsTreeView.Tables[1];
foreach (DataRow drOutline in dtOutline.Rows)
{
TreeNode node = new TreeNode(drOutline["PAGE_NAME"].ToString());
DataRow[] drChilds = dtTree.Select("PAGE_ID=" + drOutline["PAGE_ID"].ToString(), "CHILD_SORT_PAGE_NUM");
tvContent.Nodes.Add(node);
foreach (DataRow drChild in drChilds)
{
TreeNode childNode = new TreeNode(drChild["PAGE_NAME"].ToString());
node.ChildNodes.Add(childNode);
}
}
}
catch (Exception ex)
{
}
}
private void GetHtmlContent(string pageName)
{
try
{
CMSBL cmsBL = new CMSBL();
DataTable dtHtmlContent = cmsBL.GetHtmlContent(hdnSiteID.Value, pageName);
foreach (DataRow drHtmlContent in dtHtmlContent.Rows)
{
literal1.Text = Server.HtmlDecode(drHtmlContent["HTML_TEXT"].ToString().Replace("'", "'"));
}
}
catch (Exception ex)
{
}
}
private void LoadFields()
{
try
{
CMSBL cmsBL = new CMSBL();
DataTable pageDT = cmsBL.GetPage(hdnSiteID.Value, hdnChildPageID.Value);
foreach (DataRow pageDR in pageDT.Rows)
{
txtPageName.Text = pageDR["PAGE_NAME"].ToString();
txtPageCaption.Text = pageDR["PAGE_CAPTION"].ToString();
txtMetaTitle.Text = pageDR["META_TITLE"].ToString();
txtMetaKeywords.Text = pageDR["META_KEYWORDS"].ToString();
txtMetaDescription.Text = pageDR["META_DESC"].ToString();
}
}
catch (Exception ex)
{
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
int returnNumber = -1;
int rowNumber = 0;
rowNumber = GetSelectedRow();
if (rowNumber >= 0)
{
string companyID = dgSites.Items[rowNumber].Cells[2].Text;
string siteID = dgSites.Items[rowNumber].Cells[0].Text;
CMSBL cmsBL = new CMSBL();
returnNumber = cmsBL.DeleteSite(companyID, siteID, _userName);
}
/*for (int i = 0; i < dgSites.Items.Count; i++)
{
CheckBox chkFlag;
chkFlag = (CheckBox)dgSites.Items[i].Cells[0].FindControl("chkSelect");
if (chkFlag.Checked)
{
string companyID = dgSites.Items[i].Cells[2].Text;
string siteID = dgSites.Items[i].Cells[0].Text;
CMSBL cmsBL = new CMSBL();
returnNumber = cmsBL.DeleteSite(companyID, siteID, _userName);
}
}*/
if (returnNumber > 0)
{
lblMessage.Text = "Successfully deleted the site.";
lblMessage.ForeColor = System.Drawing.Color.Green;
LoadSiteDetails();
}
else
{
lblMessage.Text = "Site Not Deleted.";
lblMessage.ForeColor = System.Drawing.Color.Red;
}
}
protected void tvContent_SelectedNodeChanged(object sender, EventArgs e)
{
try
{
DateTime startTime = DateTime.Parse(hdnStartTime.Value);
TimeSpan timeDiff = DateTime.Now.Subtract(startTime);
double dTime = Convert.ToDouble(timeDiff.TotalSeconds);
if (dTime > 10)
{
CMSBL cmsBL = new CMSBL();
//cmsBL.CaptureContentUsage("", "", "", dTime.ToString(), "");
}
hdnStartTime.Value = System.DateTime.Now.TimeOfDay.ToString(); ;
string pageName = tvContent.SelectedNode.Value;
GetHtmlContent(pageName);
}
catch (Exception ex)
{
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
int returnNumber = -1;
int rowNumber = 0;
rowNumber = GetSelectedRow();
if (rowNumber >= 0)
{
string pageID = dgOutline.Items[rowNumber].Cells[0].Text;
CMSBL cmsBL = new CMSBL();
returnNumber = cmsBL.DeleteOutline(hdnSiteID.Value, pageID);
}
/*for (int i = 0; i < dgOutline.Items.Count; i++)
{
CheckBox chkFlag;
chkFlag = (CheckBox)dgOutline.Items[i].Cells[0].FindControl("chkSelect");
if (chkFlag.Checked)
{
string pageID = dgOutline.Items[i].Cells[0].Text;
CMSBL cmsBL = new CMSBL();
returnNumber = cmsBL.DeleteOutline(hdnSiteID.Value, pageID);
}
}*/
if (returnNumber > 0)
{
lblMessage.Text = "Successfully deleted the Outline.";
lblMessage.ForeColor = System.Drawing.Color.Green;
LoadOutlineDetails();
}
else
{
lblMessage.Text = "Outline Not Deleted.";
lblMessage.ForeColor = System.Drawing.Color.Red;
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
int returnNumber = -1;
int rowNumber = 0;
rowNumber = GetSelectedRow();
if (rowNumber >= 0)
{
string childPageID = dgPages.Items[rowNumber].Cells[0].Text;
CMSBL cmsBL = new CMSBL();
returnNumber = cmsBL.DeletePage(hdnSiteID.Value, hdnPageID.Value, childPageID);
}
if (returnNumber == 1)
{
lblMessage.Text = "Page Deleted Successfully.";
lblMessage.ForeColor = System.Drawing.Color.Green;
LoadPageDetails();
}
else
{
lblMessage.Text = "Page Not Deleted.";
lblMessage.ForeColor = System.Drawing.Color.Red;
}
}
private void SavePage()
{
try
{
int returnNumber = -1;
int sortNumber = 0;
int childPageNumber = -1;
string pageModID = "0";
string pageName = txtPageName.Text.Replace("'", "''");
string pageCaption = txtPageCaption.Text.Replace("'", "''");
string metaTitle = txtMetaTitle.Text.Replace("'", "''");
string metaDesc = txtMetaDescription.Text.Replace("'", "''");
string metaKey = txtMetaKeywords.Text.Replace("'", "''");
CMSBL cmsBL = new CMSBL();
if (lblTitle.Text == "Add Page")
{
bool duplicatePage = cmsBL.DuplicatePageName(hdnSiteID.Value, pageName);
if (duplicatePage)
{
lblMessage.Text = "Duplicate Page Name";
lblMessage.ForeColor = System.Drawing.Color.Red;
return;
}
}
SqlServer sqlServer = new SqlServer(Util.SqlConnectionString()); ;
string isPublished = "";
if (rbYes.Checked)
isPublished = "1";
else if (rbNo.Checked)
isPublished = "0";
//sortNumber = cmsBL.GetDuplicatePageSort(hdnSiteID.Value, hdnPageID.Value, ddlSortNumber.SelectedValue);
if (sortNumber == 0)
{
childPageNumber = cmsBL.JMD_PAGE_SAVE(hdnChildPageID.Value, hdnSiteName.Value, pageName, pageCaption,
metaTitle, metaDesc, metaKey, "",
isPublished, "0", "0", "Admin", "Admin", "Admin", "Admin", "Admin", "Admin", "0", "0", "0", "1");
if (lblTitle.Text == "Update Page")
{
DataSet dsPageMod = new DataSet();
dsPageMod = sqlServer.JMD_LOAD_MODS(hdnSiteName.Value, pageName);
if (dsPageMod.Tables[0].Rows.Count > 0)
{
DataRow[] dr = dsPageMod.Tables[0].Select("PAGE_NAME='" + pageName + "'");
if (dr.Length > 0)
pageModID = dr[0]["PAGE_MOD_ID"].ToString();
}
returnNumber = cmsBL.UpdateTreeview(hdnSiteID.Value, hdnPageID.Value, childPageNumber.ToString(), ddlSortNumber.SelectedValue, _userName);
}
else
{
returnNumber = cmsBL.CreateTreeview(hdnSiteID.Value, hdnPageID.Value, childPageNumber.ToString(), ddlSortNumber.SelectedValue, _userName);
}
sqlServer.JMD_PAGE_MOD_SAVE(pageModID, hdnSiteName.Value, pageName, "7",
"Mod_" + pageName, "7", "1", "0", "Admin;Guests;Registered;",
"Admin;", "Admin;", "Admin;", "Admin;", "0");
if (lblTitle.Text == "Add Page")
{
lblMessage.Text = "Successfully added the new Page.";
}
else
{
lblMessage.Text = "Successfully updated the Page.";
}
lblMessage.ForeColor = System.Drawing.Color.Green;
}
else
{
lblMessage.Text = "Sort Number already exist.";
lblMessage.ForeColor = System.Drawing.Color.Red;
}
}
catch (Exception ex)
{
lblMessage.Text = "Page Not Updated.";
lblMessage.ForeColor = System.Drawing.Color.Red;
}
}
private void LoadPageDetails()
{
try
{
CMSBL cmsBL = new CMSBL();
DataTable siteDT = cmsBL.GetAllPages(hdnSiteID.Value, hdnPageID.Value);
dgPages.DataSource = siteDT;
dgPages.DataBind();
/*if ((dgPages.Items.Count % dgPages.PageSize == 1) &&
(dgPages.CurrentPageIndex == dgPages.PageCount - 1) &&
(dgPages.CurrentPageIndex != 0))
{
dgPages.CurrentPageIndex = dgPages.CurrentPageIndex - 1;
}*/
}
catch (Exception ex)
{
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
try
{
CMSBL cmsBL = new CMSBL();
int returnNumber = -1;
int folderNumber = -1;
int siteNumber = -1;
string siteName = txtSiteName.Text.Replace("'", "''");
string companyName = ddlCompany.SelectedValue.ToString();
folderNumber = cmsBL.GetDuplicateFolder(txtFolderName.Text);
if (lblTitle.Text == "Add Company-Site")
{
siteNumber = cmsBL.GetDuplicateSite(siteName, companyName);
if (siteNumber == 0 && folderNumber == 0)
{
returnNumber = cmsBL.CreateSite(companyName, siteName, "", ddlStyleSheet.SelectedValue.ToString(), "", txtFolderName.Text, _userName);
if (returnNumber == 1)
{
createFolder(txtFolderName.Text);
cmsBL.UpdateModuleMaster(companyName, siteName, _userName);
}
}
}
else if (lblTitle.Text == "Update Company-Site")
{
returnNumber = cmsBL.UpdateSite(ddlCompany.SelectedValue.ToString(), siteName, "", ddlStyleSheet.SelectedValue.ToString(), "", txtFolderName.Text, _userName);
}
if (returnNumber == 1)
{
if (lblTitle.Text == "Add Company-Site")
{
lblMessage.Text = "Successfully added a new site.";
}
else
{
lblMessage.Text = "Successfully updated the site.";
}
lblMessage.ForeColor = System.Drawing.Color.Green;
}
else if (siteNumber == 10)
{
lblMessage.Text = "Site already exist";
lblMessage.ForeColor = System.Drawing.Color.Red;
}
else if (folderNumber == 11)
{
lblMessage.Text = "Folder already exist";
lblMessage.ForeColor = System.Drawing.Color.Red;
}
else
{
lblMessage.Text = "Site Not Updated";
lblMessage.ForeColor = System.Drawing.Color.Red;
}
}
catch (Exception ex)
{
}
}
private void LoadFields(string companyID, string siteID)
{
try
{
CMSBL cmsBL = new CMSBL();
DataTable siteDT = cmsBL.GetSite(companyID, siteID);
foreach (DataRow siteDR in siteDT.Rows)
{
txtSiteName.Text = siteDR["SITE_NAME"].ToString();
ddlCompany.SelectedValue = siteDR["COMPANYID"].ToString();
ddlStyleSheet.SelectedValue = siteDR["STYLE_SHEET"].ToString();
txtFolderName.Text = siteDR["SITE_FOLDER"].ToString();
}
}
catch (Exception ex)
{
}
}
private void LoadCompany()
{
try
{
CMSBL cmsBL = new CMSBL();
DataTable companyDT = cmsBL.GetAllCompany();
ddlCompany.Items.Clear();
ddlCompany.Items.Add(new ListItem("Select Company", "Select Company"));
foreach (DataRow companyDR in companyDT.Rows)
{
ddlCompany.Items.Add(new ListItem(companyDR["COMPANYNAME"].ToString(), companyDR["COMPANYID"].ToString()));
}
}
catch (Exception ex)
{
}
}
private void SavePage()
{
try
{
int returnNumber = -1;
int childPageNumber = -1;
string pageModID = "0";
string pageName = txtPageName.Text.Replace("'", "''");
string pageCaption = txtPageCaption.Text.Replace("'", "''");
string metaTitle = txtMetaTitle.Text.Replace("'", "''");
string metaDesc = txtMetaDescription.Text.Replace("'", "''");
string metaKey = txtMetaKeywords.Text.Replace("'", "''");
CMSBL cmsBL = new CMSBL();
if (lblTitle.Text == "Add Page")
{
bool duplicatePage = cmsBL.DuplicatePageName(hdnSiteID.Value, pageName);
if (duplicatePage)
{
lblMessage.Text = "Duplicate Page Name";
lblMessage.ForeColor = System.Drawing.Color.Red;
return;
}
}
SqlServer sqlServer = new SqlServer(Util.SqlConnectionString());
childPageNumber = cmsBL.JMD_PAGE_SAVE(hdnChildPageID.Value, hdnSiteName.Value, pageName, pageCaption,
metaTitle, metaDesc, metaKey, "",
"1", "0", "0", "Admin", "Admin", "Admin", "Admin", "Admin", "Admin", "0", "0", "0", "1");
if (lblTitle.Text == "Update Page")
{
DataSet dsPageMod = new DataSet();
dsPageMod = sqlServer.JMD_LOAD_MODS(hdnSiteName.Value, pageName);
if (dsPageMod.Tables[0].Rows.Count > 0)
{
DataRow[] dr = dsPageMod.Tables[0].Select("PAGE_NAME='" + pageName + "'");
if (dr.Length > 0)
pageModID = dr[0]["PAGE_MOD_ID"].ToString();
}
}
sqlServer.JMD_PAGE_MOD_SAVE(pageModID, hdnSiteName.Value, pageName, "7",
"Mod_" + pageName, "7", "1", "0", "Admin;Guests;Registered;",
"Admin;", "Admin;", "Admin;", "Admin;", "0");
lblMessage.Text = "Page Updated Successfully";
lblMessage.ForeColor = System.Drawing.Color.Green;
}
catch (Exception ex)
{
lblMessage.Text = "Page Not Updated";
lblMessage.ForeColor = System.Drawing.Color.Red;
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
try
{
CMSBL cmsBL = new CMSBL();
int returnNumber = -1;
int sortNumber = -1;
string outlineName = txtOutlineName.Text.Replace("'", "''");
string outlineRemark = txtOutlineRemark.Text.Replace("'", "''");
sortNumber = cmsBL.GetDuplicateOutlineSort(hdnSiteID.Value, ddlSortNumber.SelectedValue);
if (sortNumber == 0)
{
if (lblTitle.Text == "Add Outline")
{
returnNumber = cmsBL.GetDuplicateOutline(hdnSiteID.Value, outlineName);
if (returnNumber == 0)
{
returnNumber = cmsBL.CreateOutline(hdnSiteID.Value, outlineName, outlineRemark, ddlSortNumber.SelectedValue, "Y", _userName);
}
}
else if (lblTitle.Text == "Update Outline")
{
returnNumber = cmsBL.UpdateOutline(hdnSiteID.Value, hdnPageID.Value, outlineName, outlineRemark, ddlSortNumber.SelectedValue, _userName);
}
}
if (returnNumber == 1)
{
if (lblTitle.Text == "Add Outline")
{
lblMessage.Text = "Successfully added the new Outline.";
}
else
{
lblMessage.Text = "Successfully updated the Outline.";
}
lblMessage.ForeColor = System.Drawing.Color.Green;
}
else if (returnNumber == 10)
{
lblMessage.Text = "Outline already exist.";
lblMessage.ForeColor = System.Drawing.Color.Red;
}
else if (sortNumber == 10)
{
lblMessage.Text = "Sort Number already exist.";
lblMessage.ForeColor = System.Drawing.Color.Red;
}
else
{
if (lblTitle.Text == "Add Outline")
{
lblMessage.Text = "Outline Not Added.";
}
else
{
lblMessage.Text = "Outline Not Updated.";
}
lblMessage.ForeColor = System.Drawing.Color.Red;
}
}
catch (Exception ex)
{
}
}
private void LoadFields(string siteID, string pageID)
{
try
{
CMSBL cmsBL = new CMSBL();
DataTable siteDT = cmsBL.GetOutline(siteID, pageID);
foreach (DataRow siteDR in siteDT.Rows)
{
txtOutlineName.Text = siteDR["PAGE_NAME"].ToString();
txtOutlineRemark.Text = siteDR["PAGE_REMARK"].ToString();
ddlSortNumber.SelectedValue = siteDR["SORT_NUMBER"].ToString();
hdnMaxSortNum.Value = siteDR["SORT_NUMBER"].ToString();
}
}
catch (Exception ex)
{
}
}