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>
</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;
}
}
}
No comments:
Post a Comment