protected void Page_Load(object sender, EventArgs e)
{
using (TheClubBDEntities myEnt = new TheClubBDEntities())
{
var allSponsors = from sp in myEnt.Sponsors
orderby sp.FechaAlta
select sp;
GridView1.DataSource = allSponsors;
GridView1.DataBind();
}
}
protected void imgBtnDelete_Click(object sender, ImageClickEventArgs e)
{
using (TheClubBDEntities myEntities = new TheClubBDEntities())
{
var aRaceType = (from r in myEntities.RaceTypes
where r.Id == _Id
select r).Single();
myEntities.RaceTypes.DeleteObject(aRaceType);
myEntities.SaveChanges();
}
GridView1.DataBind();
setNormalMode();
}
protected void imgBtnCancel_Click(object sender, ImageClickEventArgs e)
{
using (TheClubBDEntities myEnt = new TheClubBDEntities())
{
var aRaceType = (from rt in myEnt.RaceTypes
orderby rt.Name ascending
where rt.Id == LastPos
select rt).SingleOrDefault();
if (aRaceType == null)
{
_Id = -1;
LastPos = -1;
}
else
{
_Id = aRaceType.Id;
txbxNombre.Text = aRaceType.Name;
txbxPuntos.Text = aRaceType.PuntosPart.ToString();
txbxMemo.Text = aRaceType.Memo;
}
setNormalMode();
}
}
protected void imgBtnFirst_Click(object sender, ImageClickEventArgs e)
{
using (TheClubBDEntities myEnt = new TheClubBDEntities())
{
var aRaceType = (from rt in myEnt.RaceTypes
orderby rt.Name ascending
select rt).FirstOrDefault();
if (aRaceType == null)
_Id = -1;
else
{
_Id = aRaceType.Id;
LastPos = _Id;
txbxNombre.Text = aRaceType.Name;
txbxPuntos.Text = aRaceType.PuntosPart.ToString();
txbxMemo.Text = aRaceType.Memo;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
using (TheClubBDEntities myEnt = new TheClubBDEntities())
{
if (!Page.IsPostBack)
{
var aRaceType = (from rt in myEnt.RaceTypes
select rt).FirstOrDefault();
if (aRaceType == null)
{
_Id = -1;
LastPos = -1;
}
else
{
_Id = aRaceType.Id;
LastPos = _Id;
txbxNombre.Text = aRaceType.Name;
txbxPuntos.Text = aRaceType.PuntosPart.ToString();
txbxMemo.Text = aRaceType.Memo;
}
}
}
}
protected void imgBtnSave_Click(object sender, ImageClickEventArgs e)
{
using (TheClubBDEntities myEntities = new TheClubBDEntities())
{
RaceType aRaceType;
if (_Id == -1) //Save new
{
aRaceType = new RaceType();
myEntities.RaceTypes.AddObject(aRaceType);
}
else
{
aRaceType = (from r in myEntities.RaceTypes
where r.Id == _Id
select r).Single();
}
aRaceType.Name = txbxNombre.Text;
aRaceType.PuntosPart = Int32.Parse(txbxPuntos.Text);
aRaceType.Memo = txbxMemo.Text;
LastPos = _Id;
myEntities.SaveChanges();
GridView1.DataBind();
setNormalMode();
}
}