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