SUJOY SANTRA

DESIGN.ASPX

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.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>Product Registration</title>

//Page validations start
<script language="javascript" type="text/javascript">
function validate() {
if (document.getElementById("<%=txtprid.ClientID%>").value == "") {
alert("Product id Field can not be blank");
document.getElementById("<%=txtprid.ClientID%>").focus();
return false;
}
if (document.getElementById("<%=txtprname.ClientID %>").value == "") {
alert("Product name can not be blank");
document.getElementById("<%=txtprname.ClientID %>").focus();
return false;
}
if (document.getElementById("<%=txtprprice.ClientID %>").value == "") {
alert("product price can not be blank");
document.getElementById("<%=txtprprice.ClientID %>").focus();
return false;
}
if (document.getElementById("<%=txtprdesc.ClientID %>").value == "") {
alert("product description can not be blank");
document.getElementById("<%=txtprdesc.ClientID %>").focus();
return false;
}
return true;
}
</script>
//Page validations end

</head>
<body style="text-align: left">
<form id="form1" runat="server">
<div>
<div style="text-align: center">
<br /><br />

<table align="center" border="1" style="height: 221px; width: 401px">

<tr>
<td style="text-align: center; font-size: x-large;" colspan="2">
PRODUCT ENTRY
</td>
</tr>

<tr>
<td style="text-align: left">
Product ID:-
</td>
<td style="width: 100px">
<asp:TextBox ID="txtprid" runat="server" Width="200px" autocomplete="off"></asp:TextBox>
</td>
</tr>

<tr>
<td style="text-align: left" class="style1">
Product Name:-
</td>
<td style="width: 100px">
<asp:TextBox ID="txtprname" runat="server" Width="200px" autocomplete="off"></asp:TextBox>
</td>
</tr>

<tr>
<td style="text-align: left">
Product Type:-
</td>
<td style="width: 100px">
<asp:DropDownList ID="ddprtype" runat="server" Width="200px">
<asp:ListItem Selected="True">Shampoo</asp:ListItem>
<asp:ListItem>Soap</asp:ListItem>
<asp:ListItem>Spray</asp:ListItem>
</asp:DropDownList>
</td>
</tr>

<tr>
<td style="text-align: left">
Verification:-
</td>
<td align="left">
<asp:RadioButton ID="RadioButton1" runat="server" GroupName="ver" Text="Yes" />
   
<asp:RadioButton ID="RadioButton2" runat="server" GroupName="ver" Text="No" />
</td>
</tr>

<tr>
<td style="text-align: left" class="style2">
Description:-
</td>
<td>
<asp:TextBox ID="txtprdesc" runat="server" TextMode="MultiLine" Width="200px"
autocomplete="off"></asp:TextBox>
</td>
</tr>

<tr>
<td style="text-align: left">
Price:-
</td>
<td>
<asp:TextBox ID="txtprprice" runat="server" Width="200px" autocomplete="off"></asp:TextBox>
</td>
</tr>

<tr>
<td colspan="2" style="text-align: center">
<asp:Button ID="btnsave" runat="server" Font-Bold="True" OnClientClick=" return validate()"
Text="SAVE" onclick="btnsave_Click" />
</td>
</tr>

<tr>
<td colspan="2" style="text-align: center">
<asp:Label ID="Label1" runat="server" Font-Bold="True" Text="Label"
Visible="False"></asp:Label>
</td>
</tr>

</table>
</div>
</div>
</form>
</body>
</html>

PROPERTYPRODUCT CLASS:-

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

/// <summary>
/// Summary description for PROPERTYEMP
/// </summary>
public class PROPERTYPRODUCT
{
public int prid;
public string prname;
public string prtype;
public string prver;
public string prdesc;
public int prprice;
}

BUSINESSPRODUCT CLASS:-

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

/// <summary>
/// Summary description for BUSINESSEMP
/// </summary>
public class BUSINESSPRODUCT
{
public void intersave(PROPERTYPRODUCT p1)
{
DATAPRODUCT d1 = new DATAPRODUCT();
d1.insertdata(p1);
}

}

DATAPRODUCT CLASS:-

using System;

using System.Data;

using System.Configuration;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

/// <summary>

/// Summary description for DATAEMP

/// </summary>

public class DATAPRODUCT

{

public void exesql(SqlCommand cmd, string proc)

{

SqlConnection cn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True");

//SqlConnection cn=new SqlConnection=("Connection String");

cn.Open();

cmd.Connection = cn;

cmd.CommandType = CommandType.StoredProcedure;

cmd.CommandText = proc;

cmd.ExecuteNonQuery();

}

public void insertdata(PROPERTYPRODUCT p1)

{

SqlCommand cmd = new SqlCommand();

cmd.Parameters.AddWithValue("@pid", p1.prid);

cmd.Parameters.AddWithValue("@pname", p1.prname);

cmd.Parameters.AddWithValue("@ptype", p1.prtype);

cmd.Parameters.AddWithValue("@pver", p1.prver);

cmd.Parameters.AddWithValue("@pdesc", p1.prdesc);

cmd.Parameters.AddWithValue("@pprice", p1.prprice);

exesql(cmd, "insertproduct");

}

DESIGN.ASPX.CS

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
btnsave.Attributes.Add("onclick", "return validate()");
incr();
}
protected void Button1_Click(object sender, EventArgs e)
{

}
protected void btnsave_Click(object sender, EventArgs e)
{
PROPERTYPRODUCT p1 = new PROPERTYPRODUCT();

p1.prid = Convert.ToInt32(txtprid.Text);
p1.prname = txtprname.Text;
p1.prtype = ddprtype.SelectedItem.Text;
if (RadioButton1.Checked == true)
{
p1.prver = RadioButton1.Text;
}
else
{
p1.prver = RadioButton2.Text;
}
p1.prdesc = txtprdesc.Text;
p1.prprice = Convert.ToInt32(txtprprice.Text);

BUSINESSPRODUCT b1 = new BUSINESSPRODUCT();
b1.intersave(p1);

Label1.Visible = true;
Label1.Text = "Data Stored";

cleartext();

}
private void cleartext()
{
txtprid.Text = "";
txtprname.Text = "";
txtprdesc.Text = "";
txtprprice.Text = "";
txtprid.Focus();
incr();
}
private void incr()
{
int a;
SqlConnection cn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True");
if (txtprid.Text == "")
{
cn.Open();
string sqlstr = "select * from product";
SqlDataAdapter sda = new SqlDataAdapter(sqlstr, cn);
DataSet dst = new DataSet();
sda.Fill(dst);
if (dst.Tables[0].Rows.Count != 0)
{
a = dst.Tables[0].Rows.Count;
a = a + 1;
txtprid.Text = Convert.ToString(a);
txtprname.Focus();
}
else
{
txtprid.Text = "1";
txtprname.Focus();
}
cn.Close();
}
}
}

SUJOY SANTRA

Thursday 3 September 2015

3 Tier

DATAPRODUCT CLASS:-

DESIGN.ASPX.CS

Popular Posts