public Club GetClubById(int clubId) { var club = new Club(); using (var connection = new EntityConnection("name=CoreContainer")) { _core = new CoreContainer(connection); club = _core.Clubs .Include("CurrentPresident") .Include("Locations") .Include("RegisteringDriver") .Where(c => c.ClubId == clubId) .FirstOrDefault(); } return club; }
public Club UpdateClub(Club club) { using (var connection = new EntityConnection("name=CoreContainer")) { _core = new CoreContainer(connection); _core.Clubs.Attach(_core.Clubs.Single(c => c.ClubId == club.ClubId)); _core.Clubs.ApplyCurrentValues(club); _core.SaveChanges(); } return club; }
public Club SaveNewClub(Club club) { using (var connection = new EntityConnection("name=CoreContainer")) { _core = new CoreContainer(connection); _core.Clubs.AddObject(club); _core.SaveChanges(); } return club; }
/// <summary> /// Create a new Club object. /// </summary> /// <param name="clubId">Initial value of the ClubId property.</param> /// <param name="fullName">Initial value of the FullName property.</param> /// <param name="acronym">Initial value of the Acronym property.</param> /// <param name="city">Initial value of the City property.</param> /// <param name="state">Initial value of the State property.</param> /// <param name="regionId">Initial value of the RegionId property.</param> /// <param name="dateCreated">Initial value of the DateCreated property.</param> /// <param name="country">Initial value of the Country property.</param> public static Club CreateClub(global::System.Int32 clubId, global::System.String fullName, global::System.String acronym, global::System.String city, global::System.String state, global::System.Int32 regionId, global::System.DateTime dateCreated, global::System.String country) { Club club = new Club(); club.ClubId = clubId; club.FullName = fullName; club.Acronym = acronym; club.City = city; club.State = state; club.RegionId = regionId; club.DateCreated = dateCreated; club.Country = country; return club; }
/// <summary> /// Deprecated Method for adding a new object to the Clubs EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToClubs(Club club) { base.AddObject("Clubs", club); }
public RegisterClubViewModel RegisterNewClub(RegisterClubViewModel clubModel) { var newClub = new Club { FullName = clubModel.FullName, Acronym = clubModel.Acronym, City = clubModel.City, State = clubModel.State, RegionId = clubModel.RegionId, Country = clubModel.Country, DateCreated = DateTime.Now }; var newDriver = new Driver { FirstName = clubModel.FirstName, LastName = clubModel.LastName, RccScreenName = clubModel.ScreenName, City = clubModel.City, State = clubModel.State, EmailAddress = clubModel.EmailAddress.ToLower(), DateCreated = DateTime.Now }; try { Membership.CreateUser(newDriver.EmailAddress, clubModel.Password, newDriver.EmailAddress); _driverRepository.SaveNewDriver(newDriver); _clubRepository.SaveNewClub(newClub); newClub.CurrentPresidentDriverId = newDriver.DriverId; newClub.RegisteringDriverId = newDriver.DriverId; _clubRepository.UpdateClub(newClub); newDriver.HomeClubId = newClub.ClubId; _driverRepository.UpdateDriver(newDriver); //clubModel.ClubId = newClub.ClubId; using (var _mailClient = new SmtpClient(ConfigurationManager.AppSettings["SmtpServer"])) { var message = new MailMessage(); string toAddress = ConfigurationManager.AppSettings["NewClubToAddress"]; message.To.Add(new MailAddress(toAddress, "ProgressTen.com Registration")); message.From = new MailAddress("*****@*****.**", "ProgressTen Registration"); message.Subject = "ProgressTen - New Club Registration"; message.Body = @" A new club has been submitted for consideration with the following information:\n\n Club Name: " + newClub.FullName + @"\n Acronym: " + newClub.Acronym + @"\n City: " + newClub.City + @"\n State: " + newClub.State + @"\n RegionId: " + newClub.RegionId + @"\n Country: " + newClub.Country + @"\n President's Name: " + newDriver.FullName + @"\n President's ScreenName: " + newDriver.RccScreenName + @"\n President's Email: " + newDriver.EmailAddress + @"\n"; _mailClient.Send(message); } clubModel.StatusMessage = MvcHtmlString.Create("<p>" + "Thank you for submitting your club as a member club of ProgressTen.com. As you know, clubs must be " + "sanctioned, or in the process of becoming sanctioned with the USRCCA. As soon as we are able to " + "confirm your status with the USRCCA, we'll notify you of your club's confirmation." + "</p>" + "<p>" + "In the mean time, you are now registered as a Driver in ProgressTen.com and you have access to the " + "public areas that are available to all Drivers who are not yet affiliated with a club. You can log in " + "anytime with the email address and password you provided." + "</p>" + "<p>" + "<a href='./" + newClub.ClubId + "' >Go To Club Page</a></p>" + "<p>" + "<a href='../Login' >Log In</a></p>"); } catch (Exception ex) { log.Error("Problem Creating New Club for User:"******" Club: " + newClub.FullName, ex); Membership.DeleteUser(newDriver.EmailAddress); clubModel.StatusMessage = MvcHtmlString.Create("<p>" + "There was a problem submitting this New Club entry. You may double check that all your data was " + "entered correctly and try again. ProgressTen.com administrators have been made aware of the " + "error and will look into the matter further." + "</p>"); } return clubModel; }