Vijubook'S: November 2013

Wednesday, 27 November 2013

list using Session C# in asp.net

list using Session :

Class Create :

public class CartList

{

public int quantity;

public string Name;

public decimal amount;

public int ID;

public string ImageURL;

public string Price;

}

Using C# Page :

List<CartList> objCartList;

protected void btn_Click(object sender, EventArgs e)

{

/* Create Cart List */

bool isNew = true;

if ((Session["Cart"] == null))

objCartList = new List<CartList>();

else

objCartList = (List<CartList>)Session["cart"];

/* ID already Checked.alredy ProductID to Add list Update amount and Quantity */

for (int i = 0; i < objCartList.Count; i++)

{

if (objCartList[i].ID == Convert.ToInt16(lblID.Text.ToString()))

{

// objCartList.Remove(objCartList[i]);

objCartList[i].amount = objCartList[i].amount +

Convert.ToDecimal(lblPrice.Text);

objCartList[i].quantity = objCartList[i].quantity + 1;

isNew = false;

break;

}

/* Insert New List */

if (isNew)

{

CartList cartList = new CartList();

cartList.ID = Convert.ToInt16(lblID.Text);

cartList.Name = lblName.Text;

cartList.amount = Convert.ToDecimal(lblPrice.Text);

cartList.quantity = 1;

cartList.ImageURL = Image1.ImageUrl.ToString();

cartList.Price = lblPrice.Text;

objCartList.Add(cartList);

// objCartList.Sort();

}

Session["Cart"] = objCartList;

string[] arrID = new string[20];

for (int i = 0; i < objCartList.Count; i++)

{

arrID[i] =Convert.ToInt16(objCartList[i].quantity).ToString();

bb += Convert.ToInt16(arrID[i]);

}

string cc = bb.ToString();

Session["ItemCount"] = cc.ToString();

}

another C# Page :

aspx:

<asp:Repeater ID="rptProductList" runat="server" OnItemCommand="rptProductList_ItemCommand" >

<HeaderTemplate>

<table>

<asp:Label ID="lbl" Text="ProductName" runat="server"> </asp:Label>

</td>

<asp:Label ID="Label1" Text="Price" runat="server"> </asp:Label>

</td>

<asp:Label ID="Label2" Text="Quantity" runat="server"> </asp:Label>

</td>

<asp:Label ID="Label3" Text="Total Price" runat="server"> </asp:Label>

</td>

</td>

</tr>

</HeaderTemplate>

<ItemTemplate>

<div>

<tr>

<asp:Image ID="Image1" runat="server" Height="125px" Width="125px" />

</td>

<asp:Label ID="lblName" runat="server"></asp:Label>

</td>

<asp:Label ID="lblPrice" runat="server"></asp:Label>

</td>

<asp:TextBox ID="txtQuantity" Width="50px" MaxLength="3" runat="server"></asp:TextBox>

--Update Column

<asp:LinkButton ID="lnkUpdate" runat="server" Text="Update" CommandName="UpdateColumn">

</asp:LinkButton>

</td>

<asp:Label ID="lblQuantity" runat="server"></asp:Label>

</td>

<asp:LinkButton ID="lnkDelete" runat="server" Text="X"

CommandName="DeleteColumn">

</asp:LinkButton>

<asp:Label ID="lblID" runat="server"></asp:Label>

</td>

</tr>

</ItemTemplate>

<FooterTemplate>

</table>

</div>

</FooterTemplate>

</asp:Repeater>

aspx:cs

List<CartList> objCartList;

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

/* Session Cart Using List */

objCartList = (List<CartList>)Session["cart"];

View();

}

public void View()

{

string[] arrID = new string[20];

int Count;

if (objCartList.Count != 0)

{

/* Repeater Cintrol Fill using Session Cart */

foreach (RepeaterItem rpt in rptProductList.Items)

{

Label lbl = (Label)rpt.FindControl("lblQuantity");

Label lblPri = (Label)rpt.FindControl("lblPrice");

Label lblID = (Label)rpt.FindControl("lblID");

TextBox txtQuantity = (TextBox)rpt.FindControl("txtQuantity");

Label lblName = (Label)rpt.FindControl("lblName");

Image img = (Image)rpt.FindControl("Image1");

LinkButton lnkUpda = (LinkButton)rpt.FindControl("lnkUpdate");

LinkButton lnkDel = (LinkButton)rpt.FindControl("lnkDelete");

lnkUpda.CommandArgument=

objCartList[rpt.ItemIndex].ID.ToString();

lnkDel.CommandArgument =

objCartList[rpt.ItemIndex].ID.ToString();

img.ImageUrl =

objCartList[rpt.ItemIndex].ImageURL.ToString();

lbl.Text =

objCartList[rpt.ItemIndex].amount.ToString();

lblPri.Text =

objCartList[rpt.ItemIndex].Price.ToString();

txtQuantity.Text =

objCartList[rpt.ItemIndex].quantity.ToString();

lblName.Text =

objCartList[rpt.ItemIndex].Name.ToString();

}

else

{

lblCartNotselected.Text = "You Selected Not Cart";

Session["ItemCount"] = "0";

}

/* Repeater Command Using Update Delete CartList Row */

protected void rptProductList_ItemCommand(object source, RepeaterCommandEventArgs e)

{

// btn.Attributes.Add("onclick", "if

//( ! confirm( 'Delete this record?' )) return false; ");

if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)

{

--DeleteColumn

if (e.CommandName == "DeleteColumn")

{

bjCartList = (List<CartList>)Session["cart"];

UpdateID = e.CommandArgument.ToString();

TextBox txtQuantity = (TextBox)e.Item.FindControl("txtQuantity");

for (int i = 0; i < objCartList.Count; i++)

{

if (objCartList[i].ID == Convert.ToInt16(UpdateID))

{

--Remove

objCartList.Remove(objCartList[i]);

break;

}

View();

string[] arrID = new string[20];

for (int i = 0; i < objCartList.Count; i++)

{

arrID[i] =

Convert.ToInt16(objCartList[i].quantity).ToString();

bb += Convert.ToInt16(arrID[i]);

}

string cc = bb.ToString();

Session["ItemCount"] = cc.ToString();

}

--UpdateColumn

if (e.CommandName == "UpdateColumn")

{

objCartList = (List<CartList>)Session["cart"];

UpdateID = e.CommandArgument.ToString();

TextBox txtQuantity = (TextBox)e.Item.FindControl("txtQuantity");

Label lblPri = (Label)e.Item.FindControl("lblPrice");

for (int i = 0; i < objCartList.Count; i++)

{

if (objCartList[i].ID == Convert.ToInt16(UpdateID))

{

--Update

int aa = Convert.ToInt16(txtQuantity.Text);

int bb = Convert.ToInt16(lblPri.Text);

objCartList[i].quantity = aa;

objCartList[i].amount = aa * bb;

break;

}

View();

string[] arrID = new string[20];

for (int i = 0; i < objCartList.Count; i++)

{

arrID[i] = Convert.ToInt16(objCartList[i].quantity).ToString();

bb += Convert.ToInt16(arrID[i]);

}

string cc = bb.ToString();

Session["ItemCount"] = cc.ToString();

}

Monday, 18 November 2013

shopping cart using Session Arraylist and dataset in asp.net Update,Delete

shopping cart using Session Arraylist and dataset in asp.net Update,Delete :

Using Session and DataSet :

http://vijubook.blogspot.in/2013/11/shopping-cart-using-session-arraylist.html

aspx:

-- CSS

.tblTD {

width:200px;

font-size:15px;

text-align:center;

color:white;

}

</style>

<asp:Repeater ID="rptProductList" runat="server"

OnItemDataBound="rptProductList_ItemDataBound"

OnItemCommand="rptProductList_ItemCommand" >

<HeaderTemplate>

<table>

<asp:Label ID="lbl" Text="ProductName"

runat="server"> </asp:Label>

</td>

<asp:Label ID="Label1" Text="Price" runat="server"> </asp:Label>

</td>

<asp:Label ID="Label2" Text="Qty" runat="server"> </asp:Label>

</td>

</td>

</td>

</tr>

</HeaderTemplate>

<ItemTemplate>

<div>

<tr>

<asp:Image ID="Image1" runat="server"

ImageUrl='<%#"Handler1.ashx?id="+ Eval("ID")%>'

Height="125px" Width="125px" />

</td>

<asp:Label ID="lblName" runat="server"

Text='<%#Eval("pro") %>'></asp:Label>

</td>

<asp:Label ID="lblPrice" Text='<%#Eval("sp")%>'

runat="server"></asp:Label>

</td>

<asp:Label ID="lblQuantity" runat="server"></asp:Label>

</td>

<asp:TextBox ID="txtQuantity" Width="50px" runat="server">

</asp:TextBox>

--LinkButton Update CommandName,Command Argument

<asp:LinkButton ID="lnkUpdate" runat="server"

Text="Update" CommandArgument='<%#Eval("ID") %>' CommandName="UpdateColumn">

</asp:LinkButton>

</td>

--LinkButton Delete CommandName,Command Argument

<asp:LinkButton ID="lnkDelete" runat="server" Text="X"

CommandArgument='<%#Eval("ID") %>'

CommandName="DeleteColumn">

</asp:LinkButton>

<asp:Label ID="lblID" runat="server"></asp:Label>

</td>

</tr>

</ItemTemplate>

<FooterTemplate>

</table>

</div>

</FooterTemplate>

</asp:Repeater>

aspx:CS :

using System;

using System.Collections;

using System.Collections.Generic;

using System.Configuration;

using System.Data;

using System.Data.SqlClient;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

namespace project

{

public partial class Cart : System.Web.UI.Page

{

SqlConnection cn = new

SqlConnection(ConfigurationManager.AppSettings["Connection"]);

SqlDataAdapter da = new SqlDataAdapter();

System.Collections.ArrayList myArrayList = new ArrayList();

DataSet ds = new DataSet();

string aa;

string DeleteID, UpdateID,UpdateValue;

int bb=0;

protected void Page_Load(object sender, EventArgs e)

{

http://vijubook.blogspot.in/2013/11/shopping-cart-using-session-arraylist.html

if (!IsPostBack)

{

ds = (DataSet)Session["CartDS"];

View();

}

public void View()

{

string[] arrID = new string[20];

int Count;

if (Session["CartDS"] != null)

{

if (ds.Tables[0].Rows.Count != 0)

{

for (int i = 0; i < ds.Tables[0].Rows.Count; i++)

{

arrID[i] = ds.Tables[0].Rows[i]["ID"].ToString() + ",";

aa += arrID[i];

}

aa = aa.Trim(',');

string Select;

Select = "Select * From tbl_product where ID in (" + aa + ")";

da = new SqlDataAdapter(Select, cn);

DataSet ds1 = new DataSet();

da.Fill(ds1);

rptProductList.DataSource = ds1;

rptProductList.DataBind();

--Quantity Add

foreach (RepeaterItem rpt in rptProductList.Items)

{

Label lbl = (Label)rpt.FindControl("lblQuantity");

Label lblID = (Label)rpt.FindControl("lblID");

TextBox txtQuantity =

(TextBox)rpt.FindControl("txtQuantity");

lbl.Text = ds.Tables[0].Rows[rpt.ItemIndex]

["items"].ToString();

lblID.Text = ds.Tables[0].Rows[rpt.ItemIndex]

["ID"].ToString();

txtQuantity.Text = ds.Tables[0].Rows[rpt.ItemIndex

["items"].ToString();

}

for (int i = 0; i < ds.Tables[0].Rows.Count; i++)

{

arrID[i] = ds.Tables[0].Rows[i]["items"].ToString();

bb += Convert.ToInt16(arrID[i]);

}

string cc = bb.ToString();

string Cou = ds1.Tables[0].Rows.Count.ToString();

Session["ItemCount"] = cc.ToString();

}

else

{

lblCartNotselected.Text = "You Selected Not Cart";

Session["ItemCount"] = "0";

}

else

{

Session["ItemCount"] = "0";

lblCartNotselected.Text = "You Selected Not Cart ! !";

}

--Repeater Control ItemCommand

protected void rptProductList_ItemCommand(object source,

RepeaterCommandEventArgs e)

{

if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)

{

--Delete LinkButton CommandName and CommandArgument Passing

if (e.CommandName == "DeleteColumn")

{

Label lblQuantity = (Label)e.Item.FindControl("lblQuantity");

string aa = lblQuantity.Text;

DeleteID = e.CommandArgument.ToString();

ds = (DataSet)Session["CartDS"];

DataTable dt1 = new DataTable();

dt1 = ds.Tables[0];

foreach (DataRow dr in ds.Tables[0].Rows)

{

if (dr["id"].ToString() == DeleteID)

{

--Delete

dr.Delete();

ds.Tables[0].AcceptChanges();

break;

}

// ds.Tables[0].AcceptChanges();

}

View();

Response.Redirect("Cart.aspx");

}

--Update LinkButton CommandName and CommandArgument Passing

if (e.CommandName == "UpdateColumn")

{

UpdateID = e.CommandArgument.ToString();

TextBox txtQuantity=

(TextBox)e.Item.FindControl("txtQuantity");

ds = (DataSet)Session["CartDS"];

for (int i = 0; i < ds.Tables[0].Rows.Count; i++)

{

if (ds.Tables[0].Rows[i]["id"].ToString() == UpdateID)

{

--Update

ds.Tables[0].Rows[i]["items"] = txtQuantity.Text;

ds.Tables[0].AcceptChanges();

break;

}

View();

}

Friday, 15 November 2013

shopping cart using Session Arraylist and dataset in asp.net

shopping cart using Session Arraylist and dataset in asp.net :

BuyNow Button Click :

aspx:CS :

public class CartRow

{

public string ID;

public string Name;

public string Count;

};

public class CartList

{

public System.Collections.ArrayList list = new ArrayList(20);

};

CartList objCartList = new CartList();

- - Button Click

protected void btn_Click(object sender, EventArgs e)

{

if ((Session["Cart"] == null))

{

Session["Cart"] = objCartList;

}

else

{

objCartList = (CartList)(Session["cart"]);

}

string S_ID = lblID.Text;

CartRow objCartrow = new CartRow();

CartRow objTestCartRow = new CartRow();

objCartrow.ID = S_ID;

objCartrow.Name = lblName.Text;

objCartrow.Count = "1";

int listCount = objCartList.list.Count;

for (int i = 0; i < listCount; i++)

{

objTestCartRow = (CartRow)objCartList.list[i];

if (objTestCartRow.ID == S_ID)

{

int nItems =Int32.Parse(objTestCartRow.Count.ToString());

nItems += 1;

objTestCartRow.Count = nItems.ToString();

objCartList.list.RemoveAt(i);

objCartrow = objTestCartRow; ;

break;

}

objCartList.list.Add(objCartrow);

- -Array List Convert To DataSet

DataSet ds1 = new DataSet();

ds1 = bind();

-- Session Value DataSet

Session["CartDS"] = ds1;

-- Item Count

string[] arrID = new string[20];

for (int i = 0; i < ds1.Tables[0].Rows.Count; i++)

{

arrID[i] = ds1.Tables[0].Rows[i]["items"].ToString();

bb += Convert.ToInt16(arrID[i]);

}

string cc = bb.ToString();

string Cou = ds1.Tables[0].Rows.Count.ToString();

Session["ItemCount"] = cc.ToString();

}

--Array List Convert to Dataset

public DataSet bind()

{

DataSet ds = new DataSet();

DataTable dt = new DataTable();

ds.Tables.Add(dt);

ds.Tables[0].Columns.Add("id",

System.Type.GetType("System.Object"));

ds.Tables[0].Columns.Add("items",

System.Type.GetType("System.Object"));

foreach (object obj in objCartList.list)

{

for (int i = 0; i < objCartList.list.Count; i++)

{

CartRow ca = new CartRow();

DataRow rows = ds.Tables[0].NewRow();

rows[0] = ((CartRow)objCartList.list[i]).ID;

rows[1] = ((CartRow)objCartList.list[i]).Count;

ds.Tables[0].Rows.Add(rows);

}

break;

}

return ds;

}

--Use to another Page :

protected void Page_Load(object sender, EventArgs e)

{

--- Session

ds = (DataSet)Session["CartDS"];

}

Sunday, 10 November 2013

menu submenu using Database in asp.net

menu submenu using Database in asp.net :

aspx :

.MenuUL {

list-style: none;

padding: 0px;

margin: 0px;

}

.MenuUL li {

display: block;

position: relative;

float: left;

border: 1px solid #000;

}

li ul {

display: none;

}

ul li a {

display: block;

background: #000;

padding: 5px 10px 5px 10px;

text-decoration: none;

white-space: nowrap;

color: #fff;

}

ul li a:hover {

background: #f00;

}

li:hover ul {

display: block;

position: absolute;

}

li:hover li {

float: none;

}

li:hover a {

background: #f00;

}

li:hover li a:hover {

background: #000;

}

#drop-nav li ul li {

border-top: 0px;

}

</style>

<div>

// Repeater Control :

<asp:Repeater ID="rptMenu" runat="server"

OnItemCommand="rpt_ItemCommand"

OnItemDataBound="rpt_ItemDataBound">

<li>

<asp:Label ID="lblMenu1" CssClass="lblMenu"

runat="server" Text='<%#Eval("Menu") %>'>

</asp:Label>

</a>

<ul>

// Repeater Control SubMenu :

<asp:Repeater ID="rptSub" runat="server">

<li>

<asp:Label ID="lblSubMenu1" CssClass="lblMenu" runat="server" Text='<%#Eval("SubMenu") %>'>

</asp:Label>

</a>

</li>

</ItemTemplate>

</asp:Repeater>

</ul>

</li>

</ItemTemplate>

</asp:Repeater>

</ul>

</div>

aspx:cs:

SqlConnection objConn = new

SqlConnection(ConfigurationManager.AppSettings["Connection"]);

SqlDataAdapter objDa = new SqlDataAdapter();

protected void Page_Load(object sender, EventArgs e)

{

ViewMenu();

}

public void ViewMenu()

{

string Select;

Select = "SELECT * FROM Menu ORDER BY ID Desc; SELECT * FROM

SubMenu SM INNER JOIN Menu M ON M.ID=SM.SubMenuID ";

objDa = new SqlDataAdapter(Select, objConn);

objDa.Fill(ds);

ds.Relations.Add(new DataRelation("Menu",

ds.Tables[0].Columns["ID"],

ds.Tables[1].Columns["SubMenuID"]));

rptMenu.DataSource = ds.Tables[0];

rptMenu.DataBind();

}

protected void rptMenu_ItemCommand(object source,

RepeaterCommandEventArgs e)

{

Repeater rptSubMenu = e.Item.FindControl("rptSubMenu")

as Repeater;

rptSubMenu.DataSource = ds.Tables[1];

rptSubMenu.DataBind();

}

protected void rpt_ItemCommand(object source,

RepeaterCommandEventArgs e)

{

}

protected void rpt_ItemDataBound(object sender,

RepeaterItemEventArgs e)

{

DataRowView drv = e.Item.DataItem as DataRowView;

Repeater rptSubMenu = e.Item.FindControl("rptSub") as Repeater;

rptSubMenu .DataSource = drv.CreateChildView("Menu");

rptSubMenu .DataBind();

}

Wednesday, 6 November 2013

asp.net chart control

asp.net chart control :

* Add Refrence

System.Data.DataVisualization

aspx :

<%@ Register assembly="System.Web.DataVisualization, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"

namespace="System.Web.UI.DataVisualization.Charting" tagprefix="AChart" %>

<div>

<AChart:Chart ID="ChartID" runat="server" Width="345px" >

<series>

<AChart:Series Name="Series1" ChartType="Pie">

</AChart:Series>

</series>

<AChart:ChartArea Name="ChartArea1">

</AChart:ChartArea>

</chartareas>

</AChart:Chart>

</div>

aspx.cs :

Add Namespace :

using System.Web.UI.DataVisualization;

using System.Web.UI.DataVisualization.Charting;

SqlConnection objConn = new

SqlConnection(ConfigurationManager.AppSettings["Connection"]);

SqlDataAdapter objDa = new SqlDataAdapter();

string Select;

Select = "Select Act_ID,Act_Name,Act_salary From Actor";

objDa = new SqlDataAdapter(Select, objConn);

DataSet ds = new DataSet();

objDa.Fill(ds);

ChartID.DataSource = ds;

ChartID.Legends.Add("Actor").Title = "Student Sample";

ChartID.Series["Series1"].XValueMember = "Act_Name";

--Column Name

ChartID.Series["Series1"].YValueMembers = "Act_salary";

--Column Name

ChartID.DataBind();

----------------------------------------------

-----------------------------------------------