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