protected void btnAddFood_Click(object sender, EventArgs e)
{
//connect
using (DefaultConnection1 db = new DefaultConnection1())
{
//create a new food in memory
food fd = new food();
Int32 food_id = 0;
//check for a url
if (!String.IsNullOrEmpty(Request.QueryString["food_id"]))
{
//get the id from the url
food_id = Convert.ToInt32(Request.QueryString["food_id"]);
//look up the food
fd = (from f in db.foods
where f.food_id == food_id
select f).FirstOrDefault();
}
//importing the user_id from the session object.
Int32 user_id = Convert.ToInt32(Session["user_id"]);
//fill the properties of the new food entry
fd.food_name = txtFoodName.Text;
fd.food_calories = Convert.ToInt32(txtCalories.Text);
fd.food_date = Convert.ToDateTime(txtDate.Text);
fd.user_id = user_id;
if (food_id == 0)
{
db.foods.Add(fd);
}
//Save the food to the database.
db.SaveChanges();
//redierect to the food list page.
Response.Redirect("food_tracker.aspx");
}
}
protected void grdExercise_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
//Identify the excercise ID to be deleted from the row that the user selected from
Int32 exercise_id = Convert.ToInt32(grdExercise.DataKeys[e.RowIndex].Values["exercise_id"]);
//Connect
using (DefaultConnection1 db = new DefaultConnection1())
{
exercise ex = (from x in db.exercises
where x.exercise_id == exercise_id
select x).FirstOrDefault();
//delete
db.exercises.Remove(ex);
db.SaveChanges();
//refresh
GetExercise();
}
}
protected void grdFood_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
//indentify the food ID to be deleted from the row the user seleted from.
Int32 food_id = Convert.ToInt32(grdFood.DataKeys[e.RowIndex].Values["food_id"]);
//connect
using (DefaultConnection1 db = new DefaultConnection1())
{
food fd = (from f in db.foods
where f.food_id == food_id
select f).FirstOrDefault();
//delete
db.foods.Remove(fd);
db.SaveChanges();
//refresh
GetFood();
}
}
protected void btnAddExercise_Click(object sender, EventArgs e)
{
//Connect
using (DefaultConnection1 db = new DefaultConnection1())
{
//create new exercise in memory
exercise ex = new exercise();
Int32 exercise_id = 0;
//check for URL
if (!String.IsNullOrEmpty(Request.QueryString["exercise_id"])){
//get the id from the url
exercise_id = Convert.ToInt32(Request.QueryString["exercise_id"]);
//Look up the food
ex = (from x in db.exercises
where x.exercise_id == exercise_id
select x).FirstOrDefault();
}
//importing the user_id from the session object.
Int32 user_id = Convert.ToInt32(Session["user_id"]);
//fill the properties of the new Exercise
ex.exercise_name = txtExerciseName.Text;
ex.exercise_rep = txtReps.Text;
ex.exercise_date = Convert.ToDateTime(txtExerciseDate.Text);
ex.user_id = user_id;
if(exercise_id == 0){
db.exercises.Add(ex);
}
//Save the exercise to the data base
db.SaveChanges();
//redirect to the exercise tracker page
Response.Redirect("exercise_tracker.aspx");
}
}
protected void btnSignUp_Click(object sender, EventArgs e)
{
//connect
using (DefaultConnection1 db = new DefaultConnection1())
{
//create a new user
user objI = new user();
//fill the properties from the form inputs
objI.first_name = txtFName.Text;
objI.last_name = txtLName.Text;
objI.email = txtEmail.Text;
//salt and hash the plan text password.
String password = txtPassword.Text;
String salt = CreateSalt(8);
String pass_and_salt = password + salt;
// Create a new instance of the hash crypto service provider.
HashAlgorithm hashAlg = new SHA256CryptoServiceProvider();
// Convert the data to hash to an array of Bytes.
byte[] bytValue = System.Text.Encoding.UTF8.GetBytes(pass_and_salt);
// Compute the Hash. This returns an array of Bytes.
byte[] bytHash = hashAlg.ComputeHash(bytValue);
// Optionally, represent the hash value as a base64-encoded string,
// For example, if you need to display the value or transmit it over a network.
string base64 = Convert.ToBase64String(bytHash);
objI.password = base64;
objI.salt = salt;
//save
db.users.Add(objI);
db.SaveChanges();
}
}