public List<Guid> GetTopActList()
{
using (var db = new FirewoodContext())
{
var result = db.Joins.GroupBy(x => x.ActID).OrderByDescending(x => x.Count()).Select(x => x.Key).ToList<Guid>();
return result;
}
}
public int GetSumByActID(Guid actid)
{
using (var db = new FirewoodContext())
{
var joinList = db.Joins.Where(x => x.ActID == actid && x.Status == 1);
return joinList.Count();
}
}
public List<Org> GetAllOrg(int n, int page)
{
using (var db = new FirewoodContext())
{
var org = db.Orgs.Where(x => x.State > 0).OrderByDescending(x => x.RegisterTime);
return org.Skip(n * (page - 1)).Take(n).ToList<Org>();
}
}
public List<Activity> GetActByClass2(string class2, int n, int page)
{
using (var db = new FirewoodContext())
{
var activities = db.Activities.Where(x => x.Class2 == class2 && x.State > 0).OrderByDescending(x => x.BeginTime);
return activities.Skip(n * (page - 1)).Take(n).ToList<Activity>();
}
}
public Org GetOrgByID(Guid orgid)
{
using (var db = new FirewoodContext())
{
var org = db.Orgs.Where(x => x.State > 0 && x.OrgID.Equals(orgid)).FirstOrDefault();
return org;
}
}
public Org GetOrgByName(string orgname)
{
using (var db = new FirewoodContext())
{
var org = db.Orgs.Where(x => x.OrgName == orgname).FirstOrDefault();
return org;
}
}
public int GetOrgCount()
{
using (var db = new FirewoodContext())
{
var org = db.Orgs.Where(x => x.State > 0);
return org.Count();
}
}
public bool OrgNameRegistered(string orgname)
{
using (var db = new FirewoodContext())
{
var org = db.Orgs.Where(x => x.OrgName == orgname && x.State > 0).FirstOrDefault();
return org != null;
}
}
public bool AddComment(Comment comment)
{
using (var db = new FirewoodContext())
{
db.Comments.Add(comment);
return db.SaveChanges() == 1 ? true : false;
}
}
public bool Delete(Guid actid)
{
using (var db = new FirewoodContext())
{
var act = db.Activities.Find(actid);
act.State = -1;
return db.SaveChanges() == 1;
}
}
public bool Create(Activity act)
{
act.State = 1;
using (var db = new FirewoodContext())
{
db.Activities.Add(act);
return db.SaveChanges() == 1;
}
}
//根据用户id查看留言
public List<Comment> selectByUserID(Guid userID, int n, int page)
{
using (var db = new FirewoodContext())
{
var a = db.Comments.Where(x => x.UserID == userID && x.Type == 1 && x.State > 0);
var b = a.OrderByDescending(x => x.ComTime).Skip(n * (page - 1)).Take(n).ToList<Comment>();
return b;
}
}
public bool Create(Join join)
{
join.Status = 1;
using (var db = new FirewoodContext())
{
db.Joins.Add(join);
return db.SaveChanges() == 1 ? true : false;
}
}
public bool Delete(Guid actid, Guid userid)
{
using (var db = new FirewoodContext())
{
var join = db.Joins.Where(x => x.ActID == actid && x.UserID == userid && x.Status == 1).FirstOrDefault();
join.Status = -1;
return db.SaveChanges() == 1 ? true : false;
}
}
public bool Delete(Guid orgid)
{
using (var db = new FirewoodContext())
{
var org = db.Orgs.Find(orgid);
org.State = -1;
return db.SaveChanges() == 1;
}
}
public List<Guid> GetActListByUserID(Guid userid)
{
using (var db = new FirewoodContext())
{
var join = (from o in db.Joins
where o.UserID.Equals(userid) && o.Status > 0
select o.ActID);
return join.ToList<Guid>();
}
}
public bool Update(Org org)
{
using (var db = new FirewoodContext())
{
var x = db.Orgs.Find(org.OrgID);
x.OrgDepartment = org.OrgDepartment;
x.OrgIntroduction = org.OrgIntroduction;
x.OrgContact = org.OrgContact;
return db.SaveChanges() == 1;
}
}
public bool Create(Org org)
{
org.RegisterTime = DateTime.Now;
org.LastLogin = DateTime.Now;
org.State = 1;
using (var db = new FirewoodContext())
{
db.Orgs.Add(org);
return db.SaveChanges() == 1;
}
}
public bool IsExist(Guid actid, Guid uid)
{
using (var db = new FirewoodContext())
{
var join = db.Joins.Where(x => x.ActID == actid && x.UserID == uid).FirstOrDefault();
if (join == null) return false;
else if (join.Status == -1) return false;
else if (join.Status == 1) return true;
return true;
}
}
public bool AddNextComID(Guid ComID, Guid NextComID)
{
using (var db = new FirewoodContext())
{
var a = db.Comments.Where(x => x.ComID == ComID).FirstOrDefault();
if (a == null)
return false;
a.NextComID = NextComID;
return db.SaveChanges() == 1 ? true : false;
}
}
public bool DeleteByActID(Guid actid)
{
using (var db = new FirewoodContext())
{
var joins = db.Joins.Where(x => x.ActID == actid && x.Status == 1);
foreach (Join join in joins)
{
join.Status = -1;
}
return db.SaveChanges() > 0 ? true : false;
}
}
//查看某个活动的最新的几条留言
public List<Comment> selectCommentByActID_num(Guid ActID, int num)
{
using (var db = new FirewoodContext())
{
var a = db.Comments.Where(x => x.ActID == ActID && x.Type == 1 && x.State > 0);
var b = a.OrderByDescending(x => x.ComTime);
if (b.ToList<Comment>().Count >= 5)
{
return b.Take(num).ToList<Comment>();
}
return b.ToList<Comment>();
}
}
//查看回复情况
public List<Comment> selectCommentByComID(Guid ComID)
{
using (var db = new FirewoodContext())
{
var a = db.Comments.Where(x => x.ComID == ComID).FirstOrDefault().NextComID;
List<Comment> commentList = new List<Comment>();
while (a != null)
{
var b = db.Comments.Where(x => x.ComID == a && x.State > 0).FirstOrDefault();
commentList.Add(b);
a = b.NextComID;
}
return commentList;
}
}
public bool DeleteByOrgID(Guid orgid)
{
using (var db = new FirewoodContext())
{
var activities = db.Activities.Where(x => x.OrgID == orgid && x.State > 0);
foreach (Activity act in activities)
{
var results = db.Joins.Where(x => x.ActID == act.ActID && x.Status > 0);
foreach (Join join in results)
{
join.Status = -1;
}
act.State = -1;
}
return db.SaveChanges() >= 0;
}
}
public bool UpdateLoginTime(string orgname)
{
using (var db = new FirewoodContext())
{
var org = db.Orgs.Where(x => x.OrgName == orgname).FirstOrDefault();
org.LastLogin = DateTime.Now;
return db.SaveChanges() == 1;
}
}
public List<Activity> GetActByOrgID(Guid orgid, int n, int page)
{
using (var db = new FirewoodContext())
{
var activities = db.Activities.Where(x => x.OrgID == orgid && x.State > 0).OrderByDescending(x => x.BeginTime);
return activities.Skip(n * (page - 1)).Take(n).ToList<Activity>();
}
}
public int GetActCount(Guid orgid)
{
using (var db = new FirewoodContext())
{
var org = db.Activities.Where(x => x.OrgID.Equals(orgid));
return org.Count();
}
}
public List<Activity> GetActByEndTime(int n, int page)
{
using (var db = new FirewoodContext())
{
var activities = db.Activities.Where(x => x.EndTime > DateTime.Now && x.State > 0).OrderByDescending(x => x.BeginTime);
return activities.Skip(n * (page - 1)).Take(n).ToList<Activity>();
}
}
public Activity GetActByID(Guid actid)
{
using (var db = new FirewoodContext())
{
return db.Activities.Find(actid);
}
}