public List <FeatureImageDTO> addFeaturedImage(FeatureImageDTO f)
{
using (var db = new GG.Models.GGModelContainer())
{
FeatureImage FeatureImageTbl = new FeatureImage();
FeatureImageDTO newFeatureImage = new FeatureImageDTO();
FeatureImageTbl = new FeatureImage
{
Url = f.url
};
db.FeatureImages.Add(FeatureImageTbl);
db.SaveChanges();
var l = (from x in db.FeatureImages
.Select(b => new FeatureImageDTO
{
id = b.Id,
url = b.Url
})
select x).ToList();
return(l);
}
}
public List <FeatureImageDTO> removeFeatureImage(FeatureImageDTO f)
{
using (var db = new GG.Models.GGModelContainer())
{
var existingFeatureImage = (from x in db.FeatureImages where x.Id == f.id select x).FirstOrDefault();
db.FeatureImages.Remove(existingFeatureImage);
db.SaveChanges();
var l = (from x in db.FeatureImages
.Select(b => new FeatureImageDTO
{
id = b.Id,
url = b.Url
})
select x).ToList();
return(l);
}
}
public List <TypeDTO> allTypes_Mixer()
{
List <TypeDTO> response = new List <TypeDTO>();
using (var db = new GG.Models.GGModelContainer())
{
var l = (from type in db.Types
where type.Venues.Any(z => z.Types.Contains(type))
select type);
var t = (from x in l
.Select(b => new TypeDTO
{
id = b.Id,
typeText = b.Text
})
select x).OrderBy(x => Guid.NewGuid()).Take(4).ToList();
response = t;
}
return(response);
}
public List <ImageDTO> addImage(VenueDTO v)
{
ImageDTO i = new ImageDTO();
i = v.images.Last();
using (var db = new GG.Models.GGModelContainer())
{
Image ImageTbl = new Image();
ImageDTO newImage = new ImageDTO();
ImageTbl = new Image
{
url = i.url,
VenueId = (int)v.id
};
db.Images.Add(ImageTbl);
db.SaveChanges();
newImage = i;
newImage.id = ImageTbl.Id;
var existingImage = (from x in db.Images where x.Id == newImage.id select x).FirstOrDefault();
var existingVenue = (from x in db.Venues where x.Id == v.id select x).FirstOrDefault();
existingVenue.Images.Add(existingImage);
db.SaveChanges();
var l = (from x in existingVenue.Images
.Select(b => new ImageDTO
{
id = b.Id,
url = b.url
})
select x).ToList();
return(l);
}
}
public List <HourDTO> addHour(VenueDTO v)
{
HourDTO h = new HourDTO();
h = v.hours.Last();
using (var db = new GG.Models.GGModelContainer())
{
Hours HourTbl = new Hours();
HourDTO newHour = new HourDTO();
HourTbl = new Hours
{
Text = h.hourText,
VenueId = (int)v.id
};
db.Hours.Add(HourTbl);
db.SaveChanges();
newHour = h;
newHour.id = HourTbl.Id;
var existingHour = (from x in db.Hours where x.Id == newHour.id select x).FirstOrDefault();
var existingVenue = (from x in db.Venues where x.Id == v.id select x).FirstOrDefault();
existingVenue.Hours.Add(existingHour);
db.SaveChanges();
var l = (from x in existingVenue.Hours
.Select(b => new HourDTO
{
id = b.Id,
hourText = b.Text
})
select x).ToList();
return(l);
}
}
public List <VideoDTO> addVideo(VenueDTO v)
{
VideoDTO i = new VideoDTO();
i = v.videos.Last();
using (var db = new GG.Models.GGModelContainer())
{
Video VideoTbl = new Video();
VideoDTO newVideo = new VideoDTO();
VideoTbl = new Video
{
url = i.url,
VenueId = (int)v.id
};
db.Videos.Add(VideoTbl);
db.SaveChanges();
newVideo = i;
newVideo.id = VideoTbl.Id;
var existingVideo = (from x in db.Videos where x.Id == newVideo.id select x).FirstOrDefault();
var existingVenue = (from x in db.Venues where x.Id == v.id select x).FirstOrDefault();
existingVenue.Videos.Add(existingVideo);
db.SaveChanges();
var l = (from x in existingVenue.Videos
.Select(b => new VideoDTO
{
id = b.Id,
url = b.url
})
select x).ToList();
return(l);
}
}
public List <FeatureImageDTO> carouselImages()
{
List <FeatureImageDTO> response = new List <FeatureImageDTO>();
using (var db = new GG.Models.GGModelContainer())
{
var l = (from x in db.FeatureImages
.Select(b => new FeatureImageDTO
{
id = b.Id, url = b.Url
})
select x).OrderBy(x => Guid.NewGuid()).Take(4).ToList();
response = l;
}
return(response);
}
public List <TagDTO> allTags()
{
List <TagDTO> response = new List <TagDTO>();
using (var db = new GG.Models.GGModelContainer())
{
var l = (from x in db.Tags
.Select(b => new TagDTO
{
id = b.Id,
tagText = b.Text
})
select x).OrderBy(x => x.tagText).ToList();
response = l;
}
return(response);
}
public List <PriceDTO> allPrices()
{
List <PriceDTO> response = new List <PriceDTO>();
using (var db = new GG.Models.GGModelContainer())
{
var l = (from x in db.Prices1
.Select(b => new PriceDTO
{
id = b.Id,
priceText = b.Text
})
select x).OrderBy(x => x.priceText).ToList();
response = l;
}
return(response);
}
public Boolean deleteVenue(VenueDTO v)
{
using (var db = new GG.Models.GGModelContainer())
{
Venue VenueTbl = new Venue();
var existingVenue = (from x in db.Venues where x.Id == v.id select x).FirstOrDefault();
foreach (var x in db.Types.ToList())
{
x.Venues.Remove(existingVenue);
}
foreach (var x in db.Tags.ToList())
{
x.Venues.Remove(existingVenue);
}
foreach (var x in db.Times.ToList())
{
x.Venues.Remove(existingVenue);
}
foreach (var x in db.Prices1.ToList())
{
x.Venues.Remove(existingVenue);
}
db.Venues.Remove(existingVenue);
db.SaveChanges();
return(true);
}
}
public List <HourDTO> removeHour(VenueDTO v)
{
HourDTO h = new HourDTO();
h = v.hours.Last();
using (var db = new GG.Models.GGModelContainer())
{
Venue VenueTbl = new Venue();
var existingHour = (from x in db.Hours where x.Id == h.id select x).FirstOrDefault();
var existingVenue = (from x in db.Venues where x.Id == v.id select x).FirstOrDefault();
db.Hours.Remove(existingHour);
existingVenue.Hours.Remove(existingHour);
db.SaveChanges();
var l = (from x in existingVenue.Hours
.Select(b => new HourDTO
{
id = b.Id,
hourText = b.Text
})
select x).ToList();
return(l);
}
}
public List <VideoDTO> removeVideo(VenueDTO v)
{
VideoDTO i = new VideoDTO();
i = v.videos.Last();
using (var db = new GG.Models.GGModelContainer())
{
Venue VenueTbl = new Venue();
var existingVideo = (from x in db.Videos where x.Id == i.id select x).FirstOrDefault();
var existingVenue = (from x in db.Venues where x.Id == v.id select x).FirstOrDefault();
db.Videos.Remove(existingVideo);
existingVenue.Videos.Remove(existingVideo);
db.SaveChanges();
var l = (from x in existingVenue.Videos
.Select(b => new VideoDTO
{
id = b.Id,
url = b.url
})
select x).ToList();
return(l);
}
}
public List <PriceDTO> removePrice(VenueDTO v)
{
PriceDTO p = new PriceDTO();
p = v.prices.Last();
using (var db = new GG.Models.GGModelContainer())
{
Venue VenueTbl = new Venue();
var existingPrice = (from x in db.Prices1 where x.Id == p.id select x).FirstOrDefault();
var existingVenue = (from x in db.Venues where x.Id == v.id select x).FirstOrDefault();
existingVenue.Prices.Remove(existingPrice);
db.SaveChanges();
var l = (from x in existingVenue.Prices
.Select(b => new PriceDTO
{
id = b.Id,
priceText = b.Text
})
select x).ToList();
return(l);
}
}
public List <TimeDTO> removeTime(VenueDTO v)
{
TimeDTO t = new TimeDTO();
t = v.times.Last();
using (var db = new GG.Models.GGModelContainer())
{
Venue VenueTbl = new Venue();
var existingTime = (from x in db.Times where x.Id == t.id select x).FirstOrDefault();
var existingVenue = (from x in db.Venues where x.Id == v.id select x).FirstOrDefault();
existingVenue.Times.Remove(existingTime);
db.SaveChanges();
var l = (from x in existingVenue.Times
.Select(b => new TimeDTO
{
id = b.Id,
timeText = b.Text
})
select x).ToList();
return(l);
}
}
public List <PriceDTO> allPrices_Mixer()
{
List <PriceDTO> response = new List <PriceDTO>();
using (var db = new GG.Models.GGModelContainer())
{
var l = (from price in db.Prices1
where price.Venues.Any(z => z.Prices.Contains(price))
select price);
var t = (from x in l
.Select(b => new PriceDTO
{
id = b.Id,
priceText = b.Text
})
select x).ToList().OrderBy(x => Guid.NewGuid()).Take(4).ToList();
response = t;
}
return(response);
}
public List <TimeDTO> addTime(VenueDTO v)
{
TimeDTO t = new TimeDTO();
t = v.times.Last();
using (var db = new GG.Models.GGModelContainer())
{
if (t.id == null)
{
Models.Time TimeTbl = new Models.Time();
TimeDTO newTime = new TimeDTO();
TimeTbl = new Models.Time
{
Text = t.timeText
};
db.Times.Add(TimeTbl);
db.SaveChanges();
newTime = t;
newTime.id = TimeTbl.Id;
var existingTime = (from x in db.Times where x.Id == newTime.id select x).FirstOrDefault();
var existingVenue = (from x in db.Venues where x.Id == v.id select x).FirstOrDefault();
existingVenue.Times.Add(existingTime);
db.SaveChanges();
var l = (from x in existingVenue.Times
.Select(b => new TimeDTO
{
id = b.Id,
timeText = b.Text
})
select x).ToList();
return(l);
}
else
{
Venue VenueTbl = new Venue();
var existingTime = (from x in db.Times where x.Id == t.id select x).FirstOrDefault();
var existingVenue = (from x in db.Venues where x.Id == v.id select x).FirstOrDefault();
existingVenue.Times.Add(existingTime);
db.SaveChanges();
var l = (from x in existingVenue.Times
.Select(b => new TimeDTO
{
id = b.Id,
timeText = b.Text
})
select x).ToList();
return(l);
}
}
}
public List <PriceDTO> addPrice(VenueDTO v)
{
PriceDTO p = new PriceDTO();
p = v.prices.Last();
using (var db = new GG.Models.GGModelContainer())
{
if (p.id == null)
{
Price PriceTbl = new Price();
PriceDTO newPrice = new PriceDTO();
PriceTbl = new Price
{
Text = p.priceText
};
db.Prices1.Add(PriceTbl);
db.SaveChanges();
newPrice = p;
newPrice.id = PriceTbl.Id;
var existingPrice = (from x in db.Prices1 where x.Id == newPrice.id select x).FirstOrDefault();
var existingVenue = (from x in db.Venues where x.Id == v.id select x).FirstOrDefault();
existingVenue.Prices.Add(existingPrice);
db.SaveChanges();
var l = (from x in existingVenue.Prices
.Select(b => new PriceDTO
{
id = b.Id,
priceText = b.Text
})
select x).ToList();
return(l);
}
else
{
Venue VenueTbl = new Venue();
var existingPrice = (from x in db.Prices1 where x.Id == p.id select x).FirstOrDefault();
var existingVenue = (from x in db.Venues where x.Id == v.id select x).FirstOrDefault();
existingVenue.Prices.Add(existingPrice);
db.SaveChanges();
var l = (from x in existingVenue.Prices
.Select(b => new PriceDTO
{
id = b.Id,
priceText = b.Text
})
select x).ToList();
return(l);
}
}
}
public List <VenueDTO> allVenues()
{
List <VenueDTO> response = new List <VenueDTO>();
using (var db = new GG.Models.GGModelContainer())
{
var l = (from x in db.Venues
.Select(b => new VenueDTO
{
id = b.Id,
address = b.Address,
city = b.City,
// hours = b.Hours,
name = b.Name,
contact = b.Contact,
email = b.Email,
facebook = b.Facebook,
instagram = b.Instagram,
neighborhood = b.Neighborhood,
parking = b.Parking,
twitter = b.Twitter,
zip = b.Zip,
phone = b.Phone,
notes = b.Notes,
prices = b.Prices.Select(m => new PriceDTO
{
id = m.Id,
priceText = m.Text
}).ToList(),
hours = b.Hours.Select(m => new HourDTO
{
id = m.Id,
hourText = m.Text
}).OrderBy(g => g.id).ToList(),
state = b.State,
tags = b.Tags.Select(m => new TagDTO
{
id = m.Id,
tagText = m.Text
}).ToList(),
times = b.Times.Select(m => new TimeDTO
{
id = m.Id,
timeText = m.Text
}).ToList(),
types = b.Types.Select(m => new TypeDTO
{
id = m.Id,
typeText = m.Text
}).ToList(),
website = b.Website,
images = b.Images.Select(m => new ImageDTO
{
id = m.Id,
url = m.url
}).ToList(),
videos = b.Videos.Select(m => new VideoDTO
{
id = m.Id,
url = m.url
}).ToList()
})
select x).OrderBy(x => x.name).ToList();
response = l;
}
return(response);
}
public List <VenueDTO> searchVenue(VenueSearchDTO v)
{
List <VenueDTO> response = new List <VenueDTO>();
using (var db = new GG.Models.GGModelContainer())
{
var query = (from oData in db.Venues select oData);
if (v.price != "whatever")
{
query = query.Where(m => m.Prices.Any(pr => pr.Text == v.price));
}
if (v.tag != "anything")
{
query = query.Where(m => m.Tags.Any(ta => ta.Text == v.tag));
}
if (v.time != "anytime")
{
query = query.Where(m => m.Times.Any(ti => ti.Text == v.time));
}
if (v.type != "random place")
{
query = query.Where(m => m.Types.Any(ty => ty.Text == v.type));
}
var l = query
.Select(b => new VenueDTO
{
id = b.Id,
city = b.City,
address = b.Address,
// hours = b.Hours,
name = b.Name,
state = b.State,
website = b.Website,
zip = b.Zip,
twitter = b.Twitter,
parking = b.Parking,
phone = b.Phone,
notes = b.Notes,
neighborhood = b.Neighborhood,
instagram = b.Instagram,
contact = b.Contact,
email = b.Email,
facebook = b.Facebook
,
images = b.Images.Select(m => new ImageDTO
{
id = m.Id,
url = m.url
}).ToList(),
hours = b.Hours.Select(m => new HourDTO
{
id = m.Id,
hourText = m.Text
}).ToList(),
videos = b.Videos.Select(m => new VideoDTO
{
id = m.Id,
url = m.url
}).ToList()
}).OrderBy(x => Guid.NewGuid())
.Take(6).ToList();
response = l;
}
return(response);
}
public Boolean updateVenue(VenueDTO v)
{
Boolean response;
using (var db = new GG.Models.GGModelContainer())
{
if (v.id == null)
{
Venue VenueTbl = new Venue();
VenueTbl = new Venue
{
Address = v.address,
City = v.city,
// Hours = v.hours,
Name = v.name,
State = v.state,
Website = v.website,
Contact = v.contact,
Email = v.email,
Facebook = v.facebook,
Instagram = v.instagram,
Neighborhood = v.neighborhood,
Twitter = v.twitter,
Zip = v.zip,
Parking = v.parking,
Phone = v.phone,
Notes = v.notes
};
db.Venues.Add(VenueTbl);
db.SaveChanges();
response = true;
return(response);
}
else
{
Venue VenueTbl = new Venue();
var existingVenue = (from x in db.Venues where x.Id == v.id select x).FirstOrDefault();
existingVenue.Address = v.address;
existingVenue.City = v.city;
// existingVenue.Hours = v.hours;
existingVenue.Name = v.name;
existingVenue.State = v.state;
existingVenue.Website = v.website;
existingVenue.Email = v.email;
existingVenue.Zip = v.zip;
existingVenue.Twitter = v.twitter;
existingVenue.Parking = v.parking;
existingVenue.Phone = v.phone;
existingVenue.Notes = v.notes;
existingVenue.Facebook = v.facebook;
existingVenue.Instagram = v.instagram;
existingVenue.Neighborhood = v.neighborhood;
existingVenue.Contact = v.contact;
db.SaveChanges();
return(true);
}
}
}
