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