public List <Activity> GetByPage(string sortOrder, string searchString) { BADBContext db = new BADBContext(); var activities = from a in db.Activities select a; if (!String.IsNullOrEmpty(searchString)) { activities = activities.Where(s => s.Name.Contains(searchString) || s.Detail.Contains(searchString)); } switch (sortOrder) { case "name_desc": activities = activities.OrderByDescending(s => s.Name); break; case "Date": activities = activities.OrderBy(s => s.StartDateTime); break; case "date_desc": activities = activities.OrderByDescending(s => s.StartDateTime); break; default: activities = activities.OrderByDescending(s => s.Name); break; } return(activities.ToList()); }
public bool Save(SysLog log) { BADBContext db = new BADBContext(); db.SysLogs.Add(log); return(db.SaveChanges() > 0); }
public IList <Activity> GetByCondition(Func <Activity, bool> condition) { using (BADBContext db = new BADBContext()) { return(db.Activities.Where(condition).ToList()); } }
public IList <Member> GetByCondition(Func <Member, bool> condition) { using (BADBContext db = new BADBContext()) { return(db.Members.Where(condition).ToList()); } }
public bool Save(Activity a) { BADBContext db = new BADBContext(); db.Activities.Add(a); return(db.SaveChanges() > 0); }
public bool Save(Member m) { BADBContext db = new BADBContext(); db.Members.Add(m); return(db.SaveChanges() > 0); }
public bool Delete(Guid memberID) { BADBContext db = new BADBContext(); var info = db.Members.Where(r => r.ID == memberID).FirstOrDefault(); db.Members.Remove(info); return(db.SaveChanges() > 0); }
public bool DeleteJoinInfo(Guid ActivityID, string MemberAlias) { BADBContext db = new BADBContext(); var info = db.ActivityJoinInfos.Where(r => r.MemberAlias == MemberAlias && r.ActivityID == ActivityID).FirstOrDefault(); db.ActivityJoinInfos.Remove(info); return(db.SaveChanges() > 0); }
public bool Delete(Guid ActivityID) { BADBContext db = new BADBContext(); var info = db.Activities.Where(r => r.ID == ActivityID).FirstOrDefault(); db.Activities.Remove(info); return(db.SaveChanges() > 0); }
public bool SaveLikeInfo(ActivityLikeInfo info) { BADBContext db = new BADBContext(); if (db.ActivityLikeInfos.Where(r => r.MemberAlias == info.MemberAlias && r.ActivityID == info.ActivityID).Count() > 0) { return(true); } db.ActivityLikeInfos.Add(info); return(db.SaveChanges() > 0); }
public void Edit(Member m) { using (BADBContext db = new BADBContext()) { var old = db.Members.Where(r => r.ID == m.ID).FirstOrDefault(); if (null != old) { old.DisplayName = m.DisplayName; old.AvantarPath = m.AvantarPath; old.CreateDate = DateTime.UtcNow.AddHours(8); } db.SaveChanges(); } }
public void Edit(ActivityType at) { using (BADBContext db = new BADBContext()) { var old = db.ActivityTypes.Where(r => r.ID == at.ID).FirstOrDefault(); if (null != old) { old.Name = at.Name; old.Description = at.Description; old.PosterImagePath1 = at.PosterImagePath1; old.CreateDate = DateTime.UtcNow.AddHours(8); } db.SaveChanges(); } }
public bool Save(ActivityType a) { BADBContext db = new BADBContext(); var maxRank = db.ActivityTypes.Max(r => r.Rank); if (null == maxRank) { maxRank = 0; } a.Rank = ++maxRank; a.CreateDate = DateTime.UtcNow.AddHours(8); db.ActivityTypes.Add(a); return(db.SaveChanges() > 0); }
public void Edit(Activity activity) { using (BADBContext db = new BADBContext()) { var old = db.Activities.Where(r => r.ID == activity.ID).FirstOrDefault(); if (null != old) { old.Name = activity.Name; old.StartDateTime = activity.StartDateTime; old.EndDateTime = activity.EndDateTime; old.Detail = activity.Detail; old.ActivityTypeID = activity.ActivityTypeID; old.Address = activity.Address; } db.SaveChanges(); } }
public bool Up(Guid activityTypeID) { BADBContext db = new BADBContext(); var maxRank = db.ActivityTypes.Max(r => r.Rank); var cur = db.ActivityTypes.Where(r => r.ID == activityTypeID).FirstOrDefault(); if (cur.Rank == maxRank) { return(true); } var previous = db.ActivityTypes.Where(r => r.Rank == cur.Rank + 1).FirstOrDefault(); int?curRank = cur.Rank; cur.Rank = previous.Rank; previous.Rank = curRank; return(db.SaveChanges() > 0); }
public bool Down(Guid activityTypeID) { BADBContext db = new BADBContext(); var minRank = db.ActivityTypes.Min(r => r.Rank); var cur = db.ActivityTypes.Where(r => r.ID == activityTypeID).FirstOrDefault(); if (cur.Rank == minRank) { return(true); } var next = db.ActivityTypes.Where(r => r.Rank == cur.Rank - 1).FirstOrDefault(); int?curRank = cur.Rank; cur.Rank = next.Rank; next.Rank = curRank; return(db.SaveChanges() > 0); }
public List <Activity> GetAll() { BADBContext db = new BADBContext(); return(db.Activities.OrderByDescending(r => r.StartDateTime).ThenByDescending(r => r.CreateDate).ToList()); }
public IEnumerable <Member> GetAll() { BADBContext db = new BADBContext(); return(db.Members.OrderByDescending(r => r.CreateDate).ToList()); }
public List <ActivityLikeInfo> GetAllLikeInfo(Guid ActivityID) { BADBContext db = new BADBContext(); return(db.ActivityLikeInfos.Where(r => r.ActivityID == ActivityID).ToList()); }
public IEnumerable <ActivityType> GetAll() { BADBContext db = new BADBContext(); return(db.ActivityTypes.OrderByDescending(r => r.Rank).ToList()); }
public bool Exists(string domainAlias) { BADBContext db = new BADBContext(); return(db.Members.Where(r => r.Alias.Equals(domainAlias)).Count() > 0); }