<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="SalesOrder.aspx.cs" Inherits="SalesOrder" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
<script type="text/javascript" language="javascript">
function GetTotal() {
var val1 = document.forms("form1")['txtq'].value;
alert("price");
alert(val1);
var val2 = document.forms("form1")['txtp'].value;
alert(val2);
if (val1 != "" && val2 != "") {
document.forms("form1")['txttotal'].value; = val1 * val2;
}
}
</script>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder3" Runat="Server">
<asp:Panel ID="Panel1" runat="server">
<br />
<asp:HyperLink ID="HyperLink12" runat="server" NavigateUrl="~/Customer.aspx">Customer Details</asp:HyperLink>
<br />
<br />
<br />
<asp:HyperLink ID="HyperLink13" runat="server" NavigateUrl="~/SalesOrder.aspx">Sales Order</asp:HyperLink>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
</asp:Panel>
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="ContentPlaceHolder2" Runat="Server">
<table>
<tr>
<td align="right">Customer ID</td>
<td>
<asp:DropDownList ID="ddlcid" runat="server" DataSourceID="SqlDataSource1"
DataTextField="Customer_Id" DataValueField="Customer_Id" AppendDataBoundItems="true">
<asp:ListItem>---select Customer id---</asp:ListItem>
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:sqlserverConnectionString %>"
SelectCommand="SELECT [Customer_Id] FROM [CustomerTable_]">
</asp:SqlDataSource>
</td>
</tr>
<tr>
<td align="right">Product Id</td>
<td>
<asp:DropDownList ID="ddlpid" runat="server" DataSourceID="SqlDataSource2"
DataTextField="Productcode" DataValueField="Productcode"
AppendDataBoundItems="true"
onselectedindexchanged="ddlpid_SelectedIndexChanged" AutoPostBack="True">
<asp:ListItem>---select Product Id---</asp:ListItem>
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:sqlserverConnectionString %>"
SelectCommand="SELECT [Productcode] FROM [Products]"></asp:SqlDataSource>
</td>
</tr>
<tr>
<td align="right">Price</td>
<td>
<asp:TextBox ID="txtp" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td align="right">Quantity</td>
<td>
<asp:TextBox ID="txtq" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"
ErrorMessage="*" ForeColor="Red" ControlToValidate="txtq"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td align="right">Total</td>
<td>
<asp:TextBox ID="txttotal" runat="server"></asp:TextBox>
<input type="button" name="total" value="add" onclick="javascript:GetTotal()" />
</td>
</tr>
<tr>
<td align="right">Date Of Delivery</td>
<td>
<asp:TextBox ID="txtdate" runat="server"></asp:TextBox>
<asp:Calendar ID="Calendar1"
runat="server" BackColor="White" BorderColor="#999999" CellPadding="4" BorderWidth="2px"
DayNameFormat="Shortest" Font-Names="Verdana" Font-Size="8pt" ForeColor="Black"
Height="180px" Width="200px"
onselectionchanged="Calendar1_SelectionChanged">
<DayHeaderStyle BackColor="#CCCCCC" Font-Bold="True" Font-Size="7pt" />
<NextPrevStyle VerticalAlign="Bottom" />
<OtherMonthDayStyle ForeColor="#808080" />
<SelectedDayStyle BackColor="#666666" Font-Bold="True" ForeColor="White" />
<SelectorStyle BackColor="#CCCCCC" />
<TitleStyle BackColor="#999999" BorderColor="Black" Font-Bold="True" />
<TodayDayStyle BackColor="#CCCCCC" ForeColor="Black" />
<WeekendDayStyle BackColor="#FFFFCC" />
</asp:Calendar>
</td>
</tr>
<tr>
<td colspan="2" align="center">
<asp:Button ID="btnsubmit" runat="server" Text="Submit"
onclick="btnsubmit_Click" />
</td>
</tr>
</table>
</asp:Content>
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 SalesOrder : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
// ScriptManager.RegisterClientScriptBlock(this,this.GetType(),"hi","GetTotal()",true);
}
protected void Calendar1_SelectionChanged(object sender, EventArgs e)
{
System.DateTime myDate = new System.DateTime();
myDate = Calendar1.SelectedDate;
txtdate.Text = myDate.ToString("dd/MM/yyyy");
}
protected void btnsubmit_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=CKRBTECH\\SQLEXPRESS;Initial Catalog=sqlserver;Integrated Security=True");
SqlCommand cmd = new SqlCommand("insert into Sales_Order(CustomerId,ProductId,Price,Quantity,Total,Date_Of_Deliver)values(@custid,@prodid,@price,@qty,@tot,@date) ", con);
cmd.Parameters.AddWithValue("@custid", ddlcid.SelectedItem.ToString());
cmd.Parameters.AddWithValue("@prodid", ddlpid.SelectedItem.ToString());
cmd.Parameters.AddWithValue("@price", txtp.Text.ToString());
cmd.Parameters.AddWithValue("@qty", txtq.Text.ToString());
cmd.Parameters.AddWithValue("@total", txttotal.Text.ToString());
cmd.Parameters.AddWithValue("@date", txtdate.Text.ToString());
con.Open();
cmd.ExecuteNonQuery();
con.Close();
Response.Write("data inserted successfully");
}
protected void ddlpid_SelectedIndexChanged(object sender, EventArgs e)
{
showdata(ddlpid.SelectedItem.Value);
}
private void showdata(string id)
{
DataTable dt = new DataTable();
SqlConnection con = new SqlConnection("Data Source=CKRBTECH\\SQLEXPRESS;Initial Catalog=sqlserver;Integrated Security=True");
SqlCommand cmd = new SqlCommand("select Price from Products where Productcode=@prodid", con);
cmd.Parameters.AddWithValue("@prodid", ddlpid.SelectedItem.Value);
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
if (dt.Rows.Count > 0)
{
txtp.Text = dt.Rows[0]["Price"].ToString();
}
con.Close();
}
}