public Int16 completion(int userId, string username, string firstName, string lastName, Int16 gender, int locationId, string birthDate, bool hasPhoto)
{
Int16 status = 0;
//check username valid
Regex RgxUrl = new Regex("[^a-zA-Z]");
if (Regex.Matches(username, @"[a-zA-Z]").Count == 0)
{
status = -2;
}
else
{
//special symbols
RgxUrl = new Regex("[^a-zA-Z0-9]");
if (RgxUrl.IsMatch(username))
{
status = -3;
}
else
{
//check username exists
Classes.UserInfo ui = new Classes.UserInfo();
bool usernameExists = ui.checkUsernameExists(username);
if (usernameExists)
{
status = -1;
}
else
{
status = 1;
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["AppConnectionString"].ConnectionString);
SqlCommand sqlCmd = new SqlCommand("sp_completion", sqlConn);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add("@UserId", SqlDbType.Int).Value = userId;
sqlCmd.Parameters.Add("@Username", SqlDbType.VarChar).Value = username;
sqlCmd.Parameters.Add("@FirstName", SqlDbType.NVarChar).Value = firstName;
sqlCmd.Parameters.Add("@LastName", SqlDbType.NVarChar).Value = lastName;
sqlCmd.Parameters.Add("@Gender", SqlDbType.TinyInt).Value = gender;
sqlCmd.Parameters.Add("@LocationId", SqlDbType.Int).Value = locationId;
sqlCmd.Parameters.Add("@BirthDate", SqlDbType.Date).Value = Convert.ToDateTime(birthDate);//Convert.ToDateTime(dob);
sqlCmd.Parameters.Add("@HasPhoto", SqlDbType.Bit).Value = hasPhoto;
//try
//{
sqlConn.Open();
sqlCmd.ExecuteNonQuery();
//}
//catch (Exception ex)
//{
//}
//finally
//{
sqlConn.Close();
sqlCmd.Dispose();
sqlConn.Dispose();
//}
Classes.Notifications n = new Classes.Notifications();
n.notificationAdd(userId, 1, Convert.ToInt64(userId));
string email = ui.getEmailByUserId(userId);
string siteLink = ConfigurationManager.AppSettings["WebsiteLink"].ToString();
string link = siteLink;
string message = "<br/>Welcome to CityCrowd.<br/>You have successfully registered.<br/><a href='"
+ link + "'>CLICK HERE</a> to visit the website.<br/><br/>CityCowd Team";
if (!ui.isUserEmailVerified(userId))
{
string VCode = Convert.ToString(Guid.NewGuid());
SqlConnection sqlConn2 = new SqlConnection(ConfigurationManager.ConnectionStrings["AppConnectionString"].ConnectionString);
SqlCommand sqlCmd2 = new SqlCommand("sp_verifyEmailAdd", sqlConn2);
sqlCmd2.CommandType = CommandType.StoredProcedure;
sqlCmd2.Parameters.Add("@UserId", SqlDbType.Int).Value = userId;
sqlCmd2.Parameters.Add("@VCode", SqlDbType.NVarChar).Value = VCode;
sqlConn2.Open();
sqlCmd2.ExecuteNonQuery();
link = siteLink + "Verify/Email/" + VCode;
message = "<br/>Welcome to CityCrowd.<br/>You have successfully registered.<br/><a href='"
+ link + "'>CLICK HERE</a> to verify your email address and visit the website.<br/><br/>CityCowd Team";
}
Classes.Mail m = new Classes.Mail();
int status2 = m.sendMail("register", email,
"Hi, " + firstName + message, "");
}
}
}
return(status);
}
public Int16 completion(int userId, string username, string firstName, string lastName, Int16 gender, int locationId, string birthDate, bool hasPhoto)
{
Int16 status = 0;
//check username valid
Regex RgxUrl = new Regex("[^a-zA-Z]");
if (Regex.Matches(username, @"[a-zA-Z]").Count == 0)
{
status = -2;
}
else
{
//special symbols
RgxUrl = new Regex("[^a-zA-Z0-9]");
if (RgxUrl.IsMatch(username))
{
status = -3;
}
else
{
//check username exists
Classes.UserInfo ui = new Classes.UserInfo();
bool usernameExists = ui.checkUsernameExists(username);
if (usernameExists)
{
status = -1;
}
else
{
status = 1;
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["AppConnectionString"].ConnectionString);
SqlCommand sqlCmd = new SqlCommand("sp_completion", sqlConn);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add("@UserId", SqlDbType.Int).Value = userId;
sqlCmd.Parameters.Add("@Username", SqlDbType.VarChar).Value = username;
sqlCmd.Parameters.Add("@FirstName", SqlDbType.NVarChar).Value = firstName;
sqlCmd.Parameters.Add("@LastName", SqlDbType.NVarChar).Value = lastName;
sqlCmd.Parameters.Add("@Gender", SqlDbType.TinyInt).Value = gender;
sqlCmd.Parameters.Add("@LocationId", SqlDbType.Int).Value = locationId;
sqlCmd.Parameters.Add("@BirthDate", SqlDbType.Date).Value = Convert.ToDateTime(birthDate);//Convert.ToDateTime(dob);
sqlCmd.Parameters.Add("@HasPhoto", SqlDbType.Bit).Value = hasPhoto;
//try
//{
sqlConn.Open();
sqlCmd.ExecuteNonQuery();
//}
//catch (Exception ex)
//{
//}
//finally
//{
sqlConn.Close();
sqlCmd.Dispose();
sqlConn.Dispose();
//}
Classes.Notifications n = new Classes.Notifications();
n.notificationAdd(userId, 1, Convert.ToInt64(userId));
string email = ui.getEmailByUserId(userId);
string siteLink = ConfigurationManager.AppSettings["WebsiteLink"].ToString();
string link = siteLink;
string message = "<br/>Welcome to CityCrowd.<br/>You have successfully registered.<br/><a href='"
+ link + "'>CLICK HERE</a> to visit the website.<br/><br/>CityCowd Team";
if(!ui.isUserEmailVerified(userId))
{
string VCode = Convert.ToString(Guid.NewGuid());
SqlConnection sqlConn2 = new SqlConnection(ConfigurationManager.ConnectionStrings["AppConnectionString"].ConnectionString);
SqlCommand sqlCmd2 = new SqlCommand("sp_verifyEmailAdd", sqlConn2);
sqlCmd2.CommandType = CommandType.StoredProcedure;
sqlCmd2.Parameters.Add("@UserId", SqlDbType.Int).Value = userId;
sqlCmd2.Parameters.Add("@VCode", SqlDbType.NVarChar).Value = VCode;
sqlConn2.Open();
sqlCmd2.ExecuteNonQuery();
link = siteLink + "Verify/Email/" + VCode;
message = "<br/>Welcome to CityCrowd.<br/>You have successfully registered.<br/><a href='"
+ link + "'>CLICK HERE</a> to verify your email address and visit the website.<br/><br/>CityCowd Team";
}
Classes.Mail m = new Classes.Mail();
int status2 = m.sendMail("register", email,
"Hi, " + firstName + message, "");
}
}
}
return status;
}
