public bool UpdatePreferences()
{
string connectionString = "Provider=Microsoft.JET.OLEDB.4.0;data source=" + Server.MapPath("~\\App_Data\\G2C.mdb");
OleDbConnection conn = new OleDbConnection(connectionString);
string sql;
sql = "UPDATE G2CUser SET UserName=@UserName, UserEmail=@AccEmail,";
if (txtPassword.Text.Trim() != "")
{
sql += "UserPassword=@Password,";
}
sql += "UserToName1=@ToName1,UserToEmail1=@ToEmail1,UserToSMS1=@ToSMS1,UserToName2=@ToName2,UserToEmail2=@ToEmail2,UserToSMS2=@ToSMS2,UserToName3=@ToName3,UserToEmail3=@ToEmail3,UserToSMS3=@ToSMS3,UserModifyDate=now WHERE UserId=@UserId";
OleDbCommand cmd = new OleDbCommand(sql, conn);
cmd.Parameters.Add(new OleDbParameter("@UserName", txtAccName.Text));
cmd.Parameters.Add(new OleDbParameter("@AccEmail", txtAccEmail.Text));
if (txtPassword.Text.Trim() != "")
{
cmd.Parameters.Add(new OleDbParameter("@Password", GlobalClass.encodePassword(txtPassword.Text)));
}
cmd.Parameters.Add(new OleDbParameter("@ToName1", txtToName1.Text));
cmd.Parameters.Add(new OleDbParameter("@ToEmail1", txtToEmail1.Text));
cmd.Parameters.Add(new OleDbParameter("@ToSMS1", chkToSMS1.Checked));
cmd.Parameters.Add(new OleDbParameter("@ToName2", txtToName2.Text));
cmd.Parameters.Add(new OleDbParameter("@ToEmail2", txtToEmail2.Text));
cmd.Parameters.Add(new OleDbParameter("@ToSMS2", chkToSMS2.Checked));
cmd.Parameters.Add(new OleDbParameter("@ToName3", txtToName3.Text));
cmd.Parameters.Add(new OleDbParameter("@ToEmail3", txtToEmail3.Text));
cmd.Parameters.Add(new OleDbParameter("@ToSMS3", chkToSMS3.Checked));
cmd.Parameters.Add(new OleDbParameter("@UserId", Session["UserId"]));
OleDbDataReader reader = null;
string errorMsg = "";
try
{
conn.Open();
reader = cmd.ExecuteReader();
return(true);
}
catch (Exception ex)
{
errorMsg = ex.Message;
return(false);
}
finally
{
if (reader != null)
{
reader.Close();
}
if (conn != null)
{
conn.Close();
}
}
}
public bool UpdatePassword(string psNewPassword)
{
string connectionString = "Provider=Microsoft.JET.OLEDB.4.0;data source=" + Server.MapPath("~\\App_Data\\G2C.mdb");
OleDbConnection conn = new OleDbConnection(connectionString);
string sql;
sql = "UPDATE G2CUser SET UserPassword=@Password,UserModifyDate=now";
sql += " WHERE UserEmail=@AccEmail";
OleDbCommand cmd = new OleDbCommand(sql, conn);
cmd.Parameters.Add(new OleDbParameter("@Password", GlobalClass.encodePassword(psNewPassword)));
cmd.Parameters.Add(new OleDbParameter("@AccEmail", txtEmail.Text));
OleDbDataReader reader = null;
string errorMsg = "";
try
{
conn.Open();
reader = cmd.ExecuteReader();
return(true);
}
catch (Exception ex)
{
errorMsg = ex.Message;
return(false);
}
finally
{
if (reader != null)
{
reader.Close();
}
if (conn != null)
{
conn.Close();
}
}
}
protected void btnSignIn_Click(object sender, EventArgs e)
{
// Validation Code
// Set flag to false
flgValidationError = false;
// If built in validation finds an error
//if (IsValid != true) { flgValidationError = true; }
// ** Email validation **
lblErrorEmail.Visible = false;
// Check for blank email
if (txtEmail.Text.Trim() == "")
{
lblErrorEmail.Visible = true;
flgValidationError = true;
ValidationError.Display("Email address is blank");
}
else
{
// Check for valid email format
if (GlobalClass.isValidEmail(txtEmail.Text) == false)
{
lblErrorEmail.Visible = true;
flgValidationError = true;
ValidationError.Display("Email address is formatted incorrectly");
}
}
// ** Password validation **
lblErrorPassword.Visible = false;
// Check for blank password
if (txtPassword.Text.Trim() == "")
{
lblErrorPassword.Visible = true;
flgValidationError = true;
ValidationError.Display("Password is blank");
}
if (flgValidationError == true)
{
return;
}
// Try to sign in user
if (SignInUser(txtEmail.Text, GlobalClass.encodePassword(txtPassword.Text)) == false)
{
flgValidationError = true;
ValidationError.Display("Email address or Password is incorrect");
}
else
{
GlobalClass.checkFavorites();
GlobalClass.logLogin("SignIn");
if (Request.QueryString["page"] == "List")
{
Response.Redirect("List.aspx");
}
else if (Request.QueryString["page"] == "Preferences")
{
Response.Redirect("Preferences.aspx");
}
else if (Request.QueryString["page"] == "PreferencesReset")
{
Response.Redirect("Preferences.aspx?page=PreferencesReset");
}
else
{
Response.Redirect("Shopping.aspx");
}
}
}
protected void btnCreateList_Click(object sender, EventArgs e)
{
// Validation Code
// Set flag to false
bool flgValidationError = false;
// If built in validation finds an error
//if (IsValid != true) { flgValidationError = true; }
// ** Email validation **
lblErrorEmail.Visible = false;
// Check for blank email
if (txtEmail.Text.Trim() == "")
{
lblErrorEmail.Visible = true;
flgValidationError = true;
ValidationError.Display("Email address is blank");
}
else
{
// Check for valid email format
if (GlobalClass.isValidEmail(txtEmail.Text) == false)
{
lblErrorEmail.Visible = true;
flgValidationError = true;
ValidationError.Display("Email address is formatted incorrectly");
}
}
// ** Password validation **
lblErrorPassword.Visible = false;
// Check for blank password
if (txtPassword.Text.Trim() == "")
{
lblErrorPassword.Visible = true;
flgValidationError = true;
ValidationError.Display("Password is blank");
}
else
{
// Check for password lenght
if (txtPassword.Text.Length < 6)
{
lblErrorPassword.Visible = true;
flgValidationError = true;
ValidationError.Display("Password needs to be longer");
}
}
if (flgValidationError == true)
{
return;
}
// Check for unique email
if (GlobalClass.isUniqueEmail(txtEmail.Text) == false)
{
lblErrorEmail.Visible = true;
flgValidationError = true;
ValidationError.Display("A list already exisit for this email address, use the Sign in link below to see it");
}
else
{
// Create new user account
string strUserId = System.Guid.NewGuid().ToString();
if (CreateAccount(strUserId, txtEmail.Text, GlobalClass.encodePassword(txtPassword.Text)) == false)
{
flgValidationError = true;
ValidationError.Display("Error creating account");
}
else
{
Session["UserId"] = strUserId;
Session["DisplayName"] = txtEmail.Text;
Session["FirstVisit"] = "Yes";
Session["Favorites"] = "1"; // new
// write coded user id cookie
//http://stackoverflow.com/questions/1093181/how-can-i-encrypt-a-cookie-content-in-a-simple-way-in-c-3-0
var plainBytes = Encoding.ASCII.GetBytes(strUserId);
var codedBytes = plainBytes;
Response.Cookies["timeout"].Value = Convert.ToBase64String(codedBytes);
Response.Cookies["timeout"].Expires = DateTime.Now.AddDays(30);
CreateSampleItems(strUserId, 3, "Milk", 8, 3.49, 2, "Whole");
CreateSampleItems(strUserId, 1, "White Bread", 1, 1.25, 1, "Check for fresh");
CreateSampleItems(strUserId, 5, "Ice Cream", 4, 4, 0, "Gallon of Vanilla");
CreateSampleItems(strUserId, 3, "Ceddar Cheese", 7, 2, 1, "Small bag shredded");
CreateSampleItems(strUserId, 3, "Eggs", 8, 2.25, 1, "Large, Grade A");
CreateSampleItems(strUserId, 8, "Paper Towels", 0, 0, 1, "");
CreateSampleItems(strUserId, 2, "Ground Chuck", 1, 6.50, 1, "2 pounds");
CreateSampleItems(strUserId, 6, "Tomatoes", 10, 0, 3, "Get extra if they look good");
CreateSampleItems(strUserId, 1, "~", 0, 0, 0, "");
EmailWelcome(txtEmail.Text);
GlobalClass.logLogin("Home - New Account");
Response.Redirect("List.aspx");
}
}
}
