-
Notifications
You must be signed in to change notification settings - Fork 0
/
PersonalDetails.aspx.cs
157 lines (139 loc) · 6.18 KB
/
PersonalDetails.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
155
156
157
using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
namespace DC
{
public partial class PersonalDetails : System.Web.UI.Page
{
SqlConnection CONN = new SqlConnection(ConfigurationManager.AppSettings["webconn"]);
SqlCommand CMD;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataTable dt = new DataTable();
DataRow dr;
dt.Columns.Add("SN");
dt.Columns.Add("VaccineName");
dt.Columns.Add("VaccinePrice");
dt.Columns.Add("VaccineImage");
dt.Columns.Add("VaccinationCharge");
if (Request.QueryString["id"] != null)
{
if (Session["Buyitems"] == null)
{
dr = dt.NewRow();
String mycon = "Data Source=DESKTOP-V7UTR4K;Initial Catalog = DataDictionary; Integrated Security = True";
SqlConnection scon = new SqlConnection(mycon);
String myquery = "select * from VaccineDetails where VaccineId=" +
Request.QueryString["id"];
SqlCommand cmd = new SqlCommand();
cmd.CommandText = myquery;
cmd.Connection = scon;
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds);
dr["SN"] = 1;
dr["VaccineName"] = ds.Tables[0].Rows[0]["VaccineName"].ToString();
dr["VaccineImage"] = ds.Tables[0].Rows[0]["VaccineImage"].ToString();
dr["VaccinePrice"] = ds.Tables[0].Rows[0]["VaccinePrice"].ToString();
dr["VaccinationCharge"] = ds.Tables[0].Rows[0]["VaccinationCharge"].ToString();
dt.Rows.Add(dr);
GridView1.DataSource = dt;
GridView1.DataBind();
Session["buyitems"] = dt;
Response.Redirect("PersonalDetails.aspx");
}
else
{
dt = (DataTable)Session["buyitems"];
// int sr;
// sr = dt.Rows.Count;
dr = dt.NewRow();
String mycon = "Data Source=DESKTOP-V7UTR4K;Initial Catalog = DataDictionary; Integrated Security = True";
SqlConnection scon = new SqlConnection(mycon);
String myquery = "select * from VaccineDetails where VaccineId=" + Request.QueryString["id"];
SqlCommand cmd = new SqlCommand();
cmd.CommandText = myquery;
cmd.Connection = scon;
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds);
dr["SN"] = 1;
dr["VaccineName"] = ds.Tables[0].Rows[0]["VaccineName"].ToString();
dr["VaccineImage"] = ds.Tables[0].Rows[0]["VaccineImage"].ToString();
dr["VaccinePrice"] = ds.Tables[0].Rows[0]["VaccinePrice"].ToString();
dr["VaccinationCharge"] = ds.Tables[0].Rows[0]["VaccinationCharge"].ToString();
dt.Rows.Add(dr);
GridView1.DataSource = dt;
GridView1.DataBind();
Session["buyitems"] = dt;
Response.Redirect("PersonalDetails.aspx");
}
}
else
{
dt = (DataTable)Session["buyitems"];
GridView1.DataSource = dt;
GridView1.DataBind();
}
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
DataTable dt = new DataTable();
dt = (DataTable)Session["buyitems"];
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
int sr;
int sr1;
string qdata;
string dtdata;
sr = Convert.ToInt32(dt.Rows[i]["SN"].ToString());
TableCell cell = GridView1.Rows[e.RowIndex].Cells[0];
qdata = cell.Text;
dtdata = sr.ToString();
sr1 = Convert.ToInt32(qdata);
if (sr == sr1)
{
dt.Rows[i].Delete();
dt.AcceptChanges();
//Label1.Text = "Item Has Been Deleted From Shopping Cart";
break;
}
}
for (int i = 1; i <= dt.Rows.Count; i++)
{
dt.Rows[i - 1]["SN"] = i;
dt.AcceptChanges();
}
Session["buyitems"] = dt;
Response.Redirect("UserHome.aspx");
}
protected void Button1_Click(object sender, EventArgs e)
{
CONN.Open();
CMD = new SqlCommand("insert into PersonalDetails (Name,DOB,Gender,Aadhar,Health,Dose,CovidMember) values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + DropDownList1.SelectedValue + "'," + TextBox3.Text + ",'" + TextBox4.Text + "', '" + DropDownList2.SelectedValue + "','" + RadioButtonList1.SelectedValue + "')", CONN);
int x = CMD.ExecuteNonQuery();
if (x > 0)
{
Label1.Text = "done !";
Response.Redirect("WhenWhere.aspx");
}
else
{
Label1.Text = "not done !";
}
CONN.Close();
}
}
}