protected void Unnamed1_LoggedIn(object sender, EventArgs e)
{
//Search user in BD and obtain his active value
string user = LoginControl.UserName;
bool canPass = false;
//Search for user in users BD to check his state.
//Search for user in users BD to check his state.
using (var db = new ClubSiteContext())
{
var userData = (from users in db.Members
where users.UserName == user
select users).FirstOrDefault();
if (userData != null)
canPass = userData.State;
}
if (!canPass)
{
FormsAuthentication.SignOut();
FormsAuthentication.RedirectToLoginPage();
Response.Redirect("/Account/LoginNotActive.aspx");
}
}
protected void RegisterUser_CreatedUser(object sender, EventArgs e)
{
//save aditional DataBind of user
using (var bd = new ClubSiteContext())
{
try
{
string aUserName = ((TextBox)RegisterUser.CreateUserStep.ContentTemplateContainer.FindControl("UserName")).Text;
string aFirstName = ((TextBox)RegisterUser.CreateUserStep.ContentTemplateContainer.FindControl("txbxName")).Text;
string aSecondName = ((TextBox)RegisterUser.CreateUserStep.ContentTemplateContainer.FindControl("txbxSecondName")).Text;
string aBlogURL = ((TextBox)RegisterUser.CreateUserStep.ContentTemplateContainer.FindControl("txbxBlog")).Text;
string aMemo = ((TextBox)RegisterUser.CreateUserStep.ContentTemplateContainer.FindControl("txbxMemo")).Text;
string aDNI = ((TextBox)RegisterUser.CreateUserStep.ContentTemplateContainer.FindControl("txbxDNI")).Text;
DateTime? aBirthDate = null;
try
{
aBirthDate = Convert.ToDateTime(((TextBox)RegisterUser.CreateUserStep.ContentTemplateContainer.FindControl("txbxBdate")).Text);
}
catch
{
aBirthDate = null;
}
DateTime aRegDate = DateTime.Now;
bool aState = false;
bool visible = false;
bool federated = ((CheckBox)RegisterUser.CreateUserStep.ContentTemplateContainer.FindControl("chbxFederated")).Checked;
string aNImageURL = ((Image)RegisterUser.CreateUserStep.ContentTemplateContainer.FindControl("imgNImageURL")).ImageUrl;
string anImageURL = ((Image)RegisterUser.CreateUserStep.ContentTemplateContainer.FindControl("imgImageURL")).ImageUrl;
string aTlf = ((TextBox)RegisterUser.CreateUserStep.ContentTemplateContainer.FindControl("txbxTlf")).Text;
string aMobile = ((TextBox)RegisterUser.CreateUserStep.ContentTemplateContainer.FindControl("txbxMobile")).Text;
string anEMail = ((TextBox)RegisterUser.CreateUserStep.ContentTemplateContainer.FindControl("Email")).Text;
string aClubNumber = ((TextBox)RegisterUser.CreateUserStep.ContentTemplateContainer.FindControl("txbxClubNumber")).Text;
string aStreet = ((TextBox)RegisterUser.CreateUserStep.ContentTemplateContainer.FindControl("txbxStreet")).Text;
string aNumber = ((TextBox)RegisterUser.CreateUserStep.ContentTemplateContainer.FindControl("txbxNumber")).Text;
string aCity = ((TextBox)RegisterUser.CreateUserStep.ContentTemplateContainer.FindControl("txbxCity")).Text;
string aCountry = ((TextBox)RegisterUser.CreateUserStep.ContentTemplateContainer.FindControl("txbxCountry")).Text;
string aPostalCode = ((TextBox)RegisterUser.CreateUserStep.ContentTemplateContainer.FindControl("txbxPostalCode")).Text;
Address anAddress = new Address(aStreet, aNumber, aCity, aCountry, aPostalCode);
Member aMember = new Member(aUserName, aClubNumber, aFirstName, aSecondName, aDNI, anAddress, aTlf, aMobile, anEMail,
aState, federated, visible, aBirthDate, aMemo, anImageURL, aNImageURL, aBlogURL);
bd.Members.Add(aMember);
bd.SaveChanges();
}
catch (Exception)
{
throw;
}
}
FormsAuthentication.SetAuthCookie(RegisterUser.UserName, createPersistentCookie: false);
string continueUrl = RegisterUser.ContinueDestinationPageUrl;
if (!OpenAuth.IsLocalUrl(continueUrl))
{
continueUrl = "~/";
}
Response.Redirect(continueUrl);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!X.IsAjaxRequest)
{
try
{
aRaceID = Convert.ToInt32(Request.QueryString["Id"]);
//Search data for SponsorId
using (ClubSiteContext db = new ClubSiteContext())
{
Race aRace = (from r in db.Races where r.Id == aRaceID select r).FirstOrDefault();
//Puts data into web forms
txbxID.Text = Convert.ToString(aRace.Id);
txbxDate.Text = Convert.ToString(aRace.RaceDate);
txbxRaceType.Text = aRace.RaceType.Name;
txbxPoints.Text = Convert.ToString(aRace.RaceType.Points);
imgImage.ImageUrl = aRace.ImageURL;
txbxName.Text = aRace.Name;
if (aRace.Address != null)
{
txbxStreet.Text = aRace.Address.Street;
txbxNumber.Text = aRace.Address.Number;
txbxCity.Text = aRace.Address.City;
txbxCountry.Text = aRace.Address.Country;
txbxPostalCode.Text = aRace.Address.PostalCode;
}
txbxMemo.Text = aRace.Memo;
//Load data for map
////To avoid problems with the , and . in decimal numbers
System.Globalization.CultureInfo culture = new System.Globalization.CultureInfo("en-US");
txbxLatitud.Text = Convert.ToString(aRace.Latitud, culture);
txbxLongitud.Text = Convert.ToString(aRace.Longitud, culture);
//Loads data for clubbers in race selected ordered by UserName
var aRace2 = (from r in db.Races
where r.Id == aRaceID
select r).FirstOrDefault();
var membersInRace = from m in aRace2.Members
where m.State == true
orderby m.UserName
select new { m.UserName, m.ImageURL, m.NImageURL, m.BlogURL, m.SecondName, m.FirstName, m.Number };
this.StoreGPClubbersEnComp.DataSource = membersInRace;
this.StoreGPClubbersEnComp.DataBind();
}
}
catch (Exception)
{
txbxName.Text = "";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
int aSponsorId;
try
{
aSponsorId = Convert.ToInt32(Request.QueryString["SponsorId"]);
//Search data for SponsorId
using (ClubSiteContext db = new ClubSiteContext())
{
Sponsor aSponsor = (from sp in db.Sponsors where sp.SponsorId == aSponsorId select sp).FirstOrDefault();
//Puts data into web forms
laSponsorName.Text = aSponsor.Nombre;
imgLogo.ImageUrl = aSponsor.LogoURL;
imgImage.ImageUrl = aSponsor.ImageURL;
txbxCondiciones.Text = aSponsor.CondOfertadas;
hlWebSite.Text = aSponsor.WebURL;
hlWebSite.NavigateUrl = aSponsor.WebURL;
laTlf.Text = aSponsor.Tlf;
laMail.Text = aSponsor.EMail;
if (aSponsor.Address!=null)
{
laCalle.Text=aSponsor.Address.Street;
laNumero.Text=aSponsor.Address.Number;
laCiudad.Text=aSponsor.Address.City;
laProvincia.Text=aSponsor.Address.Country;
laCPostal.Text=aSponsor.Address.PostalCode;
}
//Load data for map
////To avoid problems with the , and . in decimal numbers
System.Globalization.CultureInfo culture = new System.Globalization.CultureInfo("en-US");
txbxLatitud.Text = Convert.ToString(aSponsor.Latitud, culture);
txbxLongitud.Text = Convert.ToString(aSponsor.Longitud, culture);
//Hide parts if user is not registered
try
{
string user = Membership.GetUser().UserName;
}
catch (Exception)
{
laCondiciones.Visible = false;
txbxCondiciones.Visible = false;
}
}
}
catch (Exception)
{
laSponsorName.Text = "";
}
}
protected void btnOrderUsername_Click(object sender, DirectEventArgs e)
{
using (var db = new ClubSiteContext())
{
var data = from m in db.Members
orderby m.UserName
where (m.State == true) && (m.Visible == true)
select new { m.UserName, m.ImageURL, m.NImageURL, m.BlogURL, m.SecondName, m.FirstName };
this.Store1.DataSource = data;
this.Store1.DataBind();
}
}
protected void btnOrderUsername_Click(object sender, DirectEventArgs e)
{
using (var db = new ClubSiteContext())
{
var aRace2 = (from r in db.Races
where r.Id == aRaceID
select r).FirstOrDefault();
StoreGPClubbersEnComp.DataSource = from m in aRace2.Members
where m.State == true
orderby m.UserName
select new { m.UserName, m.ImageURL, m.NImageURL, m.BlogURL, m.SecondName, m.FirstName, m.Number };
StoreGPClubbersEnComp.DataBind();
}
}
protected void btnOrderName_Click(object sender, DirectEventArgs e)
{
DateTime fromDate = dtfFromDate.SelectedDate;
DateTime toDate = dtfToDate.SelectedDate;
using (var db = new ClubSiteContext())
{
var data = from r in db.Races
orderby r.Name, r.RaceDate
where (r.RaceDate >= fromDate) && (r.RaceDate <= toDate)
select new { RaceId = r.Id, r.Name, r.RaceDate, r.ImageURL };
this.Store1.DataSource = data;
this.Store1.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!X.IsAjaxRequest)
{
using (var db = new ClubSiteContext())
{
var data = from s in db.Sponsors
orderby s.Nombre
where (s.Activo == true)
select new { s.Nombre, s.LogoURL, s.SponsorId };
this.Store1.DataSource = data;
this.Store1.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!X.IsAjaxRequest)
{
using (var db = new ClubSiteContext())
{
var data = from m in db.Members
orderby m.UserName
where (m.State == true) && (m.Visible == true)
select new { m.UserName, m.ImageURL, m.NImageURL, m.BlogURL, m.SecondName, m.FirstName };
this.Store1.DataSource = data;
this.Store1.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!X.IsAjaxRequest)
{
DateTime fromDate= new DateTime(DateTime.Now.Year,1,1);
DateTime toDate = new DateTime(DateTime.Now.Year, 12, 31);
dtfFromDate.SelectedDate = fromDate;
dtfToDate.SelectedDate = toDate;
using (var db = new ClubSiteContext())
{
var data = from r in db.Races
orderby r.Name, r.RaceDate
where (r.RaceDate>=fromDate) && (r.RaceDate<=toDate)
select new { RaceId = r.Id, r.Name, r.RaceDate, r.ImageURL };
this.Store1.DataSource = data;
this.Store1.DataBind();
}
}
}
public void DoDelAllRaces()
{
//Del all races between fromDate and toDate
DateTime fromDate = dtfFromDate.SelectedDate;
DateTime toDate = dtfToDate.SelectedDate;
using (var db = new ClubSiteContext())
{
Member aMember = (from m in db.Members
where m.UserName == memberUsed.UserName
select m).FirstOrDefault();
if (aMember == null)
{
// The item wasn't found
ModelState.AddModelError("", String.Format("Clubber : {0} no encontrada", memberUsed.UserName));
X.Msg.Alert("Atención", "Clubber no encontrado. Borrado de competiciones cancelado,").Show();
return;
}
var dataToRemove = from r in aMember.Races where r.RaceDate >= fromDate && r.RaceDate <= toDate select r;
foreach (Race aRaceToRemove in dataToRemove.ToList())
{
aMember.Races.Remove(aRaceToRemove);
}
db.SaveChanges();
LoadDataInGridForRacesForClubber();
X.Msg.Alert("Atención", "Todas las competiciones del clubber entre el " + fromDate.ToShortDateString() +
" y el " + toDate.ToShortDateString() + "han sido borradas.").Show();
}
}
public void DoDel()
{
//1-Delete user in Member table in ClubSite.mdf DB
using (var db = new ClubSiteContext())
{
//Delete the user
var aClubberToDelete = (from c in db.Members
where c.UserName == actualUserName
select c).Single();
db.Members.Remove(aClubberToDelete);
db.SaveChanges();
//Delete de Image files for the user
if (System.IO.File.Exists(Server.MapPath(imgNImage.ImageUrl)))
System.IO.File.Delete(Server.MapPath(imgNImage.ImageUrl));
if (System.IO.File.Exists(Server.MapPath(imgImage.ImageUrl)))
System.IO.File.Delete(Server.MapPath(imgImage.ImageUrl));
Notification.Show(new NotificationConfig { Title = "Aviso", Icon = Icon.Information, Html = "Usuario "+ actualUserName +" borrado correctamente." });
}
//2-Delete user in Membership and Users tables in ClubSiteBDDefault DB
Membership.DeleteUser(actualUserName);
//3-Load data for the first member into the form.
using (var db = new ClubSiteContext())
{
var aMember = (from members in db.Members
orderby members.UserName
select members).FirstOrDefault();
if (aMember == null)
{
actualUserName = "";
memberUsed = new Member();
LoadMemberInForm(memberUsed);
Notification.Show(new NotificationConfig { Title = "Aviso", Icon = Icon.Information, Html = "Ya no hay ningún usuario registrado. Para crear nuevos usuarios vaya al formulario de registro." });
}
else
{
LoadMemberInForm(aMember);
memberUsed.CopyMember(aMember);
}
oldMemberUsed.CopyMember(memberUsed);
}
//4-Refresh the GridView
GPClubbers.DataBind();
}
protected void GPSponsors_CellClick(object sender, EventArgs e)
{
//Click a Sponsor in grid and show data in edit boxes
try
{
CellSelectionModel sm = this.GPSponsors.GetSelectionModel() as CellSelectionModel;
Int32 actualSId = Convert.ToInt32(sm.SelectedCell.RecordID);
//Search the Sponsor and load into model object.
using (var db = new ClubSiteContext())
{
sponsorUsed = (from sponsors in db.Sponsors
orderby sponsors.Nombre
where sponsors.SponsorId == actualSId
select sponsors).FirstOrDefault();
if (sponsorUsed == null)
X.Msg.Alert("Atención", "No hay ningún sponsor registrado en la Base de datos.").Show();
oldSponsorUsed.CopySponsor(sponsorUsed);
//Loads model object data into form
LoadSponsorInForm(sponsorUsed);
}
}
catch (Exception) { }
btnBorrar.Enabled = true;
}
public void DoDel()
{
if (sponsorUsed.SponsorId == 0)
{ //No Race Type selected
X.Msg.Alert("Atención", "No hay nada que borrar ya que no hay sponsors registrados.").Show();
}
else
{
using (var db = new ClubSiteContext())
{
Sponsor item = (from sponsors in db.Sponsors
where sponsors.SponsorId == sponsorUsed.SponsorId
select sponsors).FirstOrDefault();
if (item == null)
{
// The item wasn't found
ModelState.AddModelError("", String.Format("Sponsor con id : {0} no encontrado", sponsorUsed.SponsorId));
X.Msg.Alert("Atención", "Sponsor no encontrado").Show();
return;
}
db.Sponsors.Remove(item);
db.SaveChanges();
this.StoreGPSponsors.DataBind();
X.Msg.Alert("Atención", "Sponsor borrado.").Show();
//Load data for first race type
sponsorUsed = (from sponsors in db.Sponsors
orderby sponsors.Nombre
select sponsors).FirstOrDefault();
if (sponsorUsed == null)
{
//Last item was erased. No items in BD.
sponsorUsed = new Sponsor();
X.Msg.Alert("Atención", "No queda ningún sponsor registrado en la Base de datos.").Show();
}
oldSponsorUsed.CopySponsor(sponsorUsed);
//Loads model object data into form
LoadSponsorInForm(sponsorUsed);
}
}
}
protected void StoreGPRacesForClubber_ReadData(object sender, StoreReadDataEventArgs e)
{
using (var db = new ClubSiteContext())
{
Store store = this.GPRacesForClubber.GetStore();
var aMember = (from m in db.Members
where m.UserName == memberUsed.UserName
select m).FirstOrDefault();
if (aMember != null)
{
store.DataSource = from r in aMember.Races
orderby r.RaceDate
select new { RaceId = r.Id, r.Name, RDate = r.RaceDate, SportName = r.RaceType.Sport.Name, RaceTypeName = r.RaceType.Name };
store.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!X.IsAjaxRequest)
{
memberUsed = new Member();
oldMemberUsed = new Member();
newNumber = false;
newImage = false;
newNImage = false;
using (var db = new ClubSiteContext())
{
memberUsed = (from members in db.Members
orderby members.UserName
select members).FirstOrDefault();
if (memberUsed == null)
{
actualUserName = "";
Notification.Show(new NotificationConfig { Title = "Atención", Icon = Icon.Error, Html = "No hay ningún usuario registrado en la Base de datos. Vaya al formulario de registro para crear nuevos usuarios." });
}
else
{
actualUserName = memberUsed.UserName;
//Load Dates
DateTime fromDate = new DateTime(DateTime.Now.Year, 1, 1);
DateTime toDate = new DateTime(DateTime.Now.Year, 12, 31);
dtfFromDate.SelectedDate = fromDate;
dtfToDate.SelectedDate = toDate;
//Load data for Races combobox
LoadDataInRacesCombo();
//Load data for races for the clubber selected
LoadDataInGridForRacesForClubber();
}
LoadMemberInForm(memberUsed);
oldMemberUsed.CopyMember(memberUsed);
}
}
}
protected void GVClubbers_Click(object sender, EventArgs e)
{
try
{
CellSelectionModel sm = this.GPClubbers.GetSelectionModel() as CellSelectionModel;
string actualRId = sm.SelectedCell.RecordID;
using (var db = new ClubSiteContext())
{
memberUsed = (from m in db.Members
where m.UserName == actualRId
select m).FirstOrDefault();
if (memberUsed == null)
X.Msg.Alert("Atención", "No hay ningun clubber registrada en la Base de datos.").Show();
oldMemberUsed.CopyPerson(memberUsed);
//Loads model object data into form
LoadMemberInForm(memberUsed);
}
}
catch (Exception) { }
}
public void DoDelRace()
{
bool sigue = true;
string messageError = "";
//Verify race exists
if (txbxUserName.Text == "")
{
sigue = false;
messageError = "No hay competiciones que quitar.";
}
if (sigue)
{
if (actualRaceId == 0)
{
messageError = "Seleccione una competición para quitar de la tabla.";
sigue = false;
}
}
if (sigue)
{
//Load data for username
using (var db = new ClubSiteContext())
{
Member aMember = new Member();
Race aRace = new Race();
aMember = (from m in db.Members where m.UserName == memberUsed.UserName select m).FirstOrDefault();
aRace = (from r in db.Races where r.Id == actualRaceId select r).FirstOrDefault();
try
{
aRace.Members.Remove(aMember);
db.SaveChanges();
LoadDataInGridForRacesForClubber();
X.Msg.Alert("Atención", memberUsed.UserName + " quitad@ de la competición.").Show();
}
catch (Exception)
{
X.Msg.Alert("Atención", "Hubo un problema al quitar a " + memberUsed.UserName + " de la competición seleccionada.").Show();
}
}
}
if (!sigue)
{
X.Msg.Alert("Atención", messageError).Show();
}
}
public void DoSave()
{
bool sigue = true;
bool nuevo = false;
string messageError = null;
//Save if conditions are ok.
if (sigue)
{
//Update actual member
actualUserName = txbxUserName.Text;
using (var db = new ClubSiteContext())
{
Member aMember = (from members in db.Members
where members.UserName == actualUserName
select members).FirstOrDefault();
if (aMember == null)
{ //New User
aMember = new Member();
aMember.UserName = actualUserName;
nuevo = true;
}
try
{
aMember.FirstName = txbxFirstName.Text;
aMember.SecondName = txbxSecondName.Text;
aMember.BlogURL = txbxBlogURL.Text;
aMember.Memo = txbxMemo.Text;
aMember.DNI = txbxDNI.Text;
if (txbxBdate.Value.ToString() == "01/01/0001 0:00:00")
{
aMember.BirthDate = null;
}
else
{
try
{
aMember.BirthDate = Convert.ToDateTime(txbxBdate.Text);
}
catch
{
aMember.BirthDate = null;
}
}
aMember.Federated = chbxFederated.Checked;
aMember.State = chBxActiveUser.Checked;
aMember.Visible = chbxVisible.Checked;
if (FileUploadNumber.HasFile)
{
aMember.NImageURL = "../Images/Clubbers/" + FileUploadNumber.FileName; //imgNImage.ImageUrl;
}
else
{
aMember.NImageURL = memberUsed.NImageURL;
}
if (FileUploadImage.HasFile)
{
aMember.ImageURL = "../Images/Clubbers/" + FileUploadImage.FileName; //imgImage.ImageUrl;
}
else
{
aMember.ImageURL = memberUsed.ImageURL;
}
aMember.Tlf = txbxTlf.Text;
aMember.Mobile = txbxMobile.Text;
aMember.EMail = txbxEMail.Text;
if (nuevo)
{
aMember.Address = new Address();
}
aMember.Address.Street = txbxStreet.Text;
aMember.Address.Number = txbxNumber.Text;
aMember.Address.City = txbxCity.Text;
aMember.Address.Country = txbxCountry.Text;
aMember.Address.PostalCode = txbxPostalCode.Text;
aMember.Number = txbxClubberNumber.Text;
if (nuevo)
{
db.Members.Add(aMember);
}
db.SaveChanges();
memberUsed.CopyMember(aMember);
oldMemberUsed.CopyMember(aMember);
Notification.Show(new NotificationConfig { Title = "Aviso", Icon = Icon.Information, Html = "Datos del usuario "+ actualUserName +" grabados" });
}
catch (Exception)
{
sigue = false;
messageError = " No se grabaron los datos, se produjo un error al acceder a la base";
}
GPClubbers.DataBind();
newNumber = false;
newImage = false;
}
}
if (!sigue)
{
X.Msg.Alert("Atención", messageError).Show();
}
}
public void DoDelAllClubbers()
{
//Del all races
using (var db = new ClubSiteContext())
{
Race aRace = (from races in db.Races
where races.Id == rUsed.Id
select races).FirstOrDefault();
if (aRace == null)
{
// The item wasn't found
ModelState.AddModelError("", String.Format("Competición con id : {0} no encontrada", rUsed.Id));
X.Msg.Alert("Atención", "Competición no encontrada. Borrado cancelado,").Show();
return;
}
aRace.Members.Clear();
db.SaveChanges();
LoadDataInGridForMembersInRace();
X.Msg.Alert("Atención", "Clubbers inscritos en la carrera borrados.").Show();
}
}
protected void LoadDataInGridForRacesForClubber()
{
using (var db = new ClubSiteContext())
{
Store store = this.GPRacesForClubber.GetStore();
var aMember = (from m in db.Members
where m.UserName == memberUsed.UserName
select m).FirstOrDefault();
if (aMember != null)
{
store.DataSource = from r in aMember.Races
orderby r.RaceDate
select new { RaceId = r.Id, r.Name, RDate = r.RaceDate, SportName = r.RaceType.Sport.Name, RaceTypeName = r.RaceType.Name };
}
else
{
store.DataSource = new List<Races>();
}
store.DataBind();
}
}
public void DoSave()
{
bool sigue = true;
string messageError = null;
//Save if conditions are ok.
if (sigue)
{
using (var db = new ClubSiteContext())
{
Race aRace;
if (rUsed.Id == 0)
{ //New Race
aRace = new Race();
aRace.Name = txbxName.Text;
aRace.Name = txbxName.Text;
aRace.RaceDate = Convert.ToDateTime(txbxDate.Text);
aRace.ImageURL = rUsed.ImageURL;
aRace.RaceTypeID = aRaceIdSelectedInCombo;
try
{
aRace.PartFem = Convert.ToInt16(txbxPartGenFem.Text);
}
catch (Exception)
{
aRace.PartFem = 0;
}
try
{
aRace.PartMasc = Convert.ToInt16(txbxPartGenMasc.Text);
}
catch (Exception)
{
aRace.PartMasc = 0;
}
Address anAddres = new Address(txbxStreet.Text, txbxNumber.Text, txbxCity.Text, txbxCountry.Text, txbxPostalCode.Text);
aRace.Address = anAddres;
aRace.Memo = txbxMemo.Text;
string aux = ReformatNumber(txbxLatitud.Text);
if (aux == null)
aRace.Latitud = 0;
else
{
aRace.Latitud = Convert.ToDouble(aux);
}
aux = ReformatNumber(txbxLongitud.Text);
if (aux == null)
aRace.Longitud = 0;
else
{
aRace.Longitud = Convert.ToDouble(aux);
}
db.Races.Add(aRace);
messageError = "Nueva competición grabada";
}
else
{ //Update actual Race
aRace = (from races in db.Races
where races.Id == rUsed.Id
select races).FirstOrDefault();
if (aRace == null)
{
// The item wasn't found
ModelState.AddModelError("", String.Format("Competición con Id : {0} no encontrada", rUsed.Id));
X.Msg.Alert("Atención", "Competición no encontrada. Grabación de datos cancelada.").Show();
return;
}
aRace.Name = txbxName.Text;
aRace.RaceDate = Convert.ToDateTime(txbxDate.Text);
aRace.ImageURL = rUsed.ImageURL;
aRace.RaceTypeID = aRaceIdSelectedInCombo;
Address anAddres = new Address(txbxStreet.Text, txbxNumber.Text, txbxCity.Text, txbxCountry.Text, txbxPostalCode.Text);
aRace.Address = anAddres;
aRace.Memo = txbxMemo.Text;
string aux = ReformatNumber(txbxLatitud.Text);
if (aux == null)
aRace.Latitud = 0;
else
{
aRace.Latitud = Convert.ToDouble(aux);
}
aux = ReformatNumber(txbxLongitud.Text);
if (aux == null)
aRace.Longitud = 0;
else
{
aRace.Longitud = Convert.ToDouble(aux);
}
messageError = "Datos de competición actualizados";
}
db.SaveChanges();
LoadRaceInForm(aRace); //To update the ID (identity file)
rUsed.CopyRace(aRace);
oldRUsed.CopyRace(rUsed);
StoreGPRaces.DataBind();
X.Msg.Alert("Atención", messageError).Show();
}
btnBorrar.Enabled = true;
}
else
{
X.Msg.Alert("Atención", messageError).Show();
}
}
protected void StoreCbRaces_ReadData(object sender, StoreReadDataEventArgs e)
{
using (var db = new ClubSiteContext())
{
DateTime fromDate = dtfFromDate.SelectedDate;
DateTime toDate = dtfToDate.SelectedDate;
Store store = this.cbRaces.GetStore();
store.DataSource = from r in db.Races
join rt in db.RaceTypes on r.RaceTypeID equals rt.RaceTypeID
join s in db.Sports on rt.SportID equals s.SportID
where r.RaceDate >= fromDate && r.RaceDate <= toDate
orderby s.Name, rt.Name, r.Name
select new { RaceId = r.Id, Name = r.Name + " (" + s.Name + " " + rt.Name + ")" };
store.DataBind();
}
}
//protected void btnDelClubber_Click(object sender, EventArgs e)
//{
// //string messageError = "";
// //String memberUserName = lbClubbersTakingPart.Text;
// //ListItem memberToDelete = lbClubbersTakingPart.Items.FindByValue(memberUserName);
// //if (memberToDelete == null)
// //{
// // messageError = "<script>alert('No hay Clubbers para borrar de la carrera')</script>";
// //}
// //else
// //{
// // //Delete clubber/race from BD
// // DeleteClubberTakingPartInRace(memberUserName);
// // //Delete clubber from List Box
// // lbClubbersTakingPart.Items.Remove(memberToDelete);
// // messageError = "<script>alert('Clubbers borrado de la carrera')</script>";
// //}
// //Response.Write(messageError);
//}
////private void DeleteClubberTakingPartInRace(string memberUserName)
////{
//// using (var db = new ClubSiteContext())
//// {
//// Race aRace = (from r in db.Races
//// where r.Id == rUsed.Id
//// select r).FirstOrDefault();
//// Member aMember = (from m in db.Members
//// where m.UserName == memberUserName
//// select m).FirstOrDefault();
//// aRace.Members.Remove(aMember);
//// db.SaveChanges();
//// }
////}
protected void cbRaceTypesChangeValue(object sender, DirectEventArgs e)
{
//Search points for RaceType Selected
string points = "";
try
{
Int32 aRaceTypeId = Convert.ToInt32(cbRaceTypes.SelectedItem.Value);
using (var db = new ClubSiteContext())
{
RaceType aRT = (from rt in db.RaceTypes
where rt.RaceTypeID == aRaceTypeId
select rt).FirstOrDefault();
if (aRT != null)
points = Convert.ToString(aRT.Points);
}
txbxPoints.Text = points;
}
catch (Exception)
{
txbxPoints.Text = "";
}
}
private bool VerifyIfRaceExist(int actualRaceId)
{
bool exist = false;
using (var db = new ClubSiteContext())
{
var item = (from r in db.Races where r.Id == actualRaceId select r).FirstOrDefault();
if (item != null) exist = true;
}
return exist;
}
protected void GPRaces_Cell_Click(object sender, EventArgs e)
{
try
{
CellSelectionModel sm = this.GPRaces.GetSelectionModel() as CellSelectionModel;
Int32 actualRId = Convert.ToInt32(sm.SelectedCell.RecordID);
using (var db = new ClubSiteContext())
{
rUsed = (from races in db.Races
where races.Id == actualRId
select races).FirstOrDefault();
if (rUsed == null)
X.Msg.Alert("Atención", "No hay ninguna carrera registrada en la Base de datos.").Show();
oldRUsed.CopyRace(rUsed);
//Loads model object data into form
LoadRaceInForm(rUsed);
}
}
catch (Exception) { }
btnBorrar.Enabled = true;
}
public void DoSave()
{
bool sigue = true;
string messageError = null;
//Save if conditions are ok.
if (sigue)
{
// Load the item here, e.g. item = MyDataLayer.Find(id);
using (var db = new ClubSiteContext())
{
Sponsor aSponsor;
if (sponsorUsed.SponsorId == 0)
{ //New Race Type
//aSponsor = new Sponsor();
aSponsor = LoadSponsorFromForm();
db.Sponsors.Add(aSponsor);
}
else
{ //Update actual Race Type
aSponsor = (from sponsors in db.Sponsors
where sponsors.SponsorId == sponsorUsed.SponsorId
select sponsors).FirstOrDefault();
if (aSponsor == null)
{
// The item wasn't found
ModelState.AddModelError("", String.Format("Sponsor con Id : {0} no encontrada", sponsorUsed.SponsorId));
X.Msg.Alert("Atención", "Sponsor no encontrado, grabación cancelada").Show();
return;
}
aSponsor.LogoURL = sponsorUsed.LogoURL;
aSponsor.ImageURL = sponsorUsed.ImageURL;
aSponsor.Nombre = txbxNombre.Text;
aSponsor.ContactPerson = txbxContacto.Text;
aSponsor.RegDate = Convert.ToDateTime(txbxRegDate.Text);
aSponsor.Activo = chbcActivo.Checked;
try
{
aSponsor.AportInicial = Convert.ToDecimal(txbxAportInicial.Text);
}
catch (Exception)
{
aSponsor.AportInicial = 0;
}
try
{
aSponsor.AportRecibida = Convert.ToDecimal(txbxAportRecibida.Text);
}
catch (Exception)
{
aSponsor.AportRecibida = 0;
}
aSponsor.CondOfertadas = txbxCondOfertadas.Text;
aSponsor.WebURL = txbxBlogURL.Text;
aSponsor.EMail = txbxEMail.Text;
aSponsor.Mobile = txbxMobile.Text;
aSponsor.Tlf = txbxTlf.Text;
aSponsor.Memo = txbxMemo.Text;
aSponsor.Address.Street = txbxStreet.Text;
aSponsor.Address.City = txbxCity.Text;
aSponsor.Address.Number = txbxNumber.Text;
aSponsor.Address.Country = txbxCountry.Text;
aSponsor.Address.PostalCode = txbxPostalCode.Text;
string aux = ReformatNumber(txbxLatitud.Text);
if (aux == null)
aSponsor.Latitud = 0;
else
{
aSponsor.Latitud = Convert.ToDouble(aux);
}
aux = ReformatNumber(txbxLongitud.Text);
if (aux == null)
aSponsor.Longitud = 0;
else
{
aSponsor.Longitud= Convert.ToDouble(aux);
}
}
db.SaveChanges();
LoadSponsorInForm(aSponsor); //To update the ID (identity file)
sponsorUsed.CopySponsor(aSponsor);
oldSponsorUsed.CopySponsor(sponsorUsed);
this.StoreGPSponsors.DataBind();
X.Msg.Alert("Atención", "Datos de sponsor grabados.").Show();
}
btnBorrar.Enabled = true;
}
else
{
X.Msg.Alert("Atención", messageError).Show();
}
}
protected void LoadDataInGridForClubbers()
{
using (var db = new ClubSiteContext())
{
//Load data for clubbers combobox
Store storeClubbers = this.cbClubbers.GetStore();
storeClubbers.DataSource = from m in db.Members
where m.State == true
orderby m.SecondName, m.FirstName
select new { m.UserName, Name = (m.SecondName + ", " + m.FirstName) };
storeClubbers.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
sponsorUsed = new Sponsor();
oldSponsorUsed = new Sponsor();
using (var db = new ClubSiteContext())
{
sponsorUsed = (from sponsors in db.Sponsors
orderby sponsors.Nombre
select sponsors).FirstOrDefault();
if (sponsorUsed == null)
{
sponsorUsed = new Sponsor();
Response.Write("<script>alert('No hay ningún Sponsor registrado en la Base de datos.')</script>");
}
oldSponsorUsed.CopySponsor(sponsorUsed);
LoadSponsorInForm(sponsorUsed);
}
}
}
public void DoAddRace()
{
bool sigue = true;
string messageError = "";
//Load data for Race/Clubber
using (var db = new ClubSiteContext())
{
Member aMember = new Member();
Race aRace = new Race();
aMember = (from m in db.Members where m.UserName == memberUsed.UserName select m).FirstOrDefault();
aRace = (from r in db.Races where r.Id == actualRaceId select r).FirstOrDefault();
//verify if member is in members list for race
if (aRace.Members.Contains(aMember) == true)
{
messageError = memberUsed.UserName + " ya esta inscrit@ en esa competición.";
sigue = false;
}
else
{
try
{
aRace.Members.Add(aMember);
db.SaveChanges();
LoadDataInGridForRacesForClubber();
X.Msg.Alert("Atención", "Se ha inscrito a " + memberUsed.UserName + " en la competición.").Show();
}
catch (Exception)
{
X.Msg.Alert("Atención", "Hubo un problema al añadir a " + memberUsed.UserName + "a la lista de participantes en la competición.").Show();
}
}
}
if (!sigue)
{
X.Msg.Alert("Atención", messageError).Show();
}
}
