PurchaseOrder.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;using
System.Collections.Generic;///
<summary>///
Summary description for PurchaseOrder///
</summary>public
class PurchaseOrder{
#region
Constructor public PurchaseOrder(){
}
public PurchaseOrder(int purchaseordernumber, string companyname, string partnumber, string itemdescription, int quantity, string manufacturer, decimal targetprice, DateTime deliverydate){ }
#endregion
#region
Declarations public string testConnectionString = "Data Source=INBLRBOASQLSVR;Initial Catalog=test;Integrated Security=True"; public string SP_ADD_PURCHASEORDER = "SavePurchaseOrder"; public string SP_DELETE_PURCHASEORDER = "DeletePurchaseOrder"; public string SP_GET_ALL_PARTNUMBER_BY_PURCHASEORDER = "GetAllPartNumberByPurchaseOrder"; public string SP_UPDATE_PURCHASEORDER = "UpdatePurchaseOrder"; public string DeletePartNumber = "DeletePartNumber"; /* Private Variables Declaration */ private int _purchaseOrder; private string _companyName; private string _partNumber; private string _itemDescription; private int _quantity; private string _manufacturer; private decimal _targetPrice; private DateTime _deliveryDate;#endregion
#region
Propeties/* Properties */ public int PurchaseOrderNumber
{
get { return _purchaseOrder; } set { _purchaseOrder = value; }}
public string CompanyName{
get { return _companyName; } set { _companyName = value; }}
public string PartNumber{
get { return _partNumber; } set { _partNumber = value; }}
public string ItemDescription{
get { return _itemDescription; } set { _itemDescription = value; }}
public int Quantity{
get { return _quantity; } set { _quantity = value; }}
public string Manufacturer{
get {return _manufacturer; } set { _manufacturer = value; }}
public decimal TargetPrice{
get { return _targetPrice; } set { _targetPrice = value; }}
public DateTime DeliveryDate{
get { return _deliveryDate; } set { _deliveryDate = value; }}
#endregion
#region
Methods public void AddPurchaseOrder(PurchaseOrder pur){
try{
SqlConnection myConnection = new SqlConnection(testConnectionString); SqlCommand myCommand = new SqlCommand(SP_ADD_PURCHASEORDER, myConnection);myCommand.CommandType =
CommandType.StoredProcedure;myCommand.Parameters.AddWithValue(
"@PurchaseOrderNumber",pur.PurchaseOrderNumber);myCommand.Parameters.AddWithValue(
"@CompanyName", pur.CompanyName);myConnection.Open();
myCommand.ExecuteNonQuery();
myConnection.Close();
}
catch (Exception ex){
string st = ex.Message;}
}
public void UpdatePurchaseOrder(PurchaseOrder pur)
{
try{
SqlConnection myConnection = new SqlConnection(testConnectionString); SqlCommand myCommand = new SqlCommand(SP_UPDATE_PURCHASEORDER, myConnection);myCommand.CommandType =
CommandType.StoredProcedure;myCommand.Parameters.AddWithValue(
"@PurchaseOrderNumber", pur.PurchaseOrderNumber);myCommand.Parameters.AddWithValue(
"@PartNumber", pur.PartNumber);myConnection.Open();
myCommand.ExecuteNonQuery();
myConnection.Close();
}
catch (Exception ex){
string st = ex.Message;}
}
public void DeletePurchaseOrder(PurchaseOrder pur){
try{
SqlConnection myConnection = new SqlConnection(testConnectionString); SqlCommand myCommand = new SqlCommand(SP_DELETE_PURCHASEORDER, myConnection);myCommand.CommandType =
CommandType.StoredProcedure;myCommand.Parameters.AddWithValue(
"@PurchaseOrderNumber", pur.PurchaseOrderNumber);myCommand.Parameters.AddWithValue(
"@PartNumber", pur.PartNumber);myConnection.Open();
myCommand.ExecuteNonQuery();
myConnection.Close();
}
catch(Exception ex){
string st = ex.Message;}
}
public List<PurchaseOrder> GetAllPartNumberByPurchaseOrder(){
List<PurchaseOrder> partList = new List<PurchaseOrder>(); SqlConnection myConnection = new SqlConnection(testConnectionString); SqlCommand myCommand = new SqlCommand(SP_GET_ALL_PARTNUMBER_BY_PURCHASEORDER, myConnection);myConnection.Open();
SqlDataReader reader = myCommand.ExecuteReader(); while (reader.Read()){
PurchaseOrder purchaseorder = new PurchaseOrder((int)reader["PurchaseOrderNumber"], (string)reader["PartNumber"], (string)reader["ItemDescription"], (int)reader["Quantity"], (string)reader["Manufacturer"], (decimal)reader["TargetPrice"], (DateTime)reader["DeliveryDate"]);partList.Add(purchaseorder);
}
myConnection.Close();
reader.Close();
myCommand.Dispose();
if (partList != null && partList.Count > 0) return partList; else return null;}
#endregion
}
<%
@ Page Language="C#" AutoEventWireup="true" CodeFile="PurchaseOrder.aspx.cs" Inherits="PurchaseOrder" %><!
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>Untitled Page</title></
head><
body> <form id="form1" runat="server"> <div> <table> <tr> <td style="width:25%"><asp:Label ID="lblPurchaseOrderNumber" runat="server" Text="PurchaseOrderNumber"></asp:Label></td> <td style="width:25%"><asp:TextBox ID="txtPurchaseOrderNumber" runat="server"></asp:TextBox></td> <td style="width:25%"><asp:Label ID="lblCompanyName" runat="server" Text="Label"></asp:Label></td> <td style="width:25%"> <asp:DropDownList ID="drpCompanyName" runat="server"> <asp:ListItem Text="XXXXX & co" Value="1"></asp:ListItem> <asp:ListItem Text="YYYYY & co" Value="2"></asp:ListItem> <asp:ListItem Text="ZZZZZ & co" Value="3"></asp:ListItem> <asp:ListItem Text="AAAAA & co" Value="4"></asp:ListItem> <asp:ListItem Text="QQQQQ & co" Value="5"></asp:ListItem> </asp:DropDownList> </td> </tr> <tr> <td colspan="5"> <!-- Grid View --> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" OnRowEditing="GridView1_RowEditing" DataKeyNames="ID" OnRowUpdating="GridView1_RowUpdating" OnRowDeleting="GridView1_RowDeleting" ShowFooter="True" OnRowCommand="GridView1_RowCommand" DataSourceID="objUser"> <Columns> <asp:TemplateField HeaderText=""> <FooterTemplate>
Join the conversation! Your thoughts help the community grow.