ASP.NET C# AJAX DOTNETNUKE SOLUTIONS GOOGLE APPS - MICROSOFT TECHNICAL ISSUES

Retrieve passwords from a Dotnetnuke system

2010-05-09T11:19:00.002+05:30

I have posted another post for resetting the lost passwords through the database. Today I am going to show how to get the password through a C# code.
DotNetNuke is using a highly secured encrypted method to save passwords to the system. I am not going to explain it here. In some other cases you may need to retrieve the saved passwords. It won’t possible to read it via SQL tables because of it is encrypted.
But if you want to compare the passwords with your logged in user or with your passing password string you can use this method.

public string ReturnPw()
        {
                UserController uc = new UserController();
                UserInfo ui = new UserInfo();
                if (UserId > 0)
                {
                     ui = uc.GetUser(this.PortalId, this.UserId);
                     string un = ui.Username.ToString();

                    UserInfo oUser = UserController.GetUserByName(this.PortalId, un);
                    if (oUser != null)
                    {
                        //Get the password
                        string pwrd = UserController.GetPassword(ref oUser, "");
                        return pwrd;
                    }
                }
                return "N/A";
        }

This method is giving the password of logged in user. But you can customize it as your requirement.

dotnetnuke store product search module - part 1

2010-01-20T14:12:00.019+05:30

DotNetNuke® is the ideal platform for building professional websites and web applications with dynamic content and interactive features. DotNetNuke store module is an ecommerce module which is running on DNN platform. This module contains lots of features. But I saw there was not a product search module. The module team leader Gilles Le Pigocher and Benoit Sarton helped me to develop this feature. Gilles Le Pigocher has added this to his long to do list. So this will be available in the future with a future store version. But until then this will be useful to all of you. Still you can use the store module with the search module what I have given. As you know this module contains 21 projects. Then I have added only source file codes with my modified codes. If you have any questions I am ready to help you. Once again my special thanks to my two French friends Gilles Le Pigocherand Benoît Sarton for their effort and all the advices.

Catalog.ascx.cs

using System;
using System.Collections;
using System.Collections.Specialized;
using System.IO;
using System.Net;
using System.Text.RegularExpressions;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using DotNetNuke.Common.Utilities;
using DotNetNuke.Entities.Modules;
using DotNetNuke.Entities.Modules.Actions;
using DotNetNuke.Services.Exceptions;
using DotNetNuke.Services.Localization;
using DotNetNuke.Security;
using DotNetNuke.Modules.Store.Admin;
using DotNetNuke.Modules.Store.Catalog;
using DotNetNuke.Modules.Store.Components;
using System.Web;

namespace DotNetNuke.Modules.Store.WebControls
{
 public enum ProductListTypes
 {
        New,
  Featured,
  Popular,
  Category,

        MySearchResult
 }

 /// 
 /// Summary description for Media.
 /// 

 public partial class Catalog : PortalModuleBase, IActionable
 {
  #region Private Members

        private ModuleSettings moduleSettings;
        private StoreInfo storeInfo;
        private string templatesPath = "";
  private CatalogNavigation catalogNav;
  private CategoryInfo categoryInfo = new CategoryInfo();
  private ProductInfo productInfo = new ProductInfo();
        private string npTitle = null;
        private string fpTitle = null;

        private string MSTitle = null;

        private string ppTitle = null;
        private string cpTitle = null;
        private enum MetaTags
        {
            Title = 1,
            Keywords,
            Description,
        }
        private Regex regTokens = new Regex("\\[\\w+\\]", RegexOptions.IgnoreCase | RegexOptions.Compiled);

        #endregion

  #region Public Properties

  public ModuleSettings ModuleSettings
  {
   get{return moduleSettings;}
  }

  public Int32 CategoryID
  {
   get {return catalogNav.CategoryID;}
  }

  public Int32 ProductID
  {
   get {return catalogNav.ProductID;}
  }

        public DotNetNuke.Framework.CDefault BasePage
        {
            get { return (DotNetNuke.Framework.CDefault)this.Page; }
        }

        #endregion

  #region Web Form Designer generated code

  override protected void OnInit(EventArgs e)
  {
   //
   // CODEGEN: This call is required by the ASP.NET Web Form Designer.
   //
   InitializeComponent();
   base.OnInit(e);

        }
  
  /// 
  ///  Required method for Designer support - do not modify
  ///  the contents of this method with the code editor.
  /// 

  private void InitializeComponent()
  {
            if (storeInfo == null)
            {
                StoreController storeController = new StoreController();
                storeInfo = storeController.GetStoreInfo(PortalId);
            }
        }

  #endregion

  #region Events

  protected void Page_Load(object sender, System.EventArgs e)
  {
            if (storeInfo != null)
            {
                npTitle = Localization.GetString("NPTitle.Text", this.LocalResourceFile);
                fpTitle = Localization.GetString("FPTitle.Text", this.LocalResourceFile);

                MSTitle = Localization.GetString("MSTitle.Text", this.LocalResourceFile);

                ppTitle = Localization.GetString("PPTitle.Text", this.LocalResourceFile);
                cpTitle = Localization.GetString("CPTitle.Text", this.LocalResourceFile);

                try
                {
                    if (storeInfo.PortalTemplates)
                    {
                        templatesPath = PortalSettings.HomeDirectoryMapPath + "Store\\";
                        CssTools.AddCss(this.Page, PortalSettings.HomeDirectory + "Store", PortalId);
                    }
                    else
                    {
                        templatesPath = MapPath(ModulePath) + "\\";
                        CssTools.AddCss(this.Page, this.TemplateSourceDirectory, PortalId);
                    }

                    moduleSettings = new ModuleSettings(this.ModuleId, this.TabId);

                    catalogNav = new CatalogNavigation(Request.QueryString);

                    if (catalogNav.CategoryID == Null.NullInteger)
                    {
                        if (bool.Parse(moduleSettings.General.UseDefaultCategory))
                        {
                            catalogNav.CategoryID = int.Parse(moduleSettings.General.DefaultCategoryID);
                            Response.Redirect(catalogNav.GetNavigationUrl(), true);
                        }
                    }

                    if (catalogNav.ProductID != Null.NullInteger)
                    {
                        ProductController productController = new ProductController();
                        productInfo = productController.GetProduct(PortalId, catalogNav.ProductID);
                        catalogNav.CategoryID = productInfo.CategoryID;
                    }

                    if (catalogNav.CategoryID != Null.NullInteger)
                    {
                        CategoryController categoryController = new CategoryController();
                        categoryInfo = categoryController.GetCategory(catalogNav.CategoryID);
                    }

                    if (storeInfo.SEOFeature)
                    {
                        BasePage.Title = SEO(Localization.GetString("ListSEOTitle", this.LocalResourceFile), MetaTags.Title);
                        BasePage.Description = SEO(Localization.GetString("ListSEODescription", this.LocalResourceFile), MetaTags.Description);
                        BasePage.KeyWords = SEO(Localization.GetString("ListSEOKeywords", this.LocalResourceFile), MetaTags.Keywords);
                    }

                    this.Controls.Add(TemplateController.ParseTemplate(templatesPath, moduleSettings.General.Template, new ProcessTokenDelegate(processToken)));
                }
                catch (Exception ex)
                {
                    Exceptions.ProcessModuleLoadException(this, ex);
                }
            }
            else
            {
                string ErrorSettings = Localization.GetString("ErrorSettings", this.LocalResourceFile);
                string ErrorSettingsHeading = Localization.GetString("ErrorSettingsHeading", this.LocalResourceFile);
                DotNetNuke.UI.Skins.Skin.AddModuleMessage(this, ErrorSettingsHeading, ErrorSettings, DotNetNuke.UI.Skins.Controls.ModuleMessage.ModuleMessageType.YellowWarning);
            }
        }

  #endregion

  #region Private Functions

  private Control processToken(string tokenName)
  {
   ProductController productController = new ProductController();
   ArrayList productList = new ArrayList();

   switch (tokenName.ToUpper())
   {
    case "MESSAGE":
                    if (bool.Parse(moduleSettings.General.ShowMessage) && categoryInfo != null)
                    {
                        Panel pnlMessage = new Panel();
                        pnlMessage.CssClass = "StoreMessage";
                        if (categoryInfo != null)
                        {
                            string message = Server.HtmlDecode(categoryInfo.Message);
                            if (message != Null.NullString)
                            {
                                Panel pnlCategoryMessage = new Panel();
                                pnlCategoryMessage.CssClass = "StoreCategoryMessage";
                                Literal litCategoryMessage = new Literal();
                                litCategoryMessage.Text = System.Web.HttpUtility.HtmlDecode(message);
                                pnlCategoryMessage.Controls.Add(litCategoryMessage);
                                pnlMessage.Controls.Add(pnlCategoryMessage);
                            }
                        }

                        if (catalogNav.CategoryID != Null.NullInteger)
                        {
                            //sub categories...
                            CategoryController controller = new CategoryController();
                            ArrayList subCategories = controller.GetCategories(PortalId, false, catalogNav.CategoryID);
                            if (subCategories.Count > 0)
                            {
                                HtmlGenericControl pSubCategories = new HtmlGenericControl("p");
                                pSubCategories.Attributes.Add("class", "StoreSubCategories");

                                LiteralControl BreakRow = new LiteralControl(Localization.GetString("BeforeSubCategories", this.LocalResourceFile));
                                pSubCategories.Controls.Add(BreakRow);

                                Boolean bIsFirst = true;
                                foreach (CategoryInfo category in subCategories)
                                {
                                    if (bIsFirst)
                                    {
                                        bIsFirst = false;
                                    }
                                    else
                                    {
                                        LiteralControl BreakRow2 = new LiteralControl(Localization.GetString("BetweenSubCategories", this.LocalResourceFile));
                                        pSubCategories.Controls.Add(BreakRow2);
                                    }
                                    HyperLink link = new HyperLink();
                                    link.Text = category.CategoryName;
                                    link.CssClass = "StoreSubCategoryItem";
                                    StringDictionary replaceParams = new StringDictionary();
                                    replaceParams["CategoryID"] = category.CategoryID.ToString();
                                    replaceParams["ProductID"] = Null.NullString;
                                    replaceParams["PageIndex"] = Null.NullString;
                                    link.NavigateUrl = catalogNav.GetNavigationUrl(replaceParams, storeInfo.StorePageID);
                                    pSubCategories.Controls.Add(link);
                                }
                                BreakRow = new LiteralControl(Localization.GetString("AfterSubCategories", this.LocalResourceFile));
                                pSubCategories.Controls.Add(BreakRow);
                                pnlMessage.Controls.Add(pSubCategories);
                            }
                        }
                        return pnlMessage;
                    }
                    else
                        return null;

                case "NEW":
                    if (bool.Parse(moduleSettings.General.ShowNewProducts))
                    {
                        if (catalogNav.CategoryID != Null.NullInteger)
                        {
                            GetNewProducts(catalogNav.CategoryID, productList);
                            productList = TruncateList(productList, int.Parse(moduleSettings.NewProducts.RowCount) * int.Parse(moduleSettings.NewProducts.ColumnCount));
                            return LoadProductList(productList, ProductListTypes.New);
                        }
                        else
                        {
                            GetPortalNewProducts(PortalId, productList);
                            productList = TruncateList(productList, int.Parse(moduleSettings.NewProducts.RowCount) * int.Parse(moduleSettings.NewProducts.ColumnCount));
                            return LoadProductList(productList, ProductListTypes.New);
                        }
                    }
                    else
                    {
                        return null;
                    }

    case "FEATURED":
     if (bool.Parse(moduleSettings.General.ShowFeaturedProducts))
     {
      if(catalogNav.CategoryID != Null.NullInteger)
      {
                            GetFeaturedProducts(catalogNav.CategoryID, productList);
       productList = TruncateList(productList, int.Parse(moduleSettings.FeaturedProducts.RowCount) * int.Parse(moduleSettings.FeaturedProducts.ColumnCount));
       return LoadProductList(productList, ProductListTypes.Featured);
      }
      else
      {
                            GetPortalFeaturedProducts(PortalId, productList);
       productList = TruncateList(productList, int.Parse(moduleSettings.FeaturedProducts.RowCount) * int.Parse(moduleSettings.FeaturedProducts.ColumnCount));
       return LoadProductList(productList, ProductListTypes.Featured);
      }
     }
     else
     {
      return null;
     }


                case "MYSEARCHRESULT":

                    if (bool.Parse(moduleSettings.General.ShowMYSEARCHProducts))
                    {

                        if (catalogNav.CategoryID != Null.NullInteger)
                        {
                            GetMYSEARCHProducts(catalogNav.CategoryID, productList, catalogNav.SearchText, catalogNav.SearchField);
                            productList = TruncateList(productList, int.Parse(moduleSettings.MYSEARCHProducts.RowCount) * int.Parse(moduleSettings.MYSEARCHProducts.ColumnCount));
                            return LoadProductList(productList, ProductListTypes.MySearchResult);
                        }
                        else
                        {
                            GetPortalMYSEARCHProducts(PortalId, productList, catalogNav.SearchText, catalogNav.SearchField);
                            productList = TruncateList(productList, int.Parse(moduleSettings.MYSEARCHProducts.RowCount) * int.Parse(moduleSettings.MYSEARCHProducts.ColumnCount));
                            return LoadProductList(productList, ProductListTypes.MySearchResult);
                        }
                    }
                    else
                    {
                        return null;
                    }



    case "POPULAR":
     if (bool.Parse(moduleSettings.General.ShowPopularProducts))
     {
      if(catalogNav.CategoryID != Null.NullInteger)
      {
                            GetPopularProducts(catalogNav.CategoryID, productList);
       productList = TruncateList(productList, int.Parse(moduleSettings.PopularProducts.RowCount) * int.Parse(moduleSettings.PopularProducts.ColumnCount));
       return LoadProductList(productList, ProductListTypes.Popular);
      }
      else
      {
                            GetPortalPopularProducts(PortalId, productList);
                            productList = TruncateList(productList, int.Parse(moduleSettings.PopularProducts.RowCount) * int.Parse(moduleSettings.PopularProducts.ColumnCount));
       return LoadProductList(productList, ProductListTypes.Popular);
      }
     }
     else
     {
      return null;
     }

    case "CATEGORY":
     if (bool.Parse(moduleSettings.General.ShowCategoryProducts))
     {
      if(catalogNav.CategoryID != Null.NullInteger && catalogNav.ProductID == Null.NullInteger)
      {
                            GetCategoryProducts(catalogNav.CategoryID, productList);
       return LoadProductList(productList, ProductListTypes.Category);
      }
      else
      {
       return null;
      }
     }
     else
     {
      return null;
     }

    case "DETAIL":
     if(bool.Parse(moduleSettings.General.ShowProductDetail) && catalogNav.ProductID != Null.NullInteger)
     {
      return LoadProductDetail();
     }
     else
     {
      return null;
     }

    default:
     LiteralControl litText = new LiteralControl(tokenName);
     return litText;
   }
  }

        private void GetNewProducts(int categoryID, ArrayList products)
        {
            CategoryController categoryController = new CategoryController();
            ProductController productController = new ProductController();

            CategoryInfo category = categoryController.GetCategory(categoryID);

            foreach (ProductInfo product in productController.GetNewProducts(categoryID, false))
            {
                if (storeInfo.ProductsBehavior == (int)Behavior.HideProduct && product.StockQuantity < 1)
                {
                    // Do nothing, in this case the product is hidden
                }
                else
                    products.Add(product);
            }

            foreach (CategoryInfo childCategory in categoryController.GetCategories(PortalId, false, categoryID))
            {
                if (childCategory.CategoryID != Null.NullInteger)
                {
                    GetNewProducts(childCategory.CategoryID, products);
                }
            }
        }

        private void GetPortalNewProducts(int portalID, ArrayList products)
        {
            ProductController productController = new ProductController();

            foreach (ProductInfo product in productController.GetPortalNewProducts(portalID, false))
            {
                if (storeInfo.ProductsBehavior == (int)Behavior.HideProduct && product.StockQuantity < 1)
                {
                    // Do nothing, in this case the product is hidden
                }
                else
                    products.Add(product);
            }
        }

        private void GetFeaturedProducts(int categoryID, ArrayList products)
        {
            CategoryController categoryController = new CategoryController();
            ProductController productController = new ProductController();

            CategoryInfo category = categoryController.GetCategory(categoryID);

            foreach (ProductInfo product in productController.GetFeaturedProducts(categoryID, false))
            {
                if (storeInfo.ProductsBehavior == (int)Behavior.HideProduct && product.StockQuantity < 1)
                {
                    // Do nothing, in this case the product is hidden
                }
                else
                    products.Add(product);
            }

            foreach (CategoryInfo childCategory in categoryController.GetCategories(PortalId, false, categoryID))
            {
                if (childCategory.CategoryID != Null.NullInteger)
                {
                    GetFeaturedProducts(childCategory.CategoryID, products);
                }
            }
        }

        private void GetPortalFeaturedProducts(int portalID, ArrayList products)
        {
            ProductController productController = new ProductController();

            foreach (ProductInfo product in productController.GetPortalFeaturedProducts(portalID, false))
            {
                if (storeInfo.ProductsBehavior == (int)Behavior.HideProduct && product.StockQuantity < 1)
                {
                    // Do nothing, in this case the product is hidden
                }
                else
                    products.Add(product);
            }
        }


        private void GetMYSEARCHProducts(int categoryID, ArrayList products, string SearchText, string SearchField)
        {
            CategoryController categoryController = new CategoryController();
            ProductController productController = new ProductController();

            CategoryInfo category = categoryController.GetCategory(categoryID);

            foreach (ProductInfo product in productController.GetMYSEARCHProducts(categoryID, false,SearchText,SearchField))
            {
                if (storeInfo.ProductsBehavior == (int)Behavior.HideProduct && product.StockQuantity < 1)
                {
                    // Do nothing, in this case the product is hidden
                }
                else
                    products.Add(product);
            }

            foreach (CategoryInfo childCategory in categoryController.GetCategories(PortalId, false, categoryID))
            {
                if (childCategory.CategoryID != Null.NullInteger)
                {
                    GetMYSEARCHProducts(childCategory.CategoryID, products,SearchText,SearchField);
                }
            }
        }

        private void GetPortalMYSEARCHProducts(int portalID, ArrayList products, string SearchText, string SearchField)
        {
            ProductController productController = new ProductController();

            foreach (ProductInfo product in productController.GetPortalMYSEARCHProducts(portalID, false,SearchText,SearchField))
            {
                if (storeInfo.ProductsBehavior == (int)Behavior.HideProduct && product.StockQuantity < 1)
                {
                    // Do nothing, in this case the product is hidden
                }
                else
                    products.Add(product);
            }
        }


        private void GetPopularProducts(int categoryID, ArrayList products)
        {
            CategoryController categoryController = new CategoryController();
            ProductController productController = new ProductController();

            CategoryInfo category = categoryController.GetCategory(categoryID);

            foreach (ProductInfo product in productController.GetPopularProducts(PortalId, categoryID, false))
            {
                if (storeInfo.ProductsBehavior == (int)Behavior.HideProduct && product.StockQuantity < 1)
                {
                    // Do nothing, in this case the product is hidden
                }
                else
                    products.Add(product);
            }

            foreach (CategoryInfo childCategory in categoryController.GetCategories(PortalId, false, categoryID))
            {
                if (childCategory.CategoryID != Null.NullInteger)
                {
                    GetPopularProducts(childCategory.CategoryID, products);
                }
            }
        }

        private void GetPortalPopularProducts(int portalID, ArrayList products)
        {
            ProductController productController = new ProductController();

            foreach (ProductInfo product in productController.GetPortalPopularProducts(portalID, false))
            {
                if (storeInfo.ProductsBehavior == (int)Behavior.HideProduct && product.StockQuantity < 1)
                {
                    // Do nothing, in this case the product is hidden
                }
                else
                    products.Add(product);
            }
        }

        private void GetCategoryProducts(int categoryID, ArrayList products)
        {
            CategoryController categoryController = new CategoryController();
            ProductController productController = new ProductController();

            CategoryInfo category = categoryController.GetCategory(categoryID);

            int sortID;
            if (catalogNav.SortID != Null.NullInteger)
            {
                // Currently selected sort column
                sortID = catalogNav.SortID;
            }
            else
            {
                // Default sort column
                sortID = int.Parse(moduleSettings.CategoryProducts.SortBy);
            }
            string sortDir;
            if (catalogNav.SortDir != Null.NullString)
            {
                // Currently selected sort direction
                sortDir = catalogNav.SortDir;
            }
            else
            {
                // Default sort direction
                sortDir = moduleSettings.CategoryProducts.SortDir;
            }

            foreach (ProductInfo product in productController.GetCategoryProducts(categoryID, false, sortID, sortDir))
            {
                if (storeInfo.ProductsBehavior == (int)Behavior.HideProduct && product.StockQuantity < 1)
                {
                    // Do nothing, in this case the product is hidden
                }
                else
                    products.Add(product);
            }

            if (bool.Parse(moduleSettings.CategoryProducts.SubCategories))
            {
                foreach (CategoryInfo childCategory in categoryController.GetCategories(PortalId, false, categoryID))
                {
                    if (childCategory.CategoryID != Null.NullInteger)
                    {
                        GetCategoryProducts(childCategory.CategoryID, products);
                    }
                }
            }
        }

  private Control LoadProductList(ArrayList products, ProductListTypes listType)
  {
   if (products != null && products.Count > 0)
   {
    ProductList productList = (ProductList)LoadControl(ModulePath + "ProductList.ascx");
    productList.ParentControl = this as PortalModuleBase;
    productList.CategoryID = catalogNav.CategoryID;
                productList.ModuleConfiguration = this.ModuleConfiguration;

    switch (listType)
    {
                    case ProductListTypes.New:
                        productList.ListType = listType;
                        productList.Title = npTitle;
                        productList.ContainerTemplate = moduleSettings.NewProducts.ContainerTemplate;
                        productList.ContainerCssClass = "StoreNewProductList";
                        productList.Template = moduleSettings.NewProducts.Template;
                        productList.ItemCssClass = "StoreNewProductItem";
                        productList.AlternatingItemCssClass = "StoreNewProductAlternatingItem";
                        productList.RowCount = int.Parse(moduleSettings.NewProducts.RowCount);
                        productList.ColumnCount = int.Parse(moduleSettings.NewProducts.ColumnCount);
                        productList.ColumnWidth = int.Parse(moduleSettings.NewProducts.ColumnWidth);
                        productList.Direction = moduleSettings.NewProducts.RepeatDirection;
                        productList.ShowThumbnail = bool.Parse(moduleSettings.NewProducts.ShowThumbnail);
                        productList.ThumbnailWidth = int.Parse(moduleSettings.NewProducts.ThumbnailWidth);
                        productList.ShowDetail = bool.Parse(moduleSettings.General.ShowProductDetail);
                        productList.DetailPage = int.Parse(moduleSettings.NewProducts.DetailPage);
                        break;

     case ProductListTypes.Featured:
                        productList.ListType = listType;
                        productList.Title = fpTitle;
                        productList.ContainerTemplate = moduleSettings.FeaturedProducts.ContainerTemplate;
                        productList.ContainerCssClass = "StoreFeaturedProductList";
      productList.Template = moduleSettings.FeaturedProducts.Template;
                        productList.ItemCssClass = "StoreFeaturedProductItem";
                        productList.AlternatingItemCssClass = "StoreFeaturedProductAlternatingItem";
      productList.RowCount = int.Parse(moduleSettings.FeaturedProducts.RowCount);
      productList.ColumnCount = int.Parse(moduleSettings.FeaturedProducts.ColumnCount);
      productList.ColumnWidth = int.Parse(moduleSettings.FeaturedProducts.ColumnWidth);
                        productList.Direction = moduleSettings.FeaturedProducts.RepeatDirection;
      productList.ShowThumbnail = bool.Parse(moduleSettings.FeaturedProducts.ShowThumbnail);
      productList.ThumbnailWidth = int.Parse(moduleSettings.FeaturedProducts.ThumbnailWidth);
                        productList.ShowDetail = bool.Parse(moduleSettings.General.ShowProductDetail);
      productList.DetailPage = int.Parse(moduleSettings.FeaturedProducts.DetailPage);
      break;

                    case ProductListTypes.MySearchResult:
                        productList.ListType = listType;
                        productList.Title = MSTitle;
                        productList.ContainerTemplate = moduleSettings.MYSEARCHProducts.ContainerTemplate;
                        productList.ContainerCssClass = "StoreFeaturedProductList";
                        productList.Template = moduleSettings.MYSEARCHProducts.Template;
                        productList.ItemCssClass = "StoreFeaturedProductItem";
                        productList.AlternatingItemCssClass = "StoreFeaturedProductAlternatingItem";
                        productList.RowCount = int.Parse(moduleSettings.MYSEARCHProducts.RowCount);
                        productList.ColumnCount = int.Parse(moduleSettings.MYSEARCHProducts.ColumnCount);
                        productList.ColumnWidth = int.Parse(moduleSettings.MYSEARCHProducts.ColumnWidth);
                        productList.Direction = moduleSettings.MYSEARCHProducts.RepeatDirection;
                        productList.ShowThumbnail = bool.Parse(moduleSettings.MYSEARCHProducts.ShowThumbnail);
                        productList.ThumbnailWidth = int.Parse(moduleSettings.MYSEARCHProducts.ThumbnailWidth);
                        productList.ShowDetail = bool.Parse(moduleSettings.General.ShowProductDetail);
                        productList.DetailPage = int.Parse(moduleSettings.MYSEARCHProducts.DetailPage);
                        break;

     case ProductListTypes.Popular:
                        productList.ListType = listType;
                        productList.Title = ppTitle;
                        productList.ContainerTemplate = moduleSettings.PopularProducts.ContainerTemplate;
                        productList.ContainerCssClass = "StorePopularProductList";
      productList.Template = moduleSettings.PopularProducts.Template;
                        productList.ItemCssClass = "StorePopularProductItem";
                        productList.AlternatingItemCssClass = "StorePopularProductAlternatingItem";
      productList.RowCount = int.Parse(moduleSettings.PopularProducts.RowCount);
      productList.ColumnCount = int.Parse(moduleSettings.PopularProducts.ColumnCount);
      productList.ColumnWidth = int.Parse(moduleSettings.PopularProducts.ColumnWidth);
                        productList.Direction = moduleSettings.PopularProducts.RepeatDirection;
      productList.ShowThumbnail = bool.Parse(moduleSettings.PopularProducts.ShowThumbnail);
      productList.ThumbnailWidth = int.Parse(moduleSettings.PopularProducts.ThumbnailWidth);
                        productList.ShowDetail = bool.Parse(moduleSettings.General.ShowProductDetail);
      productList.DetailPage = int.Parse(moduleSettings.PopularProducts.DetailPage);
      break;

     case ProductListTypes.Category:
                        productList.ListType = listType;
                        productList.Title = cpTitle;
                        productList.ContainerTemplate = moduleSettings.CategoryProducts.ContainerTemplate;
                        productList.ContainerCssClass = "StoreCategoryProductList";
      productList.Template = moduleSettings.CategoryProducts.Template;
                        productList.ItemCssClass = "StoreCategoryProductItem";
                        productList.AlternatingItemCssClass = "StoreCategoryProductAlternatingItem";
      productList.RowCount = int.Parse(moduleSettings.CategoryProducts.RowCount);
      productList.ColumnCount = int.Parse(moduleSettings.CategoryProducts.ColumnCount);
      productList.ColumnWidth = int.Parse(moduleSettings.CategoryProducts.ColumnWidth);
                        productList.Direction = moduleSettings.CategoryProducts.RepeatDirection;
      productList.ShowThumbnail = bool.Parse(moduleSettings.CategoryProducts.ShowThumbnail);
      productList.ThumbnailWidth = int.Parse(moduleSettings.CategoryProducts.ThumbnailWidth);
                        productList.ShowDetail = bool.Parse(moduleSettings.General.ShowProductDetail);
      productList.DetailPage = int.Parse(moduleSettings.CategoryProducts.DetailPage);
      break;
    }

    productList.DataSource = products;
    
    return productList;
   }
   else
   {
    return null;
   }
  }

  private Control LoadProductDetail()
  {
   ProductDetail productDetail = (ProductDetail)LoadControl(ModulePath + "ProductDetail.ascx");

   productDetail.ParentControl = this as PortalModuleBase;
            productDetail.ModuleConfiguration = this.ModuleConfiguration;
   productDetail.CategoryID = productInfo.CategoryID;
   productDetail.ShowThumbnail = bool.Parse(moduleSettings.ProductDetail.ShowThumbnail);
   productDetail.ThumbnailWidth = int.Parse(moduleSettings.ProductDetail.ThumbnailWidth);
   productDetail.ShowReviews = bool.Parse(moduleSettings.ProductDetail.ShowReviews);
   productDetail.DataSource = productInfo;

   return productDetail;
  }

  private ArrayList TruncateList(ArrayList list, int maxCount)
  {
   if (list.Count > maxCount)
   {
    list.RemoveRange(maxCount, list.Count - maxCount);
   }
   return list;
  }

        private string SEO(string seoResource, MetaTags metaType)
        {
            string tempResource = seoResource;
            string tempValue = "";
            MatchCollection matchCol = regTokens.Matches(tempResource);

            if (matchCol.Count > 0)
            {
                foreach (Match match in matchCol)
                {
                    switch (metaType)
                    {
                        case MetaTags.Title:
                            switch (match.Value.ToUpper())
                            {
                                case "[PAGETITLE]":
                                    tempValue = BasePage.Title;
                                    break;
                                case "[STORETITLE]":
                                    tempValue = storeInfo.Name;
                                    break;
                                case "[CATEGORYNAME]":
                                    if (catalogNav.CategoryID != Null.NullInteger)
                                    {
                                        tempValue = categoryInfo.CategoryName;
                                    }
                                    else
                                    {
                                        tempValue = "";
                                    }
                                    break;
                                default:
                                    tempValue = match.Value;
                                    break;
                            }
                            break;
                        case MetaTags.Keywords:
                            switch (match.Value.ToUpper())
                            {
                                case "[PAGEKEYWORDS]":
                                    tempValue = BasePage.KeyWords;
                                    break;
                                case "[STOREKEYWORDS]":
                                    tempValue = storeInfo.Keywords;
                                    break;
                                case "[CATEGORYKEYWORDS]":
                                    if (catalogNav.CategoryID != Null.NullInteger)
                                    {
                                        tempValue = categoryInfo.CategoryKeywords;
                                    }
                                    else
                                    {
                                        tempValue = "";
                                    }
                                    break;
                                default:
                                    tempValue = match.Value;
                                    break;
                            }
                            break;
                        case MetaTags.Description:
                            switch (match.Value.ToUpper())
                            {
                                case "[PAGEDESCRIPTION]":
                                    tempValue = BasePage.Description;
                                    break;
                                case "[STOREDESCRIPTION]":
                                    tempValue = storeInfo.Description;
                                    break;
                                case "[CATEGORYDESCRIPTION]":
                                    if (catalogNav.CategoryID != Null.NullInteger)
                                    {
                                        tempValue = categoryInfo.CategoryDescription;
                                    }
                                    else
                                    {
                                        tempValue = "";
                                    }
                                    break;
                                default:
                                    tempValue = match.Value;
                                    break;
                            }
                            break;
                    }
                    tempResource = tempResource.Replace(match.Value, tempValue);
                }
            }
            return tempResource.Trim();
        }

        #endregion

  #region IActionable Members

  public DotNetNuke.Entities.Modules.Actions.ModuleActionCollection ModuleActions
  {
   get
   {
    ModuleActionCollection actions = new ModuleActionCollection();
                if (storeInfo != null)
                {
                    actions.Add(GetNextActionID(), Localization.GetString("AddNewProduct", this.LocalResourceFile), ModuleActionType.AddContent, "", "", EditUrl("EditID", "Product"), false, SecurityAccessLevel.Edit, true, false);
                }
    return actions; 
   }
  }

  #endregion
 }
}

Continue - Part 2

dotnetnuke store product search module - part 2

2010-01-20T14:12:00.017+05:30

ProductList.ascx.cs

using System;
using System.Globalization;
using System.Collections;
using System.Collections.Specialized;
using System.Web;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using DotNetNuke.Common;
using DotNetNuke.Common.Utilities;
using DotNetNuke.Modules.Store.Admin;
using DotNetNuke.Modules.Store.Catalog;
using DotNetNuke.Modules.Store.Components;
//using DotNetNuke.Modules.Store.Providers.Tax;
using DotNetNuke.Services.Localization;

namespace DotNetNuke.Modules.Store.WebControls
{
 /// 
 /// Summary description for Media.
 /// 

 public partial class ProductList : StoreControlBase
 {
  #region Private Declarations

        private ModuleSettings moduleSettings;
        private CatalogNavigation moduleNav;
  private ProductInfo productInfo;
        private CategoryController categoryControler;
        private int categoryID = 0;
  private string templatesPath = "";
  private string imagesPath = "";
  private string title = "";
        private string containerTemplate = "";
        private string containerCssClass = "";
  private string template = "";
        private string itemCssClass = "";
        private string alternatingItemCssClass = "";
  private int rowCount = 10;
  private int columnCount = 2;
  private int columnWidth = 200;
        private string direction = "";
  private bool showThumbnail = true;
  private int thumbnailWidth = 90;
  private bool showDetail = true;
  private int detailPageID = 0;
        private ProductListTypes listType;
        private StoreInfo storeInfo;
        private NumberFormatInfo LocalFormat = (NumberFormatInfo)NumberFormatInfo.CurrentInfo.Clone();
        private ArrayList labelsPageInfo = new ArrayList();
        private ArrayList labelsPageNav = new ArrayList();
        private ArrayList buttonsPrevious = new ArrayList();
        private ArrayList buttonsNext = new ArrayList();
        private ArrayList placeholdersPageList = new ArrayList();
        private DataList lstProducts;

        

        #endregion

  #region Public Properties

  public int CategoryID
  {
   get {return categoryID;}
   set {categoryID = value;}
  }

  public string Title
  {
   get {return title;}
   set {title = value;}
  }

        public string ContainerTemplate
  {
            get { return containerTemplate; }
            set { containerTemplate = value; }
  }

        public string ContainerCssClass
  {
            get { return containerCssClass; }
            set { containerCssClass = value; }
  }

  public string Template
  {
   get {return template;}
   set {template = value;}
  }

  public string ItemCssClass
  {
            get { return itemCssClass; }
            set { itemCssClass = value; }
  }

        public string AlternatingItemCssClass
  {
            get { return alternatingItemCssClass; }
            set { alternatingItemCssClass = value; }
  }

  public int RowCount
  {
   get {return rowCount;}
   set {rowCount = value;}
  }

  public int ColumnCount
  {
   get {return columnCount;}
   set {columnCount = value;}
  }

  public int ColumnWidth
  {
   get {return columnWidth;}
   set {columnWidth = value;}
  }

        public string Direction
  {
            get { return direction; }
            set { direction = value; }
  }

  public bool ShowThumbnail
  {
   get {return showThumbnail;}
   set {showThumbnail = value;}
  }
  
  public int ThumbnailWidth
  {
   get {return thumbnailWidth;}
   set {thumbnailWidth = value;}
  }

  public bool ShowDetail
  {
            get { return showDetail; }
            set { showDetail = value; }
  }

  public int DetailPage
  {
   get { return detailPageID; }
   set { detailPageID = value; }
  }

        public ProductListTypes ListType
        {
            get { return listType; }
            set { listType = value; }
        }

  #endregion

  #region Web Form Designer generated code
  override protected void OnInit(EventArgs e)
  {
   //
   // CODEGEN: This call is required by the ASP.NET Web Form Designer.
   //
   InitializeComponent();
   base.OnInit(e);
  }
  
  /// 
  ///  Required method for Designer support - do not modify
  ///  the contents of this method with the code editor.
  /// 

  private void InitializeComponent()
  {
  }
  #endregion

  #region Events

  protected void Page_Load(object sender, EventArgs e)
  {
            if (storeInfo == null)
            {
                StoreController storeController = new StoreController();
                storeInfo = storeController.GetStoreInfo(PortalId);
                if (storeInfo.PortalTemplates)
                {
                    templatesPath = PortalSettings.HomeDirectoryMapPath + "Store\\";
                    imagesPath = PortalSettings.HomeDirectory + "Store/Templates/Images/";
                }
                else
                {
                    templatesPath = MapPath(ModulePath);
                    imagesPath = parentControl.ModulePath + "Templates/Images/";
                }
            }

            if (storeInfo.CurrencySymbol != string.Empty)
            {
                LocalFormat.CurrencySymbol = storeInfo.CurrencySymbol;
            }

            moduleSettings = new ModuleSettings(this.ModuleId, this.TabId);

            moduleNav = new CatalogNavigation(Request.QueryString);

            //0 indicates that no detail page is being used, so use current tabid
   if (this.DetailPage == 0) 
   {
    this.DetailPage = this.TabId;
   }
   moduleNav.TabId = this.DetailPage;

   if (moduleNav.PageIndex == Null.NullInteger)
   {
    moduleNav.PageIndex = 1;
   }

            if (containerTemplate == string.Empty)
            {
                this.Controls.Add(TemplateController.ParseTemplate(templatesPath, "ListContainer.htm", new ProcessTokenDelegate(processToken)));
            }
            else
            {
                this.Controls.Add(TemplateController.ParseTemplate(templatesPath, containerTemplate, new ProcessTokenDelegate(processToken)));
            }
            if (lstProducts != null) BindData();
        }

  private void lstProducts_ItemDataBound(object sender, DataListItemEventArgs e)
  {
   productInfo = (ProductInfo)e.Item.DataItem;

            if (columnWidth > 0)
       e.Item.Width = columnWidth;
            switch (e.Item.ItemType)
            {
                case ListItemType.Item:
                    e.Item.CssClass = itemCssClass;
                    break;
                case ListItemType.AlternatingItem:
                    e.Item.CssClass = alternatingItemCssClass;
                    break;
            }

            ProductDetail productListItem = (ProductDetail)LoadControl(ModulePath + "ProductDetail.ascx");
            productListItem.Template = template;
            productListItem.ParentControl = this.ParentControl;
            productListItem.CategoryID = productInfo.CategoryID;
            productListItem.ShowThumbnail = ShowThumbnail;
            productListItem.ThumbnailWidth = ThumbnailWidth;
            productListItem.DataSource = productInfo;
            productListItem.ShowDetail = (showDetail == false) & (detailPageID == Null.NullInteger) ? false : true;
            productListItem.DetailID = detailPageID;
            productListItem.InList = true;

            e.Item.Controls.Add(productListItem);
  }

  #endregion

  #region Protected Functions

  protected void BindData()
  {
   PagedDataSource pagedData = null;

   // Get the product data
   ArrayList productArray = (dataSource as ArrayList);
   if ((productArray == null) || (productArray.Count == 0))
   {
                foreach (Label lblPageNav in labelsPageNav)
                {
                    lblPageNav.Visible = false;
                }
            }
   else
   {
    int itemCount  = productArray.Count;
    int pageSize  = rowCount * columnCount;
    int currentPage  = moduleNav.PageIndex - 1; // Convert to zero-based index

                foreach (Label lblPageNav in labelsPageNav)
                {
                    lblPageNav.Visible = true;
                }

    // Created paged data source
    pagedData = new PagedDataSource();
                if (ViewState["productArray"] != null && IsPostBack)
                {
                    pagedData.DataSource = (ArrayList)ViewState["productArray"];
                }
                else
                {
                    pagedData.DataSource = productArray;
                    ViewState["productArray"] = pagedData.DataSource;
                }
    pagedData.AllowPaging = true;
    pagedData.PageSize = pageSize;
    pagedData.CurrentPageIndex = currentPage;

    UpdatePagingControls(itemCount, pageSize, moduleNav.PageIndex);
   }

   // Databind with product list
            if (lstProducts != null)
            {
                lstProducts.DataSource = pagedData;
                lstProducts.DataBind();

                if (lstProducts.Items.Count == 0)
                {
                    this.Visible = false;
                }
            }
        }

  protected void UpdatePagingControls(int itemCount, int pageSize, int currentPage)
  {
   StringDictionary replaceParams = new StringDictionary();

   // Get total pages
   int rem;
   int totalPages = Math.DivRem(itemCount, pageSize, out rem);
   if (rem > 0)
   {
    totalPages++;
   }

   // Hide and return if only one page
   if (totalPages == 1)
   {
                foreach (Label lblPageNav in labelsPageNav)
                {
                    lblPageNav.Visible = false;
                }
                return;
   }

   ////////////////////////////
   // Previous/Next Buttons

   int prevIndex = currentPage - 1;
   if ((prevIndex < 1) || (prevIndex > totalPages))
   {
    prevIndex = 1;
   }

   replaceParams["PageIndex"] = prevIndex.ToString();
            foreach (HyperLink btnPrev in buttonsPrevious)
            {
                btnPrev.NavigateUrl = moduleNav.GetNavigationUrl(replaceParams, storeInfo.StorePageID);
            }

   int nextIndex = currentPage + 1;
   if (nextIndex >= totalPages)
   {
    nextIndex = totalPages;
   }

   replaceParams["PageIndex"] = nextIndex.ToString();
            foreach (HyperLink btnNext in buttonsNext)
            {
                btnNext.NavigateUrl = moduleNav.GetNavigationUrl(replaceParams, storeInfo.StorePageID);
            }

   ////////////////////////////
   // Page Index List

   // Determine page range to display
   int rangeMin = currentPage - 10;
   int rangeMax = currentPage + 10;

   if (rangeMin < 1)
   {
    rangeMax = rangeMax + Math.Abs(rangeMin) + 1;
    rangeMin = 1;
   }

   if (rangeMax >= totalPages)
   {
    rangeMin = rangeMin - (rangeMax - totalPages);
    if (rangeMin <= 1)
    {
     rangeMin = 1;
    }

    rangeMax = totalPages;
   }

            foreach (PlaceHolder phPageList in placeholdersPageList)
            {
                // Create link for each page
                for (int i = rangeMin; i <= rangeMax; i++)
                {
                    replaceParams["PageIndex"] = i.ToString();

                    if (i == currentPage)
                    {
                        Label pageLabel = new Label();
                        pageLabel.Text = i.ToString();
                        pageLabel.CssClass = "StoreCurrentPageNumber";
                        phPageList.Controls.Add(pageLabel);
                        phPageList.Controls.Add(new LiteralControl("  "));
                    }
                    else
                    {
                        HyperLink pageLink = new HyperLink();
                        pageLink.Text = i.ToString();
                        pageLink.NavigateUrl = moduleNav.GetNavigationUrl(replaceParams, storeInfo.StorePageID);
                        pageLink.CssClass = "StorePageNumber";

                        phPageList.Controls.Add(pageLink);
                        phPageList.Controls.Add(new LiteralControl("  "));
                    }

                }
            }

            foreach (Label lblPageInfo in labelsPageInfo)
            {
                lblPageInfo.Text = string.Format(Localization.GetString("PageInfo.Text", this.LocalResourceFile), currentPage, totalPages);
            }
        }

        protected void ddlSortBy_SelectedIndexChanged(object sender, EventArgs e)
        {
            DropDownList ddlSortBy = (sender as DropDownList);
            if (ddlSortBy != null)
            {
                moduleNav.SortID = int.Parse(ddlSortBy.SelectedValue);
                moduleNav.SortDir = "ASC";
                moduleNav.PageIndex = Null.NullInteger;
            }
            Response.Redirect(moduleNav.GetNavigationUrl());
        }

        private void btnSortDir_Click(object sender, ImageClickEventArgs e)
        {
            ImageButton button = (sender as ImageButton);
            if (button != null)
            {
                moduleNav.PageIndex = Null.NullInteger;
                if (button.CommandArgument.ToUpper() == "ASC")
                {
                    moduleNav.SortDir = "DESC";
                }
                else
                {
                    moduleNav.SortDir = "ASC";
                }
                Response.Redirect(moduleNav.GetNavigationUrl());
            }
        }

        private void btnMYSEARCH_Click(object sender, ImageClickEventArgs e)
        {
            //ImageButton button_Myserch = (sender as ImageButton);
            ImageButton button_Myserch = sender as ImageButton;
            if (button_Myserch != null)
            {
                moduleNav.PageIndex = Null.NullInteger;

                    moduleNav.SortDir = "DESC";

                    DropDownList ddlMYSEARCH = (DropDownList)this.FindControl("ddMYSEARCH");
                    TextBox txtMYSEARCH = (TextBox)this.FindControl("txtMYSEARCH");

                    if (ddlMYSEARCH != null && txtMYSEARCH != null)
                    //&& ddlMYSEARCH.SelectedValue.ToString() != null && txtMYSEARCH.Text.ToString() != null
                    {
                        moduleNav.SearchField = ddlMYSEARCH.SelectedValue.ToString();
                        moduleNav.SearchText = txtMYSEARCH.Text.ToString();
                    }
                    else
                    {
                        moduleNav.SearchField = "Manufacturer";
                        moduleNav.SearchText = "JK";

                    }

                Response.Redirect(moduleNav.GetNavigationUrl());
            }
        }



  #endregion

  #region Private Functions

  private Control processToken(string tokenName)
  {
   switch (tokenName.ToUpper())
   {
                case "LISTTITLE":
                    Label lblTitle = new Label();
                    lblTitle.CssClass = "StoreListTitle";
                    lblTitle.Text = title;
                    return lblTitle;

                case "PAGENAV":
                    if (ListType == ProductListTypes.Category || 
                        ListType == ProductListTypes.MySearchResult)
                    {
                        HyperLink btnPrevious = new HyperLink();
                        btnPrevious.Text = Localization.GetString("Previous.Text", this.LocalResourceFile);
                        btnPrevious.CssClass = "StorePagePrevious";
                        buttonsPrevious.Add(btnPrevious);

                        Literal lblSpace = new Literal();
                        lblSpace.Text = "  ";

                        HyperLink btnNext = new HyperLink();
                        btnNext.Text = Localization.GetString("Next.Text", this.LocalResourceFile);
                        btnNext.CssClass = "StorePageNext";
                        buttonsNext.Add(btnNext);

                        PlaceHolder phPageList = new PlaceHolder();
                        placeholdersPageList.Add(phPageList);

                        Label lblPageNav = new Label();
                        lblPageNav.Controls.Add(btnPrevious);
                        lblPageNav.Controls.Add(lblSpace);
                        lblPageNav.Controls.Add(phPageList);
                        lblPageNav.Controls.Add(btnNext);
                        lblPageNav.CssClass = "StorePageNav";
                        labelsPageNav.Add(lblPageNav);
                        return lblPageNav;
                    }
                    else
                        return null;

                case "PAGEINFO":
                    Label lblPageInfo = new Label();
                    lblPageInfo.CssClass = "StorePageInfo";
                    lblPageInfo.Text = string.Format(Localization.GetString("PageInfo.Text", this.LocalResourceFile), 1, 1);
                    labelsPageInfo.Add(lblPageInfo);
                    return lblPageInfo;

                case "PRODUCTS":
                    lstProducts = new DataList();
                    lstProducts.CssClass = containerCssClass;
                    lstProducts.RepeatLayout = RepeatLayout.Table;
                    switch (direction)
                    {
                        case "V":
                            lstProducts.RepeatDirection = RepeatDirection.Vertical;
                            break;
                        case "H":
                        default:
                            lstProducts.RepeatDirection = RepeatDirection.Horizontal;
                            break;
                    }
                    lstProducts.RepeatColumns = columnCount;
                    lstProducts.ItemDataBound += new DataListItemEventHandler(lstProducts_ItemDataBound);
                    return lstProducts;

                case "ITEMSCOUNT":
                    if (dataSource != null)
                    {
                        Label lblItems = new Label();
                        lblItems.CssClass = "StoreItemsCount";
                        lblItems.Text = string.Format(Localization.GetString("ItemsCount.Text", this.LocalResourceFile), (dataSource as ArrayList).Count);
                        return lblItems;
                    }
                    else
                        return null;

                case "SELECTEDCATEGORY":
                    if (ListType == ProductListTypes.Category)
                    {
                        categoryControler = new CategoryController();
                        CategoryInfo categoryInfo = categoryControler.GetCategory(CategoryID);
                        if (categoryInfo != null)
                        {
                            Label lblProductCategory = new Label();
                            lblProductCategory.Text = string.Format(Localization.GetString("SelectedCategory.Text", this.LocalResourceFile), categoryInfo.CategoryName);
                            lblProductCategory.CssClass = "StoreSelectedCategory";
                            return lblProductCategory;
                        }
                        else
                            return null;
                    }
                    else
                        return null;

                case "CATEGORIESBREADCRUMB":
                    if (ListType == ProductListTypes.Category || ListType == ProductListTypes.MySearchResult)
                    {
                        categoryControler = new CategoryController();
                        CategoryInfo categoryInfo = categoryControler.GetCategory(CategoryID);
                        if (categoryInfo != null)
                        {
                            string categoryName = categoryInfo.CategoryName;
                            bool hasParent = categoryInfo.ParentCategoryID != Null.NullInteger;
                            // Create label to contains all other controls
                            Label lblCategoriesBreadcrumb = new Label();
                            lblCategoriesBreadcrumb.CssClass = "StoreCategoriesBreadcrumb";
                            // Create "before" label with locale resource
                            Label lblBeforeBreadcrumb = new Label();
                            lblBeforeBreadcrumb.Text = Localization.GetString("BeforeCategoriesBreadcrumb", this.LocalResourceFile);
                            lblBeforeBreadcrumb.CssClass = "StoreBeforeBreadcrumb";
                            lblCategoriesBreadcrumb.Controls.Add(lblBeforeBreadcrumb);
                            // Create "between" label with locale resource
                            Literal litBetwenBreadcrumb = new Literal();
                            litBetwenBreadcrumb.Text = Localization.GetString("BetweenCategoriesBreadcrumb", this.LocalResourceFile);
                            // Create label to contains categories
                            Label lblBreadcrumb = new Label();
                            lblBreadcrumb.CssClass = "StoreBreadcrumb";
                            lblCategoriesBreadcrumb.Controls.Add(lblBreadcrumb);
                            int parentCategoryID = categoryInfo.ParentCategoryID;
                            // Create catalog navigation object to compute hyperlink URL
                            CatalogNavigation categogyNav = new CatalogNavigation();
                            categogyNav.TabId = this.TabId;
                            // Loop for parent categories
                            while (parentCategoryID != Null.NullInteger)
                            {
                                categoryInfo = categoryControler.GetCategory(categoryInfo.ParentCategoryID);
                                if (categoryInfo != null)
                                {
                                    parentCategoryID = categoryInfo.ParentCategoryID;
                                    if (parentCategoryID != Null.NullInteger)
                                    {
                                        lblBreadcrumb.Controls.Add(litBetwenBreadcrumb);
                                    }
                                    // Create hyperlink with the parent category
                                    HyperLink hlCategory = new HyperLink();
                                    hlCategory.Text = categoryInfo.CategoryName;
                                    categogyNav.CategoryID = categoryInfo.CategoryID;
                                    hlCategory.NavigateUrl = categogyNav.GetNavigationUrl();
                                    lblBreadcrumb.Controls.Add(hlCategory);
                                }
                                else
                                    parentCategoryID = Null.NullInteger;
                            }
                            // Insert separator if parent exist
                            if (hasParent)
                            {
                                lblBreadcrumb.Controls.Add(litBetwenBreadcrumb);
                            }
                            // Create literal with selected category name
                            Literal litSelectedCategory = new Literal();
                            litSelectedCategory.Text = categoryName;
                            lblBreadcrumb.Controls.Add(litSelectedCategory);
                            // Create "after" label with locale resource
                            Label lblAfterBreadcrumb = new Label();
                            lblAfterBreadcrumb.Text = Localization.GetString("AfterCategoriesBreadcrumb", this.LocalResourceFile);
                            lblAfterBreadcrumb.CssClass = "StoreAfterBreadcrumb";
                            lblCategoriesBreadcrumb.Controls.Add(lblAfterBreadcrumb);
                            return lblCategoriesBreadcrumb;
                        }
                        else
                            return null;
                    }
                    else
                        return null;

                case "SORTBY":
                    if (ListType == ProductListTypes.Category)
                    {
                        // Create label to contains all other controls
                        Label lblSortBy = new Label();
                        lblSortBy.CssClass = "StoreSortBy";
                        // Create literal text with locale resource
                        Literal litSortBy = new Literal();
                        litSortBy.Text = Localization.GetString("SortBy", this.LocalResourceFile);
                        lblSortBy.Controls.Add(litSortBy);
                        // Create DropDownList with column names
                        DropDownList ddlSortBy = new DropDownList();
                        ddlSortBy.AutoPostBack = true;
                        ddlSortBy.Items.Add(new ListItem(Localization.GetString("SortManufacturer", this.LocalResourceFile), "0"));
                        ddlSortBy.Items.Add(new ListItem(Localization.GetString("SortModelNumber", this.LocalResourceFile), "1"));
                        ddlSortBy.Items.Add(new ListItem(Localization.GetString("SortModelName", this.LocalResourceFile), "2"));
                        ddlSortBy.Items.Add(new ListItem(Localization.GetString("SortUnitPrice", this.LocalResourceFile), "3"));
                        if (moduleNav.SortID != Null.NullInteger)
                        {
                            // Currently selected sort column
                            ddlSortBy.SelectedIndex = moduleNav.SortID;
                        }
                        else
                        {
                            // Default sort column
                            ddlSortBy.SelectedValue = moduleSettings.CategoryProducts.SortBy;
                        }
                        ddlSortBy.SelectedIndexChanged += new EventHandler(ddlSortBy_SelectedIndexChanged);
                        lblSortBy.Controls.Add(ddlSortBy);

                        // Create Sort Order image button
                        ImageButton btnSortDir = new ImageButton();
                        string sortDir;
                        if (moduleNav.SortDir != Null.NullString)
                        {
                            // Currently selected sort direction
                            sortDir = moduleNav.SortDir;
                        }
                        else
                        {
                            // Default sort direction
                            sortDir = moduleSettings.CategoryProducts.SortDir;
                        }
                        string imageName;
                        string altText;
                        if (sortDir.ToUpper() == "ASC")
                        {
                            imageName = "arrow_up.png";
                            altText = Localization.GetString("SortAscending", this.LocalResourceFile);
                        }
                        else
                        {
                            imageName = "arrow_down.png";
                            altText = Localization.GetString("SortDescending", this.LocalResourceFile);
                        }
                        btnSortDir.CommandArgument = sortDir;
                        btnSortDir.AlternateText = altText;
                        if (storeInfo.PortalTemplates)
                        {
                            btnSortDir.ImageUrl = PortalSettings.HomeDirectory + "Store/Templates/Images/" + imageName;
                        }
                        else
                        {
                            btnSortDir.ImageUrl = this.TemplateSourceDirectory + "/Templates/Images/" + imageName;
                        }
                        btnSortDir.Click += new ImageClickEventHandler(btnSortDir_Click);
                        lblSortBy.Controls.Add(btnSortDir);
                        return lblSortBy;
                    }
                    else
                        return null;


                case "MYSEARCH":
                    if (ListType == ProductListTypes.Category)
                    {
                        // Create label to contains all other controls
                        Label lblMYSEARCH = new Label();
                        lblMYSEARCH.CssClass = "StoreSearchLable";
                        // Create literal text with locale resource
                        Literal litMYSEARCH = new Literal();
                        litMYSEARCH.Text = Localization.GetString("MYSEARCHBy", this.LocalResourceFile);
                        lblMYSEARCH.Controls.Add(litMYSEARCH);

                        // Create DropDownList with column names
                        DropDownList ddlMYSEARCH = new DropDownList();
                        ddlMYSEARCH.ID = "ddMYSEARCH";
                        ddlMYSEARCH.CssClass = "ddlMySearch";

                        ddlMYSEARCH.AutoPostBack = false;
                        ddlMYSEARCH.Items.Add(new ListItem(Localization.GetString("MYSEARCHManufacturer", this.LocalResourceFile), "Manufacturer"));
                        ddlMYSEARCH.Items.Add(new ListItem(Localization.GetString("MYSEARCHModelNumber", this.LocalResourceFile), "ModelNumber"));
                        ddlMYSEARCH.Items.Add(new ListItem(Localization.GetString("MYSEARCHModelName", this.LocalResourceFile), "ModelName"));

                        if (moduleNav.SearchField != Null.NullString)//Null.NullInteger
                        {
                            // Currently selected Search column
          ddlMYSEARCH.SelectedValue = moduleNav.SearchField.ToString();
                        }
                        else
                        {
                        }

                        

                        lblMYSEARCH.Controls.Add(ddlMYSEARCH);
                        
                        TextBox txtMYSEARCH = new TextBox();
                        txtMYSEARCH.ID = "txtMYSEARCH";
                        txtMYSEARCH.CssClass = "txtMySearch";

                        txtMYSEARCH.AutoPostBack = false;

                        if (moduleNav.SearchText != Null.NullString)
                        {
                            txtMYSEARCH.Text = moduleNav.SearchText;
                        }

                        // Create Searching image button
                        ImageButton btnMYSEARCH = new ImageButton();
                        
                        string imageName;
                        string altText;

                        string searching_field = ddlMYSEARCH.SelectedValue.ToString();
                        string searching_Text = txtMYSEARCH.Text.ToString();


                            imageName = "Search_button.png";
                            altText = Localization.GetString("SearchButtonAlt", this.LocalResourceFile);
                        
                        btnMYSEARCH.AlternateText = altText;
                        if (storeInfo.PortalTemplates)
                        {
                            btnMYSEARCH.ImageUrl = PortalSettings.HomeDirectory + "Store/Templates/Images/" + imageName;
                        }
                        else
                        {
                            btnMYSEARCH.ImageUrl = this.TemplateSourceDirectory + "/Templates/Images/" + imageName;
                        }

                        lblMYSEARCH.Controls.Add(txtMYSEARCH);
                        lblMYSEARCH.Controls.Add(btnMYSEARCH);
                        btnMYSEARCH.Click += new ImageClickEventHandler(btnMYSEARCH_Click);

                        return lblMYSEARCH;
                    }
                    else
                        return null;

    default:
     LiteralControl litText = new LiteralControl(tokenName);
     return litText;
   }
  }

  #endregion
 }
}

Continue - Part 3

dotnetnuke store product search module - part 3

2010-01-20T14:12:00.016+05:30

CatalogSettings.ascx.cs

using System;
using System.Collections;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using DotNetNuke;
using DotNetNuke.Common;
using DotNetNuke.Entities.Portals;
using DotNetNuke.Entities.Tabs;
using DotNetNuke.Modules.Store.Admin;
using DotNetNuke.Modules.Store.Catalog;
using DotNetNuke.Security;
using DotNetNuke.Security.Roles;
using DotNetNuke.Services.Exceptions;
using DotNetNuke.Services.Localization;

namespace DotNetNuke.Modules.Store.WebControls
{
 /// 
 /// Summary description for Settings.
 /// 

    public partial class CatalogSettings : DotNetNuke.Entities.Modules.ModuleSettingsBase
 {
  protected ModuleSettings moduleSettings;
        private StoreInfo storeInfo;
        private string templatesPath = "";

  #region Web Form Designer generated code
  override protected void OnInit(EventArgs e)
  {
   //
   // CODEGEN: This call is required by the ASP.NET Web Form Designer.
   //
   InitializeComponent();
   base.OnInit(e);

   moduleSettings = new ModuleSettings(this.ModuleId,  this.TabId);
  }
  
  /// 
  ///  Required method for Designer support - do not modify
  ///  the contents of this method with the code editor.
  /// 

  private void InitializeComponent()
  {

  }
  #endregion

  #region Events
  protected void Page_Load(object sender, System.EventArgs e)
  {
   try
   {
    if (!Page.IsPostBack)
    {
                    CategoryController categoryController = new CategoryController();
     ArrayList categoryList = categoryController.GetCategories(this.PortalId, false, -1);
     bool defaultExists = false;

                    lstDefaultCategory.Items.Add(new ListItem(Localization.GetString("SelectDefaultCategory", this.LocalResourceFile), "-1"));

     foreach (CategoryInfo categoryInfo in categoryList)
     {
      lstDefaultCategory.Items.Add(new ListItem(categoryInfo.CategoryName, categoryInfo.CategoryID.ToString()));

      if (categoryInfo.CategoryID.ToString() == moduleSettings.General.DefaultCategoryID)
      {
       defaultExists = true;
      }
     }

     if (lstDefaultCategory.Items.Count > 1 && Int32.Parse(moduleSettings.General.DefaultCategoryID) > 0 && defaultExists)
     {
      lstDefaultCategory.SelectedValue = moduleSettings.General.DefaultCategoryID;
     }
    }
   }
   catch(Exception ex)
   {
    Exceptions.ProcessModuleLoadException(this, ex);
   }
  }
  #endregion

  #region Base Method Implementations
  public override void LoadSettings()
  {
   try
   {
    if (!Page.IsPostBack)
    {
                    if (storeInfo == null)
                    {
                        StoreController storeController = new StoreController();
                        storeInfo = storeController.GetStoreInfo(PortalId);
                        if (storeInfo.PortalTemplates)
                        {
                            templatesPath = PortalSettings.HomeDirectoryMapPath + "Store\\";
                        }
                        else
                        {
                            templatesPath = MapPath(ModulePath) + "\\";
                        }
                    }

                    // Add tab name to combo boxes (Detail Page and Return Page) for each section
     TabController tabController = new TabController();
     ArrayList tabs = tabController.GetTabs(PortalId);

                    lstNPLDetailPage.Items.Add(new ListItem(Localization.GetString("NPLSamePage", this.LocalResourceFile), "0"));
                    lstFPLDetailPage.Items.Add(new ListItem(Localization.GetString("FPLSamePage", this.LocalResourceFile), "0"));
                    lstMSLDetailPage.Items.Add(new ListItem(Localization.GetString("MSLSamePage", this.LocalResourceFile), "0"));
                    lstPPLDetailPage.Items.Add(new ListItem(Localization.GetString("PPLSamePage", this.LocalResourceFile), "0"));
                    lstCPLDetailPage.Items.Add(new ListItem(Localization.GetString("CPLSamePage", this.LocalResourceFile), "0"));
                    lstPDSReturnPage.Items.Add(new ListItem(Localization.GetString("PDSSamePage", this.LocalResourceFile), "0"));

     foreach (TabInfo tabInfo in tabs)
     {
      if (!tabInfo.IsDeleted && !tabInfo.IsAdminTab && !tabInfo.IsSuperTab)
      {
                            lstNPLDetailPage.Items.Add(new ListItem(tabInfo.TabName, tabInfo.TabID.ToString()));
                            lstFPLDetailPage.Items.Add(new ListItem(tabInfo.TabName, tabInfo.TabID.ToString()));
                            lstMSLDetailPage.Items.Add(new ListItem(tabInfo.TabName, tabInfo.TabID.ToString()));
       lstPPLDetailPage.Items.Add(new ListItem(tabInfo.TabName, tabInfo.TabID.ToString()));
       lstCPLDetailPage.Items.Add(new ListItem(tabInfo.TabName, tabInfo.TabID.ToString()));
                            lstPDSReturnPage.Items.Add(new ListItem(tabInfo.TabName, tabInfo.TabID.ToString()));
      }
     }
     
     loadTemplates();

                    // Add directions to repeat combo boxes
                    String repeatDirection = Localization.GetString("RepeatDirectionHoriz", this.LocalResourceFile);
                    lstNPLRepeatDirection.Items.Add(new ListItem(repeatDirection, "H"));
                    lstFPLRepeatDirection.Items.Add(new ListItem(repeatDirection, "H"));
                    lstMSLRepeatDirection.Items.Add(new ListItem(repeatDirection, "H"));
                    lstPPLRepeatDirection.Items.Add(new ListItem(repeatDirection, "H"));
                    lstCPLRepeatDirection.Items.Add(new ListItem(repeatDirection, "H"));

                    repeatDirection = Localization.GetString("RepeatDirectionVert", this.LocalResourceFile);
                    lstNPLRepeatDirection.Items.Add(new ListItem(repeatDirection, "V"));
                    lstFPLRepeatDirection.Items.Add(new ListItem(repeatDirection, "V"));
                    lstMSLRepeatDirection.Items.Add(new ListItem(repeatDirection, "V"));
                    lstPPLRepeatDirection.Items.Add(new ListItem(repeatDirection, "V"));
                    lstCPLRepeatDirection.Items.Add(new ListItem(repeatDirection, "V"));

                    // Add column names to sort order combo boxes
                    String sortBy = "";
                    sortBy = Localization.GetString("SortManufacturer", this.LocalResourceFile);
                    lstCPLSortBy.Items.Add(new ListItem(sortBy, "0"));
                    sortBy = Localization.GetString("SortModelNumber", this.LocalResourceFile);
                    lstCPLSortBy.Items.Add(new ListItem(sortBy, "1"));
                    sortBy = Localization.GetString("SortModelName", this.LocalResourceFile);
                    lstCPLSortBy.Items.Add(new ListItem(sortBy, "2"));
                    sortBy = Localization.GetString("SortUnitPrice", this.LocalResourceFile);
                    lstCPLSortBy.Items.Add(new ListItem(sortBy, "3"));
                    String sortDir = "";
                    sortDir = Localization.GetString("SortAscending", this.LocalResourceFile);
                    lstCPLSortDir.Items.Add(new ListItem(sortDir, "ASC"));
                    sortDir = Localization.GetString("SortDescending", this.LocalResourceFile);
                    lstCPLSortDir.Items.Add(new ListItem(sortDir, "DESC"));

     // General Player Settings
                    chkEnableContentIndexing.Checked = bool.Parse(moduleSettings.General.EnableContentIndexing);
     chkUseDefaultCategory.Checked = bool.Parse(moduleSettings.General.UseDefaultCategory);
     chkShowMessage.Checked = bool.Parse(moduleSettings.General.ShowMessage);
                    chkShowNew.Checked = bool.Parse(moduleSettings.General.ShowNewProducts);
     chkShowFeatured.Checked = bool.Parse(moduleSettings.General.ShowFeaturedProducts);

                    chkShowMYSEARCH.Checked = bool.Parse(moduleSettings.General.ShowMYSEARCHProducts);

     chkShowPopular.Checked = bool.Parse(moduleSettings.General.ShowPopularProducts);
     chkShowCategory.Checked = bool.Parse(moduleSettings.General.ShowCategoryProducts);
     chkShowDetail.Checked = bool.Parse(moduleSettings.General.ShowProductDetail);
     lstDefaultCategory.SelectedValue = moduleSettings.General.DefaultCategoryID;
                    ListItem itemTemplate = lstTemplate.Items.FindByText(moduleSettings.General.Template);
                    if (itemTemplate != null)
                    {
                        itemTemplate.Selected = true;
                    }

                    // New list settings
                    ListItem itemNPLContainerTemplate = lstNPLContainerTemplate.Items.FindByText(moduleSettings.NewProducts.ContainerTemplate);
                    if (itemNPLContainerTemplate != null)
     {
                        itemNPLContainerTemplate.Selected = true;
     }
                    ListItem itemNPLTemplate = lstNPLTemplate.Items.FindByText(moduleSettings.NewProducts.Template);
                    if (itemNPLTemplate != null)
                    {
                        itemNPLTemplate.Selected = true;
                    }
                    txtNPLRowCount.Text = moduleSettings.NewProducts.RowCount;
                    txtNPLColumnCount.Text = moduleSettings.NewProducts.ColumnCount;
                    txtNPLColumnWidth.Text = moduleSettings.NewProducts.ColumnWidth;
                    ListItem itemNPLDirection = lstNPLRepeatDirection.Items.FindByValue(moduleSettings.NewProducts.RepeatDirection);
                    if (itemNPLDirection != null)
                    {
                        itemNPLDirection.Selected = true;
                    }
                    txtNPLThumbnailWidth.Text = moduleSettings.NewProducts.ThumbnailWidth;
                    chkNPLShowThumbnail.Checked = bool.Parse(moduleSettings.NewProducts.ShowThumbnail);
                    lstNPLDetailPage.SelectedValue = moduleSettings.NewProducts.DetailPage;

     // Featured list settings
                    ListItem itemFPLContainerTemplate = lstFPLContainerTemplate.Items.FindByText(moduleSettings.FeaturedProducts.ContainerTemplate);
                    if (itemFPLContainerTemplate != null)
     {
                        itemFPLContainerTemplate.Selected = true;
     }
     ListItem itemFPLTemplate = lstFPLTemplate.Items.FindByText(moduleSettings.FeaturedProducts.Template);
     if (itemFPLTemplate != null)
     {
      itemFPLTemplate.Selected = true;
     }
     txtFPLRowCount.Text = moduleSettings.FeaturedProducts.RowCount;
     txtFPLColumnCount.Text = moduleSettings.FeaturedProducts.ColumnCount;
     txtFPLColumnWidth.Text = moduleSettings.FeaturedProducts.ColumnWidth;
                    ListItem itemFPLDirection = lstFPLRepeatDirection.Items.FindByValue(moduleSettings.FeaturedProducts.RepeatDirection);
                    if (itemFPLDirection != null)
                    {
                        itemFPLDirection.Selected = true;
                    }
     txtFPLThumbnailWidth.Text = moduleSettings.FeaturedProducts.ThumbnailWidth;
     chkFPLShowThumbnail.Checked = bool.Parse(moduleSettings.FeaturedProducts.ShowThumbnail);
     lstFPLDetailPage.SelectedValue = moduleSettings.FeaturedProducts.DetailPage;


                    // MYSEARCH list settings
                    ListItem itemMSLContainerTemplate = lstMSLContainerTemplate.Items.FindByText(moduleSettings.MYSEARCHProducts.ContainerTemplate);
                    if (itemMSLContainerTemplate != null)
                    {
                        itemMSLContainerTemplate.Selected = true;
                    }
                    ListItem itemMSLTemplate = lstMSLTemplate.Items.FindByText(moduleSettings.MYSEARCHProducts.Template);
                    if (itemMSLTemplate != null)
                    {
                        itemMSLTemplate.Selected = true;
                    }
                    txtMSLRowCount.Text = moduleSettings.MYSEARCHProducts.RowCount;
                    txtMSLColumnCount.Text = moduleSettings.MYSEARCHProducts.ColumnCount;
                    txtMSLColumnWidth.Text = moduleSettings.MYSEARCHProducts.ColumnWidth;
                    ListItem itemMSLDirection = lstMSLRepeatDirection.Items.FindByValue(moduleSettings.MYSEARCHProducts.RepeatDirection);
                    if (itemMSLDirection != null)
                    {
                        itemMSLDirection.Selected = true;
                    }
                    txtMSLThumbnailWidth.Text = moduleSettings.MYSEARCHProducts.ThumbnailWidth;
                    chkMSLShowThumbnail.Checked = bool.Parse(moduleSettings.MYSEARCHProducts.ShowThumbnail);
                    lstMSLDetailPage.SelectedValue = moduleSettings.MYSEARCHProducts.DetailPage;


     // Popular list settings
                    ListItem itemPPLContainerTemplate = lstPPLContainerTemplate.Items.FindByText(moduleSettings.PopularProducts.ContainerTemplate);
                    if (itemPPLContainerTemplate != null)
     {
                        itemPPLContainerTemplate.Selected = true;
     }
     ListItem itemPPLTemplate = lstPPLTemplate.Items.FindByText(moduleSettings.PopularProducts.Template);
     if (itemPPLTemplate != null)
     {
      itemPPLTemplate.Selected = true;
     }
     txtPPLRowCount.Text = moduleSettings.PopularProducts.RowCount;
     txtPPLColumnCount.Text = moduleSettings.PopularProducts.ColumnCount;
     txtPPLColumnWidth.Text = moduleSettings.PopularProducts.ColumnWidth;
                    ListItem itemPPLDirection = lstPPLRepeatDirection.Items.FindByValue(moduleSettings.PopularProducts.RepeatDirection);
                    if (itemPPLDirection != null)
                    {
                        itemPPLDirection.Selected = true;
                    }
     txtPPLThumbnailWidth.Text = moduleSettings.PopularProducts.ThumbnailWidth;
     chkPPLShowThumbnail.Checked = bool.Parse(moduleSettings.PopularProducts.ShowThumbnail);
     lstPPLDetailPage.SelectedValue = moduleSettings.PopularProducts.DetailPage;

     // Category list settings
     ListItem itemCPLContainerTemplate = lstCPLContainerTemplate.Items.FindByText(moduleSettings.CategoryProducts.ContainerTemplate);
                    if (itemCPLContainerTemplate != null)
     {
                        itemCPLContainerTemplate.Selected = true;
     }
     ListItem itemCPLTemplate = lstCPLTemplate.Items.FindByText(moduleSettings.CategoryProducts.Template);
     if (itemCPLTemplate != null)
     {
      itemCPLTemplate.Selected = true;
     }
     txtCPLRowCount.Text = moduleSettings.CategoryProducts.RowCount;
     txtCPLColumnCount.Text = moduleSettings.CategoryProducts.ColumnCount;
     txtCPLColumnWidth.Text = moduleSettings.CategoryProducts.ColumnWidth;
                    ListItem itemCPLDirection = lstCPLRepeatDirection.Items.FindByValue(moduleSettings.CategoryProducts.RepeatDirection);
                    if (itemCPLDirection != null)
                    {
                        itemCPLDirection.Selected = true;
                    }
     txtCPLThumbnailWidth.Text = moduleSettings.CategoryProducts.ThumbnailWidth;
     chkCPLShowThumbnail.Checked = bool.Parse(moduleSettings.CategoryProducts.ShowThumbnail);
     lstCPLDetailPage.SelectedValue = moduleSettings.CategoryProducts.DetailPage;
                    lstCPLSortBy.SelectedValue = moduleSettings.CategoryProducts.SortBy;
                    lstCPLSortDir.SelectedValue = moduleSettings.CategoryProducts.SortDir;
                    chkCPLSubCategories.Checked = bool.Parse(moduleSettings.CategoryProducts.SubCategories);

     // Detail settings
     ListItem itemDetailTemplate = lstDetailTemplate.Items.FindByText(moduleSettings.ProductDetail.Template);
     if (itemDetailTemplate != null)
     {
      itemDetailTemplate.Selected = true;
     }
     chkDetailShowThumbnail.Checked = bool.Parse(moduleSettings.ProductDetail.ShowThumbnail);
     txtDetailThumbnailWidth.Text = moduleSettings.ProductDetail.ThumbnailWidth;
     chkDetailShowReviews.Checked = bool.Parse(moduleSettings.ProductDetail.ShowReviews);
                    lstPDSReturnPage.SelectedValue = moduleSettings.ProductDetail.ReturnPage;
    }
   }
   catch(Exception ex)
   {
    Exceptions.ProcessModuleLoadException(this, ex);
   }
  }

  public override void UpdateSettings()
  {
   try
   {
    PortalSecurity security = new PortalSecurity();

    // General Settings
                moduleSettings.General.EnableContentIndexing = chkEnableContentIndexing.Checked.ToString();
    moduleSettings.General.Template = lstTemplate.SelectedItem.Text;
    moduleSettings.General.UseDefaultCategory = chkUseDefaultCategory.Checked.ToString();
    moduleSettings.General.ShowMessage = chkShowMessage.Checked.ToString();
                moduleSettings.General.ShowNewProducts = chkShowNew.Checked.ToString();
                moduleSettings.General.ShowFeaturedProducts = chkShowFeatured.Checked.ToString();
    moduleSettings.General.ShowPopularProducts = chkShowPopular.Checked.ToString();
    moduleSettings.General.ShowCategoryProducts = chkShowCategory.Checked.ToString();
    moduleSettings.General.ShowProductDetail = chkShowDetail.Checked.ToString();
                moduleSettings.General.Template = lstTemplate.SelectedItem.Text;

    if (chkUseDefaultCategory.Checked)
    {
     moduleSettings.General.DefaultCategoryID = lstDefaultCategory.SelectedItem.Value;
    }

                // New list settings
                moduleSettings.NewProducts.ContainerTemplate = lstNPLContainerTemplate.SelectedItem.Text;
                moduleSettings.NewProducts.Template = lstNPLTemplate.SelectedItem.Text;
                moduleSettings.NewProducts.RowCount = security.InputFilter(txtNPLRowCount.Text, PortalSecurity.FilterFlag.NoMarkup | PortalSecurity.FilterFlag.NoScripting);
                moduleSettings.NewProducts.ColumnCount = security.InputFilter(txtNPLColumnCount.Text, PortalSecurity.FilterFlag.NoMarkup | PortalSecurity.FilterFlag.NoScripting);
                moduleSettings.NewProducts.ColumnWidth = security.InputFilter(txtNPLColumnWidth.Text, PortalSecurity.FilterFlag.NoMarkup | PortalSecurity.FilterFlag.NoScripting);
                moduleSettings.NewProducts.RepeatDirection = lstNPLRepeatDirection.SelectedItem.Value;
                moduleSettings.NewProducts.ThumbnailWidth = security.InputFilter(txtNPLThumbnailWidth.Text, PortalSecurity.FilterFlag.NoMarkup | PortalSecurity.FilterFlag.NoScripting);
                moduleSettings.NewProducts.ShowThumbnail = chkNPLShowThumbnail.Checked.ToString();
                moduleSettings.NewProducts.DetailPage = lstNPLDetailPage.SelectedItem.Value;

    // Featured list settings
                moduleSettings.FeaturedProducts.ContainerTemplate = lstFPLContainerTemplate.SelectedItem.Text;
    moduleSettings.FeaturedProducts.Template = lstFPLTemplate.SelectedItem.Text;
    moduleSettings.FeaturedProducts.RowCount = security.InputFilter(txtFPLRowCount.Text, PortalSecurity.FilterFlag.NoMarkup | PortalSecurity.FilterFlag.NoScripting );
    moduleSettings.FeaturedProducts.ColumnCount = security.InputFilter(txtFPLColumnCount.Text, PortalSecurity.FilterFlag.NoMarkup | PortalSecurity.FilterFlag.NoScripting );
    moduleSettings.FeaturedProducts.ColumnWidth = security.InputFilter(txtFPLColumnWidth.Text, PortalSecurity.FilterFlag.NoMarkup | PortalSecurity.FilterFlag.NoScripting );
                moduleSettings.FeaturedProducts.RepeatDirection = lstFPLRepeatDirection.SelectedItem.Value;
    moduleSettings.FeaturedProducts.ThumbnailWidth = security.InputFilter(txtFPLThumbnailWidth.Text, PortalSecurity.FilterFlag.NoMarkup | PortalSecurity.FilterFlag.NoScripting );
    moduleSettings.FeaturedProducts.ShowThumbnail = chkFPLShowThumbnail.Checked.ToString();
    moduleSettings.FeaturedProducts.DetailPage = lstFPLDetailPage.SelectedItem.Value;

                // MYSEARCH list settings
                moduleSettings.MYSEARCHProducts.ContainerTemplate = lstMSLContainerTemplate.SelectedItem.Text;
                moduleSettings.MYSEARCHProducts.Template = lstMSLTemplate.SelectedItem.Text;
                moduleSettings.MYSEARCHProducts.RowCount = security.InputFilter(txtMSLRowCount.Text, PortalSecurity.FilterFlag.NoMarkup | PortalSecurity.FilterFlag.NoScripting);
                moduleSettings.MYSEARCHProducts.ColumnCount = security.InputFilter(txtMSLColumnCount.Text, PortalSecurity.FilterFlag.NoMarkup | PortalSecurity.FilterFlag.NoScripting);
                moduleSettings.MYSEARCHProducts.ColumnWidth = security.InputFilter(txtMSLColumnWidth.Text, PortalSecurity.FilterFlag.NoMarkup | PortalSecurity.FilterFlag.NoScripting);
                moduleSettings.MYSEARCHProducts.RepeatDirection = lstMSLRepeatDirection.SelectedItem.Value;
                moduleSettings.MYSEARCHProducts.ThumbnailWidth = security.InputFilter(txtMSLThumbnailWidth.Text, PortalSecurity.FilterFlag.NoMarkup | PortalSecurity.FilterFlag.NoScripting);
                moduleSettings.MYSEARCHProducts.ShowThumbnail = chkMSLShowThumbnail.Checked.ToString();
                moduleSettings.MYSEARCHProducts.DetailPage = lstMSLDetailPage.SelectedItem.Value;

    // Popular list settings
                moduleSettings.PopularProducts.ContainerTemplate = lstPPLContainerTemplate.SelectedItem.Text;
    moduleSettings.PopularProducts.Template = lstPPLTemplate.SelectedItem.Text;
    moduleSettings.PopularProducts.RowCount = security.InputFilter(txtPPLRowCount.Text, PortalSecurity.FilterFlag.NoMarkup | PortalSecurity.FilterFlag.NoScripting );
    moduleSettings.PopularProducts.ColumnCount = security.InputFilter(txtPPLColumnCount.Text, PortalSecurity.FilterFlag.NoMarkup | PortalSecurity.FilterFlag.NoScripting );
    moduleSettings.PopularProducts.ColumnWidth = security.InputFilter(txtPPLColumnWidth.Text, PortalSecurity.FilterFlag.NoMarkup | PortalSecurity.FilterFlag.NoScripting );
                moduleSettings.PopularProducts.RepeatDirection = lstPPLRepeatDirection.SelectedItem.Value;
    moduleSettings.PopularProducts.ThumbnailWidth = security.InputFilter(txtPPLThumbnailWidth.Text, PortalSecurity.FilterFlag.NoMarkup | PortalSecurity.FilterFlag.NoScripting );
    moduleSettings.PopularProducts.ShowThumbnail = chkPPLShowThumbnail.Checked.ToString();
    moduleSettings.PopularProducts.DetailPage = lstPPLDetailPage.SelectedItem.Value;

    // Category list settings
                moduleSettings.CategoryProducts.ContainerTemplate = lstCPLContainerTemplate.SelectedItem.Text;
    moduleSettings.CategoryProducts.Template = lstCPLTemplate.SelectedItem.Text;
    moduleSettings.CategoryProducts.RowCount = security.InputFilter(txtCPLRowCount.Text, PortalSecurity.FilterFlag.NoMarkup | PortalSecurity.FilterFlag.NoScripting );
    moduleSettings.CategoryProducts.ColumnCount = security.InputFilter(txtCPLColumnCount.Text, PortalSecurity.FilterFlag.NoMarkup | PortalSecurity.FilterFlag.NoScripting );
    moduleSettings.CategoryProducts.ColumnWidth = security.InputFilter(txtCPLColumnWidth.Text, PortalSecurity.FilterFlag.NoMarkup | PortalSecurity.FilterFlag.NoScripting );
                moduleSettings.CategoryProducts.RepeatDirection = lstCPLRepeatDirection.SelectedItem.Value;
    moduleSettings.CategoryProducts.ThumbnailWidth = security.InputFilter(txtCPLThumbnailWidth.Text, PortalSecurity.FilterFlag.NoMarkup | PortalSecurity.FilterFlag.NoScripting );
    moduleSettings.CategoryProducts.ShowThumbnail = chkCPLShowThumbnail.Checked.ToString();
    moduleSettings.CategoryProducts.DetailPage = lstCPLDetailPage.SelectedItem.Value;
                moduleSettings.CategoryProducts.SortBy = lstCPLSortBy.SelectedItem.Value;
                moduleSettings.CategoryProducts.SortDir = lstCPLSortDir.SelectedItem.Value;
                moduleSettings.CategoryProducts.SubCategories = chkCPLSubCategories.Checked.ToString();

    // Detail settings
    moduleSettings.ProductDetail.Template = lstDetailTemplate.SelectedItem.Text;
    moduleSettings.ProductDetail.ShowThumbnail = chkDetailShowThumbnail.Checked.ToString();
    moduleSettings.ProductDetail.ThumbnailWidth = security.InputFilter(txtDetailThumbnailWidth.Text, PortalSecurity.FilterFlag.NoMarkup | PortalSecurity.FilterFlag.NoScripting );
                moduleSettings.ProductDetail.ShowReviews = chkDetailShowReviews.Checked.ToString();
                moduleSettings.ProductDetail.ReturnPage = lstPDSReturnPage.SelectedItem.Value;
   }
   catch(Exception ex)
   {
    Exceptions.ProcessModuleLoadException(this, ex);
   }
  }

  #endregion

  #region Private Functions
  private void loadTemplates()
  {
            ArrayList templates = TemplateController.GetTemplates(templatesPath);

   foreach (TemplateInfo templateInfo in templates)
   {
    lstTemplate.Items.Add(new ListItem(templateInfo.Name,  templateInfo.Path));
                lstNPLContainerTemplate.Items.Add(new ListItem(templateInfo.Name, templateInfo.Path));
                lstNPLTemplate.Items.Add(new ListItem(templateInfo.Name, templateInfo.Path));
                lstFPLContainerTemplate.Items.Add(new ListItem(templateInfo.Name, templateInfo.Path));
    lstFPLTemplate.Items.Add(new ListItem(templateInfo.Name,  templateInfo.Path));

                lstMSLContainerTemplate.Items.Add(new ListItem(templateInfo.Name, templateInfo.Path)); //Prasad
                lstMSLTemplate.Items.Add(new ListItem(templateInfo.Name, templateInfo.Path)); //Prasad

                lstPPLContainerTemplate.Items.Add(new ListItem(templateInfo.Name, templateInfo.Path));
    lstPPLTemplate.Items.Add(new ListItem(templateInfo.Name,  templateInfo.Path));
                lstCPLContainerTemplate.Items.Add(new ListItem(templateInfo.Name, templateInfo.Path));
    lstCPLTemplate.Items.Add(new ListItem(templateInfo.Name,  templateInfo.Path));
    lstDetailTemplate.Items.Add(new ListItem(templateInfo.Name,  templateInfo.Path));
   }
  }
  #endregion
 }
}

Continue - Part 4

dotnetnuke store product search module - part 4

2010-01-20T14:12:00.015+05:30

DesktopModules\Store\Catalog\Providers\DataProviders\SqlDataProvider\SqlDataProvider.cs
Add these methods

public override IDataReader GetPortalMYSEARCHProducts(int PortalID, bool Archived, string SearchText, string SearchField)
        {
            return SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "Store_Products_GetPortalMYSEARCHProducts", PortalID, Archived,SearchText,SearchField);
        }

public override IDataReader GetMYSEARCHProducts(int CategoryID, bool Archived, string SearchText, string SearchField)
        {
            return SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "Store_Products_GetMYSEARCHProducts", CategoryID, Archived,SearchText,SearchField);
        }

DesktopModules\Store\Catalog\ModuleSettings.cs

Change Public methods Like this.

public class ModuleSettings
 {
  public GeneralSettings General;
        public NewProductsSettings NewProducts;
        public FeaturedProductsSettings FeaturedProducts;
        public MYSEARCHProductsSettings MYSEARCHProducts; 
  public PopularProductsSettings PopularProducts;
  public CategoryProductsSettings CategoryProducts;
  public ProductDetailSettings ProductDetail;
  public CategoryMenuSettings CategoryMenu;

  public ModuleSettings(int moduleId, int tabId)
  {
   General = new GeneralSettings(moduleId, tabId);
            NewProducts = new NewProductsSettings(moduleId, tabId);
            FeaturedProducts = new FeaturedProductsSettings(moduleId, tabId);
            MYSEARCHProducts = new MYSEARCHProductsSettings(moduleId, tabId);
   PopularProducts = new PopularProductsSettings(moduleId, tabId);
   CategoryProducts = new CategoryProductsSettings(moduleId, tabId);
   ProductDetail = new ProductDetailSettings(moduleId, tabId);
   CategoryMenu = new CategoryMenuSettings(moduleId, tabId);
  }
 }

Add this Region with other settings. (ModuleSettings.cs)

#region MYSEARCH Product Settings
    public class MYSEARCHProductsSettings : SettingsWrapper
    {
        [ModuleSetting("mslcontainertemplate", "ListContainer.htm")]
        public string ContainerTemplate
        {
            [MethodImpl(MethodImplOptions.NoInlining)]
            get
            {
                MethodBase m = MethodBase.GetCurrentMethod();
                return getSetting(m);
            }
            [MethodImpl(MethodImplOptions.NoInlining)]
            set
            {
                MethodBase m = MethodBase.GetCurrentMethod();
                setSetting(m, value);
            }
        }

        [ModuleSetting("msltemplate", "MYSEARCHProduct.htm")]
        public string Template
        {
            [MethodImpl(MethodImplOptions.NoInlining)]
            get
            {
                MethodBase m = MethodBase.GetCurrentMethod();
                return getSetting(m);
            }
            [MethodImpl(MethodImplOptions.NoInlining)]
            set
            {
                MethodBase m = MethodBase.GetCurrentMethod();
                setSetting(m, value);
            }
        }

        [ModuleSetting("mslrowcount", "10")]
        public string RowCount
        {
            [MethodImpl(MethodImplOptions.NoInlining)]
            get
            {
                MethodBase m = MethodBase.GetCurrentMethod();
                return getSetting(m);
            }
            [MethodImpl(MethodImplOptions.NoInlining)]
            set
            {
                MethodBase m = MethodBase.GetCurrentMethod();
                setSetting(m, value);
            }
        }

        [ModuleSetting("mslcolumncount", "2")]
        public string ColumnCount
        {
            [MethodImpl(MethodImplOptions.NoInlining)]
            get
            {
                MethodBase m = MethodBase.GetCurrentMethod();
                return getSetting(m);
            }
            [MethodImpl(MethodImplOptions.NoInlining)]
            set
            {
                MethodBase m = MethodBase.GetCurrentMethod();
                setSetting(m, value);
            }
        }

        [ModuleSetting("mslcolumnwidth", "200")]
        public string ColumnWidth
        {
            [MethodImpl(MethodImplOptions.NoInlining)]
            get
            {
                MethodBase m = MethodBase.GetCurrentMethod();
                return getSetting(m);
            }
            [MethodImpl(MethodImplOptions.NoInlining)]
            set
            {
                MethodBase m = MethodBase.GetCurrentMethod();
                setSetting(m, value);
            }
        }

        [ModuleSetting("mslrepeatdirection", "H")]
        public string RepeatDirection
        {
            [MethodImpl(MethodImplOptions.NoInlining)]
            get
            {
                MethodBase m = MethodBase.GetCurrentMethod();
                return getSetting(m);
            }
            [MethodImpl(MethodImplOptions.NoInlining)]
            set
            {
                MethodBase m = MethodBase.GetCurrentMethod();
                setSetting(m, value);
            }
        }

        [ModuleSetting("mslshowthumbnail", "true")]
        public string ShowThumbnail
        {
            [MethodImpl(MethodImplOptions.NoInlining)]
            get
            {
                MethodBase m = MethodBase.GetCurrentMethod();
                return getSetting(m);
            }
            [MethodImpl(MethodImplOptions.NoInlining)]
            set
            {
                MethodBase m = MethodBase.GetCurrentMethod();
                setSetting(m, value);
            }
        }

        [ModuleSetting("mslthumbnailwidth", "90")]
        public string ThumbnailWidth
        {
            [MethodImpl(MethodImplOptions.NoInlining)]
            get
            {
                MethodBase m = MethodBase.GetCurrentMethod();
                return getSetting(m);
            }
            [MethodImpl(MethodImplOptions.NoInlining)]
            set
            {
                MethodBase m = MethodBase.GetCurrentMethod();
                setSetting(m, value);
            }
        }

        [ModuleSetting("msldetailtabid", "0")]
        public string DetailPage
        {
            [MethodImpl(MethodImplOptions.NoInlining)]
            get
            {
                MethodBase m = MethodBase.GetCurrentMethod();
                return getSetting(m);
            }
            [MethodImpl(MethodImplOptions.NoInlining)]
            set
            {
                MethodBase m = MethodBase.GetCurrentMethod();
                setSetting(m, value);
            }
        }

        public MYSEARCHProductsSettings(int moduleId, int tabId): base(moduleId, tabId)
        {
        }
    }
    #endregion

ProductController.cs
Add these methods

public ArrayList GetPortalMYSEARCHProducts(int portalID, bool archived, string SearchText, string SearchField)
        {
            return CBO.FillCollection(DataProvider.Instance().GetPortalMYSEARCHProducts(portalID, archived,SearchText,SearchField), typeof(ProductInfo));
        }

public ArrayList GetMYSEARCHProducts(int categoryID, bool archived, string SearchText, string SearchField)
        {
            return CBO.FillCollection(DataProvider.Instance().GetMYSEARCHProducts(categoryID, archived,SearchText,SearchField), typeof(ProductInfo));
        }

Continue - Part 5

dotnetnuke store product search module - part 5

2010-01-20T14:11:00.003+05:30

There are very basic stored procedures for the search module.
Database Stored Procedures

CREATE PROCEDURE [dbo].[zee_Store_Products_GetMYSEARCHProducts]
  @CategoryID int,
  @Archived bit = 0,

  @SearchText varchar(500),
  @SearchField varchar(200)
 
 AS
 SET NOCOUNT ON
 
IF @SearchField = 'Manufacturer'
 IF @Archived = 1
  BEGIN
   SELECT
    ProductID,
    PortalID,
    CategoryID,
    Manufacturer,
    ModelNumber,
    ModelName,
    ProductImage,
    UnitCost,
    Keywords,
    Summary,
    [Description],
    Featured,
    Archived,
    CreatedByUser,
    CreatedDate,
    ProductWeight,
    ProductHeight,
    ProductLength,
    ProductWidth,
    SaleStartDate,
    SaleEndDate,
    SalePrice,
    StockQuantity,
    karatage
--   ,CASE
--    WHEN  @SearchField='Manufacturer' THEN Manufacturer -- PM @SearchField
--    WHEN  @SearchField='ModelNumber'  THEN ModelNumber
--       WHEN  @SearchField='ModelName'  THEN ModelName
--   END

   FROM  dbo.zee_Store_Products 
   WHERE  dbo.zee_Store_Products.CategoryID  = @CategoryID
   AND IsDeleted = 0
   AND Archived = 1
   AND Manufacturer  like '%' + @SearchText + '%'
   
   ORDER BY NEWID()
  END
 ELSE
  BEGIN
   
   SELECT
    ProductID,
    PortalID,
    CategoryID,
    Manufacturer,
    ModelNumber,
    ModelName,
    ProductImage,
    UnitCost,
    Keywords,
    Summary,
    [Description],
    Featured,
    Archived,
    CreatedByUser,
    CreatedDate,
    ProductWeight,
    ProductHeight,
    ProductLength,
    ProductWidth,
    SaleStartDate,
    SaleEndDate,
    SalePrice,
    StockQuantity,
    karatage

--   ,CASE
--    WHEN  @SearchField='Manufacturer' THEN Manufacturer -- PM @SearchField
--    WHEN  @SearchField='ModelNumber'  THEN ModelNumber
--       WHEN  @SearchField='ModelName'  THEN ModelName
--   END
   FROM  dbo.zee_Store_Products 
   WHERE  dbo.zee_Store_Products.CategoryID  = @CategoryID
   
   AND  Archived = 0
   AND IsDeleted = 0
   AND Manufacturer  like '%' + @SearchText + '%' --@SearchField PM 

   ORDER BY NEWID()
  END



IF @SearchField = 'ModelNumber'
 IF @Archived = 1
  BEGIN
   SELECT
    ProductID,
    PortalID,
    CategoryID,
    Manufacturer,
    ModelNumber,
    ModelName,
    ProductImage,
    UnitCost,
    Keywords,
    Summary,
    [Description],
    Featured,
    Archived,
    CreatedByUser,
    CreatedDate,
    ProductWeight,
    ProductHeight,
    ProductLength,
    ProductWidth,
    SaleStartDate,
    SaleEndDate,
    SalePrice,
    StockQuantity,
    karatage
   FROM  dbo.zee_Store_Products 
   WHERE  dbo.zee_Store_Products.CategoryID  = @CategoryID
   AND IsDeleted = 0
   AND Archived = 1
   AND ModelNumber  like '%' + @SearchText + '%'
   
   ORDER BY NEWID()
  END
 ELSE
  BEGIN
   
   SELECT
    ProductID,
    PortalID,
    CategoryID,
    Manufacturer,
    ModelNumber,
    ModelName,
    ProductImage,
    UnitCost,
    Keywords,
    Summary,
    [Description],
    Featured,
    Archived,
    CreatedByUser,
    CreatedDate,
    ProductWeight,
    ProductHeight,
    ProductLength,
    ProductWidth,
    SaleStartDate,
    SaleEndDate,
    SalePrice,
    StockQuantity,
    karatage

   FROM  dbo.zee_Store_Products 
   WHERE  dbo.zee_Store_Products.CategoryID  = @CategoryID
   
   AND  Archived = 0
   AND IsDeleted = 0
   AND ModelNumber  like '%' + @SearchText + '%' --@SearchField PM 

   ORDER BY NEWID()
  END

IF @SearchField = 'ModelName'
 IF @Archived = 1
  BEGIN
   SELECT
    ProductID,
    PortalID,
    CategoryID,
    Manufacturer,
    ModelNumber,
    ModelName,
    ProductImage,
    UnitCost,
    Keywords,
    Summary,
    [Description],
    Featured,
    Archived,
    CreatedByUser,
    CreatedDate,
    ProductWeight,
    ProductHeight,
    ProductLength,
    ProductWidth,
    SaleStartDate,
    SaleEndDate,
    SalePrice,
    StockQuantity,
    karatage
   FROM  dbo.zee_Store_Products 
   WHERE  dbo.zee_Store_Products.CategoryID  = @CategoryID
   AND IsDeleted = 0
   AND Archived = 1
   AND ModelName  like '%' + @SearchText + '%'
   
   ORDER BY NEWID()
  END
 ELSE
  BEGIN
   
   SELECT
    ProductID,
    PortalID,
    CategoryID,
    Manufacturer,
    ModelNumber,
    ModelName,
    ProductImage,
    UnitCost,
    Keywords,
    Summary,
    [Description],
    Featured,
    Archived,
    CreatedByUser,
    CreatedDate,
    ProductWeight,
    ProductHeight,
    ProductLength,
    ProductWidth,
    SaleStartDate,
    SaleEndDate,
    SalePrice,
    StockQuantity,
    karatage

   FROM  dbo.zee_Store_Products 
   WHERE  dbo.zee_Store_Products.CategoryID  = @CategoryID
   
   AND  Archived = 0
   AND IsDeleted = 0
   AND ModelName  like '%' + @SearchText + '%' --@SearchField PM 

   ORDER BY NEWID()
  END 


CREATE PROCEDURE [dbo].[zee_Store_Products_GetPortalMYSEARCHProducts]
  @PortalID int,
  @Archived bit = 0,

  @SearchText varchar(500),
  @SearchField varchar(200)

 AS
 SET NOCOUNT ON
 
IF @SearchField = 'Manufacturer'
 IF @Archived = 1
  SELECT
   ProductID,
   PortalID,
   CategoryID,
   Manufacturer,
   ModelNumber,
   ModelName,
   ProductImage,
   UnitCost,
   Keywords,
   Summary,
   [Description],
   Featured,
   Archived,
   CreatedByUser,
   CreatedDate,
   ProductWeight,
   ProductHeight,
   ProductLength,
   ProductWidth,
   SaleStartDate,
   SaleEndDate,
   SalePrice,
   StockQuantity,
    karatage

--   ,CASE
--    WHEN  @SearchField='Manufacturer' THEN Manufacturer -- PM @SearchField
--    WHEN  @SearchField='ModelNumber'  THEN ModelNumber
--       WHEN  @SearchField='ModelName'  THEN ModelName
--    --WHEN  @SearchField='SalePrice'  THEN SalePrice
--   END

  FROM  dbo.zee_Store_Products 
  WHERE  PortalID = @PortalID
  --AND Featured = 1
  AND IsDeleted = 0
  --AND  Manufacturer like 'mm%' -- PM Manufacturer
  AND Manufacturer like '%' + @SearchText + '%'

  ORDER BY NEWID()
 ELSE
  SELECT
   ProductID,
   PortalID,
   CategoryID,
   Manufacturer,
   ModelNumber,
   ModelName,
   ProductImage,
   UnitCost,
   Keywords,
   Summary,
   [Description],
   Featured,
   Archived,
   CreatedByUser,
   CreatedDate,
   ProductWeight,
   ProductHeight,
   ProductLength,
   ProductWidth,
   SaleStartDate,
   SaleEndDate,
   SalePrice,
   StockQuantity,
    karatage

--   ,CASE
--    WHEN  @SearchField='Manufacturer' THEN Manufacturer -- PM @SearchField
--    WHEN  @SearchField='ModelNumber'  THEN ModelNumber
--       WHEN  @SearchField='ModelName'  THEN ModelName
--    --WHEN  @SearchField='SalePrice'  THEN SalePrice
--   END

  FROM  dbo.zee_Store_Products 
  WHERE  PortalID = @PortalID
  --AND Featured = 1
  AND  Archived = 0
  AND IsDeleted = 0
  AND Manufacturer like '%' + @SearchText + '%' -- PM Manufacturer
  --AND Manufacturer  like 'mm%' -- PM @SearchField
  ORDER BY NEWID()


IF @SearchField = 'ModelNumber'
 IF @Archived = 1
  SELECT
   ProductID,
   PortalID,
   CategoryID,
   Manufacturer,
   ModelNumber,
   ModelName,
   ProductImage,
   UnitCost,
   Keywords,
   Summary,
   [Description],
   Featured,
   Archived,
   CreatedByUser,
   CreatedDate,
   ProductWeight,
   ProductHeight,
   ProductLength,
   ProductWidth,
   SaleStartDate,
   SaleEndDate,
   SalePrice,
   StockQuantity,
    karatage

  FROM  dbo.zee_Store_Products 
  WHERE  PortalID = @PortalID
  AND IsDeleted = 0
  --AND  Manufacturer like 'mm%' -- PM Manufacturer
  AND ModelNumber like '%' + @SearchText + '%'

  ORDER BY NEWID()
 ELSE
  SELECT
   ProductID,
   PortalID,
   CategoryID,
   Manufacturer,
   ModelNumber,
   ModelName,
   ProductImage,
   UnitCost,
   Keywords,
   Summary,
   [Description],
   Featured,
   Archived,
   CreatedByUser,
   CreatedDate,
   ProductWeight,
   ProductHeight,
   ProductLength,
   ProductWidth,
   SaleStartDate,
   SaleEndDate,
   SalePrice,
   StockQuantity,
    karatage

  FROM  dbo.zee_Store_Products 
  WHERE  PortalID = @PortalID
  AND  Archived = 0
  AND IsDeleted = 0
  AND ModelNumber like '%' + @SearchText + '%' -- PM Manufacturer
  --AND Manufacturer  like 'mm%' -- PM @SearchField
  ORDER BY NEWID()




IF @SearchField = 'ModelName'
 IF @Archived = 1
  SELECT
   ProductID,
   PortalID,
   CategoryID,
   Manufacturer,
   ModelNumber,
   ModelName,
   ProductImage,
   UnitCost,
   Keywords,
   Summary,
   [Description],
   Featured,
   Archived,
   CreatedByUser,
   CreatedDate,
   ProductWeight,
   ProductHeight,
   ProductLength,
   ProductWidth,
   SaleStartDate,
   SaleEndDate,
   SalePrice,
   StockQuantity,
    karatage

  FROM  dbo.zee_Store_Products 
  WHERE  PortalID = @PortalID
  AND IsDeleted = 0
  --AND  Manufacturer like 'mm%' -- PM Manufacturer
  AND ModelName like '%' + @SearchText + '%'

  ORDER BY NEWID()
 ELSE
  SELECT
   ProductID,
   PortalID,
   CategoryID,
   Manufacturer,
   ModelNumber,
   ModelName,
   ProductImage,
   UnitCost,
   Keywords,
   Summary,
   [Description],
   Featured,
   Archived,
   CreatedByUser,
   CreatedDate,
   ProductWeight,
   ProductHeight,
   ProductLength,
   ProductWidth,
   SaleStartDate,
   SaleEndDate,
   SalePrice,
   StockQuantity,
    karatage

  FROM  dbo.zee_Store_Products 
  WHERE  PortalID = @PortalID
  AND  Archived = 0
  AND IsDeleted = 0
  AND ModelName like '%' + @SearchText + '%' -- PM Manufacturer
  --AND Manufacturer  like 'mm%' -- PM @SearchField
  ORDER BY NEWID()

Now in the html templates you can use it [MYSEARCH] for search input and [MYSEARCHRESULT] to display searched result.

Return to - Part 1

SAML Single Sign On for Google Apps in .NET and DotNetNuke

2010-01-16T14:37:00.001+05:30

Nowadays there are very popular applications like Face book Applications, Google Apps, Blogs, and Forms etc. The purpose of all this applications is collecting people to one place. But you may need to go for each and every web site or application and login to these applications separately. Most probably you may think how nice it is login to the all applications in one place under a secured environment. Yes. Now it is possible. Think there is a one web application to login and you can access all you applications from one place. You are not redirecting to any other applications. But still you are in the same web site. This is what we called SSO. SSO stands for Single Sign On. Google apps are also giving this feature. You can use some of their projects for this. But I saw there are a very few resources and references for this on the web. Now I have given some useful tips to run the .NET Google Apps web project which I got with my SSO experience.
Give your virtual directory an Application Name that does not have dots (.) in the name. To make sure you are not having naming issues, give a short name such as SSO_Dir as your Virtual Directory name.

If you are going to run your SSO application on the DNN application then you have to develop a special module. But I saw there are several issues while it running through the current DNN Framework. As a solution I propose this. Add your SSO project folder to the DNN root. If you are trying to run this application as a normal application on DNN you will see some errors. The solution is creating a sub domain for the main DNN domain and assigns the SSO root as the sub domain root path. Sometimes you may need hosing provider’s support for this. Now you can give the SSO prompt page as the Google signing page.

If your SSO application is a sub project or running through a sub domain as a sub application you will use an additional web.config file SSO application. But it may be an issue when you are running 2 web.config files under one project. Especially it is an issue in the DNN framework.

You will see this common error:

It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS

Then move the Subfolder web.config Contents to the Main folder web.config file and keep them as one project. But still you can run your sub domain as a different application.

Still if you see above error then please check your backup folder. Normally your SSO application is coming as a VS 2005 project. But if you use VS 2008 you need to convert your project for 2008 version. In this process it is copying all files to this ‘Backup’ folder.

If you do not like this solution and if you want to keep the sub web.config file as it is you can remove ‘Authentication’ properties and session states properties from it. It will work if you are not using major properties from the sub web.config file.

When you are building your own SSO application for Google Apps you need to have a better idea about this process. You can have a better knowledge about the mechanism of Google SSO this is the place - http://code.google.com/apis/apps/sso/saml_reference_implementation.html

If you are using Visual Studio 2005 these are the steps to generate certificates for the SSO Apps from our VS command prompt.

Creating and installing a certificate

Run these commands from a command prompt. If Visual Studio 2005 is installed in a different location, change the commands accordingly.

cd \projects\Google.Apps.SingleSignOn\key
"C:\Program Files\Microsoft Visual Studio 8\Common7\Tools\Bin\makecert.exe" -r -pe -n "CN=My Domain" -sky exchange -sv mycert.pvk mycert.cer
"C:\Program Files\Microsoft Visual Studio 8\Common7\Tools\Bin\pvk2pfx.exe" -pvk mycert.pvk -spc mycert.cer -pfx mycert.pfx

makecert.exe will generate two files:
mycert.cer - certificate which contains the public key
mycert.pvk - contains the private key
pvk2pfx.exe will generate one file:
mycert.pfx - contains the private key, usable by .NET framework
That is what the procedure of Google team. It is not for 2008. If you are using Visual Studio 2008 this is the way to generate certificates.

makecert.exe -r -pe -n "CN=My Domain" -sky exchange -sv mycert.pvk mycert.cer
pvk2pfx.exe -pvk mycert.pvk -spc mycert.cer -pfx mycert.pfx

You should change the certification name with the domain name and other details in the command as you want.
Now you will see the difference and the reason why I propose this way. You cannot find a folder called ‘C:\Program Files\Microsoft Visual Studio 8\Common7\Tools\Bin’ for VS 2008.
You must upload the certificates to the appropriate folder of the server which you’ve generated in your machine and to the Google Apps.

Also, please note SSO will not work if user is referred directly to
http://mydomain.com/GoogleAppsSso/Prompt.aspx. This is because a redirection from a Google Property (Docs, Gmail, Calendar...) is required in order to get the proper SAML Request and the Relay State. This a common mistake when Administrators try to refer their users directly to the SSO Prompt page.
For a success Google Apps Single Sign On application you need to pass SAMLRequest and RelayState. You can see this messages on text areas and when it is running successfully.You can hide it like this. Keep remember not to remove this text areas.

Also you can use hidden fields instead of text areas.
If you have any issues regarding the Google SSO, I like to support you. I hope to bring you more SSO tips for other applications as well in the future.

Image Thumbnail Generation

2010-01-02T15:38:00.004+05:30

Here I am posting a code for generating a thumbnail for your given image. You can pass your width and height through this method via parameters. If you want to generate square thumbnails, you need only to pass same value for width and height. Then it will give you a cropped thumbnail.

public void ResizeImage(string OrigFile, string NewFile, int NewWidth, int MaxHeight, bool ResizeIfWider)
{
System.Drawing.Image FullSizeImage = System.Drawing.Image.FromFile(OrigFile);
// Ensure the generated thumbnail is not being used by rotating it 360 degrees
FullSizeImage.RotateFlip(System.Drawing.RotateFlipType.Rotate180FlipNone);
FullSizeImage.RotateFlip(System.Drawing.RotateFlipType.Rotate180FlipNone);
if (ResizeIfWider)
{
if (FullSizeImage.Width <= NewWidth)
                {
                    NewWidth = FullSizeImage.Width;
                }
            }
            int NewHeight = FullSizeImage.Height * NewWidth / FullSizeImage.Width;
            if (NewHeight > MaxHeight) // Height resize if necessary
{
NewWidth = FullSizeImage.Width * MaxHeight / FullSizeImage.Height;
NewHeight = MaxHeight;
}

// Create the new image with the sizes we've calculated
System.Drawing.Image NewImage = FullSizeImage.GetThumbnailImage(NewWidth, NewHeight, null, IntPtr.Zero);
FullSizeImage.Dispose();
NewImage.Save(NewFile);
}

DotNetNuke Installation Issues and Solutions

2009-11-06T19:12:00.004+05:30

I have given below some tips to install DotNetNuke Installation in your system. I have seen most of developers are asking different questions with the installation failures. If you follow my instructions you can save lot of time without wasting your effort. I think the current stable version is 4.9.5. I am installing DotNetNuke successfully in XP and Vista by following this procedure.
You should not run the application before doing these instructions. You can do it after doing following changes.
Keep remember to change release.config to web.config. You should not keep a copy of the web.config file inside the root. If you want to keep it as a reference you can back up it in another location.
You can change the following code manually in the web.config file .Sometimes this will save you in your manual process installation.

Find where is the ScriptModule has added as a module.Remove all and add following lines in appropriate place.

If you are installing the source version it will say you have not installed the new Ajax version. If you have already installed Ajax in your machine then it might be an older version. Anyway for your above both issues this is the solution.
Download new Ajax toolkit from the Microsoft Ajax official site and install it in your machine. If you followed the default procedure it will save the .dll in this path.
C:\Program Files\Microsoft ASP.NET\ASP.NET 2.0 AJAX Extensions\v1.0.61025
You can copy it and save in the following folder in the DotNetNuke Installation.
In DotNetNuke.Library Project Controls Project create folder AJAX and sub folder bin Under Ajax folder
This is only if you are using new Version. If you have done this perfectly it should work Ajax functions in your application.
Anyway If you upgrade your Installation to new 3.5 Framework sometimes you may need to edit the following lines as follows.

Now build the site and run the application.
If you have any doubt about above instructions feel free to ask. I am ready to send you a working solution with the Database to your inbox.

DotNetNuke Password Reset

2009-09-14T16:33:00.004+05:30

If you forget DNN password ,Then how you are going to recover.Think you can not remember both admin and host passwords.You can do nothing without admin & host password.
Yes there is a password reminder option.But it seems not working properly.Anyway I am bringing you a good option today.Run following SQL in the Query analyzer and run the command what I have given at the end.


CREATE procedure [dbo].[uap_ResetPassword]
@UserName NVarChar(255),
@NewPassword NVarChar(255)
as
begin
Declare @PasswordSalt NVarChar(128)
Declare @ApplicationID NVarChar(255)
Declare @ApplicationName NVarChar(255)

Set @ApplicationID = (SELECT [ApplicationID] FROM aspnet_Users WHERE UserName=@UserName)
Set @ApplicationName = (SELECT [ApplicationName] FROM aspnet_Applications WHERE ApplicationID=@ApplicationID)
Set @PasswordSalt = (SELECT PasswordSalt FROM aspnet_Membership WHERE UserID IN (SELECT UserID FROM aspnet_Users WHERE UserName=@UserName))

select @ApplicationID, @ApplicationName
declare @RetVal as int
Exec @RetVal = dbo.aspnet_Membership_ResetPassword @ApplicationName, @UserName, @NewPassword, 10, 10, @PasswordSalt, -5
return @RetVal
end

-- now run this command with your username and password
uap_ResetPassword 'host','123'
uap_ResetPassword 'admin','456'

Save your time without wasting time to find the password recovery methods

Extended Ajax Calendar Extender

2009-09-12T22:41:00.009+05:30

Do you want to change the colors of the weekend in the Ajax Calendar extender control.
You have to change the behaviour of a AJAX Control Tool Kit in this way.Fllow my method.

add CSS to AjaX Control Tool Kit Solution >> Calendar Folder >> Calendar.css
Add one more line..


.ajax__calendar_container {padding:4px;cursor:default;width:170px;font-size:11px;text-align:center;font-family:tahoma,verdana,helvetica;}
.ajax__calendar_body {height:139px;width:170px;position:relative;overflow:hidden;margin:auto;}
.ajax__calendar_days, .ajax__calendar_months, .ajax__calendar_years {top:0px;left:0px;height:139px;width:170px;position:absolute;text-align:center;margin:auto;}
.ajax__calendar_container TABLE {padding:0px;margin:0px;font-size:11px;}
.ajax__calendar_container TD {padding:0px;margin:0px;font-size:11px;}
.ajax__calendar_header {height:20px;width:100%;}
.ajax__calendar_prev {cursor:pointer;width:15px;height:15px;float:left;background-repeat:no-repeat;background-position:50% 50%;background-image:url(<%=WebResource("AjaxControlToolkit.Calendar.arrow-left.gif")%>);}
.ajax__calendar_next {cursor:pointer;width:15px;height:15px;float:right;background-repeat:no-repeat;background-position:50% 50%;background-image:url(<%=WebResource("AjaxControlToolkit.Calendar.arrow-right.gif")%>);}
.ajax__calendar_title {cursor:pointer;font-weight:bold;}
.ajax__calendar_footer {height:15px;}
.ajax__calendar_today {cursor:pointer;padding-top:3px;}
.ajax__calendar_dayname {height:17px;width:17px;text-align:right;padding:0 2px;}
.ajax__calendar_day {height:17px;width:18px;text-align:right;padding:0 2px;cursor:pointer;}
.ajax__calendar_month {height:44px;width:40px;text-align:center;cursor:pointer;overflow:hidden;}
.ajax__calendar_year {height:44px;width:40px;text-align:center;cursor:pointer;overflow:hidden;}
.ajax__calendar .ajax__calendar_container {border:1px solid #646464;background-color:#ffffff;color:#000000;}
.ajax__calendar .ajax__calendar_footer {border-top:1px solid #f5f5f5;}
.ajax__calendar .ajax__calendar_dayname {border-bottom:1px solid #f5f5f5;}
.ajax__calendar .ajax__calendar_day {border:1px solid #ffffff;}
.ajax__calendar .ajax__calendar_month {border:1px solid #ffffff;}
.ajax__calendar .ajax__calendar_year {border:1px solid #ffffff;}
.ajax__calendar .ajax__calendar_active .ajax__calendar_day {background-color:#edf9ff;border-color:#0066cc;color:#0066cc;}
.ajax__calendar .ajax__calendar_active .ajax__calendar_month {background-color:#edf9ff;border-color:#0066cc;color:#0066cc;}
.ajax__calendar .ajax__calendar_active .ajax__calendar_year {background-color:#edf9ff;border-color:#0066cc;color:#0066cc;}
.ajax__calendar .ajax__calendar_other .ajax__calendar_day {background-color:#ffffff;border-color:#ffffff;color:#646464;}
.ajax__calendar .ajax__calendar_other .ajax__calendar_year {background-color:#ffffff;border-color:#ffffff;color:#646464;}
.ajax__calendar .ajax__calendar_hover .ajax__calendar_day {background-color:#edf9ff;border-color:#daf2fc;color:#0066cc;}
.ajax__calendar .ajax__calendar_hover .ajax__calendar_month {background-color:#edf9ff;border-color:#daf2fc;color:#0066cc;}
.ajax__calendar .ajax__calendar_hover .ajax__calendar_year {background-color:#edf9ff;border-color:#daf2fc;color:#0066cc;}
.ajax__calendar .ajax__calendar_hover .ajax__calendar_title {color:#0066cc;}
.ajax__calendar .ajax__calendar_hover .ajax__calendar_today {color:#0066cc;}
//the upper line is already there.....you have to add this css line
.ajax__calendar .ajax__calendar_new .ajax__calendar_day {color:Red;}

in then CalendarBehavior.js file add code...(modified only bold one) Line Number 1048


for (var week = 0; week < weekrow =" this._daysBody.rows[week];" dayofweek =" 0;" daycell =" weekRow.cells[dayOfWeek].firstChild;" title =" currentDate.localeFormat(" date =" currentDate;" currentdate =" new">

if (dtf.ShortestDayNames[(dayOfWeek + firstDayOfWeek) % 7] == "Su") {
//if sunday then change the color  
Sys.UI.DomElement.addCssClass(dayCell.parentNode, "ajax__calendar_new");  }
if (dtf.ShortestDayNames[(dayOfWeek + firstDayOfWeek) % 7] == "Sa") {
//if saturday then chagne the color  
Sys.UI.DomElement.addCssClass(dayCell.parentNode, "ajax__calendar_new");  }
} }

/// you will find this in _performLayout: function() { 
/// Updates the various views of the calendar to match the current selected and visible dates
/// 
switch (this._mode) {
case "days":

If this helps you please give me your comment and put your new suggestions here.

Ajax calendar with drop downs

2009-08-18T17:05:00.010+05:30

Ajax Calendar control has only one view to display the date.But some of people are not familiar with this view and they want the old classic view with drop downs to select dates.This is what who are looking for the custom calendar control.You can use this as a user control and just drag and drop to the design view to use it.

.aspx


<%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="ajaxToolkit" %>

 <%--onFocus="javascript:this.blur();" autocomplete="off"--%>
*

.cs



using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class Quote_Engine_CustomAjaxCalender : System.Web.UI.UserControl
{
public string DateTextFromValue
{
  get { return DateTextFrom.Text; }
  set { DateTextFrom.Text = value; }
}

public Boolean DateTextRequired
{
  get { return DateTextFromRequired.Enabled; }
  set { DateTextFromRequired.Enabled = value; }
}

public string DateTextRequiredText
{
  get { return DateTextFromRequired.ErrorMessage; }
  set { DateTextFromRequired.ErrorMessage = value; }
}

//private string theDateTextFrom;

protected void Page_Load(object sender, EventArgs e)
{
  if (!Page.IsPostBack)
  {
      Populate_MonthList();
      Populate_YearList();

      DateTime dt;
      if (DateTextFrom.Text != "")
      {
          dt = DateTime.Parse(DateTextFrom.Text);
          Calendar1.TodaysDate = dt;
      }
  }
}

// SET THE FIRST CALENDAR (FROM DATE)
public void Set_Calendar(object Sender, EventArgs E)
{
  string theDate = drpCalMonth.SelectedItem.Value + " 1, " + drpCalYear.SelectedItem.Value;
  DateTime dtFoo;
  dtFoo = System.Convert.ToDateTime(theDate);
  Calendar1.TodaysDate = dtFoo;
}

protected void Calendar1_SelectionChanged(object sender, EventArgs e)
{
  // Popup result is the selected date
  drpCalMonth.SelectedIndex = Calendar1.SelectedDate.Month - 1;
  drpCalYear.SelectedItem.Selected = false;
  drpCalYear.Items.FindByValue(Calendar1.SelectedDate.Year.ToString()).Selected = true;

  // Popup result is the selected date
  //PopupControlExtender1.Commit(Calendar1.SelectedDate.ToShortDateString());
  PopupControlExtender1.Commit(Calendar1.SelectedDate.ToString("dd/MM/yyyy"));

}

// INNOVATIVE CALENDARS VIA AJAX THAT ALLOW USER TO PICK MONTH AND DATE VIA DROPDOWN
void Populate_MonthList()
{
  drpCalMonth.Items.Add("January");
  drpCalMonth.Items.Add("February");
  drpCalMonth.Items.Add("March");
  drpCalMonth.Items.Add("April");
  drpCalMonth.Items.Add("May");
  drpCalMonth.Items.Add("June");
  drpCalMonth.Items.Add("July");
  drpCalMonth.Items.Add("August");
  drpCalMonth.Items.Add("September");
  drpCalMonth.Items.Add("October");
  drpCalMonth.Items.Add("November");
  drpCalMonth.Items.Add("December");
  //string strMonth;

  //if (DateTextFrom.Text == "")
  //    strMonth = DateTime.Now.ToString("MMMM");
  //else

  //    strMonth = Convert.ToDateTime(DateTextFrom.Text).ToString("MMMM");
  //drpCalMonth.Items.FindByValue(strMonth).Selected = true;
}

// POPULATE THE YEARLIST FROM 20 YEARS AGO TO ONE YEAR HENCE
void Populate_YearList()
{
  int intYear;


  // Year list can be changed by changing the lower and upper
  // limits of the For statement
  for (intYear = DateTime.Now.Year - 10; intYear <= DateTime.Now.Year + 10; intYear++)        {            drpCalYear.Items.Add(intYear.ToString());        }         //if (DateTextFrom.Text == "")        //    drpCalYear.Items.FindByValue(DateTime.Now.Year.ToString()).Selected = true;        //else        //{        //    string strYear = Convert.ToDateTime(DateTextFrom.Text).Year.ToString();        //    drpCalYear.Items.FindByValue(strYear).Selected = true;        //}    } }

Ajax Calendar Themes

2009-08-18T16:03:00.012+05:30

Most of the people like to give a different look and feel to the calendar control. There are two themes for Ajax Calendar. This will help you to modify your calendar view.



/* Start - Calander Styles */
.ajax__calendar_container
{padding:4px;position:absolute;cursor:default;width:170px;font-size:11px;
text-align:center;font-family:tahoma,verdana,helvetica;}
.ajax__calendar_body
{height:139px;width:170px;position:relative;overflow:hidden;margin:auto; }
.ajax__calendar_days, .ajax__calendar_months, .ajax__calendar_years
{top:0px;left:0px;height:139px;width:170px;position:absolute;
text-align:center;margin:auto;}
.ajax__calendar_container TABLE {font-size:11px;}
.ajax__calendar_header {height:20px; background-color:#63B2DB;width:100%;}
.ajax__calendar_prev
{cursor:pointer;width:15px;height:15px;float:left;
background-repeat:no-repeat;background-position:50% 50%;
background-image:
url();}
.ajax__calendar_next
{cursor:pointer;width:15px;height:15px;float:right;
background-repeat:no-repeat;background-position:50% 50%;
background-image:
url();}
.ajax__calendar_title {cursor:pointer;font-weight:bold;}
.ajax__calendar_footer {height:15px; background-color:#63B2DB;}
.ajax__calendar_today {cursor:pointer;padding-top:3px;}
.ajax__calendar_dayname {height:17px;width:18px;text-align:right;padding:0 2px;}
.ajax__calendar_day
{height:17px;width:18px;text-align:right;padding:0 2px;cursor:pointer;}
.ajax__calendar_month
{height:44px;width:40px;text-align:center;cursor:pointer;overflow:hidden;}
.ajax__calendar_year
{height:44px;width:40px;text-align:center;cursor:pointer;overflow:hidden;}
.ajax__calendar .ajax__calendar_container
{border:1px solid #646464;background-color:#ffffff;color:#000000;}
.ajax__calendar .ajax__calendar_footer {border-top:1px solid #f5f5f5;}
.ajax__calendar .ajax__calendar_dayname {border-bottom:1px solid #f5f5f5;}
.ajax__calendar .ajax__calendar_day {border:1px solid #ffffff;}
.ajax__calendar .ajax__calendar_month {border:1px solid #ffffff;}
.ajax__calendar .ajax__calendar_year {border:1px solid #ffffff;}
.ajax__calendar .ajax__calendar_active .ajax__calendar_day
{background-color:#edf9ff;border-color:#0066cc;color:#0066cc;}
.ajax__calendar .ajax__calendar_active .ajax__calendar_month
{background-color:#edf9ff;border-color:#0066cc;color:#0066cc;}
.ajax__calendar .ajax__calendar_active .ajax__calendar_year
{background-color:#edf9ff;border-color:#0066cc;color:#0066cc;}
.ajax__calendar .ajax__calendar_other .ajax__calendar_day
{background-color:#ffffff;border-color:#ffffff;color:#ffffff;cursor:default;}
.ajax__calendar .ajax__calendar_other .ajax__calendar_month
{background-color:#ffffff;border-color:#ffffff;color:#ffffff;cursor:default;}
.ajax__calendar .ajax__calendar_other .ajax__calendar_year
{background-color:#ffffff;border-color:#ffffff;color:#ffffff;cursor:default;}
.ajax__calendar .ajax__calendar_today .ajax__calendar_day
{background-color:#fff2a8;}
.ajax__calendar .ajax__calendar_hover .ajax__calendar_day
{background-color:#edf9ff;border-color:#daf2fc;color:#0066cc;}
.ajax__calendar .ajax__calendar_hover .ajax__calendar_month
{background-color:#edf9ff;border-color:#daf2fc;color:#0066cc;}
.ajax__calendar .ajax__calendar_hover .ajax__calendar_year
{background-color:#edf9ff;border-color:#daf2fc;color:#0066cc;}
.ajax__calendar .ajax__calendar_hover .ajax__calendar_title {color:#0066cc;}
.ajax__calendar .ajax__calendar_hover .ajax__calendar_today {color:#0066cc;}

/* End - Calander Styles */

This is the second theme and you should use the class name inside the calendar control like this.

.aspx

.css


/*Start Cal Theme */
.cal_The .ajax__calendar_container

{
background-color: #63B2DB; border:solid 0px #cccccc;

}

.cal_The .ajax__calendar_header

{
background-color: #63B2DB; margin-bottom: 4px;

}

.cal_The .ajax__calendar_title
{

}

.cal_The .ajax__calendar_next,

.cal_The .ajax__calendar_prev

{
color: #004080; padding-top: 3px;

}

.cal_The .ajax__calendar_body

{
background-color: #FFFFFF; border: solid 1px #cccccc;
/*e9e9e9*/
}

.cal_The .ajax__calendar_dayname

{
text-align:center; font-weight:bold; margin-bottom: 4px; margin-top: 2px;
background-color: #ffffff;
}

.cal_The .ajax__calendar_day

{
text-align:center;

}

.cal_The .ajax__calendar_hover .ajax__calendar_day,

.cal_The .ajax__calendar_hover .ajax__calendar_month,

.cal_The .ajax__calendar_hover .ajax__calendar_year,

.cal_The .ajax__calendar_active

{
color: #004080; font-weight:bold; background-color: #ffffff;

}

.cal_The .ajax__calendar_today

{
font-weight:bold;

}

.cal_The .ajax__calendar_other,

.cal_The .ajax__calendar_hover .ajax__calendar_today,

.cal_The .ajax__calendar_hover .ajax__calendar_title

{
color: #bbbbbb;

}
/*End Cal Theme*/

I have added the simple example for the above style sheet as the Deepak's request.

Ajax Reorder list with database-Issues & solutions

2009-08-17T18:49:00.020+05:30

Ajax control toolkit is providing us a great control called ReoderList with lot of features. But there is not a direct method to deal with the database records. Anyway today I am bringing you a solution for this. This will view details from the database table in the reorderlist with both images and text. Not only that. It will update the new order to the database field once you change the order. I have tested this and this is my working code. You should change the commands in the SqlDataSource and change the field names in .cs file to your table field names.

You'd better keep remember this too for the best result. This will require the new release of the Ajax control toolkit and new framework of .net like 3.5.Because it is using Linq in .cs code. I found another issue and I have written to Microsoft people about this. Reorderlist control is not working in their IE 8 old version. I have mentioned this in my previous post. You can try with install new version of that browser and test it too.
.aspx


 
<asp:UpdatePanel ID="Up1" runat="server">
                 <ContentTemplate>
           
            <div class="reorderListDemo">
                <ajaxtoolkit:ReorderList ID="ReorderList1" runat="server" 
                                        AllowReorder="True" 
                                        PostBackOnReorder="true"
                                        DataSourceID="SqlDataSource1" 
                                        CallbackCssStyle="callbackStyle" 
                                        DragHandleAlignment="Right"
                                        ItemInsertLocation="End"
                                        DataKeyField="id"
                                        EnableViewState="true"
                                        SortOrderField="oderId"
                                        Width="500px"
                                        >
                                        
                                        <ItemTemplate>
                                            <div style="width:300px; display:inline; vertical-align:top;">
                                            
                                        <div style="width:50px;float:left; vertical-align:middle; padding-top:40px; ">  <asp:Label ID="Label2" runat="server" Text='<%# HttpUtility.HtmlEncode(Convert.ToString(Eval("oderId"))) %>' /> </div> <%--<%#  HttpUtility.HtmlEncode(Convert.ToString(Convert.ToInt32(Eval("oderId"))+1))%>--%>
                                        <div style="width:150px;float:left;">   <asp:Image Width="100px"  ID="Image1" runat="server" ImageUrl='<%# DataBinder.Eval(Container.DataItem, "image_name", "~/DesktopModules/Ricette/imgUpload/tmp/tbn{0}")%>' /> </div>
                                        <div style="width:70px;float:left;">   <asp:ImageButton CommandName="Delete" ImageUrl="imgUpload/basket.png" ID="ImageButton1" runat="server" Height="70px" Width="56px" /> </div>                                          

                                            </div>
                                        </ItemTemplate>
                                        <EditItemTemplate>
                                            <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("image_name") %>' />
                                            <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("id") %>' />
                                            <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("title_id") %>' />
                                            <asp:TextBox ID="TextBox5" runat="server" Text='<%# Bind("oderId") %>' />
                                            <asp:TextBox ID="TextBox6" runat="server" Text='<%# Bind("published") %>' />
                                        </EditItemTemplate>
                                        <ReorderTemplate>
                                            <asp:Panel ID="Panel1" runat="server" CssClass="reorderCue" />
                                        </ReorderTemplate>
                                        <DragHandleTemplate>
                                            <div style="height:99px; width:100px; cursor:move; float:left;">
                                                <asp:Image runat="server" ImageUrl="~/DesktopModules/Ricette/imgUpload/hand.gif" />
                                             </div>
                                        </DragHandleTemplate>
                                        
                                        <InsertItemTemplate>
                                            <div style="padding-left:5px; float:none; border-bottom:thin solid transparent;">
                                                <asp:Panel ID="Panel2" runat="server" DefaultButton="Button1" Width="650px" >
                                                        <asp:Button ID="Button1" runat="server"  CommandName="Insert" Text="Refresh and Publish" />
                                                </asp:Panel>
                                            </div>
                                        </InsertItemTemplate>
                                        
                </ajaxtoolkit:ReorderList>
            </div>
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                ConnectionString="<%$ ConnectionStrings:SiteSqlServer %>" 
                DeleteCommand="DELETE FROM [Ricette_Images] WHERE [id] = @id" 
                InsertCommand="INSERT INTO [Ricette_Images] ([title_id], [image_name], [oderId], [published]) VALUES (@title_id, @image_name, @oderId, @published) DELETE FROM [Ricette_Images] WHERE [image_name] = 'noname'" 
                SelectCommand="SELECT [id], [title_id], [image_name], [oderId], [published] FROM [Ricette_Images] WHERE [title_id] = @title_id order by oderId asc" 
                UpdateCommand="UPDATE [Ricette_Images] SET [title_id] = @title_id, [image_name] = @image_name, [oderId] = @oderId, [published] = @published WHERE [id] = @id">
                
                <SelectParameters>
                    <asp:Parameter Name="title_id" Type="String" DefaultValue="<%= title_id %>" />
                </SelectParameters>
                <DeleteParameters>
                    <asp:Parameter Name="id" Type="Int32" />
                </DeleteParameters>
                <UpdateParameters>
                    <asp:Parameter Name="title_id" Type="Int32" />
                    <asp:Parameter Name="image_name" Type="String" />
                    <asp:Parameter Name="oderId" Type="Int32" />
                    <asp:Parameter Name="published" Type="Boolean" />
                    <asp:Parameter Name="id" Type="Int32" />
                </UpdateParameters>
                <InsertParameters>
                    <asp:Parameter Name="title_id" Type="Int32" DefaultValue="111" />
                    <asp:Parameter Name="image_name" Type="String" DefaultValue="noname" />
                    <asp:Parameter Name="oderId" Type="Int32" DefaultValue="11" /> 
                    <asp:Parameter Name="published" Type="Boolean" DefaultValue="false"/>
                </InsertParameters>
            </asp:SqlDataSource>
            
                </ContentTemplate>
            </asp:UpdatePanel>

.cs


 
protected void ReorderList1_ItemReorder(object sender, AjaxControlToolkit.ReorderListItemReorderEventArgs e)
{
//get Old Priority
int oldI = e.OldIndex;
//get New Priority
int newI = e.NewIndex;
//get the selected Item Value
string selectedDK = ReorderList1.DataKeys[oldI].ToString();
string i2updateList = "";
//Build update list based on everything after/equal to the new priority but not equal to the selected one and in order so they can be updated in order
SqlConnection oConn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings.Get("SiteSqlServer"));
{
SqlCommand sqlCmd = new SqlCommand("select id from Ricette_Images where id <> '" + selectedDK + "' and oderId >= '" + newI + "' order by oderId asc", oConn);
oConn.Open();
using (SqlDataReader reader = sqlCmd.ExecuteReader())
{
while (reader.Read())
{
if (string.IsNullOrEmpty(i2updateList))
{
 
i2updateList = reader["id"].ToString();
}
else
{
 
i2updateList += "," + reader["id"].ToString();
}
}
}
}
int newPriority = newI;
string[] rolArr = null;
rolArr = i2updateList.Split(',');
//update each from the list by 1
foreach (var x in rolArr)
{
newPriority = newPriority + 1;
SqlConnection myConnection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings.Get("SiteSqlServer"));
{
myConnection.Open();
SqlCommand myCommand = new SqlCommand("update Ricette_Images set oderId = '" + newPriority + "' where id='" + x + "'", myConnection);
 
myCommand.ExecuteNonQuery();
}
 
newPriority = newPriority;
}
//finally, update the selected one for its changed priority
SqlConnection myConne = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings.Get("SiteSqlServer"));
{
myConne.Open();
SqlCommand myCommand = new SqlCommand("update Ricette_Images set oderId = '" + newI.ToString() + "' where id='" + selectedDK + "'", myConne);
myCommand.ExecuteNonQuery();
}
}
void ReorderList1_ItemCommand(object sender, AjaxControlToolkit.ReorderListCommandEventArgs e, AjaxControlToolkit.ReorderListItemReorderEventArgs ee)
{
int oldI = ee.OldIndex;//get Old Priority
string selectedDK = ReorderList1.DataKeys[oldI].ToString();//get the selected Item Value
// If you want support for multiple commands
SqlConnection myConnect = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings.Get("SiteSqlServer"));
myConnect.Open();
if (e.CommandName == "Delete")
//return;
{
//DELETE FROM [Ricette_Images] WHERE [id] = @id
SqlCommand myCommand = new SqlCommand("DELETE FROM Ricette_Images where id='" + selectedDK + "'", myConnect);
myCommand.ExecuteNonQuery();
}
if (e.CommandName == "Select")
//return;
{
int titleid = Convert.ToInt32(HttpContext.Current.Session["RecordID"]);
//SqlDataSource1.SelectParameters.Add("userNum", userNum);
SqlDataSource1.SelectParameters.Add("@title_id", titleid.ToString());
//SELECT [id], [title_id], [image_name], [oderId], [published] FROM [Ricette_Images] WHERE [title_id] = title_id order by oderId asc"
SqlCommand sqlCmd = new SqlCommand("select [id], [title_id], [image_name], [oderId], [published] from Ricette_Images where title_id ='" + titleid + "' order by oderId DESC", myConnect);
sqlCmd.ExecuteNonQuery();
}
if (e.CommandName == "Insert")
//return;
{
string imgNullName = "t";
SqlCommand myCommandCheckNull = new SqlCommand("DELETE FROM Ricette_Images where image_name='" + imgNullName + "'", myConnect);
myCommandCheckNull.ExecuteNonQuery();
}
if (e.CommandName == "Refresh")
//return;
{
int Currenttitleid = Convert.ToInt32(HttpContext.Current.Session["RecordID"]);
bool Newpublished = true;
SqlConnection myConnect1 = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings.Get("SiteSqlServer"));
{
myConnect1.Open();
SqlCommand myCommand = new SqlCommand("update Ricette_Images set published = '" + Newpublished + "' where title_id='" + Currenttitleid + "'", myConnect1);
myCommand.ExecuteNonQuery();
}
}
}

.css

SQL


CREATE TABLE [dbo].[Ricette_Images](
 [id] [int] IDENTITY(1,1) NOT NULL,
 [title_id] [int] NULL,
 [image_name] [varchar](500) NULL CONSTRAINT [DF_Ricette_Images_image_name]  DEFAULT ('img'),
 [oderId] [int] NULL,
 [published] [bit] NULL CONSTRAINT [DF_Ricette_Images_published]  DEFAULT ((0)),
 CONSTRAINT [PK_Ricette_Images] PRIMARY KEY CLUSTERED 
(
 [id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

Welcome for your comments and for your questions.

Select a future date with Ajax Calendar

2009-08-17T18:48:00.005+05:30

There is not a method to validate future or past date in Ajax CalendarExtender Control. This is the JavaScript to set validate the Ajax calendar for future date. If you want to validate past date ,you have to do only change the comparison symbol.


    <script language="javascript" type="text/javascript">
        function checkDate(sender,args)
            {       
                if (sender._selectedDate < new Date())
                {
                    alert("You must select a date in the future.");
                   
                    //create the date
                    var myDate = new Date();
                    //add a day to the date
                    myDate.setDate(myDate.getDate() + 1);
                    sender._selectedDate = myDate;  //new Date();
                    // set the date back to the current date
                    sender._textbox.set_Value(sender._selectedDate.format(sender._format))
                }

            }

    </script>

New Ajax Calendar with new feature

2009-08-17T18:37:00.014+05:30

I have posted a solution before for an Ajax calendar with drop downs.But there is a control called CalendarExtenderPlus .you can find it from http://lionsden.co.il/codeden/?p=222 .This control has developed by Hanan Schwartzberg.But there were some issues.Anyway Hanan could fix some of the issues.But I noted there was an issue when we are using this control with other Ajax controls.The issue was can not select a date after the first selection.Because calendar control is getting stuck.We were sending more than 30 messages to each other to figure out the issue.Anyway finally I could find the issue.That was 2 java script errors.
The error was
Microsoft JScript runtime error: Sys.InvalidOperationException: Type Sys.Timer has already been registered.

Anyway I found this solution for this.You should modify the ScriptManager code like this.Then everything will work fine.Thank you very much for your great work Hanan.I just put pepper and salt on to it.



        runat="server"
        EnablePageMethods="true"  
        EnableScriptGlobalization="true"  
        ScriptMode="Release" />

I recommend to install AJAX Control Toolkit May 2009 Release or later version like Version 3.0.30512 for best result with this.

File uploading with Ajax without a page refresh

2009-08-10T11:45:00.006+05:30

This is a common issue what .net developers are facing frequently who are following the general methods with Ajax update panel.Can you use the file upload control in the update panel for not to refresh the page when you are uploading a file?Simple answer is no.Because it needs a full page post back and if you use a AsyncPostBackTrigger as a trigger will give an Error.Because the result is something like FileUpload1.HasFile = False. This is what Microsoft people has missed in their Ajax controls techniques. But we will go through this challenge and I will show you my solution below.

The Best solution is Keep the file uploading in a different .aspx page an call it via an Iframe.you can retrieve all information of upload page in the Iframe by a java script. This will act as same way like in update panel. I know most of developers are wasting their time to find a solution for this.Hope this will help you all to this common issue. If you want the sample code do not hesitate to ask me.

Silverlight challenges !

2009-08-07T12:11:00.002+05:30

Microsoft has introduced a new interactive interface objects called Silverlight which was something like a replacement for Flash.Actually it was challenge to Microsoft because they did not have a technique like Flash.Anyway They hope to develop this components more user friendly and easy to use to developers.As we know they were always first in this.But their first version was more complicated and lot of bugs I found.But they found a IDE like Blend to overcome this issue.But Users should have the knowledge of new web language XAML which was built on XML concepts.But now it has come silverlight 3.0 .But still there are some conflicts to get familiar with Silverlight.I saw main three issues with Silverlight technology.

1. It requires more hardware requirements.
2. It should have a Fast Internet Connection.It is taking a long time to download to the client machine.
3. It is taking long time to develop with comparing to their other components like Visual Studio controls.

I think Nobody can give a solution for first two issues with current versions.Otherwise Microsoft should go to a new light version.

But for the third one I got a cool solution.There are more than 60 silver light components and absolutely free to use.

Silverlight Components

At the moment I am using this controls and saved my time.I will come with more experience in the future again.I have some other solutions.But still I am using them.If they work fine I will share them with you.

Ajax Issues with .NET Framework

2009-08-06T15:16:00.000+05:30

Ajax is a cool piece of cake that we are using in our application. It is not only giving the user interaction.But also saving our development time too.Microsoft people has invented Ajax control tool kit to the .NET Framework.But I saw some of issues with this and could found solutions by working on them with wasting hours and hours.I thought to share my AJAX experiences with all of you and have your feedback what you found.Hope this will save your time.

1.Version Compatibility.
Ajax control Tool Kit version 1 and 2 is most suitable with .NET Framework 2.0.But I recommended to use Ajax control tool kit version 3 with new 3.5 framework.If you are getting an error with asking for an assembly reference the best solution is restore the new version of the Ajax control tool kit and do not forget to look at the web.config file and add the reference like this.This will change according to the error.

     
  <add assembly="System.Core, Version=3.5.0.0, Culture=neutral,
     PublicKeyToken=B77A5C561934E089"/>
  <add assembly="System.Web.Extensions, Version=3.5.0.0,
     Culture=neutral,PublicKeyToken=31BF3856AD364E35"/>
  <add assembly="System.Data.DataSetExtensions, Version=3.5.0.0,
     Culture=neutral,PublicKeyToken=B77A5C561934E089"/>
  <add assembly="System.Xml.Linq, Version=3.5.0.0,
     Culture=neutral,PublicKeyToken=B77A5C561934E089"/>
  <add assembly="System.Data.Linq, Version=3.5.0.0,
     Culture=neutral,PublicKeyToken=B77A5C561934E089"/>

I will talk on this again later with more details.

2. Ajax Control Tool Kit Reorder List is not working on IE 8 Browser.I saw most of peoples' solution was install the New version of the toolkit.But you must install the new update of the IE8 browser too.There was a big issue with this control.That was reorder list can not reorder.

3.There is a common toolbox error when we are publishing the project solution.I saw there were lot of answers this and nobody gave a solution.Do not go to change the coding.Just delete the reference and restore the Ajax control toolkit to the tool box.It is working perfectly.

4.As you know Ajax is running on java scripts.There is an another amazing technique called Jquery which is running on java script.But there is a conflict when we are using both J query with Ajax.I saw this has come with J query light box.The reason was both Java scripts had used same variable names inside their coding.You should find the same variable names and change in J query scripts.That was the solution.Before it was giving java script errors with wrong line numbers.That is strange.

Solutions are seems to be easy.But Problems were wasting time of most of the people.That is why I thought to collect them in to one place and give it to you.

Do not forget to keep here your feedback.

Microsoft Technical Issues

2009-08-06T12:26:00.000+05:30

This blog is dedicated to discuss technical issues and solutions in Microsoft technologies.You can post your found solutions and issue via this blog.More articles in the future.

Welcome to my Blog

2008-05-07T11:40:00.000+05:30

Welcome to all