Asptilsand Darshan

Home Pages
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="home.aspx.cs"

Inherits="shoping.home" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>TILS FASHION</title>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1"
/>
<link rel="stylesheet"
href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.
css" />
<script
src="https://ajax.googleapis.com/ajex/libs/jquery/3.5.1/jquery.min.js"><
/script>
<script
src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js
"></script>
<style>
footer{enquiry
background-color:#f2f2f2;
padding:25px;
}
.carousel-inner img{
width:100%;
min-height:200px;
@media(max-width:600px){
.carousel-caption{
display:none;
}
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div class="jumbotron text-center" style="margin-bottom:0;
background-color:#DD5E89">
<h1>TILS FASHION</h1>
<p> The Real Indian Online Shopping Site!</p>
</div>
<%--//manu--%>
<nav class="navbar navbar-inverse">
<div class="container-fluid">
<div class="navbar-header">
<button type="button" class="navbar-toggle" data-
toggle="collapse" data-target="#mynavbar">
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="home.aspx">TV
FASHION</a>
</div>
<div class="collapse navbar-collapse" id ="mynavbar">
<ul class="nav navbar-nav">
<li class="active"><a
href="home.aspx">HOME</a></li>
<li><a href="#">About</a></li>
<li><a href="#">contact</a></li>
<li><a href="#">blog</a></li>
<li><a href="#">product</a></li>
</ul>
<ul class="nav navbar-nav navbar-right">
<li><a href="Login1.aspx"><span class="glyphicon
glyphicon-log-in"></span>Login </a></li>
<li><a href="../Signup.aspx"><span
class="glyphicon glyphicon-log-in"></span>Signup </a></li>
</ul>
</div>
</div>
</nav>
<div class="container">
<div class="row">
<div class="col-sm-8">
<div id="myCarousel" class="carousel slide" data-
ride="carousel">

<ol class="carousel-indicators">
<li data-target="#myCarousel" data-slide-
to="0" class="active"></li>
to="1"></li>
to="2"></li>
</ol>

<div class="carousel-inner" role="listbox">

<div class="item active">
<img src="https://cdn.techjuice.pk/wp-
content/uploads/2019/07/online-shopping.jpg" alt="Image" />
<div class="carousel-caption">
<h3>
offer
</h3>
<p>
Clothes.
</p>
</div>
</div>
</div>
</div>
</div>
<div class="well">
<p>There are several benefits of online
shopping. Firstly, it is very convenient as you can shop from the
comfort of your own home. Secondly, it is very fast and you can find
what you are looking for quickly and easily. Thirdly, it is very cheap
as there are no middlemen involved.</p>
</div>
<div class="well">
<p>Online shopping is a form of electronic
commerce which allows consumers to directly buy goods or services from a
seller over the Internet using a web browser or a mobile app.</p>
</div>
<div class="well">
<p>So we decided to analyze the most common
types of online shoppers that your store is and has been getting all
this while.</p>
</div>
</div>
</div>
</div>
<div class="container text-center">

<h3>
product
</h3>
<hr/>
<div class="row">
<img
src="https://www.loveyourclothes.org.uk/sites/default/files/styles/respo
nsive/public/lyc-campaigns-website-header-1600.jpg?itok=DLdKu9UI"
class="img-responsive" style="width:100%" alt="Image" />
<p>Cloths Product</p>
</div>
<img src="https://5.imimg.com/data5/LJ/RP/MY-
4878239/stationery-500x500.png" class="img-responsive"
style="width:100%" alt="Image" />
<p>stationery</p>
</div>
<div class="well">
<p>Your product descriptions can make or break
a sale. Check out our product description template and examples to help
grow your sales.</p>
</div>
<div class="well">
<p> product description template and examples
to help grow your sales.</p>
</div>
</div>
<div class="well">
<p>It’s no accident that Patagonia finds
themselves on a list like this</p>
</div>
<div class="well">
<p>Let’s pick a product, any product. This
Linked Pack 28L will do</p>
</div>
</div>
</div>
<hr/>
</div>
<div class="container text-center">

<h3>OUR PARTNER</h3>
<br />
<div class="row">
<img
src="https://pbs.twimg.com/profile_images/1455185376876826625/s1AjSxph_4
00x400.jpg" class="img-responsive" style="width:100%" alt="Image" />
<p>google</p>
</div>
<img
src="https://avatars.githubusercontent.com/u/6154722?s=280&v=4"
class="img-responsive" style="width:100%" alt="Image" />
<p>microsoft</p>
</div>
<img
src="https://upload.wikimedia.org/wikipedia/en/thumb/0/04/Facebook_f_log
o_%282021%29.svg/1200px-Facebook_f_logo_%282021%29.svg.png" class="img-
responsive" style="width:100%" alt="Image" />
<p>facebook</p>
</div>
<img src="https://encrypted-
tbn0.gstatic.com/images?q=tbn:ANd9GcRcNedYcRf9XwAahtC0U1u_GiHMLAVKhKAxBg
&usqp=CAU" class="img-responsive" style="width:100%" alt="Image" />
<p>Toyota</p>
</div>
<img
src="https://upload.wikimedia.org/wikipedia/commons/thumb/3/3b/Coca-
Cola_Logo_%285174864992%29.jpg/1200px-Coca-
Cola_Logo_%285174864992%29.jpg" class="img-responsive"
style="width:100%" alt="Image" />
<p>coco cola</p>
</div>
<img
src="https://www.companyfolders.com/blog/media/2015/01/apple-
300x300.jpg" class="img-responsive" style="width:100%" alt="Image" />
<p>apple</p>
</div>
<hr />
</div>
</div>
<br/>
<footer class="container-fluid text-center jumbotron">
<p>Created by Tilak Vaghasiya</p>
</footer>
</form>
</body>
</html>
Signup [page]
<%@ Page Language="C#" AutoEventWireup="true"

CodeBehind="Signup.aspx.cs" Inherits="shoping.Signup" %>
<!DOCTYPE html>
<title>Signup</title>
/>
css" />
<script
/script>
<script
"></script>
<style>
footer{
padding:25px;
}
width:100%;
min-height:200px;
.carousel-caption{
display:none;
}
}
</style>
</head>
<body>
</div>
<%--//manu--%>
</button>
<a class="navbar-brand" href="Admin/home.aspx">TV
FASHION</a>
</div>
</ul>
<li><a href="login.aspx"><span class="glyphicon
glyphicon-log-in"></span>Login</a></li>
</ul>
</div>
</div>
</nav>
<div class="col-sm-3"></div>
<div class="panel panel-primary">
<div class="panel-heading">Signup</div>
<div class="panel-body">
<div class="row">
<div class="form-group">
<label> Name:</label>
<asp:TextBox ID="txtname"
CssClass="form-control" runat="server"></asp:TextBox>
</div>
<label> Surname:</label>
<asp:TextBox ID="txtSurname"
</div>
<label> Address:</label>
<asp:TextBox ID="txtAddress"
</div>
<label> City:</label>
<asp:TextBox ID="txtCity"
CssClass="form-control" runat="server" ></asp:TextBox>
</div>
<label> Pincode:</label>
<asp:TextBox ID="txtPincode"
CssClass="form-control" runat="server" TextMode="Number"></asp:TextBox>
</div>
<label> Mobile:</label>
<asp:TextBox ID="txtMobile"
CssClass="form-control" runat="server" TextMode="phone"></asp:TextBox>
</div>
<label>Email:</label>
<asp:TextBox ID="txtEmail"
CssClass="form-control" runat="server" TextMode="Email"></asp:TextBox>
</div>
<label>Password:</label>
<asp:TextBox ID="txtpass"
CssClass="form-control" runat="server"
TextMode="Password"></asp:TextBox>
</div>
<label>Creted Date:</label>
<asp:TextBox ID="txtDate"
CssClass="form-control" runat="server" TextMode="Date"></asp:TextBox>
</div>
<asp:Button ID="btnSignup"
CssClass="btn btn-success" runat="server" Text="Ragistration"
/>
<asp:Button ID="btncancel"
CssClass="btn btn-danger" runat="server" Text="Cancel" />
</div>
</div>
</div>
</div>
<div class="panel-footer"></div>
</div>
</div>
</div>
</div>

</footer>
</form>
</body>
</html>
User Login .aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="login.aspx.cs"

Inherits="shoping.login" %>
<!DOCTYPE html>
<title>LOGIN</title>
/>
css" />
<script
/script>
<script
"></script>
<style>
footer{
padding:25px;
}
width:100%;
min-height:200px;
.carousel-caption{
display:none;
}
}
</style>
</head>
<body>

</div>
<%--//manu--%>
</button>
<a class="navbar-brand" href="Admin/home.aspx">TV
FASHION</a>
</div>
href="Admin/home.aspx">HOME</a></li>
</ul>
<li><a href="Signup.aspx"><span class="glyphicon
glyphicon-log-in"></span>Signup</a></li>
</ul>
</div>
</div>
</nav>
<div class="panel-heading">Login</div>
<div class="row">
<label>User ID:</label>
<asp:TextBox ID="txtuserid"
</div>
</div>
<asp:Button ID="btnlogin"
CssClass="btn btn-success" runat="server" Text="Login" />
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>

</footer>
</form>
</body>
</html>
Admin Login .aspx
<%@ Page Language="C#" AutoEventWireup="true"

CodeBehind="Login1.aspx.cs" Inherits="shoping.Admin.Login1" %>
<!DOCTYPE html>
<title></title>
/>
css" />
<script
/script>
<script
"></script>
<style>
footer{
padding:25px;
}
width:100%;
min-height:200px;
.carousel-caption{
display:none;
}
}
</style>
</head>
<body>
<div class="jumbotron text-center" style="margin-bottom:0; ">
</div>
<%--//manu--%>
</button>
<a class="navbar-brand" href="home.aspx">TV
FASHION</a>
</div>
<%-- <li><a href="#">About</a></li>
<li><a href="#">product</a></li>--%>
</ul>
<%-- <li><a href="Signup.aspx"><span
class="glyphicon glyphicon-log-in"></span>Signup</a></li>--%>
</ul>
</div>
</div>
</nav>
<div class="panel-heading">Admin Login</div>
<div class="row">
<label>User Name:</label>
<asp:TextBox ID="txtuserid"
</div>
CssClass="form-control" runat="server"
TextMode="Password"></asp:TextBox>
</div>
<asp:Button ID="btnlogin"
CssClass="btn btn-success" runat="server" Text="Login"
/>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>

<p>Created by darshan mangukiya And Tilak vaghasiya</p>
</footer>
</form>
</body>
</html>
Admin Login.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;
using System.Configuration;
namespace shoping.Admin
{
public partial class Login1 : System.Web.UI.Page
{
SqlConnection con = new
SqlConnection(ConfigurationManager.ConnectionStrings["TVFashionCon"].Con
nectionString);
protected void Page_Load(object sender, EventArgs e)
{
Session.RemoveAll();
Session.Remove("UserName");
}
protected void btnlogin_Click(object sender, EventArgs e)

{
if(IsFormValid())
{
try
{
SqlCommand cmd = new SqlCommand("select
Username,Password from Adminst where Username=@Username And
Password=@Password", con);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.Parameters.AddWithValue("@UserName",
txtuserid.Text.Trim());
cmd.Parameters.AddWithValue("@Password",
txtpass.Text.Trim());
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while(dr.Read())
{
Session["UserName"] =
dr.GetValue(0).ToString();
Response.Write("<script>alert('Login
success');</script>");
Response.Redirect("home1.aspx");
}
}
else
{
Response.Write("<script>alert('Invalid Login
.... error');</script>");
//Response.Redirect("home.aspx");
txtuserid.Text = String.Empty;
txtpass.Text = String.Empty;
}
}
catch(Exception ex)
{
Response.Write("<script>alert('"+ex.Message+"');</script>");
}
}
else
{
}
}
private bool IsFormValid()
{
if(txtuserid.Text == String.Empty )
{
Response.Write("<script>alert('user name is
required');</script>");
txtuserid.Text = String.Empty;
txtuserid.Focus();
return false;
}
if (txtpass.Text == String.Empty)
{
Response.Write("<script>alert('Password is
required');</script>");
txtpass.Text = String.Empty;
txtpass.Focus();
return false;
}
return true;
}
}
}
Admin Home .aspx
<%@ Page Title="" Language="C#"

MasterPageFile="~/Admin/masterpage.Master" AutoEventWireup="true"
CodeBehind="home1.aspx.cs" Inherits="shoping.Admin.home1" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1"
runat="server">
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>

<p>Wellcome to Admin</p>
</asp:Content>
Admin Home .aspx.cs
using System;
using System.Linq;
using System.Web;
{
public partial class home1 : System.Web.UI.Page
{
{
if (Session["UserName"]!=null)
{
Label1.Text = Session["userName"].ToString();
}
}
}
}
Master page.Master
<%@ Master Language="C#" AutoEventWireup="true"

CodeBehind="masterpage.master.cs" Inherits="shoping.Admin.masterpage" %>
<!DOCTYPE html>
<html>
<title></title>
<meta chrset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<style>
* {
box-sizing: border-box;
body {
font-family: cursive, Helvetica, sans-serif;
}
header {
background-color: #666;
padding: 30px;
text-align: center;
color: white;
}
nav {
float: left;
width:20% ;
height: 300px;
background: #ccc;
padding: 20px;
}
nav ul {
list-style-type: none;
padding: 10px;
display: block;
}
nav ul li:hover {
background-color: seagreen;
color: white;
padding: 11px;
}
artical {
float: left;
padding: 20px;
width: 80%;
background-color: #f1f1f1;
height: 300px;
}
section::after {
content: "";
display: table;
clear: both;
}
footer {
background-color:springgreen;
padding: 10px;
text-align: center;
color: white;
}
@media(max-width:600px) {
nav, article {
width: 100%;
height: auto;
}
}
</style>
<asp:ContentPlaceHolder ID="head" runat="server">

</asp:ContentPlaceHolder>
</head>
<body>
<header><h2>Tils Fashion </h2></header>

<section>
<nav>
<ul>
<li><a href="addcategory.aspx">category</a></li>
<li><a href="Additem.aspx">Item</a></li>
<li><a href="AddQuantity.aspx">Quantity</a></li>
<li><a href="#">Order</a></li>
<li><a href="#">View payment</a></li>
<li><a href="Report.aspx">Reports</a></li>
<li><a href="#">change password</a></li>
<li><a href="#">Feedback</a></li>
<li><a href="#">Logout</a></li>
</ul>
</nav>
<article>
<asp:ContentPlaceHolder ID="ContentPlaceHolder1"
runat="server">
</asp:ContentPlaceHolder>
</article>
</section>
<footer>
<p>Created by Darshan Mangukiya And Tilak vaghasiya</p>
</footer>
</form>
</body>
</html>
Add Category.aspx

CodeBehind="addcategory.aspx.cs" Inherits="shoping.Admin.addcategory" %>
<title>Add Category</title>
/>
css" />
<script
/script>
<script
"></script>
</asp:Content>
runat="server">
<div class="row">
<label>Add Category</label>
<asp:TextBox ID="txtCategory" CssClass="form-
control" runat="server"></asp:TextBox>
<br />
<asp:Button ID="btnAdd" CssClass="btn btn-success
btn-lg" runat="server" Text="ADD" />
</div>
<asp:GridView ID="GridView1" CssClass="table
table-hover" runat="server" AutoGenerateColumns="False"
DataKeyNames="CID" DataSourceID="SqlDataSource1" AllowPaging="True">
<Columns>
<asp:CommandField ShowEditButton="True"
ShowDeleteButton="True"></asp:CommandField>
<asp:BoundField DataField="CID"
HeaderText="CID" ReadOnly="True" InsertVisible="False"
SortExpression="CID"></asp:BoundField>
<asp:BoundField DataField="CName"
HeaderText="CName" SortExpression="CName"></asp:BoundField>
</Columns>
<HeaderStyle BackColor="Yellow"
ForeColor="Black"/>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1"
runat="server" ConnectionString='<%$ ConnectionStrings:TVFashionCon %>'
DeleteCommand="DELETE FROM [CateMst] WHERE [CID] = @CID"
InsertCommand="INSERT INTO [CateMst] ([CName]) VALUES (@CName)"
SelectCommand="SELECT * FROM [CateMst]" UpdateCommand="UPDATE [CateMst]
SET [CName] = @CName WHERE [CID] = @CID">
<DeleteParameters>
<asp:Parameter Name="CID"
Type="Int32"></asp:Parameter>
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="CName"
Type="String"></asp:Parameter>
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="CID"
</UpdateParameters>
</asp:SqlDataSource>
</div>
</div>
</div>
</div>
</div>
</div>
</asp:Content>
Add Category.aspx.cs
using System;
using System.Linq;
using System.Web;
using System.Data;
{
public partial class addcategory : System.Web.UI.Page
{
SqlConnection(ConfigurationManager.ConnectionStrings["TVFashionCon"].Con
nectionString);
{
{
if(!IsPostBack)
{
//BindingGridview();
}
}
else
{
Response.Redirect("Login1.aspx");
}
}
protected void btnAdd_Click(object sender, EventArgs e)

{
SqlCommand cmd = new SqlCommand(" insert into CateMst(CName)
values(@CName)", con);
if(con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.Parameters.AddWithValue("@CName",txtCategory.Text.Trim());
cmd.ExecuteNonQuery();
con.Close();
Response.Write("<script>alert('ADD Succefully');</script>");
/* BindingGridview()*/
txtCategory.Text = string.Empty;
txtCategory.Focus();
}
private void BindingGridview()

{
SqlCommand cmd = new SqlCommand(" select * from CateMst",
con);
{
con.Open();
}
SqlDataAdapter da=new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
con.Close();
if (dt.Rows.Count>0)
{
GridView1.DataSource = dt;
GridView1.DataBind();
}
else
{
GridView1.DataSource = null;
}
}
}
}
Additem.aspx

CodeBehind="Additem.aspx.cs" Inherits="shoping.Admin.Additem" %>
<title>Add Item</title>

/>
css" />
<script
/script>
<script
"></script>
</asp:Content>
runat="server">
<div class="row">
<label>Item Name</label>
<asp:TextBox ID="txtitemName" CssClass="form-control"
runat="server"></asp:TextBox>
</div>
<label>Description</label>
<asp:TextBox ID="txtDesc" CssClass="form-control"
</div>
<label>price</label>
<asp:TextBox ID="txtPrice" CssClass="form-control"
</div>
<label>Quantity</label>
<asp:TextBox ID="txtQty" CssClass="form-control"
</div>
<label>Image</label>
<asp:FileUpload ID="FileUpload1" CssClass="form-
control" runat="server" />
</div>
<label>Image 1</label>
<asp:FileUpload ID="FileUpload2" CssClass="form-
control" runat="server" />
</div>
<label>Image 2</label>
<asp:FileUpload ID="FileUpload3" CssClass="form-control"
runat="server" />
</div>
<label>Size</label>
<asp:DropDownList ID="ddlsize" CssClass="form-control"
runat="server">
<asp:ListItem text="Select Option"
value="0"></asp:ListItem>
<asp:ListItem text=" small" value="1"></asp:ListItem>
<asp:ListItem text=" large" value="2"></asp:ListItem>
<asp:ListItem text=" Smaller"
<asp:ListItem text=" xLarge"
<asp:ListItem text=" XXLarge"
<asp:ListItem text=" 01" value="6"></asp:ListItem>

</asp:DropDownList>
</div>
<label>Category</label>
<asp:DropDownList ID="ddlCategory" CssClass="form-
control" runat="server"></asp:DropDownList>
</div>
<asp:Button ID="btnAdItem" CssClass="btn btn-success
btn-lg" runat="server" Text="ADD Item" />
</div>
</div>
</div>
<div class="row">
<div class="table">
<asp:GridView ID="GridView1" runat="server"
AutoGenerateColumns="False" DataKeyNames="IID"
DataSourceID="SqlDataSource1" AllowPaging="True">
<Columns>
<asp:CommandField ShowEditButton="True"
ShowDeleteButton="True"></asp:CommandField>
<asp:BoundField DataField="IID"
HeaderText="IID" ReadOnly="True" InsertVisible="False"
SortExpression="IID"></asp:BoundField>
<asp:BoundField DataField="IName"
HeaderText="IName" SortExpression="IName"></asp:BoundField>
<asp:BoundField DataField="Detail"
HeaderText="Detail" SortExpression="Detail"></asp:BoundField>
<asp:BoundField DataField="Price"
HeaderText="Price" SortExpression="Price"></asp:BoundField>
<asp:BoundField DataField="Image"
HeaderText="Image" SortExpression="Image"></asp:BoundField>
<asp:BoundField DataField="Qnt"
HeaderText="Qnt" SortExpression="Qnt"></asp:BoundField>
<asp:BoundField DataField="CName"
HeaderText="CName" SortExpression="CName"></asp:BoundField>
<asp:BoundField DataField="Image1"
HeaderText="Image1" SortExpression="Image1"></asp:BoundField>
<asp:BoundField DataField="Image2"
HeaderText="Image2" SortExpression="Image2"></asp:BoundField>
<asp:BoundField DataField="Size"
HeaderText="Size" SortExpression="Size"></asp:BoundField>
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"

ConnectionString='<%$ ConnectionStrings:TVFashionCon %>'
DeleteCommand="DELETE FROM [ItemMt] WHERE [IID] = @IID"
InsertCommand="INSERT INTO [ItemMt] ([IName], [Detail], [Price],
[Image], [Qnt], [CName], [Image1], [Image2], [Size]) VALUES (@IName,
@Detail, @Price, @Image, @Qnt, @CName, @Image1, @Image2, @Size)"
SelectCommand="SELECT [IID], [IName], [Detail], [Price], [Image], [Qnt],
[CName], [Image1], [Image2], [Size] FROM [ItemMt]" UpdateCommand="UPDATE
[ItemMt] SET [IName] = @IName, [Detail] = @Detail, [Price] = @Price,
[Image] = @Image, [Qnt] = @Qnt, [CName] = @CName, [Image1] = @Image1,
[Image2] = @Image2, [Size] = @Size WHERE [IID] = @IID"
> <DeleteParameters>
<asp:Parameter Name="IID"
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="IName"
<asp:Parameter Name="Detail"
<asp:Parameter Name="Price"
Type="Double"></asp:Parameter>
<asp:Parameter Name="Image"
<asp:Parameter Name="Qnt"
<asp:Parameter Name="Image1"
<asp:Parameter Name="Size"
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="IName"
<asp:Parameter Name="Detail"
<asp:Parameter Name="Price"
Type="Double"></asp:Parameter>
<asp:Parameter Name="Image"
<asp:Parameter Name="Qnt"
<asp:Parameter Name="Size"
<asp:Parameter Name="IID"
</UpdateParameters>
</asp:SqlDataSource>
</div>
</div>
</div>
</asp:Content>
Additem.aspx.cs
using System;
using System.Linq;
using System.Web;
using System.Data;
using System.IO;
using System.Text;
{
public partial class Additem : System.Web.UI.Page
{

{
{
if (!IsPostBack)
{
BindCategory();
}
}
else
{
}
}
private string GetConnectionString()
{
return
System.Configuration.ConfigurationManager.ConnectionStrings["TVFashionCo
n"].ConnectionString;
}
protected void btnAdItem_Click(object sender, EventArgs e)

{
if (IsFormValidate())
{
FileUpload1.SaveAs(Server.MapPath("img") +
FileUpload1.FileName);
SqlConnection con =new

SqlConnection(GetConnectionString());
SqlCommand cmd = new SqlCommand(" insert into
ItemMt(IName,Detail,Price,Image,Qnt,CName,Image1,Image2,Size)
values(@IName,@Detail,@Price,@Image,@Qnt,@CName,@Image1,@Image2,@Size)",
con);
{
con.Open();
}
cmd.Parameters.AddWithValue("@IName",txtitemName.Text );
cmd.Parameters.AddWithValue("@Detail",txtDesc.Text );
cmd.Parameters.AddWithValue("@Price",Convert.ToDouble(txtPrice.Text) );
cmd.Parameters.AddWithValue("@Image",FileUpload1.FileName );
cmd.Parameters.AddWithValue("@Qnt",Convert.ToInt32(txtQty.Text) );
cmd.Parameters.AddWithValue("@CName",
ddlCategory.SelectedItem.Text);
cmd.Parameters.AddWithValue("@Image1",
cmd.Parameters.AddWithValue("@Image2",
cmd.Parameters.AddWithValue("@Size",
ddlsize.SelectedValue);
con.Close();
Response.Write("<script>alert(' Item add
successfully');</script>");
else
{
Response.Write("<script>alert('Validation
error');</script>");
}
}
private bool IsFormValidate()

{
if (txtitemName.Text==String.Empty)
{
Response.Write("<script>alert('item is
Required');</script>");
txtitemName.Text = string.Empty;
txtitemName.Focus();
return false;
}
if (txtDesc.Text == string.Empty)
{
Response.Write("<script>alert('Description is
txtDesc.Text = string.Empty;
txtDesc.Focus();
return false;
}
if (txtPrice.Text == string.Empty)
{
Response.Write("<script>alert('price is
txtPrice.Text = string.Empty;
txtPrice.Focus();
return false;
}
if (txtQty.Text == string.Empty)
{
Response.Write("<script>alert('Quantity is
txtQty.Text = string.Empty;
txtQty.Focus();
return false;
}
if (ddlCategory.SelectedItem.Text=="")
{
Response.Write("<script>alert('Category is
ddlCategory.Focus();
return false;
}
if (ddlsize.SelectedIndex == -1)
{
Response.Write("<script>alert('size is
ddlsize.Focus();
return false;
}
return true;
}
private void BindCategory()

{
SqlCommand cmd = new SqlCommand("select distinct CID, CName

from CateMst", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
if(dt.Rows.Count>0)
{
ddlCategory.DataSource = dt;
ddlCategory.DataTextField = "CID";
ddlCategory.DataTextField = "CName";
ddlCategory.DataBind();
}
else
{
ddlCategory.DataSource = null;
}
}
protected void SqlDataSource1_Selecting(object sender,

SqlDataSourceSelectingEventArgs e)
{
}
}
}
Add Quantity.aspx

CodeBehind="AddQuantity.aspx.cs" Inherits="shoping.Admin.AddQuantity" %>
<title>Add Quantity</title>
</asp:Content>
runat="server">
<br />
<div class="row">
<label>Item Name:</label>
<asp:DropDownList ID="ddlItemName" CssClass="form-
control" runat="server"></asp:DropDownList>
</div>
</div>
<label>Qty:</label>
<asp:TextBox ID="txtQty" CssClass="from-control"
</div>
</div>
<p></p>
<asp:Button ID="btnAddQty" CssClass="btn btn-success"
runat="server" Text="ADD" />
<p></p>
</div>
<div class="row">
<div class="table table-responsive">
<asp:GridView ID="GridView1" Caption="Add Quantity
Record" CssClass="table" runat="server"></asp:GridView>
</div>
</div>
</div>
</div>
</asp:Content>
Add Quantity.aspx.cs
using System;
using System.Linq;
using System.Web;
using System.Data;
{
public partial class AddQuantity : System.Web.UI.Page
{
{
if (Session["UserName"] != null)
{
if (!IsPostBack)
{
BindItemName();
BindGridView();
}
}
else
{
}

{
return
}
private void BindItemName()
{
SqlCommand cmd = new SqlCommand("select distinct IID,IName
from ItemMt", con);
da.Fill(dt);
if (dt.Rows.Count > 0)
{
ddlItemName.DataSource = dt;
ddlItemName.DataTextField = "IID";
ddlItemName.DataTextField = "IName";
ddlItemName.DataBind();
}
else
{
ddlItemName.DataSource = null;
ddlItemName.DataBind();
}
}
protected void btnAddQty_Click(object sender, EventArgs e)

{
SqlCommand cmd = new SqlCommand("update ItemMt set
Qnt=Qnt+@Qnt where INAme=@ID", con);
{
con.Open();
}
cmd.Parameters.AddWithValue("@Qnt", Convert.ToInt32(
txtQty.Text));
cmd.Parameters.AddWithValue("@ID",ddlItemName.SelectedValue);
con.Close();
txtQty.Text = String.Empty;
Response.Write("<script> alert('ADD Success')</script>");
BindGridView();
}
private void BindGridView()
{
{
con.Open();
}
SqlCommand cmd = new SqlCommand("select IName,ISNULL(Qnt, 0)
as Qnt from ItemMt", con);
da.Fill(dt);
con.Close();
{
GridView1.DataSource= dt;
}
else
{
}
}
}
}
Report.aspx

CodeBehind="Report.aspx.cs" Inherits="shoping.Admin.Report" %>
<title>Product Report</title>
</asp:Content>
runat="server">

<div class="panel-heading">All Product Report</div>
<div class="row">
<label>Select Category</label>
<asp:DropDownList ID="ddlCategory"
CssClass="form-control" runat="server"></asp:DropDownList>
</div>
<asp:Button ID="btnSearch" CssClass="btn btn-
info" runat="server" Text="Search" />
</div>
</div>
<div class="row">
<asp:GridView ID="GridView1" CssClass="table"
runat="server" EmptyDataText="*Record not Found...." EmptyDataRowStyle-
ForeColor="Red">
</asp:GridView>
</div>
</div>
</div>
</div>
</div>
using System;
using System.Linq;
using System.Web;
using System.Data;
using System.IO;
{
public partial class Report : System.Web.UI.Page
{
{
{
if (!IsPostBack)
{
BindCategory();
}
}
else
{
}
}
{
return
}
{
{
con.Open();
}
da.Fill(dt);
con.Close();
{
}
else
{
}
}
{
{
con.Open();
}
Image,IName,Price,Size,Qnt from ItemMt where CName=@CName", con);
cmd.Parameters.AddWithValue("@CName",ddlCategory.SelectedItem.Text);
da.Fill(dt);
con.Close();
{
}
else
{
}
}
protected void btnSearch_Click(object sender, EventArgs e)

{
BindGridView();
}
}
}
</asp:Content>
Report.aspx.cs
using System;
using System.Linq;
using System.Web;
using System.Data;
using System.IO;
{
public partial class Report : System.Web.UI.Page
{
{
{
if (!IsPostBack)
{
BindCategory();
}
}
else
{
}
}
{
return
}
{
{
con.Open();
}
da.Fill(dt);
con.Close();
{
}
else
{
}
}
{
{
con.Open();
}
Image,IName,Price,Size,Qnt from ItemMt where CName=@CName", con);
cmd.Parameters.AddWithValue("@CName",ddlCategory.SelectedItem.Text);
da.Fill(dt);
con.Close();
{
}
else
{
}
}
protected void btnSearch_Click(object sender, EventArgs e)

{
BindGridView();
}
}
}

Asptilsand Darshan

Uploaded by

Copyright:

Available Formats

Asptilsand Darshan

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Asptilsand Darshan

Uploaded by

Copyright:

Available Formats

Home Pages

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="home.aspx.cs"

<div class="carousel-inner" role="listbox">

<div class="container text-center">

<div class="container text-center">

<%@ Page Language="C#" AutoEventWireup="true"

<footer class="container-fluid text-center jumbotron">

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="login.aspx.cs"

<div class="jumbotron text-center" style="margin-bottom:0;

<footer class="container-fluid text-center jumbotron">

<%@ Page Language="C#" AutoEventWireup="true"

<footer class="container-fluid text-center jumbotron">

protected void btnlogin_Click(object sender, EventArgs e)

<%@ Page Title="" Language="C#"

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

<%@ Master Language="C#" AutoEventWireup="true"

<asp:ContentPlaceHolder ID="head" runat="server">

<header><h2>Tils Fashion </h2></header>

<%@ Page Title="" Language="C#"

protected void btnAdd_Click(object sender, EventArgs e)

private void BindingGridview()

<%@ Page Title="" Language="C#"

<meta charset="utf-8" />

<asp:ListItem text=" 01" value="6"></asp:ListItem>

<asp:SqlDataSource ID="SqlDataSource1" runat="server"

protected void Page_Load(object sender, EventArgs e)

protected void btnAdItem_Click(object sender, EventArgs e)

SqlConnection con =new

private bool IsFormValidate()

private void BindCategory()

SqlCommand cmd = new SqlCommand("select distinct CID, CName

protected void SqlDataSource1_Selecting(object sender,

<%@ Page Title="" Language="C#"

private string GetConnectionString()

protected void btnAddQty_Click(object sender, EventArgs e)

<%@ Page Title="" Language="C#"

<div class="panel panel-primary">

protected void btnSearch_Click(object sender, EventArgs e)

protected void btnSearch_Click(object sender, EventArgs e)

You might also like