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 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(); }
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 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(); } }
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(); } }
public void DoDelAllAG() { bool sigue = true; string grupo = ""; if (sigue) { //Load data for age group using (var db = new ClubSiteContext()) { var aListOfAG = from ag in db.RaceAgeGroups where ag.RaceID == rUsed.Id select ag; if (aListOfAG != null) { try { foreach (RaceAgeGroup ag in aListOfAG.ToList()) { db.RaceAgeGroups.Remove(ag); } db.SaveChanges(); LoadDataInGridForAgeGroups(); X.Msg.Alert("Atención","Todos los grupos de edad han sido quitados de la competición.").Show(); } catch (Exception) { X.Msg.Alert("Atención", "Hubo un problema al quitar el grupo de edad " + grupo + " de la competición.").Show(); } } } } }
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 DoDel() { Notification.Show(new NotificationConfig { Title = "Aviso", Icon = Icon.Information, Html = "Borrando la competición en pantalla." }); if (rUsed.Id == 0) { //No Race selected X.Msg.Alert("Atención", "No hay nada que borrar ya que no hay competiciones registradas.").Show(); } else { //Del race using (var db = new ClubSiteContext()) { Race item = (from races in db.Races where races.Id == rUsed.Id select races).FirstOrDefault(); if (item == 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; } db.Races.Remove(item); db.SaveChanges(); this.StoreGPRaces.DataBind(); X.Msg.Alert("Atención", "Competición borrada.").Show(); //Load data for first race type rUsed = (from races in db.Races orderby races.RaceDate descending, races.Name select races).FirstOrDefault(); if (rUsed == null) { //Last item was erased. No items in BD. rUsed = new Race(); X.Msg.Alert("Atención", "No queda ninguna competición registrada en la Base de datos.").Show(); } oldRUsed.CopyRace(rUsed); //Loads model object data into form LoadRaceInForm(rUsed); } } }
public void DoDelAG() { bool sigue= true; string grupo=""; //Take age group rname from GridView CellSelectionModel sm = this.GPAgeGroupsEnComp.GetSelectionModel() as CellSelectionModel; Int32 aGAId = Convert.ToInt32(sm.SelectedCell.RecordID); using (var db = new ClubSiteContext()) { RaceAgeGroup aAG = (from ag in db.RaceAgeGroups where ag.Id == aGAId select ag).FirstOrDefault(); if (aAG == null) { sigue = false; X.Msg.Alert("Atención", "No se encontró el grupo de edad " + grupo + " de la competición.").Show(); } else { grupo = aAG.Name; } } if (sigue) { //Load data for age group using (var db = new ClubSiteContext()) { RaceAgeGroup aAG = new RaceAgeGroup(); aAG = (from ag in db.RaceAgeGroups where ag.Id == aGAId select ag).FirstOrDefault(); if (aAG != null) { try { db.RaceAgeGroups.Remove(aAG); db.SaveChanges(); LoadDataInGridForAgeGroups(); X.Msg.Alert("El grupo de edad", grupo + " ha sido quitado de la competición.").Show(); } catch (Exception) { X.Msg.Alert("Atención", "Hubo un problema al quitar el grupo de edad " + grupo + " de la competición.").Show(); } } } } }
public void DoAddAG() { //Load data for username using (var db = new ClubSiteContext()) { try { RaceAgeGroup aRaceAgeGroup = new RaceAgeGroup(); aRaceAgeGroup.Name = txbxGEName.Text; aRaceAgeGroup.Part = Convert.ToInt16(txbxGEPart.Text); aRaceAgeGroup.RaceID = rUsed.Id; db.RaceAgeGroups.Add(aRaceAgeGroup); db.SaveChanges(); LoadDataInGridForAgeGroups(); X.Msg.Alert("Atención", "Se ha añadido el grupo de edad " + txbxGEName.Text + " en la competición.").Show(); } catch (Exception) { X.Msg.Alert("Atención", "Hubo un problema al añadir el grupo de edad " + txbxGEName.Text + "a la competición.").Show(); } } }
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); }
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() { 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); } } }
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(); } }
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(); } }
public void DoSave() { bool sigue = true; int points = 0; int aSportIDSelected = 0; string messageError = null; //Verify name exists if (txbxName.Text == "") { sigue = false; messageError = "Falta el nombre del tipo de competición."; } //Verify points exists and are between 0 and 10.000 if (sigue) { try { points = Convert.ToInt32(txbxPuntos.Text); if (points < 0 || points > 10000) { sigue = false; messageError="Los puntos asignados deben ser un número entre 0 y 10.000"; } } catch (Exception) { sigue = false; messageError="Debes asignar un valor numérico entre 0 y 10.000 para los puntos."; } } //Verify is a SportID was choosed. if (sigue) { try { aSportIDSelected = Convert.ToInt32(cbxDeportes.SelectedItem.Value);//Convert.ToInt32(txbxSportID.Text); if (aSportIDSelected <= 0) { sigue = false; messageError = "Escoje el tipo de deporte al que pertenece la competición."; } } catch (Exception) { sigue = false; messageError = "Escoje el tipo de deporte al que pertenece la competición."; } } //Save if conditions are ok. if (sigue) { using (var db = new ClubSiteContext()) { RaceType aRacetype; if (rtUsed.RaceTypeID == 0) { //New Race Type aRacetype = new RaceType(); aRacetype.Name = txbxName.Text; aRacetype.Points = points; aRacetype.SportID = aSportIDSelected; aRacetype.Memo = txbxMemo.Text; db.RaceTypes.Add(aRacetype); } else { //Update actual Race Type aRacetype = (from racetypes in db.RaceTypes where racetypes.RaceTypeID == rtUsed.RaceTypeID select racetypes).FirstOrDefault(); if (aRacetype == null) { // The item wasn't found ModelState.AddModelError("", String.Format("Tipo de competición con Id : {0} no encontrada", rtUsed.RaceTypeID)); X.Msg.Alert("Atención","Tipo de competición no encontrada").Show(); return; } aRacetype.Name = txbxName.Text; aRacetype.Points = points; aRacetype.SportID = aSportIDSelected; aRacetype.Memo = txbxMemo.Text; } db.SaveChanges(); LoadRaceTypeInForm(aRacetype); //To update the ID (identity file) rtUsed.CopyRaceType(aRacetype); oldRtUsed.CopyRaceType(rtUsed); this.Store1.DataBind(); X.Msg.Alert("Atención", "Nuevo tipo de competición grabada.").Show(); } btnBorrar.Enabled = true; } else { X.Msg.Alert("Atención", messageError).Show(); } }