3_INVOICINGAPPLICATIONWITHACLASS\INVOICING\INVOICE.CS
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
namespace Invoicing
{
public class clsInvoice
{
private string _InvoiceReference;
private string _InvoiceComments;
private DateTime _InvoiceDate;
private string _ProductName;
private string _ProductDescription;
private int _Qty;
private double _Amount;
private double _PaidAmount;
private double _TaxAmount;
private string _CustomerName;
private string _CustomerAddress;
private int _UnitCost;
public string InvoiceReference
{
set
{
if (value.Length == 0)
{
throw new Exception("Invoice number is compulsory");
}
_InvoiceReference = value;
}
get
{
return _InvoiceReference;
}
}
public string InvoiceComments
{
set
{
_InvoiceComments = value;
}
get
{
return _InvoiceComments;
}
}
public DateTime InvoiceDate
{
set
{
_InvoiceDate = value;
}
get
{
return _InvoiceDate;
}
}
public string ProductName
{
set
{
if (value.Length == 0)
{
throw new Exception("Product name is compulsory");
}
_ProductName = value;
}
get
{
return _ProductName;
}
}
public string ProductDescription
{
set
{
_ProductDescription = value;
}
get
{
return _ProductDescription;
}
}
public int Quantity
{
set
{
if (value < 1)
{
throw new Exception("Quantity should be numeric");
}
_Qty = value;
}
get
{
return _Qty;
}
}
public double Amount
{
set
{
_Amount = value;
}
get
{
return _Amount;
}
}
public double PaidAmount
{
set
{
_PaidAmount = value;
}
get
{
return _PaidAmount;
}
}
public double TaxAmount
{
set
{
_TaxAmount = value;
}
get
{
return _TaxAmount;
}
}
public string CustomerName
{
set
{
if (value.Length == 0)
{
throw new Exception("Customer Name is compulsory");
}
_CustomerName = value;
}
get
{
return _CustomerName;
}
}
public string CustomerAddress
{
set
{
_CustomerAddress = value;
}
get
{
return _CustomerAddress;
}
}
public int UnitCost
{
set
{
if (value == 0)
{
throw new Exception("Unit cost is compulsory");
}
_UnitCost = value;
}
get
{
return _UnitCost;
}
}
public void Insert()
{
SqlConnection ObjConnection = new SqlConnection();
ObjConnection.ConnectionString = ConfigurationSettings.AppSettings["ConnectionString"];
ObjConnection.Open();
SqlCommand objCommand = new SqlCommand();
objCommand.Connection = ObjConnection;
objCommand.CommandText = "Insert into invoice(InvoiceReference,InvoiceComments,InvoiceDate,ProductName,Description,Qty,Amount,TaxAmount,PaidAmount,CustomerName,CustomerAddress,UnitCost) values('" + _InvoiceReference + "','" + _InvoiceComments + "','" + _InvoiceDate + "','" + _ProductName + "','" + _ProductDescription + "'," + _Qty.ToString() + "," + _Amount.ToString() + "," + _TaxAmount.ToString() + "," + _PaidAmount.ToString() + ",'" + _CustomerName + "','" + _CustomerAddress + "'," + _UnitCost.ToString() + ")";
objCommand.ExecuteNonQuery();
ObjConnection.Close();
}
public void Update()
{
SqlConnection ObjConnection = new SqlConnection();
ObjConnection.ConnectionString = ConfigurationSettings.AppSettings["ConnectionString"];
ObjConnection.Open();
SqlCommand objCommand = new SqlCommand();
objCommand.Connection = ObjConnection;
objCommand.CommandText = "update invoice set InvoiceComments='" + _InvoiceComments + "',InvoiceDate='" + _InvoiceDate + "',ProductName='" + _ProductName + "',Description='" + _ProductDescription + "',Qty=" + _Qty.ToString() + ",Amount=" + _Amount + ",TaxAmount=" + _TaxAmount + ",PaidAmount=" + _PaidAmount + ",CustomerName='" + _CustomerName + "',CustomerAddress='" + _CustomerAddress + "',UnitCost=" + _UnitCost + "where InvoiceReference='" + _InvoiceReference + "'";
objCommand.ExecuteNonQuery();
}
public void Delete()
{
SqlConnection ObjConnection = new SqlConnection();
ObjConnection.ConnectionString = ConfigurationSettings.AppSettings["ConnectionString"];
ObjConnection.Open();
SqlCommand objCommand = new SqlCommand();
objCommand.Connection = ObjConnection;
objCommand.CommandText = "delete from invoice where InvoiceReference='" + _InvoiceReference + "'";
objCommand.ExecuteNonQuery();
}
public DataSet getInvoice()
{
SqlConnection ObjConnection = new SqlConnection();
ObjConnection.ConnectionString = ConfigurationSettings.AppSettings["ConnectionString"];
ObjConnection.Open();
DataSet objdataset = new DataSet();
SqlDataAdapter objDataAdapter = new SqlDataAdapter("Select * from invoice", ObjConnection);
objDataAdapter.Fill(objdataset);
ObjConnection.Close();
return objdataset;
}
public void LoadInvoice(string InvoiceNumber)
{
SqlConnection ObjConnection = new SqlConnection();
ObjConnection.ConnectionString = ConfigurationSettings.AppSettings["ConnectionString"];
ObjConnection.Open();
DataSet objdataset = new DataSet();
SqlDataAdapter objDataAdapter = new SqlDataAdapter("Select * from invoice where InvoiceReference='" + InvoiceNumber + "'", ObjConnection);
objDataAdapter.Fill(objdataset);
_CustomerName = objdataset.Tables[0].Rows[0]["Customername"].ToString();
_CustomerAddress = objdataset.Tables[0].Rows[0]["CustomerAddress"].ToString();
_Amount = Convert.ToInt16(objdataset.Tables[0].Rows[0]["Amount"]);
_PaidAmount = Convert.ToDouble(objdataset.Tables[0].Rows[0]["PaidAmount"]);
_InvoiceDate = Convert.ToDateTime(objdataset.Tables[0].Rows[0]["InvoiceDate"]);
_InvoiceComments = objdataset.Tables[0].Rows[0]["InvoiceComments"].ToString();
_InvoiceReference = objdataset.Tables[0].Rows[0]["InvoiceReference"].ToString();
_ProductName = objdataset.Tables[0].Rows[0]["ProductName"].ToString();
_ProductDescription = objdataset.Tables[0].Rows[0]["Description"].ToString();
_Qty = Convert.ToInt16(objdataset.Tables[0].Rows[0]["Qty"]);
_TaxAmount = Convert.ToDouble(objdataset.Tables[0].Rows[0]["TaxAmount"]);
_UnitCost = Convert.ToInt16(objdataset.Tables[0].Rows[0]["UnitCost"]);
}
}
}
3_InvoicingApplicationWithaClass\InvoiceEntry.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="InvoiceEntry.aspx.cs" Inherits="InvoiceEntry" %>
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>
<style type="text/css">
.style2
{
text-align: center;
}
.style3
{
color: #663300;
font-weight: bold;
}
style>
head>
<body>
<div class="style2">
<span class="style3" lang="en-us">Simple Invoicing Applicationspan>
div>
<form id="form1" runat="server">
<div>
<asp:Label ID="Label1" runat="server" Text="Customer Name">asp:Label>
<asp:TextBox ID="txtCustomerName" runat="server">asp:TextBox>
<asp:Label ID="Label2" runat="server" Text="Customer Address">asp:Label>
<asp:TextBox ID="txtCustomerAddress" runat="server" TextMode="MultiLine">asp:TextBox>
<asp:Label ID="Label3" runat="server" Text="Invoice Number">asp:Label>
<asp:TextBox ID="txtInvoiceNumber" runat="server">asp:TextBox>
<br />
<br />
<br />
<asp:Label ID="Label4" runat="server" Text="Invoice Date">asp:Label>
<span lang="en-us">
<asp:TextBox ID="txtInvoiceDate" runat="server">asp:TextBox>
<asp:Label ID="Label5" runat="server" Text="Product Name">asp:Label>
<asp:TextBox ID="txtProductName" runat="server">asp:TextBox>
<asp:Label ID="Label6" runat="server" Text="Product Description">asp:Label>
<asp:TextBox ID="txtProductDescription" runat="server">asp:TextBox>
<br />
<br />
<asp:Label ID="Label7" runat="server" Text="Unit Cost">asp:Label>
<asp:TextBox ID="txtUnitCost" runat="server">asp:TextBox>
<asp:Label ID="Label8" runat="server" Text="Quantity">asp:Label>
<asp:TextBox ID="TxtQuantity" runat="server">asp:TextBox>
<asp:Label ID="Label9" runat="server" Text="Total Amount to be paid">asp:Label>
<asp:TextBox ID="txtAmountToBePaid" runat="server">asp:TextBox>
<br />
<br />
<asp:Label ID="Label10" runat="server" Text="Total Amount paid">asp:Label>
<asp:TextBox ID="txtAmountPaid" runat="server">asp:TextBox>
<asp:Label ID="Label12" runat="server" Text="Tax Amount">asp:Label>
<asp:TextBox ID="txtTaxAmount" runat="server">asp:TextBox>
<asp:Label ID="Label11" runat="server" Text="Comments">asp:Label>
<asp:TextBox ID="txtComments" runat="server" TextMode="MultiLine">asp:TextBox>
<br />
<asp:Button ID="btnAddInvoice" runat="server" Text="Add Invoice"
style="height: 26px" onclick="btnAddInvoice_Click" />
<asp:Button ID="btnUpdateInvoice" runat="server" Text="update Invoice" onclick="btnUpdateInvoice_Click"
/>
<asp:Button ID="btnDeleteInvoice" runat="server" Text="Delete Invoice" onclick="btnDeleteInvoice_Click"
/>
span>
div>
<asp:DataGrid ID="dtgInvoice" runat="server"
onselectedindexchanged="dtgInvoice_SelectedIndexChanged" BackColor="White"
BorderColor="#DEDFDE" BorderStyle="None" BorderWidth="1px" CellPadding="4"
ForeColor="Black" GridLines="Vertical">
<FooterStyle BackColor="#CCCC99" />
<SelectedItemStyle BackColor="#CE5D5A" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#F7F7DE" ForeColor="Black" HorizontalAlign="Right"
Mode="NumericPages" />
<AlternatingItemStyle BackColor="White" />
<ItemStyle BackColor="#F7F7DE" />
<Columns>
<asp:ButtonColumn CommandName="Select" Text="Select">asp:ButtonColumn>
Columns>
<HeaderStyle BackColor="#6B696B" Font-Bold="True" ForeColor="White" />
asp:DataGrid>
<asp:Label ID="lblErrorMessage" runat="server" ForeColor="Red" Text="Label">asp:Label>
form>
body>
html>
3_INVOICINGAPPLICATIONWITHACLASS\InvoiceEntry.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.SqlClient;
using System.Data;
using Invoicing;
public partial class InvoiceEntry : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
LoadGrid();
}
private void LoadGrid()
{
// load the data set in to the data grid
clsInvoice objInvoice = new clsInvoice();
dtgInvoice.DataSource = objInvoice.getInvoice();
dtgInvoice.DataBind();
}
public void clearText()
{
txtInvoiceNumber.Text = "";
txtComments.Text = "";
txtInvoiceDate.Text = "";
txtProductName.Text = "";
txtProductDescription.Text = "";
TxtQuantity.Text = "";
txtAmountToBePaid.Text = "";
txtTaxAmount.Text = "";
txtAmountPaid.Text = "";
txtCustomerName.Text = "";
txtCustomerAddress.Text = "";
txtUnitCost.Text = "";
}
protected void btnAddInvoice_Click(object sender, EventArgs e)
{
try
{
clsInvoice objInvoice = new clsInvoice();
setObjectFromUI(objInvoice);
objInvoice.Insert();
LoadGrid();
clearText();
}
catch (Exception ex)
{
lblErrorMessage.Text = ex.Message.ToString();
}
}
public void setObjectFromUI(clsInvoice objInvoice)
{
try
{
objInvoice.CustomerName = txtCustomerName.Text;
objInvoice.CustomerAddress = txtCustomerAddress.Text;
objInvoice.Amount = Convert.ToDouble(txtAmountToBePaid.Text);
objInvoice.PaidAmount = Convert.ToDouble(txtAmountPaid.Text);
objInvoice.InvoiceDate = Convert.ToDateTime(txtInvoiceDate.Text);
objInvoice.InvoiceComments = txtComments.Text;
objInvoice.InvoiceReference = txtInvoiceNumber.Text;
objInvoice.ProductName = txtProductName.Text;
objInvoice.ProductDescription = txtProductDescription.Text;
objInvoice.Quantity = Convert.ToInt16(TxtQuantity.Text);
objInvoice.TaxAmount = Convert.ToDouble(txtTaxAmount.Text);
objInvoice.UnitCost = Convert.ToInt16(txtUnitCost.Text);
}
catch (Exception ex)
{
throw ex;
}
}
public void setUIfromObject(clsInvoice objInvoice)
{
txtCustomerName.Text = objInvoice.CustomerName;
txtCustomerAddress.Text = objInvoice.CustomerAddress;
txtAmountToBePaid.Text = objInvoice.Amount.ToString();
txtAmountPaid.Text = objInvoice.PaidAmount.ToString();
txtInvoiceDate.Text = objInvoice.InvoiceDate.ToString();
txtComments.Text = objInvoice.InvoiceComments.ToString();
txtInvoiceNumber.Text = objInvoice.InvoiceReference.ToString();
txtProductName.Text = objInvoice.ProductName.ToString();
txtProductDescription.Text = objInvoice.ProductDescription.ToString();
TxtQuantity.Text = objInvoice.Quantity.ToString();
txtTaxAmount.Text = objInvoice.TaxAmount.ToString();
txtUnitCost.Text = objInvoice.UnitCost.ToString();
}
protected void btnUpdateInvoice_Click(object sender, EventArgs e)
{
clsInvoice objInvoice = new clsInvoice();
try
{
setObjectFromUI(objInvoice);
objInvoice.Update();
clearText();
LoadGrid();
}
catch (Exception ex)
{
lblErrorMessage.Text = ex.Message.ToString();
}
}
protected void btnDeleteInvoice_Click(object sender, EventArgs e)
{
clsInvoice objInvoice = new clsInvoice();
setObjectFromUI(objInvoice);
objInvoice.Delete();
clearText();
LoadGrid();
}
protected void dtgInvoice_SelectedIndexChanged(object sender, EventArgs e)
{
clsInvoice objInvoice = new clsInvoice();
objInvoice.LoadInvoice(dtgInvoice.SelectedItem.Cells[1].Text.ToString());
setUIfromObject(objInvoice);
}
}
