public static List <ef_GetItem_Result> GetItemById(Guid itemId) { using (GatheringsEntities _db = new GatheringsEntities()) { return(_db.ef_GetItem(itemId).ToList()); } }
public static List <ef_GetVenue_Result> GetVenueByUserId() { using (GatheringsEntities _db = new GatheringsEntities()) { return(_db.ef_GetVenue(currentUserID, null).ToList()); } }
public static List <ef_GetVenue_Result> GetAllVenues() { using (GatheringsEntities _db = new GatheringsEntities()) { return(_db.ef_GetVenue(null, null).ToList()); } }
public static List <ef_GetEvent_Result> GetEventByEventId(Guid eventID) { using (GatheringsEntities _db = new GatheringsEntities()) { return(_db.ef_GetEvent(eventID, null).ToList()); } }
public static List <ef_GetVenue_Result> GetVenueByVenueId(Guid venueID) { using (GatheringsEntities _db = new GatheringsEntities()) { return(_db.ef_GetVenue(null, venueID).ToList()); } }
public static void UpdateEventIsDelete(Guid EventId, bool IsDelete) { using (GatheringsEntities _db = new GatheringsEntities()) { _db.ef_UpdateEvent(EventId, null, null, null, null, null, null, null, IsDelete); } }
public static List <ef_GetEvent_Result> GetEventByThisUser() { using (GatheringsEntities _db = new GatheringsEntities()) { return(_db.ef_GetEvent(null, currentUserID).ToList()); } }
public static void UpdateEventVenueByVenueId(Guid EventId, Guid VenueId) { using (GatheringsEntities _db = new GatheringsEntities()) { _db.ef_UpdateEvent(EventId, null, null, null, null, null, VenueId, null, null); } }
public static void UpdateEventPublic(Guid EventId, bool isPublic) { using (GatheringsEntities _db = new GatheringsEntities()) { _db.ef_UpdateEvent(EventId, null, null, null, null, null, null, isPublic, null); } }
public static void UpdateEventEndDate(Guid EventId, DateTime EndDate) { using (GatheringsEntities _db = new GatheringsEntities()) { _db.ef_UpdateEvent(EventId, null, null, null, null, EndDate, null, null, null); } }
// Get public static List <ef_GetEvent_Result> GetAllEvents() { using (GatheringsEntities _db = new GatheringsEntities()) { return(_db.ef_GetEvent(null, null).ToList()); } }
public static void UpdateEventImage(Guid EventId, string Image) { using (GatheringsEntities _db = new GatheringsEntities()) { _db.ef_UpdateEvent(EventId, null, null, Image, null, null, null, null, null); } }
public static void UpdateEventDescription(Guid EventId, string Description) { using (GatheringsEntities _db = new GatheringsEntities()) { _db.ef_UpdateEvent(EventId, null, Description, null, null, null, null, null, null); } }
// Create public static Guid CreateEvent() { Guid newID = Guid.NewGuid(); using (GatheringsEntities _db = new GatheringsEntities()) { _db.ef_CreateEvent(newID, currentUserID, null, null, null, null, null, null, false); } return(newID); }
//public static int CreateSponsorship(PurchasePageModel model) //{ // int newID; // model.eventItem.ItemIsPublic = true; // using (GatheringsEntities _db = new GatheringsEntities()) // { // var sponsorID = _db.ef_CreateSponsorship(model.eventItem.ItemId, currentUserID, model.SponsorAmount, model.eventItem.ItemIsPublic).FirstOrDefault().Value; // newID = Convert.ToInt32(sponsorID); // } // return newID; //} public static Guid CreateVenueAndAddress(Venue venue) { Guid newID = Guid.NewGuid(); using (GatheringsEntities _db = new GatheringsEntities()) { _db.ef_CreateVenue(newID, currentUserID, venue.VenueName, null, venue.VenueAddress.Street1, venue.VenueAddress.Street2, null, null, venue.VenueAddress.City, venue.VenueAddress.State, venue.VenueAddress.PostalCode, venue.VenueAddress.Country); } return(newID); }
public static Guid CreateItem(SubmitItem model) { Guid newID = Guid.NewGuid(); model.baseNewItem.ItemIsPublic = true; using (GatheringsEntities _db = new GatheringsEntities()) { _db.ef_CreateItem(newID, model.EventIdForSubmit, null, model.baseNewItem.ItemName, model.baseNewItem.ItemDescription, model.baseNewItem.Price, model.baseNewItem.ItemIsPublic, currentUserID); } return(newID); }