private void SetValuesToControl()
{
objSettings = new tblSettings();
objEncrypt = new clsEncryption();
objSettings.LoadAll();
if (objSettings.RowCount > 0)
{
try
{
txtSiteName.Text = objSettings.AppSiteName;
txtFooter.Text = objSettings.AppFooterText;
chkSiteOffline.Checked = objSettings.AppIsSiteOffline;
txtSiteOfflineMessage.Text = objSettings.AppSiteOfflineMessage;
txtSiteTagLine.Text = objSettings.AppSiteTagLine;
ddlPerMenu.SelectedValue = objSettings.AppSiteDefaultListLimit;
txtPathToFolder.Text = objSettings.AppPathToFolder;
//txtDatasourceName.Text = objSettings.AppDatasource;
//txtDatasourceUserName.Text = objSettings.AppDatasourceUserName;
//txtDataBaseName.Text = objSettings.AppDatabaseName;
txtSMTP.Text = objSettings.AppSMTP;
txtSiteEmail.Text = objSettings.AppSiteEmail;
txtPortNumber.Text = objSettings.AppPortNumber;
txtClientSiteUrl.Text = objSettings.AppClientSiteURL;
txtRecepientEmail.Text = objSettings.AppRecepientEmail;
if (objSettings.AppSiteOfflineImage.ToString() != "" && objSettings.AppSiteOfflineImage.ToString() != null)
{
imgOfflineImage.ImageUrl = objSettings.AppSiteOfflineImage;
}
if (objSettings.AppSiteLogo.ToString() != "" && objSettings.AppSiteLogo.ToString() != null)
{
ImgLogo.ImageUrl = objSettings.AppSiteLogo;
}
if (objSettings.AppSiteFavicon.ToString() != "" && objSettings.AppSiteFavicon.ToString() != null)
{
ImgFavicon.ImageUrl = objSettings.AppSiteFavicon;
}
//txtDatasourcePassword.Attributes.Add("value", objSettings.AppDatasourcePassword);
txtEmailPassword.Attributes.Add("value", objEncrypt.Decrypt(objSettings.AppEmailPassword, appFunctions.strKey));
if (objSettings.s_AppIsCOD != "")
{
CHkIsCOD.Checked = objSettings.AppIsCOD;
}
else
{
CHkIsCOD.Checked = false;
}
}
catch (Exception e)
{
}
}
objSettings = null;
}
//public void loadmenuChild(DataTable DtChildTab, int intLevel,string strPrentId,bool IsTopMenu)
//{
// if (DtChildTab.Rows.Count > 0)
// {
// if (intLevel == 2)
// {
// menuString += "<ul class=\"nav nav-second-level\">";
// }
// else if (intLevel == 3)
// {
// menuString += "<ul class=\"nav nav-third-level\">";
// }
// for (int i = 0; i <= DtChildTab.Rows.Count - 1; i++)
// {
// // If DtTab.Rows(i)("appParentId") <> 0 And DtTab.Rows(i)("appIsAdd").ToString = "False" Then
// if (IsTopMenu)
// {
// menuString += "<li><a href='MenuItems.aspx?ID=" + objEncrypt.Encrypt(DtChildTab.Rows[i]["appMenuTypeId"].ToString(), appFunctions.strKey) + "&type=mtype'>" + DtChildTab.Rows[i]["appMenuTypeName"].ToString();
// }
// else
// {
// menuString += "<li><a href='MenuItems.aspx?ID=" + objEncrypt.Encrypt(DtChildTab.Rows[i]["appMenuItemId"].ToString(), appFunctions.strKey) + "'>" + DtChildTab.Rows[i]["appMenuItem"].ToString();
// }
// objMenuType = new tblMenuType();
// DataTable DTsubchiledMenu = objMenuItem.LoadMenuItems(DtChildTab.Rows[i]["appMenuTypeId"].ToString(), strPrentId);
// if (DTsubchiledMenu.Rows.Count > 0)
// {
// menuString += " <span class=\"fa arrow\"></span> ";
// }
// menuString += "</a>";
// loadmenuChild(DTsubchiledMenu, 3, DtChildTab.Rows[i]["appMenuTypeId"].ToString(),false);
// menuString += "</li>";
// // End If
// }
// menuString += "</ul>";
// }
//}
//public void loadSubChildMenu(string menutypeID, int parentId, bool IsAdd, bool IsEdit)
//{
// DataTable DTsubchiledMenu = new DataTable();
// tblPermission objPermission = new tblPermission();
// DataTable dt = new DataTable();
// if (Session(appFunctions.Session.IsSuperAdmin.ToString) == false)
// {
// dt = objPermission.SelecteMenusubTabPermission(Session(appFunctions.Session.RoleID.ToString));
// IsAdd = dt.Rows(0)("AppIsAdd");
// IsEdit = dt.Rows(0)("AppIsEdit");
// }
// tblMenuItem objMenuItem = new tblMenuItem();
// DTsubchiledMenu = objMenuItem.LoadMenuItems(menutypeID, parentId.ToString);
// if (DTsubchiledMenu.Rows.Count > 0)
// {
// menuString += "<ul>";
// for (i = 0; i <= DTsubchiledMenu.Rows.Count - 1; i++)
// {
// menuString += "<li><a class='menuLink' id='" + DTsubchiledMenu.Rows(i)("appMenuItem").ToString + "' href='MenuItemsList.aspx?ID=" + objEncrypt.Encrypt(DTsubchiledMenu.Rows(i)("appMenuItemId"), appFunctions.strKey) + "'>" + DTsubchiledMenu.Rows(i)("appMenuItem") + "</a>";
// if (IsAdd == true)
// {
// menuString += "<a class='btnLink btnAdd' id='" + DTsubchiledMenu.Rows(i)("appMenuItemId").ToString + "' href='MenuItemDetails.aspx?PID=" + objEncrypt.Encrypt(DTsubchiledMenu.Rows(i)("appMenuItemId"), appFunctions.strKey) + "'> </a>";
// }
// if (IsEdit == true)
// {
// menuString += "<a class='btnLink btnEdit' id='" + DTsubchiledMenu.Rows(i)("appMenuItemId").ToString + "' href='MenuItemDetails.aspx?ID=" + objEncrypt.Encrypt(DTsubchiledMenu.Rows(i)("appMenuItemId"), appFunctions.strKey) + "'> </a>";
// }
// loadSubChildMenu(menutypeID, DTsubchiledMenu.Rows(i)("appMenuItemId"), IsAdd, IsEdit);
// menuString += "</li>";
// }
// menuString += "</ul>";
// }
//}
private void SetSiteDetail()
{
tblSettings objSetting = new tblSettings();
DataTable dt = new DataTable();
dt = objSetting.SetLogo();
if (dt.Rows.Count > 0)
{
linkFavIcon.Href = objSetting.AppSiteFavicon;
SiteLogo.ImageUrl = objSetting.AppSiteLogo;
lblSiteName.Text = objSetting.AppSiteName;
}
}
public void SetUpSiteSettings()
{
tblSettings objSettings = new tblSettings();
objSettings.Query.AddResultColumn(tblSettings.ColumnNames.AppSiteDefaultListLimit);
objSettings.Query.AddResultColumn(tblSettings.ColumnNames.AppFooterText);
objSettings.Query.AddResultColumn(tblSettings.ColumnNames.AppClientSiteURL);
objSettings.Query.Load();
if (objSettings.RowCount > 0)
{
Cache["ListLimit"] = objSettings.AppSiteDefaultListLimit;
Cache["ClientSiteUrl"] = objSettings.AppClientSiteURL;
Cache["FooterText"] = objSettings.AppFooterText;
strListLimit = Cache["ListLimit"].ToString();
}
else
{
Cache["ListLimit"] = "All";
Cache["ClientSiteUrl"] = "#";
Cache["FooterText"] = "";
strListLimit = "All";
}
}
private bool SaveData()
{
objSettings = new tblSettings();
objEncrypt = new clsEncryption();
objSettings.Query.Top = 1;
objSettings.Query.Load();
if (objSettings.RowCount == 0)
{
objSettings = new tblSettings();
objSettings.AddNew();
objSettings.AppCreatedDate = DateTime.Now;
objSettings.s_AppCreatedBy = Session[appFunctions.Session.UserID.ToString()].ToString();
}
objSettings.AppSiteName = txtSiteName.Text;
objSettings.AppFooterText = txtFooter.Text;
objSettings.AppIsSiteOffline = chkSiteOffline.Checked;
objSettings.AppSiteOfflineMessage = txtSiteOfflineMessage.Text;
objSettings.AppSiteTagLine = txtSiteTagLine.Text;
objSettings.AppSiteDefaultListLimit = ddlPerMenu.SelectedValue;
objSettings.AppPathToFolder = txtPathToFolder.Text;
objSettings.AppIsCOD = CHkIsCOD.Checked;
if (txtClientSiteUrl.Text.Contains("http://"))
{
objSettings.AppClientSiteURL = txtClientSiteUrl.Text;
}
else
{
objSettings.AppClientSiteURL = "http://" + txtClientSiteUrl.Text;
}
objSettings.AppEmailPassword = objEncrypt.Encrypt(txtEmailPassword.Text, appFunctions.strKey);
objSettings.AppSMTP = txtSMTP.Text;
objSettings.AppSiteEmail = txtSiteEmail.Text;
objSettings.AppRecepientEmail = txtRecepientEmail.Text;
objSettings.AppPortNumber = txtPortNumber.Text;
string strFilePath = Server.MapPath("~/Uploads/ConfigurationsSetting");
if (FileUploadOfflineImage.HasFile)
{
FileUploadOfflineImage.SaveAs(strFilePath + "/Offline.jpg");
objSettings.AppSiteOfflineImage = "Uploads/ConfigurationsSetting/Offline.jpg";
}
if (FileUploadLogo.HasFile)
{
FileUploadLogo.SaveAs(strFilePath + "/Logo.jpg");
objSettings.AppSiteLogo = "Uploads/ConfigurationsSetting/Logo.jpg";
}
if (FileUploadFavicon.HasFile)
{
FileUploadFavicon.SaveAs(strFilePath + "/Favicon.ico");
objSettings.AppSiteFavicon = "Uploads/ConfigurationsSetting/Favicon.ico";
}
//if (chkDataBaseSettings.Checked)
//{
// SaveDataBaseSettings();
//}
objSettings.Save();
SetUpSiteSettings();
objSettings = null;
return(true);
}
public void SetUpBlocks()
{
tblBlock objBlock = new tblBlock();
StringBuilder blockContent = new StringBuilder();
objBlockDt = objBlock.GetBlockByControlId();
if (Cache["SiteName"] == null)
{
tblSettings objSettings = new tblSettings();
objSettings.Query.AddResultColumn(tblSettings.ColumnNames.AppSiteName);
objSettings.Query.AddResultColumn(tblSettings.ColumnNames.AppSiteTagLine);
objSettings.Query.AddResultColumn(tblSettings.ColumnNames.AppSiteFavicon);
objSettings.LoadAll();
if (objSettings.RowCount > 0)
{
Cache["SiteName"] = objSettings.AppSiteName;
}
}
for (int i = 0; i <= objBlockDt.Rows.Count - 1; i++)
{
blockContent = new StringBuilder();
DataRow dr = objBlockDt.Rows[i];
if (dr["appMenuTypeId"].ToString() != DBNull.Value.ToString() & (bool)dr["appIsShowContent"] == false)
{
objMenuItem = new tblMenuItem();
objMenuDt = new DataTable();
objMenuDt = objMenuItem.GetChildMenus((int)dr["appMenuTypeId"]);
if (string.Compare(dr["appControlId"].ToString(), "divTopMenu") == 0)
{
blockContent.Append(" <div style=\"background-color: #ED258F;\">");
blockContent.Append(" <div class=\"wrap\">");
blockContent.Append(" <div class=\"menu\">");
blockContent.Append("<ul class=\"megamenu skyblue\">");
LoadTopMenu(ref blockContent, 0);
blockContent.Append("</ul></div></div></div>");
}
else if (string.Compare(dr["appControlId"].ToString(), "divFooterBlock1") == 0)
{
objMenuType = new tblMenuType();
if (objMenuType.LoadByPrimaryKey((int)dr["appMenuTypeId"]))
{
LoadFooterMenu(ref blockContent, 0, objMenuType.AppMenuTypeName);
}
objMenuType = null;
}
else if (string.Compare(dr["appControlId"].ToString(), "divFooterBlock2") == 0)
{
objMenuType = new tblMenuType();
if (objMenuType.LoadByPrimaryKey((int)dr["appMenuTypeId"]))
{
LoadCategory(ref blockContent);
}
objMenuType = null;
}
else if (string.Compare(dr["appControlId"].ToString(), "divCategoryFooter") == 0)
{
LoadCategoryFooter(ref blockContent);
}
else if (dr["appMenuTypeId"].ToString() != DBNull.Value.ToString())
{
blockContent.Append("<ul>");
SetUpMenu(ref blockContent, 0);
blockContent.Append("</ul>");
}
}
else if ((bool)dr["appIsShowContent"] == true)
{
blockContent.Append(dr["appContent"]);
}
StringBuilder strContent = new StringBuilder();
strContent.Append(blockContent);
blockContent = new StringBuilder();
blockContent.Append(strContent.ToString().Replace("~GetServerURL()~", PageBase.GetServerURL() + "/"));
if ((this.Master.FindControl("ContentPlaceHolder1").FindControl(dr["appControlId"].ToString()) != null))
{
((HtmlContainerControl)this.Master.FindControl("ContentPlaceHolder1").FindControl(dr["appControlId"].ToString())).InnerHtml = blockContent.ToString();
}
else if ((this.Master.FindControl(dr["appControlId"].ToString()) != null))
{
((HtmlContainerControl)this.Master.FindControl(dr["appControlId"].ToString())).InnerHtml = blockContent.ToString();
}
}
}
