public List <Location> GetAllLocation()
{
List <Location> allLocaList = new List <Location>();
using (MyCirclesEntityModel db = new MyCirclesEntityModel())
{
allLocaList = db.Locations.ToList();
return(allLocaList);
}
}
public List <Location> ByTagLocation(int locationTag)
{
List <Location> locaListByTag = new List <Location>();
using (MyCirclesEntityModel db = new MyCirclesEntityModel())
{
locaListByTag = db.Locations.Where(i => i.landmarkType == locationTag).ToList();
return(locaListByTag);
}
}
public static List <SignUpEventDetail> GetSignUpEventDetails(int eventId)
{
List <SignUpEventDetail> SignUpEventDetailsList = new List <SignUpEventDetail>();
using (MyCirclesEntityModel db = new MyCirclesEntityModel())
{
SignUpEventDetailsList = db.SignUpEventDetails.Where(event1 => event1.eventId == eventId).ToList();
return(SignUpEventDetailsList);
}
}
public static List <Itinerary> GetUserItinerary(User user)
{
List <Itinerary> itineraryList = new List <Itinerary>();
using (MyCirclesEntityModel db = new MyCirclesEntityModel())
{
itineraryList = db.Itineraries.Where(i => i.userId == user.Id).ToList();
return(itineraryList);
}
}
public static List <Itinerary> GetSpecificItinerary(int itineraryId)
{
List <Itinerary> itineraryList = new List <Itinerary>();
using (MyCirclesEntityModel db = new MyCirclesEntityModel())
{
itineraryList = db.Itineraries.Where(i => i.itineraryId == itineraryId).ToList();
return(itineraryList);
}
}
public List <Location> ByALocation(int locId)
{
List <Location> alocList = new List <Location>();
using (MyCirclesEntityModel db = new MyCirclesEntityModel())
{
alocList = db.Locations.Where(i => i.locaId == locId).ToList();
return(alocList);
}
}
public static Itinerary AddItinerayDAO(Itinerary newItinerary)
{
using (var db = new MyCirclesEntityModel())
{
Itinerary itinerary;
itinerary = db.Itineraries.Add(newItinerary);
db.SaveChanges();
return(itinerary);
}
}
public static Event GetEvent(int eventId)
{
Event eventList = new Event();
using (MyCirclesEntityModel db = new MyCirclesEntityModel())
{
eventList = db.Events.Where(event1 => event1.eventId == eventId).FirstOrDefault();
return(eventList);
}
}
public static List <ReportedPost> GetAllReportedPosts()
{
List <ReportedPost> reportedPosts = new List <ReportedPost>();
using (MyCirclesEntityModel db = new MyCirclesEntityModel())
{
reportedPosts = db.ReportedPosts.ToList();
}
return(reportedPosts);
}
public static List <DayByDay> GetByItinerary(int Id)
{
List <DayByDay> daybydayList = new List <DayByDay>();
using (MyCirclesEntityModel db = new MyCirclesEntityModel())
{
daybydayList = db.DayByDays.Where(i => i.itineraryId == Id).ToList();
return(daybydayList);
}
}
public static Follow SearchFollow(int followerId, int followingId)
{
Follow existingFollow = null;
using (var db = new MyCirclesEntityModel())
{
existingFollow = db.Follows.Where(ef => ef.FollowerId == followerId && ef.FollowingId == followingId).FirstOrDefault();
}
return(existingFollow);
}
public static List <UserCircle> RemoveUserCircles(int userId)
{
using (var db = new MyCirclesEntityModel())
{
List <UserCircle> existingUserCircles = db.UserCircles.Where(uc => uc.UserId == userId).ToList();
db.UserCircles.RemoveRange(db.UserCircles.Where(uc => uc.UserId == userId));
db.SaveChanges();
return(existingUserCircles);
}
}
public static UserCircle RemoveUserCircle(int id)
{
using (var db = new MyCirclesEntityModel())
{
UserCircle existingUserCircle = db.UserCircles.Where(uc => uc.Id == id).FirstOrDefault();
db.UserCircles.Remove(existingUserCircle);
db.SaveChanges();
return(existingUserCircle);
}
}
public static void UpdateIsDisabled(int id, bool isDisabled)
{
using (MyCirclesEntityModel db = new MyCirclesEntityModel())
{
User user = db.Users
.Where(u => u.Id == id)
.FirstOrDefault();
user.IsDeleted = isDisabled;
db.SaveChanges();
}
}
public static Event AddNewEvent(Event eventData)
{
Event evt = null;
using (MyCirclesEntityModel db = new MyCirclesEntityModel())
{
evt = db.Events.Add(eventData);
db.SaveChanges();
}
return(evt);
}
public static List <EventSchedule> getAllEventActivity(int event1)
{
List <EventSchedule> EventScheduleList = new List <EventSchedule>();
using (MyCirclesEntityModel db = new MyCirclesEntityModel())
{
EventScheduleList = db.EventSchedules.Where(eventSchedule => eventSchedule.eventId == event1).ToList();
//EventScheduleList = db.EventSchedules.ToList();
return(EventScheduleList);
}
}
public static User GetUserById(int userId)
{
User user = null;
using (MyCirclesEntityModel db = new MyCirclesEntityModel())
{
user = db.Users
.Where(u => u.Id == userId)
.FirstOrDefault();
}
return(user);
}
public static User GetUserByIdentifier(string identifier)
{
User user = new User();
using (MyCirclesEntityModel db = new MyCirclesEntityModel())
{
user = db.Users
.Where(u => u.EmailAddress == identifier || u.Username == identifier)
.FirstOrDefault();
}
return(user);
}
public static void UpdateIsEventHost(int id, bool isEventHost)
{
using (MyCirclesEntityModel db = new MyCirclesEntityModel())
{
User user = db.Users
.Where(u => u.Id == id)
.FirstOrDefault();
user.IsEventHolder = isEventHost;
db.SaveChanges();
}
}
public static List <EventSchedule> GetAllEventRegisteredByUser(int userId)
{
List <EventSchedule> EventScheduleList = new List <EventSchedule>();
using (MyCirclesEntityModel db = new MyCirclesEntityModel())
{
EventScheduleList = db.EventSchedules.Where(eventSchedule => eventSchedule.usersOptIn.Contains(userId.ToString())).ToList();
//EventScheduleList = db.EventSchedules.ToList();
return(EventScheduleList);
}
}
public static void ToggleLoginStatus(int id, bool isLoggedIn)
{
using (MyCirclesEntityModel db = new MyCirclesEntityModel())
{
User user = db.Users
.Where(u => u.Id == id)
.FirstOrDefault();
user.IsLoggedIn = isLoggedIn;
db.SaveChanges();
}
}
public static void SetMessageSeenStatus(int chatRoomId, int recieverId, bool seenStatus = true)
{
using (var db = new MyCirclesEntityModel())
{
db.Configuration.LazyLoadingEnabled = false;
foreach (var message in db.Messages.Where(m => m.ChatRoomId == chatRoomId && m.RecieverId == recieverId && m.IsSeen == false).ToList())
{
message.IsSeen = seenStatus;
}
db.SaveChanges();
}
}
public static void EditUser(User editedUser)
{
using (var db = new MyCirclesEntityModel())
{
User currentUser = db.Users.Where(u => u.Id == editedUser.Id).FirstOrDefault();
currentUser.Id = editedUser.Id;
currentUser.Username = editedUser.Username;
currentUser.Bio = editedUser.Bio;
currentUser.ProfileImage = editedUser.ProfileImage;
db.SaveChanges();
}
}
public static void DeleteReportedPostByPostId(int postId)
{
using (var db = new MyCirclesEntityModel())
{
List <ReportedPost> posts = db.ReportedPosts.Where(p => p.postId == postId).ToList();
foreach (ReportedPost post in posts)
{
post.postId = null;
}
db.SaveChanges();
}
}
public static void UpdateDay(int dayId, string notes)
{
using (MyCirclesEntityModel db = new MyCirclesEntityModel())
{
List <Day> dayList = new List <Day>();
dayList = db.Days.Where(i => i.dayId == dayId).ToList();
foreach (Day d in dayList)
{
d.notes = notes;
}
db.SaveChanges();
}
}
public static Mutual SearchMutual(int user1Id, int user2Id)
{
Mutual newMutual = null;
using (var db = new MyCirclesEntityModel())
{
Mutual existingMutual = db.Mutuals.Where(em =>
(em.User1Id == user1Id && em.User2Id == user2Id) ||
(em.User1Id == user2Id && em.User2Id == user1Id))
.FirstOrDefault();
}
return(newMutual);
}
public static void UpdateUserLocation(int id, double?latitude, double?longitude, string city)
{
using (MyCirclesEntityModel db = new MyCirclesEntityModel())
{
var userQuery = db.Users
.Where(u => u.Id == id)
.FirstOrDefault();
userQuery.Latitude = latitude;
userQuery.Longitude = longitude;
userQuery.City = city;
db.SaveChanges();
}
}
public static void AddDay(Itinerary itinerary)
{
using (var db = new MyCirclesEntityModel())
{
TimeSpan startTime = new TimeSpan(9, 0, 0);
TimeSpan endTime = new TimeSpan(21, 0, 0);
DateTime userDateTime = itinerary.startDate + startTime;
DateTime endDate = itinerary.endDate + endTime;
int interval = 30;
List <Location> locations = db.Locations.ToList();
foreach (Location location in locations)
{
TimeSpan nextEventFinishTime = userDateTime.AddMinutes(int.Parse(location.locaRecom)).TimeOfDay;
if ((nextEventFinishTime > endTime))
{
userDateTime = userDateTime.AddDays(1);
userDateTime = userDateTime.Date + startTime;
}
if (userDateTime > endDate)
{
break;
}
string dayByDayDate = userDateTime.ToString("dd MMM");
DayByDay dayByDay = db.DayByDays.Where(i => i.date == dayByDayDate && i.itineraryId == itinerary.itineraryId).FirstOrDefault();
Day newDay = new Day();
newDay.date = userDateTime;
newDay.itineraryId = itinerary.itineraryId;
newDay.locationId = location.locaId;
newDay.startTime = userDateTime;
newDay.dayByDayId = dayByDay.dayBydayId;
newDay.endTime = userDateTime.AddMinutes(int.Parse(location.locaRecom));
db.Days.Add(newDay);
db.SaveChanges();
userDateTime = userDateTime.AddMinutes(int.Parse(location.locaRecom));
userDateTime = userDateTime.AddMinutes(interval);
}
}
}
public static UserCircle AddUserCircle(UserCircle newUserCircle)
{
using (var db = new MyCirclesEntityModel())
{
Circle existingCircle = db.Circles.Where(ec => ec.Id == newUserCircle.CircleId).FirstOrDefault();
if (existingCircle == null)
{
existingCircle = CircleDAO.AddCircle(newUserCircle.CircleId);
}
db.UserCircles.Add(newUserCircle);
db.SaveChanges();
return(newUserCircle);
}
}
public static List <ReportedPostCount> GetReportedPostCountByDate()
{
using (var db = new MyCirclesEntityModel())
{
List <ReportedPostCount> counts = db.ReportedPosts
.ToList()
.GroupBy(
post => post.dateCreated
)
.Select(reportStat => new ReportedPostCount(reportStat.Key, reportStat.Count()))
.ToList();
//var query = from post in db.ReportedPosts
// group post by post.dateCreated into reportStat
// select new ReportedPostCount(reportStat.Key, reportStat.Count());
return(counts);
}
}
