public void RecordDonation(int eventId, decimal amount, string senderEmail) { using (var dataContext = new Fund4KidsContext()) { dataContext.Donations.Add(new Donation() { EventId = eventId, SenderEmail = senderEmail, Amoun = (int)amount, TimeStamp = DateTime.Now }); dataContext.SaveChanges(); } }
public List <Event> Events() { List <Event> result = null; using (var dataContext = new Fund4KidsContext()) { result = dataContext.Events.Select(e => e).ToList(); } return(result); }
public Event Event(int eventId) { Event result = null; using (var dataContext = new Fund4KidsContext()) { result = dataContext.Events.First(vent => vent.EventId == eventId); } return(result); }
public List <Denomination> Denominations() { List <Denomination> result = null; using (var dataContext = new Fund4KidsContext()) { result = dataContext.Denominations.Select(d => d).ToList(); } return(result); }
public Coordinator Coordinator(string userName) { Coordinator result = null; using (var dataContext = new Fund4KidsContext()) { result = (from coordinator in dataContext.Coordinators join user in dataContext.UserProfiles on coordinator.UserId equals user.UserId where user.UserName.Equals(userName) select coordinator).FirstOrDefault(); } return(result); }
public List <Denomination> Denominations(int eventId) { List <Denomination> result = null; using (var dataContext = new Fund4KidsContext()) { var query = (from denomination in dataContext.Denominations join eventDenomination in dataContext.EventDenominations on denomination.DenominationId equals eventDenomination.DenominationId where eventDenomination.EventId == eventId select denomination).Distinct(); return(query.ToList()); } return(result); }
public Coordinator CreateCoordinator(string paypalEmail, string userName) { Coordinator result = null; using (var dataContext = new Fund4KidsContext()) { var user = dataContext.UserProfiles.First(userp => userp.UserName.Equals(userName)); dataContext.Coordinators.Add(new Coordinator() { UserId = user.UserId, PaypalEmail = paypalEmail }); dataContext.SaveChanges(); } return(result); }
public Event SaveEvent(Event entity, string userName, List <int> denominations) { Event result; using (var dataContext = new Fund4KidsContext()) { //var user = dataContext.UserProfiles.First(userp => userp.UserName.Equals(userName)); //entity.CoordinatorId = dataContext.Coordinators.First(coordinator => coordinator.UserId == user.UserId).CoordinatorId; var coord = (from coordinator in dataContext.Coordinators join user in dataContext.UserProfiles on coordinator.UserId equals user.UserId where user.UserName.Equals(userName) select coordinator).FirstOrDefault(); entity.CoordinatorId = coord.CoordinatorId; if (entity.EventId == 0) { result = dataContext.Events.Add(entity); } else { result = dataContext.Events.Attach(entity); var entry = dataContext.Entry(entity); entry.State = EntityState.Modified; } //Get Event Id dataContext.SaveChanges(); foreach (var denom in denominations) { dataContext.EventDenominations.Add(new EventDenomination() { EventId = entity.EventId, DenominationId = denom }); } dataContext.SaveChanges(); } return(result); }