private bool CheckInput(string encoded) { try { using (QueriesTableAdapters.sp_DoesLoginExistTableAdapter ta = new QueriesTableAdapters.sp_DoesLoginExistTableAdapter()) { using (Queries.sp_DoesLoginExistDataTable dt = new Queries.sp_DoesLoginExistDataTable()) { ta.Fill(dt, StringCipher.Decrypt(encoded)); return(dt.Rows.Count > 0); } } } catch { return(false); } }
private bool CheckInput(string encoded) { try { using (QueriesTableAdapters.sp_DoesLoginExistTableAdapter ta = new QueriesTableAdapters.sp_DoesLoginExistTableAdapter()) { using (Queries.sp_DoesLoginExistDataTable dt = new Queries.sp_DoesLoginExistDataTable()) { ta.Fill(dt, StringCipher.Decrypt(encoded)); return dt.Rows.Count > 0; } } } catch { return false; } }
protected bool IsUsernameValid() { if (string.IsNullOrEmpty(UserName.Text.Trim())) { //invalid username due to it being empty or null return false; } else { using (QueriesTableAdapters.sp_DoesLoginExistTableAdapter ta = new QueriesTableAdapters.sp_DoesLoginExistTableAdapter()) { using (Queries.sp_DoesLoginExistDataTable dt = new Queries.sp_DoesLoginExistDataTable()) { ta.Fill(dt, UserName.Text.Trim().ToLowerInvariant()); return (((int)dt.Rows[0]["Count"]) == 0); } } } }
protected bool IsUsernameValid() { if (string.IsNullOrEmpty(UserName.Text.Trim())) { //invalid username due to it being empty or null return(false); } else { using (QueriesTableAdapters.sp_DoesLoginExistTableAdapter ta = new QueriesTableAdapters.sp_DoesLoginExistTableAdapter()) { using (Queries.sp_DoesLoginExistDataTable dt = new Queries.sp_DoesLoginExistDataTable()) { ta.Fill(dt, UserName.Text.Trim().ToLowerInvariant()); return(((int)dt.Rows[0]["Count"]) == 0); } } } }
protected void btnFinishRegistration_Click(object sender, EventArgs e) { Page.Validate(); if (Page.IsValid) { using (QueriesTableAdapters.sp_DoesLoginExistTableAdapter ta = new QueriesTableAdapters.sp_DoesLoginExistTableAdapter()) { using (Queries.sp_DoesLoginExistDataTable dt = new Queries.sp_DoesLoginExistDataTable()) { ta.Fill(dt, Session["login"].ToString().Trim().ToLowerInvariant()); if (((int)dt.Rows[0]["Count"]) == 0) { //no login of this name so clear to create a new one using (QueriesTableAdapters.QueriesTableAdapter qta = new QueriesTableAdapters.QueriesTableAdapter()) { short stateid = 0; try { stateid = Convert.ToInt16(State.SelectedValue); } catch { } DateTime dtBirthdate = DateTime.Today.Date; try { dtBirthdate = new DateTime(Convert.ToInt32(ddBirthdate_Year.SelectedValue), Convert.ToInt32(ddBirthdate_Month.SelectedValue), Convert.ToInt32(txtBirthdate_Day.Text.Trim())); } catch (ArgumentOutOfRangeException) { return; } //call stored procedure to add new user qta.sp_CreateLogin(FirstName.Text.Trim(), MiddleName.Text.Trim(), LastName.Text.Trim(), Address1.Text.Trim(), Address2.Text.Trim(), City.Text.Trim(), stateid, Zipcode.Text.Trim(), Session["login"].ToString().Trim(), StringCipher.Encrypt(Session["password"].ToString().Trim(), true), null, null, 1,//usertype Convert.ToInt32(Country.SelectedValue), Convert.ToInt32(Income.SelectedValue), Convert.ToInt16(Sex.SelectedValue), Convert.ToInt16(Race.SelectedValue), dtBirthdate, null, Session["email"].ToString().Trim(), OtherState.Text.Trim(), true, Convert.ToInt16(Timezone.SelectedValue), Convert.ToInt16(DiabetesType.SelectedValue)); } Response.Redirect("/Account/RegistrationComplete.aspx"); } } } } }