-
Notifications
You must be signed in to change notification settings - Fork 0
/
Receipt.aspx.cs
154 lines (145 loc) · 5.95 KB
/
Receipt.aspx.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
using System;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using iTextSharp.text;
using iTextSharp.text.pdf;
using iTextSharp.text.html.simpleparser;
using System.IO;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
public partial class Receipt : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
query.Visible = false;
signup.Visible = false;
dropdown.Visible = false;
news.Visible = false;
if (Session["user_name"] != null)
{
label1.Text = "Welcome , " + (string)Session["user_name"];
Boolean admin = (Boolean)Session["admin"];
login.Visible = false;
dropdown.Visible = true;
if (admin == true)
{
signup.Visible = true;
query.Visible = true;
news.Visible = true;
}
}
}
}
protected void submit_Click(object sender, EventArgs e)
{
int id = Convert.ToInt16(pid.Text);
DataTable dt = new DataTable();
string societyName = "Swaminarayan Park";
string cons = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
SqlDataAdapter adp = new SqlDataAdapter("Get_Payment_By_No", cons);
adp.SelectCommand.CommandType = CommandType.StoredProcedure;
adp.SelectCommand.Parameters.Add(new SqlParameter("@Payment_Id", System.Data.SqlDbType.SmallInt));
adp.SelectCommand.Parameters["@Payment_Id"].Value = id;
adp.SelectCommand.Parameters.Add(new SqlParameter("@Flat_No", System.Data.SqlDbType.NVarChar));
adp.SelectCommand.Parameters["@Flat_No"].Value = (string)Session["user_name"];
DataSet ds = new DataSet();
adp.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
dt = ds.Tables[0];
using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter hw = new HtmlTextWriter(sw))
{
StringBuilder sb = new StringBuilder();
//Generate Invoice (Bill) Header.
sb.Append("<table width='100%' cellspacing='0' cellpadding='2'>");
sb.Append("<tr><td align='center' colspan = '2'><b>Total Bill</b></td></tr>");
sb.Append("<tr><td></td>");
sb.Append("<td align = 'right'><b>Date: </b>");
sb.Append(dt.Rows[0]["Date_Payment"]);
sb.Append("</td></tr>");
sb.Append("<tr><td colspan = '2'><b>Society Name: </b>");
sb.Append(societyName);
sb.Append("</td></tr>");
sb.Append("</table>");
sb.Append("<br />");
//Generate Invoice (Bill) Items Grid.
sb.Append("<table border = '1'>");
sb.Append("<tr>");
foreach (DataColumn column in dt.Columns)
{
sb.Append("<th>");
sb.Append(column.ColumnName);
sb.Append("</th>");
}
sb.Append("</tr>");
foreach (DataRow row in dt.Rows)
{
sb.Append("<tr>");
foreach (DataColumn column in dt.Columns)
{
sb.Append("<td>");
sb.Append(row[column]);
sb.Append("</td>");
}
sb.Append("</tr>");
}
/*sb.Append("<tr><td align = 'right' colspan = '");
sb.Append(dt.Columns.Count - 1);
sb.Append("'>Total</td>");
sb.Append("<td>");
sb.Append(dt.Compute("sum(Amount)", ""));
sb.Append("</td>");*/
sb.Append("</table>");
//Export HTML String as PDF.
StringReader sr = new StringReader(sb.ToString());
Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f);
HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
PdfWriter writer = PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
pdfDoc.Open();
htmlparser.Parse(sr);
pdfDoc.Close();
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=Invoice_" + (string)Session["user_name"] + ".pdf");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.Write(pdfDoc);
//Response.End();
}
}
}
else
{
Response.Write("<script> alert('No such Payment Id exist'); </script>");
}
}
protected void dropdown_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList list = (DropDownList)sender;
string value = (string)list.SelectedValue;
if (value.Equals("Logout"))
{
//Session.Clear();
//Response.Cache.SetCacheability(HttpCacheability.NoCache);
Session.Abandon();
/*FormsAuthentication.SignOut();
Response.Cache.SetExpires(DateTime.UtcNow.AddMinutes(-1));
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.Cache.SetNoStore();*/
Response.Redirect("Home.aspx");
}
if (value.Equals("Personal Information"))
{
Response.Redirect("myaccount.aspx");
}
if (value.Equals("Change Password"))
{
Response.Redirect("changepassword.aspx");
}
}
}