public bool AddComment(Comment comment)
{
using (var db = new FirewoodContext())
{
db.Comments.Add(comment);
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 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 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)
{
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;
}
}
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 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 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 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;
}
}
