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");
}
}
}
}
}
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");
}
}
}
}
}
