|
ublic partial class StoreCategoriesEdit2 : System.Web.UI.Page |
|
{ |
|
//initalize the Security |
|
public static string Security_level = ""; |
|
|
|
protected void Page_Load(object sender, EventArgs e) |
|
{ |
|
|
|
//check to make sure that we are allowed to see this page |
|
Security_level = AdminSecurity.Page_Security("users"); |
|
if (Security_level == "" || Security_level == "N") |
|
{ |
|
|
|
Messaging.ErrMsg("You Do Not Have Rights To View This Page."); |
|
} |
|
|
|
if (!IsPostBack) |
|
{ |
|
string MySql = "Select FrontEndLanguageId,FrontEndLanguageName " |
|
+ "From SystemFrontEndLanguage " |
|
+ "Order By FrontEndLanguageIsDefualt Desc"; |
|
DataSet rs = DataAccess.ExecuteSqlWithResults(MySql); |
|
foreach (DataRow row in rs.Tables[0].Rows) |
|
{ |
|
AddTab(row["FrontEndLanguageName"].ToString()); |
|
} |
|
rs.Dispose(); |
|
|
|
|
|
MySql = "SELECT a.CategoriesId, b.CategoryLanguageDescription " |
|
+ "FROM (StoreCategories AS a " |
|
+ "INNER JOIN StoreCategoryLanguage AS b " |
|
+ "ON a.CategoriesId = b.CategoriesId) " |
|
+ "INNER JOIN SystemFrontEndLanguage AS c " |
|
+ "ON b.FrontEndLanguageId = c.FrontEndLanguageId " |
|
+ "WHERE (((c.FrontEndLanguageIsDefualt)=\"Y\"))"; |
|
rs = DataAccess.ExecuteSqlWithResults(MySql); |
|
if (rs.Tables[0].Rows.Count != 0 ) |
|
{ |
|
CategoriesParentIdDropDownList.DataSource = rs; |
|
CategoriesParentIdDropDownList.DataValueField = "CategoriesId"; |
|
CategoriesParentIdDropDownList.DataTextField = "CategoryLanguageDescription"; |
|
CategoriesParentIdDropDownList.DataBind(); |
|
} |
|
else |
|
{ |
|
CategoriesParentIdDropDownList.Visible = false; |
|
} |
|
rs.Dispose(); |
|
|
|
} |
|
} |
|
|
|
private void AddTab(string tabName) |
|
{ |
|
RadTab tab = new RadTab(); |
|
tab.Text = tabName; |
|
tab.PageViewID = tabName + "_page"; |
|
RadTabStrip1.Tabs.Add(tab); |
|
RadPageView pageView = new RadPageView(); |
|
pageView.ID = tabName + "_page"; |
|
|
|
RadMultiPage1.PageViews.Add(pageView); |
|
} |
|
|
|
protected void RadMultiPage1_PageViewCreated(object sender, RadMultiPageEventArgs e) |
|
{ |
|
string userControlName = "Controls/CategoriesLanguages.ascx"; |
|
Control userControl = Page.LoadControl(userControlName); |
|
userControl.ID = e.PageView.ID + "_userControl"; |
|
|
|
|
|
e.PageView.Controls.Add(userControl); |
|
|
|
} |
|
|
|
} |