public bool Save(SysLog log) { BADBContext db = new BADBContext(); db.SysLogs.Add(log); return(db.SaveChanges() > 0); }
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 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 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 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); }