protected void grdActivities_RowDeleting(object sender, GridViewDeleteEventArgs e) { try { using (DefaultConnectionAL conn = new DefaultConnectionAL()) { var user = HttpContext.Current.GetOwinContext().Authentication.User.Identity.GetUserId(); Int32 ActivityID = Convert.ToInt32(grdActivities.DataKeys[e.RowIndex].Values["id"]); var activityItem = (from a in conn.activities where a.id == ActivityID select a).FirstOrDefault(); //save conn.activities.Remove(activityItem); conn.SaveChanges(); //redirect to updated departments page GetActivities(); } } catch (Exception e2) { Response.Redirect("~/error.aspx"); } }
protected void GetActivities() { try { using (DefaultConnectionAL conn = new DefaultConnectionAL()) { var user = HttpContext.Current.GetOwinContext().Authentication.User.Identity.GetUserId(); //use link to query the Departments model var activityItems = (from a in conn.activities where a.account_id == user select new { a.id, a.activity_name, a.duration } ); //bind the query result to the gridview //String sort = Session["SortColumn"] + " " + Session["SortDirection"].ToString(); //grdActivities.DataSource = activity.AsQueryable().OrderBy(sort).ToList(); grdActivities.DataSource = activityItems.ToList(); grdActivities.DataBind(); } } catch (Exception e1) { Response.Redirect("/error.aspx"); } }
protected void btnLog_Click(object sender, EventArgs e) { try { //connect using (DefaultConnectionAL conn = new DefaultConnectionAL()) { activity objA = new activity(); if (!String.IsNullOrEmpty(Request.QueryString["ActivityID"])) { int ActivityID = Convert.ToInt32(Request.QueryString["ActivityID"]); objA = (from a in conn.activities where a.id == ActivityID select a).FirstOrDefault(); //Populate the activity from the input form objA.activity_name = txtActivityName.Text; } else { //Populate the activity from the input form objA.account_id = HttpContext.Current.GetOwinContext().Authentication.User.Identity.GetUserId(); objA.activity_name = txtActivityName.Text; objA.duration = lblTimeHidden.Text; } if (String.IsNullOrEmpty(Request.QueryString["ActivityID"])) { //add conn.activities.Add(objA); } conn.SaveChanges(); Response.Redirect("activitylog.aspx"); } } catch (System.IO.IOException e3) { Server.Transfer("/error.aspx", true); } }
protected void GetName() { try { using (DefaultConnectionAL conn = new DefaultConnectionAL()) { var user = HttpContext.Current.GetOwinContext().Authentication.User.Identity.GetUserId(); var name = (from n in conn.AspNetUsers where n.Id == user select n).FirstOrDefault(); lblName.Visible = true; lblName.Text = "Hey " + name.UserName + "! Thanks for using Activity Logger! Start your active lifestyle by recording an activity now!"; } } catch (Exception e) { Response.Redirect("~/error.aspx"); } }
protected void GetActivity() { activity objA = new activity(); try { using (DefaultConnectionAL conn = new DefaultConnectionAL()) { Int32 ActivityID = Convert.ToInt32(Request.QueryString["ActivityID"]); objA = (from a in conn.activities where a.id == ActivityID select a).FirstOrDefault(); txtActivityName.Text = objA.activity_name; pnlTiming.Visible = false; btnLog.Text = "Update"; } } catch (Exception e2) { Response.Redirect("~/error.aspx"); } }