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