public bool UpdateOrder() { var success = false; using (var ctx = new AgrishareEntities()) { if (SortOrder > 0) { ctx.Faqs.Where(o => o.SortOrder >= SortOrder).ToList().ForEach(o => { o.SortOrder += 1; }); } success = ctx.SaveChanges() > 0; } using (var ctx = new AgrishareEntities()) { ctx.Faqs.Attach(this); if (SortOrder == 0) { SortOrder = ctx.Faqs.Max(o => o.SortOrder) + 1; } ctx.Entry(this).State = EntityState.Modified; success = ctx.SaveChanges() > 0; } return(success); }
private bool Update() { using (var ctx = new AgrishareEntities()) { ctx.Bookings.Attach(this); ctx.Entry(this).State = EntityState.Modified; return(ctx.SaveChanges() > 0); } }
private bool Add() { using (var ctx = new AgrishareEntities()) { ctx.Journals.Attach(this); ctx.Entry(this).State = EntityState.Added; return(ctx.SaveChanges() > 0); } }
private bool Add() { ClientCorrelator = Guid.NewGuid().ToString(); using (var ctx = new AgrishareEntities()) { ctx.Transactions.Attach(this); ctx.Entry(this).State = EntityState.Added; return(ctx.SaveChanges() > 0); } }
private bool Add() { StatusId = ListingStatus.Live; using (var ctx = new AgrishareEntities()) { ctx.Listings.Attach(this); ctx.Entry(this).State = EntityState.Added; return(ctx.SaveChanges() > 0); } }
private bool Add() { StatusId = NotificationStatus.Pending; using (var ctx = new AgrishareEntities()) { ctx.Notifications.Attach(this); ctx.Entry(this).State = EntityState.Added; return(ctx.SaveChanges() > 0); } }
private bool Add() { using (var ctx = new AgrishareEntities()) { try { SortOrder = ctx.Faqs.Max(o => o.SortOrder) + 1; } catch { SortOrder = 1; } ctx.Faqs.Attach(this); ctx.Entry(this).State = EntityState.Added; return(ctx.SaveChanges() > 0); } }
public static int CleanDeletedAccounts() { using (var ctx = new AgrishareEntities()) { var oneYearAgo = DateTime.Now.AddYears(-1); var users = ctx.Users.Where(o => o.Deleted && o.LastModified > oneYearAgo); foreach (var user in users) { ctx.Entry(user).State = EntityState.Deleted; } return(ctx.SaveChanges()); } }