1
private void InsertUser()
2
{
3
if (Page.IsValid)
4
{
5
// Save new user to the database
6
SqlConnection con;
7
string sql;
8
SqlCommand cmd;
9
StringBuilder sb = new StringBuilder();
10
ArrayList values = new ArrayList();
11![](/Images/OutliningIndicators/InBlock.gif)
12
sb.Append("INSERT INTO [User] ");
13
sb.Append("(UserID, Login, Password, FirstName, LastName,");
14
sb.Append(" PhoneNumber, Email, IsAdministrator, Address,");
15
sb.Append(" CellNumber, DateOfBirth) ");
16
sb.Append("VALUES
('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', ");
17
18
// Optional values without quotes as they can be the Null value.
19
sb.Append("{8}, {9}, {10})");
20![](/Images/OutliningIndicators/InBlock.gif)
21
// Escape any quotation mark entered by the user
22
txtLogin.Text = txtLogin.Text.Replace("'","''");
23
txtPwd.Text = txtPwd.Text.Replace("'","''");
24
txtFName.Text = txtFName.Text.Replace("'","''");
25
txtLName.Text = txtLName.Text.Replace("'","''");
26
txtPhone.Text = txtPhone.Text.Replace("'","''");
27
txtMobile.Text = txtMobile.Text.Replace("'","''");
28
txtEmail.Text = txtEmail.Text.Replace("'","''");
29
txtAddress.Text = txtAddress.Text.Replace("'","''");
30
txtBirth.Text = txtBirth.Text.Replace("'","''");
31![](/Images/OutliningIndicators/InBlock.gif)
32
// Add required values to replace
33
values.Add(Guid.NewGuid().ToString());
34
values.Add(txtLogin.Text);
35
values.Add(txtPwd.Text);
36
values.Add(txtFName.Text);
37
values.Add(txtLName.Text);
38
values.Add(txtPhone.Text);
39
values.Add(txtEmail.Text);
40
values.Add(0);
41![](/Images/OutliningIndicators/InBlock.gif)
42
// Add the optional values or Null
43
if (txtAddress.Text != string.Empty)
44
values.Add("'" + txtAddress.Text + "'");
45
else
46
values.Add("Null");
47![](/Images/OutliningIndicators/InBlock.gif)
48
if (txtMobile.Text != string.Empty)
49
values.Add("'" + txtMobile.Text + "'");
50
else
51
values.Add("Null");
52![](/Images/OutliningIndicators/InBlock.gif)
53
if (txtBirth.Text != string.Empty)
54
values.Add("'" + txtBirth.Text + "'");
55
else
56
values.Add("Null");
57![](/Images/OutliningIndicators/InBlock.gif)
58
// Format the string with the array of values
59
sql = String.Format(sb.ToString(), values.ToArray());
60![](/Images/OutliningIndicators/InBlock.gif)
61
// Connect and execute the query
62
con = new SqlConnection(ConfigurationSettings.AppSettings["cnFriends.ConnectionString"]);
63
cmd = new SqlCommand(sql, con);
64
con.Open();
65![](/Images/OutliningIndicators/InBlock.gif)
66
bool doredirect = true;
67![](/Images/OutliningIndicators/InBlock.gif)
68
try
69
{
70
cmd.ExecuteNonQuery();
71
}
72
catch(SqlException e)
73
{
74
if (e.Number==2627)
75
throw new DuplicateUsernameFRException("Can't insert record", e);
76
else
77
{
78
doredirect = false;
79
this.lblMessage.Visible = true;
80
this.lblMessage.Text = "Insert couldn't be performed. ";
81
}
82
}
83
catch(OutOfMemoryException e)
84
{
85
doredirect = false;
86
this.lblMessage.Visible = true;
87
this.lblMessage.Text = "We just run of out memory, " +
88
"please restart the application!";
89
}
90
catch(Exception e)
91
{
92
Trace.Warn("FriendsReunion",
93
"An exception was thrown: " + e.Message.ToString());
94
doredirect = false;
95
this.lblMessage.Visible = true;
96
this.lblMessage.Text = "Insert couldn't be performed. User name may be already taken.";
97
}
98
finally
99
{
100
con.Close();
101
}
102![](/Images/OutliningIndicators/InBlock.gif)
103
if (doredirect)
104
Server.Transfer("Login.aspx");
105
}
106
}
107![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
2
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
3
![](/Images/OutliningIndicators/InBlock.gif)
4
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
5
![](/Images/OutliningIndicators/InBlock.gif)
6
![](/Images/OutliningIndicators/InBlock.gif)
7
![](/Images/OutliningIndicators/InBlock.gif)
8
![](/Images/OutliningIndicators/InBlock.gif)
9
![](/Images/OutliningIndicators/InBlock.gif)
10
![](/Images/OutliningIndicators/InBlock.gif)
11
![](/Images/OutliningIndicators/InBlock.gif)
12
![](/Images/OutliningIndicators/InBlock.gif)
13
![](/Images/OutliningIndicators/InBlock.gif)
14
![](/Images/OutliningIndicators/InBlock.gif)
15
![](/Images/OutliningIndicators/InBlock.gif)
16
![](/Images/OutliningIndicators/InBlock.gif)
('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', ");
17
![](/Images/OutliningIndicators/InBlock.gif)
18
![](/Images/OutliningIndicators/InBlock.gif)
19
![](/Images/OutliningIndicators/InBlock.gif)
20
![](/Images/OutliningIndicators/InBlock.gif)
21
![](/Images/OutliningIndicators/InBlock.gif)
22
![](/Images/OutliningIndicators/InBlock.gif)
23
![](/Images/OutliningIndicators/InBlock.gif)
24
![](/Images/OutliningIndicators/InBlock.gif)
25
![](/Images/OutliningIndicators/InBlock.gif)
26
![](/Images/OutliningIndicators/InBlock.gif)
27
![](/Images/OutliningIndicators/InBlock.gif)
28
![](/Images/OutliningIndicators/InBlock.gif)
29
![](/Images/OutliningIndicators/InBlock.gif)
30
![](/Images/OutliningIndicators/InBlock.gif)
31
![](/Images/OutliningIndicators/InBlock.gif)
32
![](/Images/OutliningIndicators/InBlock.gif)
33
![](/Images/OutliningIndicators/InBlock.gif)
34
![](/Images/OutliningIndicators/InBlock.gif)
35
![](/Images/OutliningIndicators/InBlock.gif)
36
![](/Images/OutliningIndicators/InBlock.gif)
37
![](/Images/OutliningIndicators/InBlock.gif)
38
![](/Images/OutliningIndicators/InBlock.gif)
39
![](/Images/OutliningIndicators/InBlock.gif)
40
![](/Images/OutliningIndicators/InBlock.gif)
41
![](/Images/OutliningIndicators/InBlock.gif)
42
![](/Images/OutliningIndicators/InBlock.gif)
43
![](/Images/OutliningIndicators/InBlock.gif)
44
![](/Images/OutliningIndicators/InBlock.gif)
45
![](/Images/OutliningIndicators/InBlock.gif)
46
![](/Images/OutliningIndicators/InBlock.gif)
47
![](/Images/OutliningIndicators/InBlock.gif)
48
![](/Images/OutliningIndicators/InBlock.gif)
49
![](/Images/OutliningIndicators/InBlock.gif)
50
![](/Images/OutliningIndicators/InBlock.gif)
51
![](/Images/OutliningIndicators/InBlock.gif)
52
![](/Images/OutliningIndicators/InBlock.gif)
53
![](/Images/OutliningIndicators/InBlock.gif)
54
![](/Images/OutliningIndicators/InBlock.gif)
55
![](/Images/OutliningIndicators/InBlock.gif)
56
![](/Images/OutliningIndicators/InBlock.gif)
57
![](/Images/OutliningIndicators/InBlock.gif)
58
![](/Images/OutliningIndicators/InBlock.gif)
59
![](/Images/OutliningIndicators/InBlock.gif)
60
![](/Images/OutliningIndicators/InBlock.gif)
61
![](/Images/OutliningIndicators/InBlock.gif)
62
![](/Images/OutliningIndicators/InBlock.gif)
63
![](/Images/OutliningIndicators/InBlock.gif)
64
![](/Images/OutliningIndicators/InBlock.gif)
65
![](/Images/OutliningIndicators/InBlock.gif)
66
![](/Images/OutliningIndicators/InBlock.gif)
67
![](/Images/OutliningIndicators/InBlock.gif)
68
![](/Images/OutliningIndicators/InBlock.gif)
69
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
70
![](/Images/OutliningIndicators/InBlock.gif)
71
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
72
![](/Images/OutliningIndicators/InBlock.gif)
73
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
74
![](/Images/OutliningIndicators/InBlock.gif)
75
![](/Images/OutliningIndicators/InBlock.gif)
76
![](/Images/OutliningIndicators/InBlock.gif)
77
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
78
![](/Images/OutliningIndicators/InBlock.gif)
79
![](/Images/OutliningIndicators/InBlock.gif)
80
![](/Images/OutliningIndicators/InBlock.gif)
81
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
82
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
83
![](/Images/OutliningIndicators/InBlock.gif)
84
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
85
![](/Images/OutliningIndicators/InBlock.gif)
86
![](/Images/OutliningIndicators/InBlock.gif)
87
![](/Images/OutliningIndicators/InBlock.gif)
88
![](/Images/OutliningIndicators/InBlock.gif)
89
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
90
![](/Images/OutliningIndicators/InBlock.gif)
91
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
92
![](/Images/OutliningIndicators/InBlock.gif)
93
![](/Images/OutliningIndicators/InBlock.gif)
94
![](/Images/OutliningIndicators/InBlock.gif)
95
![](/Images/OutliningIndicators/InBlock.gif)
96
![](/Images/OutliningIndicators/InBlock.gif)
97
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
98
![](/Images/OutliningIndicators/InBlock.gif)
99
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
100
![](/Images/OutliningIndicators/InBlock.gif)
101
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
102
![](/Images/OutliningIndicators/InBlock.gif)
103
![](/Images/OutliningIndicators/InBlock.gif)
104
![](/Images/OutliningIndicators/InBlock.gif)
105
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
106
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
107
![](/Images/OutliningIndicators/None.gif)