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);
}
