public void TestSetSport()
{
Int32 anID = 10;
string aName = "Triathlon";
string aMemo = "Esto es un ejemplo de memo";
Sport aSport = new Sport();
aSport.SetSport(anID, aName, aMemo);
Assert.AreEqual(anID, aSport.SportID);
Assert.AreEqual(aName, aSport.Name);
Assert.AreEqual(aMemo, aSport.Memo);
}
public void TestClearSportOldSportPresent()
{
Int32 anID = 10;
string aName = "Triathlon";
string aMemo = "Esto es un ejemplo de memo";
Sport aSport = new Sport(anID, aName, aMemo);
Sport oldSport = new Sport();
Assert.AreEqual(anID, aSport.SportID);
Assert.AreEqual(aName, aSport.Name);
Assert.AreEqual(aMemo, aSport.Memo);
Assert.AreEqual(0, oldSport.SportID);
Assert.AreEqual(null, oldSport.Name);
Assert.AreEqual(null, oldSport.Memo);
oldSport.CopySport(aSport);
Assert.AreEqual(anID, aSport.SportID);
Assert.AreEqual(aName, aSport.Name);
Assert.AreEqual(aMemo, aSport.Memo);
Assert.AreEqual(anID, oldSport.SportID);
Assert.AreEqual(aName, oldSport.Name);
Assert.AreEqual(aMemo, oldSport.Memo);
aSport.ClearSport();
Assert.AreEqual(0, aSport.SportID);
Assert.AreEqual(null, aSport.Name);
Assert.AreEqual(null, aSport.Memo);
Assert.AreEqual(anID, oldSport.SportID);
Assert.AreEqual(aName, oldSport.Name);
Assert.AreEqual(aMemo, oldSport.Memo);
}
public void TestSportConstructorWithoutData()
{
Int32 anID = 0;
string aName = null;
string aMemo = null;
Sport aSport = new Sport();
Assert.AreEqual(anID, aSport.SportID);
Assert.AreEqual(aName, aSport.Name);
Assert.AreEqual(aMemo, aSport.Memo);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
sportUsed = new Sport();
oldSportUsed = new Sport();
using (var db = new ClubSiteContext())
{
sportUsed = (from sports in db.Sports
orderby sports.Name
select sports).FirstOrDefault();
if (sportUsed == null)
{
sportUsed = new Sport();
X.Msg.Alert("Atención", "No hay ningún tipo de deporte registrado en la Base de datos.").Show();
}
oldSportUsed.CopySport(sportUsed);
LoadSportInForm(sportUsed);
}
}
}
public void CopySport(Sport aSport)
{
this.SportID = aSport.SportID;
this.Name = aSport.Name;
this.Memo = aSport.Memo;
}
protected void GridPanel1_Cell_Click(object sender, EventArgs e)
{
try
{
CellSelectionModel sm = this.GridPanel1.GetSelectionModel() as CellSelectionModel;
Int32 actualSportId = Convert.ToInt32(sm.SelectedCell.RecordID);
using (var db = new ClubSiteContext())
{
sportUsed = (from sports in db.Sports
orderby sports.Name
where sports.SportID == actualSportId
select sports).FirstOrDefault();
if (sportUsed == null)
{
X.Msg.Alert("Atención", "No hay ningún tipo de deporte registrado en la Base de datos.").Show();
}
oldSportUsed.CopySport(sportUsed);
LoadSportInForm(sportUsed);
}
}
catch (Exception) { }
btnBorrar.Enabled = true;
}
public void LoadSportInForm(Sport aSport)
{
txfId.Text = Convert.ToString(aSport.SportID);
txfName.Text = aSport.Name;
txfMemo.Text = aSport.Memo;
}
public void DoSave()
{
//Verify conditions
if (txfName.Text == "")
{
X.Msg.Alert("Atención", "Falta el nombre del deporte.").Show();
}
else
{
// Load the item here, e.g. item = MyDataLayer.Find(id);
using (var db = new ClubSiteContext())
{
Sport aSport;
if (sportUsed.SportID == 0)
{ //New Sport
aSport = new Sport();
aSport.Name = txfName.Text;
aSport.Memo = txfMemo.Text;
db.Sports.Add(aSport);
}
else
{ //Update actual Sport
aSport = (from sports in db.Sports
where sports.SportID == sportUsed.SportID
select sports).FirstOrDefault();
if (aSport == null)
{
// The item wasn't found
ModelState.AddModelError("", String.Format("Deporte con Id : {0} no encontrado", sportUsed.SportID));
X.Msg.Alert("Atención", "Deporte no encontrado. Grabado cancelado.").Show();
return;
}
aSport.SportID = Convert.ToInt32(txfId.Text);
aSport.Name = txfName.Text;
aSport.Memo = txfMemo.Text;
}
db.SaveChanges();
LoadSportInForm(aSport); //To update the ID (identity file)
sportUsed = aSport;
oldSportUsed.CopySport(sportUsed);
GridPanel1.DataBind();
X.Msg.Alert("Atención", "Datos de deporte grabados.").Show();
}
btnBorrar.Enabled = true;
}
}
public void DoDel()
{
Notification.Show(new NotificationConfig { Title = "Aviso", Icon = Icon.Information, Html = "Borrando el deporte en pantalla edición" });
if (sportUsed.SportID == 0)
{ //No sport selected
X.Msg.Alert("Atención", "No hay nada que borrar ya que no hay deportes registrados en la base de datos.").Show();
}
else
{
using (var db = new ClubSiteContext())
{
Sport item = (from sports in db.Sports
where sports.SportID == sportUsed.SportID
select sports).FirstOrDefault();
if (item == null)
{
// The item wasn't found
ModelState.AddModelError("", String.Format("Deporte con id : {0} no encontrado", sportUsed.SportID));
X.Msg.Alert("Atención", "Deporte no encontrado. Borrado cancelado,").Show();
return;
}
db.Sports.Remove(item);
db.SaveChanges();
this.Store1.DataBind();
X.Msg.Alert("Atención", "Tipo de carrera borrada.").Show();
//Load data for first race type
sportUsed = (from sports in db.Sports
orderby sports.Name
select sports).FirstOrDefault();
if (sportUsed == null)
{
//Last item was erased. No items in BD.
sportUsed = new Sport();
X.Msg.Alert("Atención", "No queda ningún deporte registrado en la Base de datos.").Show();
}
oldSportUsed.CopySport(sportUsed);
//Loads model object data into form
LoadSportInForm(sportUsed);
}
}
}
public void CopySport(Sport aSport)
{
this.SportID = aSport.SportID;
this.Name = aSport.Name;
this.Memo = aSport.Memo;
}
