forked from Mohammed4mach/Recipehub-project
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Sign up.aspx.cs
155 lines (132 loc) · 6.33 KB
/
Sign up.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
using System;
using System.IO;
using System.Collections.Generic;
using System.Collections;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using MySql.Data;
using MySql.Data.MySqlClient;
namespace Recipehub
{
public partial class Sign_up : System.Web.UI.Page
{
public string err;
protected void Page_Load(object sender, EventArgs e)
{
if (Request.Cookies["recipehub_user_id"] != null)
{
Response.Redirect("~/Profile Page.aspx");
Response.End();
}
MySqlConnection conn = new MySqlConnection("server=127.0.0.1;user=root;password=root;database=world;");
try
{
conn.Open();
// Insert List Items for country selection
string sql = $"SELECT Name FROM country ORDER BY Name ASC;";
MySqlDataReader countries = Func.executeSQLReader(conn, sql);;
int i = 0;
while(countries.Read())
{
country.Items.Insert(i, new ListItem(countries[0].ToString(), countries[0].ToString()));
i++;
}
countries.Close();
// Insert List Items for city selection
sql = $"SELECT Name FROM city ORDER BY Name ASC;";
MySqlDataReader cities = Func.executeSQLReader(conn, sql);
i = 0;
while(cities.Read())
{
city.Items.Insert(i, new ListItem(cities[0].ToString(), cities[0].ToString()));
i++;
}
cities.Close();
conn.Close();
}
catch (System.Exception ex)
{
err = ex.ToString();
}
}
protected void submit_Click(object sender, EventArgs e)
{
long user_id = Func.genId(100000, Int32.MaxValue);
string user_username = Func.sanInput(username.Text);
string user_email = Func.sanInput(email.Text);
string user_password = Func.hashPassword(password.Text);
string user_country = country.SelectedValue;
string user_city = city.SelectedValue;
char user_gender;
if (male.Checked)
user_gender = male.Text[male.Text.Length - 4];
else
user_gender = female.Text[female.Text.Length - 6];
/* Start validation */
// Open Connection
MySqlConnection conn = new MySqlConnection("server=127.0.0.1;user=root;password=root;database=recipehub;");
try
{
conn.Open();
// Check for identical id in the database
string sql;
MySqlDataReader readId;
do // If same id exists, generate new one
{
sql = $"SELECT user_id FROM user WHERE user_id = {user_id};";
readId = Func.executeSQLReader(conn, sql);
if(readId.HasRows)
{
user_id = Func.genId(100000, Int32.MaxValue);
}
} while (readId.HasRows);
readId.Close();
// Check for identical email address in the database
sql = $"SELECT email FROM user WHERE email = '{user_email}'";
MySqlDataReader readEmail = Func.executeSQLReader(conn, sql);
if(readEmail.HasRows) // If same email exists, display the error
{
readEmail.Close();
conn.Close();
err = "Email address is already registered __ " + password.Text;
}
else
{
readEmail.Close();
/* End validation */
/* Add user to the database */
string create_date = DateTime.Now.ToString("MM-dd-yyyy HH:mm:ss");
string[] date = birth_date.Value.Split('-');
string birthDate = new DateTime(int.Parse(date[0]), int.Parse(date[1]), int.Parse(date[2])).ToString("MM-dd-yyyy HH:mm:ss");
int user_age = DateTime.Now.Year - int.Parse(date[0]);
user_age = user_age < 0 ? 0 : user_age;
// Upload the picture and execute
string user_picture = null;
if(user_img.HasFile)
{
string extension = System.IO.Path.GetExtension(user_img.PostedFile.FileName);
user_picture = Server.MapPath("~/uploads/pictures/users/") + user_id.ToString() + extension;
user_img.SaveAs(user_picture);
// File.WriteAllBytes(Server.MapPath("~/") + user_img.PostedFile.FileName, user_img.FileBytes);
user_picture = "./uploads/pictures/users/" + user_id.ToString() + extension;
sql = $"INSERT INTO user(user_id, email, username, password, birth_date, create_date, gender, country, city, picture, age) VALUES ({user_id}, '{user_email}', '{user_username}', '{user_password}', STR_TO_DATE('{birthDate}', '%m-%d-%Y %H:%i:%s'), STR_TO_DATE('{create_date}', '%m-%d-%Y %H:%i:%s'), '{user_gender}', '{user_country}', '{user_city}', '{user_picture}', {user_age})";
}
else
sql = $"INSERT INTO user(user_id, email, username, password, birth_date, create_date, gender, country, city, picture, age) VALUES ({user_id}, '{user_email}', '{user_username}', '{user_password}', STR_TO_DATE('{birthDate}', '%m-%d-%Y %H:%i:%s'), STR_TO_DATE('{create_date}', '%m-%d-%Y %H:%i:%s'), '{user_gender}', '{user_country}', '{user_city}', NULL, {user_age})";
Func.executeSQL(conn, sql, false);
// Set cookie as user id for 30 days to identify the user
Response.SetCookie(Func.cookieSet("recipehub_user_id", user_id.ToString(), 24 * 14));
Response.Redirect("~/Profile Page.aspx");
conn.Close();
Response.End();
}
}
catch (System.Exception ex)
{
err = err + ex.Message;
}
}
}
}