30.7.10

RadAjaxManager alert telerik

RadAjaxManager1.ResponseScripts.Add("alert('Please select atleast one Recipient')");

Execute Reader and List:

int ret = 0;
SqlCommand objCmd = new SqlCommand("UspInsertUpdate_DashBoard", objCon);
objCmd.CommandType = CommandType.StoredProcedure;
#region Parameters Ordte Products
objCmd.Parameters.Add("@intDashBoardId", SqlDbType.BigInt).Value = objUI.DashBoardId;
objCmd.Parameters.Add("@intUserId", SqlDbType.BigInt).Value = objUI.UserId;
objCmd.Parameters.Add("@chvnModule", SqlDbType.NVarChar).Value = objUI.Module;
objCmd.Parameters.Add("@chvnExp", SqlDbType.NVarChar).Value = objUI.Exp;
objCmd.Parameters.Add("@chvnTitle", SqlDbType.NVarChar).Value = objUI.Title;

#endregion
try
{
objCon.Open();
ret = Convert.ToInt32(objCmd.ExecuteScalar());

}
catch
{
}
finally
{
objCmd.Dispose();
objCon.Close();
}
return ret;
=====================================

list:

SqlCommand objcmd = new SqlCommand("UspDisplayAccounts", objCon);
objcmd.CommandType = CommandType.StoredProcedure;
objcmd.Parameters.Add("@intUserId", SqlDbType.Int).Value = UserId;
List objList = new List();
SqlDataReader objDr;
objCon.Open();
objDr = objcmd.ExecuteReader();
try
{

while (objDr.Read())
{
Accounts objBol = new Accounts();
objBol.AccountId = Convert.ToInt32(objDr["crm_cust_info_pk"]);
objBol.Title = objDr["crm_cust_acc_title"].ToString();
objBol.CompanyName = objDr["Name"].ToString();
objBol.CreateDate = Convert.ToDateTime(objDr["crm_cust_create_date"]);
objBol.AddressId = Convert.ToInt32(objDr["crm_add_fk"]);
objBol.CreatedByName = objDr["created_by_name"].ToString();
objBol.AssignTo = objDr["assigned_to_name"].ToString();
objList.Add(objBol);
}
}
catch
{
}
finally
{
objDr.Close();
objCon.Close();
objcmd.Dispose();
}
return objList;
Posted by at No comments:
Labels:

Radgrid View Products aspx

Tool for write in box:http://www.accessify.com/tools-and-wizards/developer-tools/quick-escape/default.php

<%@ Page Language="C#" AutoEventWireup="true" Theme="Admin" CodeFile="ViewProducts.aspx.cs"
    Inherits="Admin_Products_ViewProducts" %>

<%@ Register Assembly="RadGrid.Net2" Namespace="Telerik.WebControls" TagPrefix="radG" %>
<%@ Register Src="../UserControls/HeaderBar.ascx" TagName="HeaderBar" TagPrefix="uc1" %>
<%@ Register Src="../UserControls/Footer.ascx" TagName="Footer" TagPrefix="uc2" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>View Products</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <div id="maincontainer">
            <!--Maincontainer starts here-->
            <div id="main_header">
                <!--Main Header starts here-->
                <uc1:HeaderBar ID="HeaderBar1" runat="server" />
            </div>
            <!--Main Header ends here-->
            <div id="body">
                <!--Body starts here-->
                <div id="bodyinnerpart">
                    <!--Body Inner starts here-->
                    <div id="body_left">
                        <!--Body left panel starts here-->
                        <div id="body_leftinner">
                            <table width="100%" border="0" cellspacing="0" cellpadding="0">
                                <tr>
                                    <td colspan="2" align="left" valign="middle" class="body_left_h1">
                                        Products
                                    </td>
                                </tr>
                                <tr>
                                    <td class="body_left_h2" style="background-color: #FFFFFF;">
                                        <a href="AddProducts.aspx">Add Products</a>
                                    </td>
                                    <td style="background-color: #FFFFFF;" class="body_left_bdr">
                                        <img src="../images/moreicon.gif" width="7" height="13" />
                                    </td>
                                </tr>
                                <tr>
                                    <td width="93%" class="body_left_h2" style="background-color: #FFFFFF;">
                                        <a href="Attributes.aspx">Add Attributes</a>
                                    </td>
                                    <td width="7%" style="background-color: #FFFFFF;" class="body_left_bdr">
                                        <img src="../images/moreicon.gif" width="7" height="13" />
                                    </td>
                                </tr>
                                <tr>
                                    <td class="body_left_h2" style="background-color: #FFFFFF;">
                                        <a href="AddColour.aspx">Add Colours</a>
                                    </td>
                                    <td style="background-color: #FFFFFF;" class="body_left_bdr">
                                        <img src="../images/moreicon.gif" width="7" height="13" />
                                    </td>
                                </tr>
                            </table>
                        </div>
                        <div id="body_leftinner1">
                        </div>
                    </div>
                    <!--Body left panel ends here-->
                    <div id="body_right">
                        <!--Body right panel starts here-->
                        <div id="body_right_top" class="body_right_h1">
                            <asp:LinkButton ID="lkparent" runat="server" Text="» Products"></asp:LinkButton>
                            &nbsp;
                        </div>
                        <div id="body_right_inner1">
                            <table width="638" border="0" align="left" cellpadding="0" cellspacing="0">
                                <tr>
                                    <td width="576" align="right" style ="padding-bottom :3px;">
                                    <asp:TextBox ID="textsearch" runat ="server" Width="130px" ></asp:TextBox>
                                        
                                    </td>
                                    <td width="62" align="right" style ="padding-bottom :3px;">
                                        <asp:ImageButton ID ="Imgsearch" runat ="server"
                                            ImageUrl ="../images/searchbutton.gif" width="57" height="19" 
                                            onclick="Imgsearch_Click" />
                                    </td>
                                </tr>
                            </table>
                        </div>
                        <div id="body_right_inner">
                         
                        </div>
                    </div>
                    <!--Body right panel ends here-->
                </div>
                <!--Body Inner ends here-->
            </div>
            <!--Body ends here-->
            <div id="footer">
                <!--Footer starts here-->
                <uc2:Footer ID="Footer1" runat="server" />
            </div>
            <!--Footer ends here-->
        </div>
    </div>
    </form>
</body>
</html>
   <radG:RadGrid ID="RadgridDisplayProducts" runat="server" Skin="WebBlue" Width="638px"
                                AutoGenerateColumns="False" GridLines="None" OnDeleteCommand="RadgridDisplayProducts_DeleteCommand"
                                OnNeedDataSource="RadgridDisplayProducts_NeedDataSource" 
                                OnItemCommand="RadgridDisplayProducts_ItemCommand" AllowPaging="True" 
                                EnableAJAX="True" EnableAJAXLoadingTemplate="True" PageSize="20">
                                <ExportSettings>
                                    <Pdf PageWidth="8.5in" PageRightMargin="" PageFooterMargin="" PageLeftMargin="" PageTopMargin=""
                                        PageHeight="11in" PageBottomMargin="" PageHeaderMargin=""></Pdf>
                                </ExportSettings>
                                <MasterTableView DataKeyNames="ProductsID">
                                    <ExpandCollapseColumn Visible="False" Resizable="False">
                                        <HeaderStyle Width="20px"></HeaderStyle>
                                    </ExpandCollapseColumn>
                                    <RowIndicatorColumn Visible="False">
                                        <HeaderStyle Width="20px"></HeaderStyle>
                                    </RowIndicatorColumn>
                                    <Columns>
                                        <radG:GridBoundColumn DataField="Products_Name" HeaderText="Product Name" UniqueName="column">
                                            <HeaderStyle Width="250px" />
                                            <ItemStyle CssClass="gridtext" />
                                        </radG:GridBoundColumn>
                                        <radG:GridBoundColumn DataField="Model" HeaderText="Product Code" UniqueName="column">
                                            <HeaderStyle Width="150px" />
                                            <ItemStyle CssClass="gridtext" />
                                        </radG:GridBoundColumn>
                                        <radG:GridTemplateColumn>
                                            <ItemTemplate>
                                                <asp:ImageButton ID="Imgbtnedit" runat="server" CausesValidation="false" CommandName="View"
                                                    ImageUrl="../images/view.gif" />
                                            </ItemTemplate>
                                            <ItemStyle Width="120px" CssClass="gridpadding2" />
                                        </radG:GridTemplateColumn>
                                        <radG:GridButtonColumn ConfirmText="Delete this Record?" ButtonType="ImageButton"
                                            ImageUrl="../images/delete.gif" CommandName="Delete" Text="Delete" UniqueName="DeleteColumn"
                                            FilterImageUrl="~/RadControls/GridSkin/Telerik/Filter.gif" SortAscImageUrl="~/RadControls/GridSkin/Telerik/SortAsc.gif"
                                            SortDescImageUrl="~/RadControls/GridSkin/Telerik/SortDesc.gif">
                                            <ItemStyle Width="98px" HorizontalAlign="center" />
                                        </radG:GridButtonColumn>
                                    </Columns>
                                </MasterTableView>
                            </radG:RadGrid>


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

public partial class Admin_Products_ViewProducts : System.Web.UI.Page
{
    ProductsManager objBll = new ProductsManager();
    CategoriesManager objcat = new CategoriesManager();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Request.QueryString["cid"] != null)
            {
                ViewState["CategoryID"] = Request.QueryString["cid"].ToString();
            }
            else
            {
                ViewState["CategoryID"] = "-1";
            }
            
            DisplayProducts();
            GenrateXML();
        }
    }
    private void GenrateXML()
    {
        DataSet objds = objcat.BLL_GetProductsXML();

        objds.WriteXml(Server.MapPath("../../Main.xml"));
    }
  
    private void DisplayProducts()
    {
        
            RadgridDisplayProducts.DataSource = objBll.BLL_DspProducts(Convert.ToInt32(ViewState["CategoryID"]));
            RadgridDisplayProducts.DataBind();
       
        
    }
    protected void RadgridDisplayProducts_ItemCommand(object source, Telerik.WebControls.GridCommandEventArgs e)
    {
        if (e.CommandName == "View")
        {
            int PID = Convert.ToInt32(RadgridDisplayProducts.MasterTableView.DataKeyValues[e.Item.ItemIndex]["ProductsID"]);
            Response.Redirect("ProductDetail.aspx?PID=" + PID.ToString());
        }
    }
    protected void RadgridDisplayProducts_DeleteCommand(object source, Telerik.WebControls.GridCommandEventArgs e)
    {
         int ProductsID = Convert.ToInt32(RadgridDisplayProducts.MasterTableView.DataKeyValues[e.Item.ItemIndex]["ProductsID"]);
         
        
         objBll.BLL_DeleteProducts(ProductsID);
         DisplayProducts();
    }
    protected void RadgridDisplayProducts_NeedDataSource(object source, Telerik.WebControls.GridNeedDataSourceEventArgs e)
    {

        //RadgridDisplayProducts.DataSource = objBll.BLL_DspProducts();
        RadgridDisplayProducts.DataSource = objBll.BLL_DspProducts(Convert.ToInt32(ViewState["CategoryID"]));
    }
    protected void Imgsearch_Click(object sender, ImageClickEventArgs e)
    {
        {
            RadgridDisplayProducts.DataSource = objBll.BLL_ADM_ProductSearch(textsearch.Text.Trim());
            RadgridDisplayProducts.DataBind();
        }
    }
}



using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using Ecommerce.BOL;

namespace Ecommerce.DAL
{
    class ProductsDB : AppConfig
    {
        //Insert Update  Products
        public int DAL_InsUpdProducts(Products objBol)
        {
            SqlCommand objCmd = new SqlCommand("ADM_InsUpdProductsInfo", objCon);
            objCmd.CommandType = CommandType.StoredProcedure;
            objCmd.Parameters.Add("@ProductsID", SqlDbType.Int).Value = objBol.ProductsID;
            objCmd.Parameters.Add("@Products_Name", SqlDbType.NVarChar).Value = objBol.Products_Name;
            objCmd.Parameters.Add("@Products_Description", SqlDbType.NVarChar).Value = objBol.Products_Description;
            objCmd.Parameters.Add("@Meta_keywords", SqlDbType.NVarChar).Value = objBol.Meta_keywords;
            objCmd.Parameters.Add("@Products_Type", SqlDbType.Int).Value = objBol.Products_Type;
            objCmd.Parameters.Add("@Show_quantity", SqlDbType.Bit).Value = objBol.Show_quantity;
            objCmd.Parameters.Add("@Model", SqlDbType.NVarChar).Value = objBol.Model;
            objCmd.Parameters.Add("@Price", SqlDbType.Decimal).Value = objBol.Price;
            objCmd.Parameters.Add("@Active", SqlDbType.Bit).Value = objBol.Active;
            objCmd.Parameters.Add("@Meta_Description", SqlDbType.NVarChar).Value = objBol.Meta_Description;
            objCmd.Parameters.Add("@Meta_Title", SqlDbType.NVarChar).Value = objBol.Meta_Title;
            objCon.Open();
            int intRetval = Convert.ToInt32(objCmd.ExecuteScalar());
            objCmd.Dispose();
            objCon.Close();
            return intRetval;


        }
        // Insert Update Products Images
        public int DAL_InsUpdProductsImages(Products objBol)
        {
            SqlCommand objCmd = new SqlCommand("ADM_InsUpdProductImages", objCon);
            objCmd.CommandType = CommandType.StoredProcedure;
            objCmd.Parameters.Add("@Products_imageID", SqlDbType.Int).Value = objBol.Products_imageID;
            objCmd.Parameters.Add("@ProductsID", SqlDbType.Int).Value = objBol.ProductsID;
            objCmd.Parameters.Add("@ColourID", SqlDbType.Int).Value = objBol.ColourID;
            objCmd.Parameters.Add("@Icon_image", SqlDbType.VarChar).Value = objBol.Icon_image;
            objCmd.Parameters.Add("@Medium_image", SqlDbType.VarChar).Value = objBol.Medium_image;
            objCmd.Parameters.Add("@Large_image", SqlDbType.VarChar).Value = objBol.Large_image;
            objCmd.Parameters.Add("@Colour_name", SqlDbType.VarChar).Value = objBol.Colour_name;
            objCmd.Parameters.Add("@default_style", SqlDbType.Bit).Value = objBol.default_style;
            objCon.Open();
            int intRetval = Convert.ToInt32(objCmd.ExecuteScalar());
            objCmd.Dispose();
            objCon.Close();
            return intRetval;


        }
        // Update Images status [ADM_UpdImagesStatus]
        public int DAL_UpdImagesStatus(int ProductsID, int Products_imageID)
        {
            SqlCommand objCmd = new SqlCommand("ADM_UpdImagesStatus", objCon);
            objCmd.CommandType = CommandType.StoredProcedure;
            objCmd.Parameters.Add("@Products_imageID", SqlDbType.Int).Value =Products_imageID;
            objCmd.Parameters.Add("@ProductsID", SqlDbType.Int).Value = ProductsID;
            objCon.Open();
            int intRetval = Convert.ToInt32(objCmd.ExecuteScalar());
            objCmd.Dispose();
            objCon.Close();
            return intRetval;


        }
        // Insert Update Products Size Quantity
        public int DAL_InsUpdProductsSize(Products objBol)
        {
            SqlCommand objCmd = new SqlCommand("ADM_InsUpdProductsSize", objCon);
            objCmd.CommandType = CommandType.StoredProcedure;
            objCmd.Parameters.Add("@Products_sizeID", SqlDbType.Int).Value = objBol.Products_sizeID;
            objCmd.Parameters.Add("@ProductsID", SqlDbType.Int).Value = objBol.ProductsID;
            objCmd.Parameters.Add("@attributes_values_id", SqlDbType.Int).Value = objBol.attributes_values_id;
            objCmd.Parameters.Add("@attributes_values_name", SqlDbType.VarChar).Value = objBol.attributes_values_name;
            objCmd.Parameters.Add("@ColourID", SqlDbType.Int).Value = objBol.ColourID;
            objCmd.Parameters.Add("@Quantity", SqlDbType.Int).Value = objBol.Quantity;
            objCmd.Parameters.Add("@Reorder_level", SqlDbType.Int).Value = objBol.Reorder_level;
            objCon.Open();
            int intRetval = Convert.ToInt32(objCmd.ExecuteScalar());
            objCmd.Dispose();
            objCon.Close();
            return intRetval;


        }
        // Insert Update Products TO Categories
        public int DAL_InsUpdProductsToCategories(Products objBol)
        {
            SqlCommand objCmd = new SqlCommand("ADM_InsUpdProductsToCategories", objCon);
            objCmd.CommandType = CommandType.StoredProcedure;
            objCmd.Parameters.Add("@Products_categoryID", SqlDbType.Int).Value = objBol.Products_categoryID;
            objCmd.Parameters.Add("@ProductsID", SqlDbType.Int).Value = objBol.ProductsID;
            objCmd.Parameters.Add("@CategoryID", SqlDbType.Int).Value = objBol.CategoryID;
            objCon.Open();
            int intRetval = Convert.ToInt32(objCmd.ExecuteScalar());
            objCmd.Dispose();
            objCon.Close();
            return intRetval;


        }

        //---------------------------------------------------------------------------------Display Products 
        public List Dal_DspProducts(Int32 CategoryID)
        {
            SqlCommand objCmd = new SqlCommand("ADM_DspProducts", objCon);
            objCmd.CommandType = CommandType.StoredProcedure;
            objCmd.Parameters.Add("@CategoryID", SqlDbType.BigInt).Value = CategoryID;
            SqlDataReader objDr;
            objCon.Open();
            objDr = objCmd.ExecuteReader();
            List objList = new List();
            if (objDr.HasRows)
            {
                while (objDr.Read())
                {

                    Products objBol = new Products();
                    objBol.ProductsID = Convert.ToInt32(objDr["ProductsID"]);
                    objBol.Products_Name = objDr["Products_Name"].ToString();
                    objBol.Model = objDr["Model"].ToString();
                    objList.Add(objBol);
                }
            }
            objDr.Close();
            objCmd.Dispose();
            objCon.Close();
            return objList;
        }
        //Display Products By ID


        public List Dal_DspProductsBYID(Int32 ProductsID)
        {
            SqlCommand objCmd = new SqlCommand("ADM_DspProductsBYID", objCon);
            objCmd.CommandType = CommandType.StoredProcedure;
            objCmd.Parameters.Add("@ProductsID", SqlDbType.Int).Value = ProductsID;
            SqlDataReader objDr;
            objCon.Open();
            objDr = objCmd.ExecuteReader();
            List objList = new List();
            if (objDr.HasRows)
            {

                objDr.Read();
                Products objBol = new Products();
                objBol.ProductsID = Convert.ToInt32(objDr["ProductsID"]);
                objBol.Products_Name = objDr["Products_Name"].ToString();
                objBol.Model = objDr["Model"].ToString();
                objBol.Products_Description = objDr["Products_Description"].ToString();
                objBol.Meta_keywords = objDr["Meta_keywords"].ToString();
                objBol.Products_Type = Convert.ToInt32(objDr["Products_Type"]);
                objBol.Show_quantity = Convert.ToBoolean(objDr["Show_quantity"]);
                objBol.Price = Convert.ToDecimal(objDr["Price"]);
                objBol.Active = Convert.ToBoolean(objDr["Active"]);
                objBol.Meta_Description = objDr["Meta_Description"].ToString();
                objBol.Meta_Title = objDr["Meta_Title"].ToString();
                objList.Add(objBol);

            }
            objDr.Close();
            objCmd.Dispose();
            objCon.Close();
            return objList;
        }
        //Dipslay product Details [ADM_DspProductsDetail]
        public DataSet Dal_DspProductsDetails(int productID)
        {
            SqlDataAdapter objadp = new SqlDataAdapter("ADM_DspProductsDetail", objCon);
            objadp.SelectCommand.CommandType = CommandType.StoredProcedure;
            objadp.SelectCommand.Parameters.Add("@ProductsID", SqlDbType.Int).Value = productID;
            DataSet objds = new DataSet();
            objadp.Fill(objds);
            return objds;
        }
    //[ADM_ProductSearch]
 //@searchItem varchar(50)
        public DataSet Dal_ADM_ProductSearch(string searchItem)
        {
            SqlDataAdapter objadp = new SqlDataAdapter("ADM_ProductSearch", objCon);
            objadp.SelectCommand.CommandType = CommandType.StoredProcedure;
            objadp.SelectCommand.Parameters.Add("@searchItem", SqlDbType.VarChar).Value = searchItem;
            DataSet objds = new DataSet();
            objadp.Fill(objds);
            return objds;
        }
        // Display Products Size [ADM_DspProductsSize]
        public DataSet Dal_DspProductsSize(int productID)
        {
            SqlDataAdapter objadp = new SqlDataAdapter("ADM_DspProductsSizeBYID", objCon);
            objadp.SelectCommand.CommandType = CommandType.StoredProcedure;
            objadp.SelectCommand.Parameters.Add("@ProductsID", SqlDbType.Int).Value = productID;
            DataSet objds = new DataSet();
            objadp.Fill(objds);
            return objds;
        }
       
        public List Dal_FillProductsolour(int productID)
        {
            SqlCommand objCmd = new SqlCommand("ADM_FillProductsColour", objCon);
            objCmd.CommandType = CommandType.StoredProcedure;
            objCmd.Parameters.Add("@ProductsID", SqlDbType.Int).Value = productID;
            SqlDataReader objDr;
            objCon.Open();
            objDr = objCmd.ExecuteReader();
            List objList = new List();
            if (objDr.HasRows)
            {
                while (objDr.Read())
                {

                    Colour objBol = new Colour();
                    objBol.ColourID = Convert.ToInt32(objDr["ColourID"]);
                    objBol.Colour_name = objDr["Colour_name"].ToString();
                    objList.Add(objBol);
                }
            }
            objDr.Close();
            objCmd.Dispose();
            objCon.Close();
            return objList;
        }
        //Display products Category [ADM_DspProducts_Category]
        public DataSet DAL_DiplayProductsCategories(int ProductsID)
        {
            SqlDataAdapter objadp = new SqlDataAdapter("ADM_DspProducts_Category", objCon);
            objadp.SelectCommand.CommandType = CommandType.StoredProcedure;
            objadp.SelectCommand.Parameters.Add("@ProductsID", SqlDbType.Int).Value = ProductsID;
            DataSet objds = new DataSet();
            objadp.Fill(objds);
            return objds;
        }
        public List Dal_DspProductsImages(int productID)
        {
            SqlCommand objCmd = new SqlCommand("ADM_DspProducts_images", objCon);
            objCmd.CommandType = CommandType.StoredProcedure;
            objCmd.Parameters.Add("@ProductsID", SqlDbType.Int).Value = productID;
            SqlDataReader objDr;
            objCon.Open();
            objDr = objCmd.ExecuteReader();
            List objList = new List();
            if (objDr.HasRows)
            {
                while (objDr.Read())
                {

                    Products objBol = new Products();
                    objBol.Products_imageID = Convert.ToInt32(objDr["Products_imageID"]);
                    objBol.ProductsID = Convert.ToInt32(objDr["ProductsID"]);
                    objBol.ColourID = Convert.ToInt32(objDr["ColourID"]);
                    objBol.Icon_image = objDr["Icon_image"].ToString();
                    objBol.Medium_image = objDr["Medium_image"].ToString();
                    objBol.Large_image =objDr["Large_image"].ToString ();
                    objBol.Colour_name = objDr["Colour_name"].ToString();
                    objBol.default_style = Convert.ToBoolean (objDr["default_style"]);
                    objList.Add(objBol);
                }
            }
            objDr.Close();
            objCmd.Dispose();
            objCon.Close();
            return objList;
        }
        //[ADM_DspProducts_imagesBYID]
        public List Dal_DspProductsImagesBYID(int productID)
        {
            SqlCommand objCmd = new SqlCommand("ADM_DspProducts_imagesBYID", objCon);
            objCmd.CommandType = CommandType.StoredProcedure;
            objCmd.Parameters.Add("@Products_imageID", SqlDbType.Int).Value = productID;
            SqlDataReader objDr;
            objCon.Open();
            objDr = objCmd.ExecuteReader();
            List objList = new List();
            if (objDr.HasRows)
            {

                objDr.Read();
                    Products objBol = new Products();
                    objBol.Products_imageID = Convert.ToInt32(objDr["Products_imageID"]);
                    objBol.ProductsID = Convert.ToInt32(objDr["ProductsID"]);
                    objBol.ColourID = Convert.ToInt32(objDr["ColourID"]);
                    objBol.Icon_image = objDr["Icon_image"].ToString();
                    objBol.Medium_image = objDr["Medium_image"].ToString();
                    objBol.Large_image = objDr["Large_image"].ToString();
                    objBol.Colour_name = objDr["Colour_name"].ToString();
                    objBol.default_style = Convert.ToBoolean(objDr["default_style"]);
                    objList.Add(objBol);
               
            }
            objDr.Close();
            objCmd.Dispose();
            objCon.Close();
            return objList;
        }
        //Delete Products Images [ADM_DelProductsImages]
        public int DAL_DeleteProductsImages(int ProductImageID)
        {

            SqlCommand objCmd = new SqlCommand("ADM_DelProductsImages", objCon);
            objCmd.CommandType = CommandType.StoredProcedure;
            objCmd.Parameters.Add("@Products_imageID", SqlDbType.Int).Value = ProductImageID;
            objCon.Open();
            int intRetval = Convert.ToInt32(objCmd.ExecuteScalar());
            objCmd.Dispose();
            objCon.Close();
            return intRetval;


        }
        //Delete Products To Categories [ADM_DelProductsToCategories]
        public void DAL_DeleteProductsToCategories(int Products_categoryID)
        {

            SqlCommand objCmd = new SqlCommand("ADM_DelProductsToCategories", objCon);
            objCmd.CommandType = CommandType.StoredProcedure;
            objCmd.Parameters.Add("@Products_categoryID", SqlDbType.Int).Value = Products_categoryID;
            objCon.Open();
            objCmd.ExecuteNonQuery();
            objCmd.Dispose();
            objCon.Close();

        }
        //Delete Products Size [ADM_DelProductsSize]
        public void DAL_DeleteProductsSize(int Products_sizeID)
        {

            SqlCommand objCmd = new SqlCommand("ADM_DelProductsSize", objCon);
            objCmd.CommandType = CommandType.StoredProcedure;
            objCmd.Parameters.Add("@Products_sizeID", SqlDbType.Int).Value = Products_sizeID;
            objCon.Open();
            objCmd.ExecuteNonQuery();
            objCmd.Dispose();
            objCon.Close();

        }
        //Delte Products From all related tables [ADM_DelProducts]
        public void DAL_DeleteProducts(int ProductsID)
        {

            SqlCommand objCmd = new SqlCommand("ADM_DelProducts", objCon);
            objCmd.CommandType = CommandType.StoredProcedure;
            objCmd.Parameters.Add("@ProductsID", SqlDbType.Int).Value = ProductsID;
            objCon.Open();
            objCmd.ExecuteNonQuery();
            objCmd.Dispose();
            objCon.Close();

        }
        //////////////////////////////Colour///////////////////////////////

        public int DAL_InsUpdColour(Colour objBol)
        {
            SqlCommand objCmd = new SqlCommand("ADM_InsUpdColour", objCon);
            objCmd.CommandType = CommandType.StoredProcedure;
            objCmd.Parameters.Add("@ColourID", SqlDbType.Int).Value = objBol.ColourID;
            objCmd.Parameters.Add("@Colour_name", SqlDbType.NVarChar).Value = objBol.Colour_name;
            objCon.Open();
            int intRetval = Convert.ToInt32(objCmd.ExecuteScalar());
            objCmd.Dispose();
            objCon.Close();
            return intRetval;


        }
        public List Dal_DspColour()
        {
            SqlCommand objCmd = new SqlCommand("ADM_DspColour", objCon);
            objCmd.CommandType = CommandType.StoredProcedure;

            SqlDataReader objDr;
            objCon.Open();
            objDr = objCmd.ExecuteReader();
            List objList = new List();
            if (objDr.HasRows)
            {
                while (objDr.Read())
                {

                    Colour objBol = new Colour();
                    objBol.ColourID = Convert.ToInt32(objDr["ColourID"]);
                    objBol.Colour_name = objDr["Colour_name"].ToString();
                    objList.Add(objBol);
                }
            }
            objDr.Close();
            objCmd.Dispose();
            objCon.Close();
            return objList;
        }
        public void DAL_DeleteColour(int ColourID)
        {

            SqlCommand objCmd = new SqlCommand("ADM_DelColour", objCon);
            objCmd.CommandType = CommandType.StoredProcedure;
            objCmd.Parameters.Add("@ColourID", SqlDbType.Int).Value = ColourID;
            objCon.Open();
            objCmd.ExecuteNonQuery();
            objCmd.Dispose();
            objCon.Close();

        }

        ///////////////////////////////CLIENT SITE FUNCTIONS/////////////////////////////
        //To Display Rotate Products [Get_Products]
        public DataSet Dal_GetRotateProducts(int CategoryID)
        {
            SqlDataAdapter objadp = new SqlDataAdapter("Get_Products", objCon);
            objadp.SelectCommand.CommandType = CommandType.StoredProcedure;
            objadp.SelectCommand.Parameters.Add("@CategoryID", SqlDbType.Int).Value = CategoryID;
            DataSet objds = new DataSet();
            objadp.Fill(objds);
            return objds;
        }
        // To Display Products Detail [Get_ProductsDetail]
        public DataSet Dal_Get_ProductsDetail(int ProductsID)
        {
            SqlDataAdapter objadp = new SqlDataAdapter("Get_ProductsDetail", objCon);
            objadp.SelectCommand.CommandType = CommandType.StoredProcedure;
            objadp.SelectCommand.Parameters.Add("@ProductsID", SqlDbType.Int).Value = ProductsID;
            DataSet objds = new DataSet();
            objadp.Fill(objds);
            return objds;
        }
        //Display Products Size [Get_ProductsSize]
        public DataSet Dal_Get_ProductsSize(int ColourID,int ProductsID)
        {
            SqlDataAdapter objadp = new SqlDataAdapter("Get_ProductsSize", objCon);
            objadp.SelectCommand.CommandType = CommandType.StoredProcedure;
            objadp.SelectCommand.Parameters.Add("@ColourID", SqlDbType.Int).Value = ColourID;
            objadp.SelectCommand.Parameters.Add("@ProductsID", SqlDbType.Int).Value = ProductsID;
            DataSet objds = new DataSet();
            objadp.Fill(objds);
            return objds;
        }
        //Displya Products Colour [Get_ProductsColour]
        public DataSet Dal_Get_ProductsColour(int ProductsID)
        {
            SqlDataAdapter objadp = new SqlDataAdapter("Get_ProductsColour", objCon);
            objadp.SelectCommand.CommandType = CommandType.StoredProcedure;
            objadp.SelectCommand.Parameters.Add("@ProductsID", SqlDbType.Int).Value = ProductsID;
            
            DataSet objds = new DataSet();
            objadp.Fill(objds);
            return objds;
        }
    }
}

Posted by at No comments:
Labels:

24.7.10

Visual Studio shortcuts

http://msdn.microsoft.com/en-us/library/da5kh0wa%28VS.80%29.aspx
Posted by at No comments:

22.7.10

How to implement Custom paging Using ASP.NET Data Grid

How to implement Custom paging Using ASP.NET Data Grid

You have Inbuilt paging facility for some of the data binding control like data grid. But it can be very inefficient. Control like repeater you don’t have inbuilt data binding facility. When you are using inbuilt paging facility it loads all the rows so very resource consuming and inefficient. But when you are using custom paging facility you return only requested rows.

Here we will examine how can we implement custom paging for data Grid using stored procedure. Here is the implementation of stored procedure. Here you have 3 parameter for stored procedure.

@page is basically page number in data grid

@pageSize is Number of records you are going to show one page

@TotalNofRecords is output parameter. It return total Number of records in the Query

Here when you go through the stored procedure you have create a tempory table and you retrieve only required data rows from that tempory table. Using @StartRecordNo and @EndRecordNo

Create PROCEDURE [dbo].[GetEmployee]

(

@Page int,

@PageSize int,

@TotalNofRecords int output

)

AS

BEGIN

SET NOCOUNT ON

DECLARE @StartRecordNo int, @EndRecordNo int

IF (@Page=0)

BEGIN

SET @StartRecordNo = 1

SET @EndRecordNo = @PageSize

END

ELSE

BEGIN

SET @StartRecordNo = @PageSize * @Page + 1

SET @EndRecordNo = (@PageSize * (@Page+1) )

END

CREATE TABLE [#TmpEmployee]

(

[RowNo] int identity(1,1),

[EmployName] int not null,

[Address] varchar(255)

)

INSERT INTO [#TmpEmployee]([EmployName], [Address])

SELECT

FirstName, Address1

FROM Employee

ORDER BY FirstName

SELECT @TotalNofRecords = COUNT( FirstName) FROM [#TmpEmployee]

SET NOCOUNT OFF

SELECT [RowNo], [FirstName], [Address]

FROM [#TmpEmployee]

WHERE [RowNo]>= @StartRecordNo

AND [RowNo]<= @EndRecordNo

RETURN 0

END

When you bind the grid you can have method call BindGrid method

private void BindGrid(int pageNo)

{

try

{

int locationId ;

int recordsPerPage = 10 ;

int totalRecords = 0;

DataTable empList = EmpService.GetEmployee( pageNo, recordsPerPage ,ref totalRecords);

if (empList.Rows.Count > 0)

{

uxEmployeGrid.DataSource = jobsList;

uxEmployeGrid.VirtualItemCount = totalRecords;

uxEmployeGrid.DataBind();

}

}

catch(Exception ex)

{

throw ex;

}

}

When call the first time call the BindGrid Method with pageNo = 0

BindGrid(0);

When click the paging call the BindGrid method

protected void uxEmployeGrid_PageIndexChanged(object source, DataGridPageChangedEventArgs e)

{

uxEmployeGrid.CurrentPageIndex = e.NewPageIndex;

BindGrid(uxEmployeGrid.CurrentPageIndex);

}
Posted by at No comments:
Labels:

asynchronous

http://www.webopedia.com/TERM/A/asynchronous.html
http://forums.asp.net/p/753551/805432.aspx
Posted by at No comments:

21.7.10

Radcombo






Posted by at No comments:
Labels:

11.7.10

New mobile Technology--Android

http://www.android.com/
Posted by at No comments:

9.7.10

Best Walk in Jobs

http://bestwalkinjobs.com/
Posted by at No comments:

2.7.10

Free Sql server Training

http://www.sqlservervideos.com/

http://weblogs.asp.net/scottgu/archive/2007/03/01/free-sql-server-training-videos-and-other-good-data-tutorial-pointers.aspx

http://www.learnitfirst.com/Course/152/SQL-Server-2005-DBA/TheBigList.aspx
Posted by at No comments:

Forms Authentication and Roles in ASP.NET with C#: Advance

http://www.dotnetfunda.com/articles/article114.aspx

http://www.dotnetfunda.com/articles/article141.aspx

http://www.codeproject.com/KB/aspnet/custom_authentication.aspx
Posted by at No comments:

1.7.10

Authentication and Authorization in ASP.NET

http://aspalliance.com/907_Authentication_and_Authorization_in_ASPNET.1
Posted by at No comments:

WHY Jquery used over javascript

http://15daysofjquery.com/quicker/4/
Posted by at No comments:
Labels:
Subscribe to: Posts (Atom)