Asp.Net Ado.Net, C#.Net,Javascript Jquery Entity Framework,Ajax,MVC..! Happy coding..! :)

Every Question..What does it mean? Why is this? How it works?
Microsoft .Net (pronounced dot (.) net) may be a package element that runs on the Windows software package. .Net provides tools and libraries that change developers to form Windows package a lot of quicker and easier. Microsoft describes it as:".Net is that the Microsoft internet Service strategy to attach data, people, system and devices through software".I'm Choulla Naresh..!

Showing posts with label Datalist Grid Cart using Sessions. Show all posts

Monday, June 16, 2014

Datalist Grid Cart using Sessions

ASPX.... Laps.aspx

---------------
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="laps.aspx.cs" Inherits="_Default" %>

<!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></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:DataList ID="dllap" runat="server" BackColor="LightGoldenrodYellow"
BorderColor="Tan" BorderWidth="1px" CellPadding="2" ForeColor="Black">
<AlternatingItemStyle BackColor="PaleGoldenrod" />
<FooterStyle BackColor="Tan" />
<HeaderStyle BackColor="Tan" Font-Bold="True" />
<ItemTemplate>
<table>
<tr>
<td>
<asp:CheckBox ID="chklap" runat="server" />
</td>
<asp:Label ID="lbllapid" runat="server" Text='<%#bind("lapid") %>' Visible="false"></asp:Label>
<td>
<asp:Label ID="lbllapname" runat="server" Text='<%#bind("lapname") %>'></asp:Label>
</td>
<td>
<asp:Image ID="lapimg" runat="server" ImageUrl='<%#bind("lapimg") %>' Height="100px" />
</td>
<td>
<asp:Label ID="lbllapprice" runat="server" Text='<%#bind("lapprice") %>'></asp:Label>
</td>

</tr>
</table>
</ItemTemplate>
<SelectedItemStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite" />
</asp:DataList>
<asp:Button ID="btnok" runat="server" Text="ok" OnClick="btnok_Click" />
<asp:Button ID="btnlogout" runat="server" Text="logout"
onclick="btnlogout_Click" />
</div>
</form>
</body>
</html>

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

laps.ASPX.CS

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

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

{

Class1 obj = new Class1();

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

//Label lbll=(Label)dl.FindControl("lbllapid");

dllap.DataSource = obj.totaaps();

dllap.DataBind();

//Session.Clear();

}

protected void btnok_Click(object sender, EventArgs e)

{

foreach (DataListItem dll in dllap.Items)

{

//finding the control in container.

CheckBox chk = (CheckBox)dll.FindControl("chklap");

if (chk.Checked)

{

Label lbll = (Label)dll.FindControl("lbllapid");

Label lblitemname = (Label)dll.FindControl("lbllapname");

Image lblimg = (Image)dll.FindControl("lapimg");

Label lblprice = (Label)dll.FindControl("lbllapprice");

//DataSet ds = obj.nnn(Convert.ToInt32(lbll.Text));

DataTable dt = new DataTable();

dt.Columns.Add("lapid", typeof(string));

dt.Columns.Add("lapname", typeof(string));

dt.Columns.Add("lapimg", typeof(string));

dt.Columns.Add("lapprice", typeof(string));

dt.Columns.Add("txtqty", typeof(string));

dt.Columns.Add("txtlaptotal", typeof(string));

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

{

dt.Rows.Add(lbll.Text,lblitemname.Text, lblimg.ImageUrl,lblprice.Text,"","");

Session["dt"] = dt;

}

else

{

DataTable dttt = (DataTable)Session["dt"];

dttt.Rows.Add(lbll.Text, lblitemname.Text, lblimg.ImageUrl, lblprice.Text,"","");

Session["dt"] = dttt;

}

//foreach (DataListItem dl in dllap.Items)

//{

// CheckBox chk = (CheckBox)dl.FindControl("chklap");

// if (chk.Checked)

// {

// Label lbl_id = (Label)dl.FindControl("lbllapid");

// Label lbl_name = (Label)dl.FindControl("lbllapname");

// Image img = (Image)dl.FindControl("lapimg");

// Label lbl_price = (Label)dl.FindControl("lbllapprice");

// dt.Rows.Add(lbl_id.Text, lbl_name.Text, img.ImageUrl, lbl_price.Text);

// }

// Session["lapid"] = dt;

//}

Response.Redirect("selectedlap.aspx");

}

protected void btnlogout_Click(object sender, EventArgs e)

{

Session.Clear();

}

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

Selected ASPX

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="selectedlap.aspx.cs" Inherits="selectedlap" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

</head>

<body>

<div>

<asp:Button ID="btnlogout" runat="server" Text="Logout" onclick="btnlogout_Click" />

<asp:GridView ID="gridlap" runat="server" AutoGenerateColumns="False"

OnSelectedIndexChanged="txtqtyChange" BackColor="#DEBA84" BorderColor="#DEBA84"

BorderStyle="None" BorderWidth="1px" CellPadding="3" CellSpacing="2">

<asp:TemplateField HeaderText="id">

<asp:Label ID="lbllapid" runat="server" Text='<%#bind("lapid") %>'></asp:Label></ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="name">

<asp:Label ID="lbllapname" runat="server" Text='<%#bind("lapname") %>'></asp:Label></ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="image" ControlStyle-Height="50px" ControlStyle-Width="50px">

<asp:Image ID="lapimg" runat="server" ImageUrl='<%#bind("lapimg") %>' />

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="quantity">

<asp:TextBox ID="txtqty" runat="server" Text='<%#Bind("txtqty") %>' OnTextChanged="txtqtyChange" AutoPostBack="true"></asp:TextBox></ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="price">

<asp:Label ID="lbllapprice" runat="server" Text='<% #bind("lapprice")%>'></asp:Label></ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="total">

<asp:TextBox ID="txtlaptotal" runat="server" Text='<%#Bind("txtlaptotal") %>'></asp:TextBox>

</ItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

total:

<asp:TextBox ID="totaltxt" runat="server"></asp:TextBox>

<asp:Button ID="btnbacklap" runat="server" Text="back"

OnClick="btnbacklap_Click" style="height: 26px" />

</div>

</form>

</body>

</html>

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

selected.aspx.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using System.Data.SqlClient;

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

{

Class1 obj1 = new Class1();

int total = 0;

DataTable dt2;

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

DataTable dtr = (DataTable)Session["dt"];

gridlap.DataSource = dtr;

gridlap.DataBind();

}

public void txtqtyChange(object sender, EventArgs e)

{

foreach (GridViewRow gd in gridlap.Rows)

{

TextBox txttotal = (TextBox)gd.FindControl("txtlaptotal");

TextBox txt = (TextBox)gd.FindControl("txtqty");

Label lbl = (Label)gd.FindControl("lbllapprice");

if (txt.Text == string.Empty)

{

}

else

{

txttotal.Text = Convert.ToString(Convert.ToInt32(txt.Text) * Convert.ToDecimal(lbl.Text));

total += Convert.ToInt32(txttotal.Text);

}

totaltxt.Text = total.ToString();

}

protected void btnbacklap_Click(object sender, EventArgs e)

{

Session.Clear();

foreach (GridViewRow objrow in gridlap.Rows)

{

Label lblid = (Label)objrow.FindControl("lbllapid");

Label lbname = (Label)objrow.FindControl("lbllapname");

Image img = (Image)objrow.FindControl("lapimg");

TextBox txtqtyy = (TextBox)objrow.FindControl("txtqty");

Label lblprice = (Label)objrow.FindControl("lbllapprice");

TextBox txttotl = (TextBox)objrow.FindControl("txtlaptotal");

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

{

DataTable dt1 = (DataTable)Session["dt"];

dt1.Rows.Add(lblid.Text, lbname.Text, img.ImageUrl, lblprice.Text,txtqtyy.Text, txttotl.Text);

Session["dt"] = dt1;

}

else

{

DataTable dt = new DataTable();

dt.Columns.Add("lapid", typeof(string));

dt.Columns.Add("lapname", typeof(string));

dt.Columns.Add("lapimg", typeof(string));

dt.Columns.Add("lapprice", typeof(string));

dt.Columns.Add("txtqty", typeof(string));

dt.Columns.Add("txtlaptotal", typeof(string));

dt.Rows.Add(lblid.Text, lbname.Text, img.ImageUrl, lblprice.Text, txtqtyy.Text, txttotl.Text);

Session["dt"] = dt;

}

Response.Redirect("laps.aspx");

}

// Response.Redirect("laps.aspx");

protected void btnlogout_Click(object sender, EventArgs e)

{

Session.Clear();

}

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

.Class.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

/// <summary>
/// Summary description for Class1
/// </summary>
public class Class1
{
public string cn = ConfigurationManager.ConnectionStrings["con"].ToString();
SqlConnection con;
SqlCommand cmd;
SqlDataAdapter da;
DataSet ds;
public Class1()
{
//
// TODO: Add constructor logic here
//
}
public DataSet totaaps()
{
con = new SqlConnection(cn);
cmd = new SqlCommand("select * from lap", con);
da = new SqlDataAdapter(cmd);
ds = new DataSet();
da.Fill(ds);
return ds;
}
public DataSet nnn(int lapid)
{
con = new SqlConnection(cn);
cmd = new SqlCommand("select * from lap where lapid='"+lapid+"'", con);
da = new SqlDataAdapter(cmd);
ds = new DataSet();
da.Fill(ds);
return ds;
}
}
---------------------------------------------------------------------------------------------------