protected void ButtonSubmit_Click(object sender, EventArgs e)
{
//validate
//save
int status;
Classes.UserProfileSet ups = new Classes.UserProfileSet();
status = ups.completion(
Convert.ToInt32(Session["UserId"]),
TextBoxUsername.Text,
TextBoxFirstName.Text,
TextBoxLastName.Text,
Convert.ToInt16(DropDownListGender.SelectedValue),
Convert.ToInt32(DropDownListCity.SelectedValue),
HiddenFieldDOB.Value);
if (status == 1)
{
Response.Redirect("~/Introduction");
}
}
protected void ButtonSubmit_Click(object sender, EventArgs e)
{
//validate
//save
int status;
Classes.UserProfileSet ups = new Classes.UserProfileSet();
status = ups.completion(
Convert.ToInt32(Session["UserId"]),
TextBoxUsername.Text,
TextBoxFirstName.Text,
TextBoxLastName.Text,
Convert.ToInt16(DropDownListGender.SelectedValue),
Convert.ToInt32(DropDownListCity.SelectedValue),
HiddenFieldDOB.Value);
if (status == 1)
{
Response.Redirect("~/Introduction");
}
}
protected void ButtonSubmit_Click(object sender, EventArgs e)
{
Int16 locationStatus = Convert.ToInt16(HiddenFieldLocationStatus.Value);
int locationId = 0;
int userId = Convert.ToInt32(Session["UserId"]);
if (locationStatus == 1)
{
locationId = Convert.ToInt32(HiddenFieldLocationId.Value);
}
else
{
locationId = 0;
Classes.Locations l = new Classes.Locations();
int status2 = l.request(userId,
TextBoxRequestLocationCountry.Text,
TextBoxRequestLocationCity.Text);
}
//save photo
photoUpload();
//validate
//save
int status;
Classes.UserProfileSet ups = new Classes.UserProfileSet();
status = ups.completion(
userId,
TextBoxUsername.Text,
TextBoxFirstName.Text,
TextBoxLastName.Text,
Convert.ToInt16(DropDownListGender.SelectedValue),
locationId,
HiddenFieldDOB.Value,
Convert.ToBoolean(HiddenFieldHasPhoto.Value));
if (status == 1)
{
DataTable dt = new DataTable();
DataSet ds = new DataSet();
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["AppConnectionString"].ConnectionString);
SqlDataAdapter sda = new SqlDataAdapter("sp_fbFriendsList", sqlConn);
sda.SelectCommand.CommandType = CommandType.StoredProcedure;
sda.SelectCommand.Parameters.Add("@UserId", SqlDbType.Int).Value = userId;
//try
//{
sda.Fill(ds);
dt = ds.Tables[0];
//}
//catch (Exception ex)
//{
//}
//finally
//{
sqlConn.Close();
sda.Dispose();
sqlConn.Dispose();
//}
for (int i = 0; i < dt.Rows.Count; i++)
{
SqlConnection sqlConn2 = new SqlConnection(ConfigurationManager.ConnectionStrings["AppConnectionString"].ConnectionString);
SqlCommand sqlCmd2 = new SqlCommand("sp_fbFriendsApply", sqlConn2);
sqlCmd2.CommandType = CommandType.StoredProcedure;
sqlCmd2.Parameters.Add("@FbId", SqlDbType.VarChar).Value = dt.Rows[i]["FriendFbId"].ToString();
sqlCmd2.Parameters.Add("@UserId", SqlDbType.Int).Value = userId;
//try
//{
sqlConn2.Open();
sqlCmd2.ExecuteNonQuery();
//}
//catch
//{
//}
//finally
//{
sqlConn2.Close();
sqlConn2.Dispose();
sqlCmd2.Dispose();
//}
}
Response.Redirect("~/Introduction");
}
else if (status == -1)
{
LabelMessage.Visible = true;
LabelMessage.Text = "Username is not available, please select another one!";
}
else if (status == -2)
{
LabelMessage.Visible = true;
LabelMessage.Text = "Username must has at least 1 letter!";
}
else if (status == -3)
{
LabelMessage.Visible = true;
LabelMessage.Text = "Username must not contains special characters!";
}
}
protected void ButtonSubmit_Click(object sender, EventArgs e)
{
Int16 locationStatus = Convert.ToInt16(HiddenFieldLocationStatus.Value);
int locationId = 0;
int userId = Convert.ToInt32(Session["UserId"]);
if (locationStatus == 1)
{
locationId = Convert.ToInt32(HiddenFieldLocationId.Value);
}
else
{
locationId = 0;
Classes.Locations l = new Classes.Locations();
int status2 = l.request(userId,
TextBoxRequestLocationCountry.Text,
TextBoxRequestLocationCity.Text);
}
//save photo
photoUpload();
//validate
//save
int status;
Classes.UserProfileSet ups = new Classes.UserProfileSet();
status = ups.completion(
userId,
TextBoxUsername.Text,
TextBoxFirstName.Text,
TextBoxLastName.Text,
Convert.ToInt16(DropDownListGender.SelectedValue),
locationId,
HiddenFieldDOB.Value,
Convert.ToBoolean(HiddenFieldHasPhoto.Value));
if (status == 1)
{
DataTable dt = new DataTable();
DataSet ds = new DataSet();
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["AppConnectionString"].ConnectionString);
SqlDataAdapter sda = new SqlDataAdapter("sp_fbFriendsList", sqlConn);
sda.SelectCommand.CommandType = CommandType.StoredProcedure;
sda.SelectCommand.Parameters.Add("@UserId", SqlDbType.Int).Value = userId;
//try
//{
sda.Fill(ds);
dt = ds.Tables[0];
//}
//catch (Exception ex)
//{
//}
//finally
//{
sqlConn.Close();
sda.Dispose();
sqlConn.Dispose();
//}
for (int i = 0; i < dt.Rows.Count; i++)
{
SqlConnection sqlConn2 = new SqlConnection(ConfigurationManager.ConnectionStrings["AppConnectionString"].ConnectionString);
SqlCommand sqlCmd2 = new SqlCommand("sp_fbFriendsApply", sqlConn2);
sqlCmd2.CommandType = CommandType.StoredProcedure;
sqlCmd2.Parameters.Add("@FbId", SqlDbType.VarChar).Value = dt.Rows[i]["FriendFbId"].ToString();
sqlCmd2.Parameters.Add("@UserId", SqlDbType.Int).Value = userId;
//try
//{
sqlConn2.Open();
sqlCmd2.ExecuteNonQuery();
//}
//catch
//{
//}
//finally
//{
sqlConn2.Close();
sqlConn2.Dispose();
sqlCmd2.Dispose();
//}
}
Response.Redirect("~/Introduction");
}
else if (status == -1)
{
LabelMessage.Visible = true;
LabelMessage.Text = "Username is not available, please select another one!";
}
else if (status == -2)
{
LabelMessage.Visible = true;
LabelMessage.Text = "Username must has at least 1 letter!";
}
else if (status == -3)
{
LabelMessage.Visible = true;
LabelMessage.Text = "Username must not contains special characters!";
}
}
