public void btnAddNewTime_Click(object sender, EventArgs e) { TextBox time = (TextBox)SwimmerDetailsView.FindControl("txtTime"); Panel addNew = (Panel)SwimmerDetailsView.FindControl("pnlNewTime"); DropDownList stroke = (DropDownList)SwimmerDetailsView.FindControl("drpStroke"); DropDownList measure = (DropDownList)SwimmerDetailsView.FindControl("drpDistance"); if (Request.QueryString["SwimmerID"] != null) { int sid = Convert.ToInt32(Request.QueryString["SwimmerID"]); var newTime = new TimeRecord(); newTime.SwimmerID = sid; newTime.DistanceID = Convert.ToInt32(measure.SelectedValue); newTime.StrokeID = Convert.ToInt32(stroke.SelectedValue); newTime.Record = time.Text; using (SwimContext _db = new SwimContext()) { _db.TimeRecords.Add(newTime); _db.SaveChanges(); Repeater repeaterTimes = SwimmerDetailsView.FindControl("repTimeRecords") as Repeater; //repeaterTimes.DataSource = _db.TimeRecords.Where(t => t.Swimmer.SwimmerID == sid).ToList(); repeaterTimes.DataBind(); } if (addNew != null) { addNew.Visible = false; } } }
protected void btnAddSwimmer_Click(object sender, EventArgs e) { Boolean fileOK = false; string avatar = ""; //get avator string path = Server.MapPath("~/Images/avatars/"); if (SwimmerImage.FileName.Length > 0) { String fileExtension = System.IO.Path.GetExtension(SwimmerImage.FileName).ToLower(); String[] allowedExtensions = { ".gif", ".png", ".jpeg", ".jpg" }; for (int i = 0; i < allowedExtensions.Length; i++) { if (fileExtension == allowedExtensions[i]) { fileOK = true; } } if (fileOK) { try { // Save to Images folder. SwimmerImage.PostedFile.SaveAs(path + SwimmerImage.FileName); avatar = SwimmerImage.FileName; } catch (Exception ex) { //LabelAddStatus.Text = ex.Message; } } } else { avatar = "holder.png"; } var newSwimmer = new Swimmer(); newSwimmer.FirstName = txtFirstName.Text; newSwimmer.LastName = txtLastName.Text; newSwimmer.TeamID = Convert.ToInt32(drpTeam.SelectedValue); newSwimmer.Gender = drpGender.SelectedValue; newSwimmer.Age = Convert.ToInt32(txtAge.Text); newSwimmer.Avatar = avatar; using (SwimContext _db = new SwimContext()) { _db.Swimmers.Add(newSwimmer); _db.SaveChanges(); } Response.Redirect("~/SwimmerList.aspx"); }
public IQueryable GetStrokes() { var _db = new SwimContext(); return(_db.Strokes); }
public IQueryable GetDistanceValues() { var _db = new SwimContext(); return(_db.Distances); }
public IQueryable GetTeams() { var _db = new SwimContext(); return(_db.Teams); }