private int SavePhotoToDb(string guidPhoto, Tuple <int, int> imSizes)
{
int userId = (int)MyUtils.GetUserField("id_user");
int newIdPhoto = 0;
//Insert a new photo to photos table
try
{
DataSet ds = db.CommandBuilder_LoadDataSet("select * from photos where id_user=-1"); //get the columns schema
DataRow newPhoto = ds.Tables[0].NewRow();
newPhoto["id_user"] = userId;
newPhoto["GUID"] = guidPhoto;
newPhoto["is_approved"] = false;
newPhoto["is_private"] = false;
newPhoto["image_height"] = imSizes.Item1;
newPhoto["image_width"] = imSizes.Item2;
ds.Tables[0].Rows.Add(newPhoto);
newIdPhoto = db.CommandBuilder_SaveDataset(); //gets back @@identity
foreach (DataRow dr in dsImages.Tables[0].Rows)
{
if (dr["ImageGuid"].ToString() == guidPhoto)
{
dr["ImageID"] = newIdPhoto;
}
}
}
finally
{
db.CommandBuilder_Disconnect();
}
return(newIdPhoto);
}
protected void btnBlock_Click(object sender, EventArgs e)
{
// Block
if ((sender as LinkButton).Text == "Block")
{
int newBlockId = 0;
//Insert a new block to blocks table
try
{
DataSet ds = db.CommandBuilder_LoadDataSet("select * from blocks where id =-1"); //get the columns schema
DataRow newBlock = ds.Tables[0].NewRow();
newBlock["id_user_child"] = (int)MyUtils.GetUserField("id_user");
newBlock["id_user"] = currentUser;
newBlock["time"] = DateTime.Now;
ds.Tables[0].Rows.Add(newBlock);
newBlockId = db.CommandBuilder_SaveDataset();
SetButtonBlock(true);
}
finally
{
db.CommandBuilder_Disconnect();
}
}
//Unblock
else
{
try
{
db.Execute(string.Format("delete from blocks where id_user_child={0} and id_user = {1}", (int)MyUtils.GetUserField("id_user"), currentUser));
SetButtonBlock(false);
}
finally
{
db.CommandBuilder_Disconnect();
}
}
}
private void SaveUserInDB()
{
try
{
DataSet ds = db.CommandBuilder_LoadDataSet(string.Format("select * from users where id_user={0}", ID_USER));
DataRow userRow = ds.Tables[0].Rows[0];
userRow["zip"] = zip;
userRow["latitude"] = otherZipData.lat;
userRow["longitude"] = otherZipData.lon;
userRow["place"] = otherZipData.place;
string old_description = Convert.ToString(userRow["title"]) + Convert.ToString(userRow["description"]) + Convert.ToString(userRow["firstdate"]);
userRow["title"] = title;
userRow["description"] = desc;
userRow["firstdate"] = date;
string new_description = Convert.ToString(userRow["title"]) + Convert.ToString(userRow["description"]) + Convert.ToString(userRow["firstdate"]);
if (old_description.ToUpper() != new_description.ToUpper())
{
userRow["status"] = 0;
}
//ddl
Utils.SetDdlField(ddlEthnicity, userRow, "id_ethnicity");
Utils.SetDdlField(ddlReligion, userRow, "id_religion");
Utils.SetDdlField(ddlChildren, userRow, "id_children");
Utils.SetDdlField(ddlDrinking, userRow, "id_drinking");
Utils.SetDdlField(ddlSmoking, userRow, "id_smoking");
Utils.SetDdlField(ddlHeight, userRow, "id_height");
Utils.SetDdlField(ddlBodyType, userRow, "id_bodytype");
Utils.SetDdlField(ddlEyeColor, userRow, "id_eyecolor");
Utils.SetDdlField(ddlHairColor, userRow, "id_haircolor");
Utils.SetDdlField(ddlRelationship, userRow, "id_relationship");
Utils.SetDdlField(ddlEducation, userRow, "id_education");
Utils.SetDdlField(ddlIncome, userRow, "id_income");
Utils.SetDdlField(ddlWorth, userRow, "id_networth");
string error = "";
DateTime dt = birthday.GetBirthday(out error);
if (error != "")
{
MyUtils.DisplayCustomMessageInValidationSummary(error, RegisterUserValidationSummary);
return;
}
userRow["birthdate"] = dt;
userRow["occupation"] = MyUtils.StripHTML(ocupation.Text.Trim());
//cbx
userRow["lookingforshortterm"] = cbxShortDating.Checked;
userRow["lookingforfriendship"] = cbxFriendship.Checked;
userRow["lookingforlongterm"] = cbxLongTerm.Checked;
userRow["lookingforarrangement"] = cbxMutually.Checked;
userRow["lookingforaffair"] = cbxDiscreet.Checked;
userRow["lookingforcasualdating"] = cbxCasual.Checked;
db.CommandBuilder_SaveDataset();
}
finally
{
db.CommandBuilder_Disconnect();
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
bool revalidate = false;
try
{
string newemail = txtEmail.Text.Trim();
int cnt = db.ExecuteScalarInt("select count(*) from users where email=" + MyUtils.safe(newemail) + " and id_user<>" + MyUtils.ID_USER);
if (cnt > 0)
{
Session["message"] = "ERROR: this email is used by other user. You need to provide a new email.";
return;
}
DataSet ds = db.CommandBuilder_LoadDataSet(string.Format("select * from users where id_user={0}", MyUtils.ID_USER));
DataRow userRow = ds.Tables[0].Rows[0];
if (txtPassword.Text.Trim() != string.Empty)
{
userRow["password"] = txtPassword.Text.Trim();
}
revalidate = userRow["email"].ToString().ToUpper() != newemail.ToUpper();
userRow["email"] = newemail;
if (revalidate)
{
userRow["email_verified"] = 0;
}
//cbx
userRow["email_new_matches"] = cbxEmailNewMatches.Checked;
userRow["email_when_new_message"] = cbxEmailWhenNewMessage.Checked;
userRow["email_when_favorited"] = cbxEmailWhenFavorited.Checked;
userRow["email_when_new_offer"] = cbxemail_when_new_offer.Checked;
userRow["email_newsletter"] = cbxEmailNewsletter.Checked;
userRow["hide_from_search_results"] = cbxHideFromSearchResults.Checked;
// userRow["hide_on_viewed_favorited_list"] = cbxHideOnViewedFavoritedList.Checked;
// userRow["hide_last_logintime"] = cbxHideLastLogintime.Checked;
db.CommandBuilder_SaveDataset();
}
finally
{
db.CommandBuilder_Disconnect();
}
MyUtils.RefreshUserRow();
if (revalidate)
{
RWorker.AddToEmailQueue("EMAIL_ACTIVATE", MyUtils.ID_USER);
}
Session["message"] = "Settings have been saved";
Response.Redirect("~/Account/");
}
protected void btnSignUp_Click(object sender, EventArgs e)
{
int id_user;
try
{
txtName.Text = txtName.Text.Trim();
txtPassword.Text = txtPassword.Text.Trim();
txtEmail.Text = txtEmail.Text.Trim();
if (db.ExecuteScalarInt(string.Format("select count(*) from users where username = {0}", MyUtils.safe(txtName.Text))) > 0)
{
MyUtils.DisplayCustomMessageInValidationSummary("User with this Username already exists.", ValidationSummary1);
return;
}
if (db.ExecuteScalarInt(string.Format("select count(*) from users where email = {0}", MyUtils.safe(txtEmail.Text))) > 0)
{
MyUtils.DisplayCustomMessageInValidationSummary("User with this Email Address already exists.", ValidationSummary1);
return;
}
string xx = Profanity.TestAndMessage(txtName.Text);
if (xx != null)
{
MyUtils.DisplayCustomMessageInValidationSummary("User name " + xx, ValidationSummary1);
return;
}
DataSet d = db.CommandBuilder_LoadDataSet("select * from users where id_user=-1"); //get the columns schema
DataRow n = d.Tables[0].NewRow();
n["username"] = MyUtils.StripHTML(txtName.Text);
n["password"] = txtPassword.Text;
n["email"] = txtEmail.Text;
n["sex"] = MyUtils.StripHTML(ddlGender.SelectedValue);
string error = "";
DateTime dt = birthday.GetBirthday(out error);
if (error != "")
{
MyUtils.DisplayCustomMessageInValidationSummary(error, ValidationSummary1);
return;
}
n["birthdate"] = dt;
n["country"] = 28; // United States
d.Tables[0].Rows.Add(n);
id_user = db.CommandBuilder_SaveDataset(); //gets back @@identity
EmailWrapper mw = new EmailWrapper();
mw.SendTemplate("EMAIL_ACTIVATE", id_user);
string membership = "";
MyUtils.authenticate(txtName.Text, txtPassword.Text, out membership);
FormsAuthentication.SetAuthCookie(txtName.Text, false);
Response.Redirect("~/Account/Registration");
}
finally
{
db.CommandBuilder_Disconnect();
}
}