public SchedulePluginsInfo FindOne(int id)
{
using (var context = new ScheduleContext())
{
return(context.Plugins.FirstOrDefault(c => c.Id == id));
}
}
public ScheduleJobsInfo FindOne(Guid id)
{
using (var context = new ScheduleContext())
{
return(context.ScheduleJobs.FirstOrDefault(c => c.Id == id));
}
}
public IQueryable <SchedulePluginsInfo> Find(Expression <Func <SchedulePluginsInfo, bool> > query)
{
var context = new ScheduleContext();
if (query != null)
{
return(context.Plugins.Where(query).OrderByDescending(c => c.Id));
}
return(context.Plugins.OrderByDescending(c => c.Id).AsQueryable());
}
public IQueryable <ScheduleJobsInfo> Find(Expression <Func <ScheduleJobsInfo, bool> > query)
{
var context = new ScheduleContext();
if (query != null)
{
return(context.Set <ScheduleJobsInfo>().Where(query));
}
return(context.ScheduleJobs.AsQueryable <ScheduleJobsInfo>());
}
public bool Remove(int id)
{
using (var context = new ScheduleContext())
{
var entity = context.Plugins.FirstOrDefault(c => c.Id == id);
if (entity != null)
{
context.Plugins.Attach(entity);
context.Entry <SchedulePluginsInfo>(entity).State = System.Data.Entity.EntityState.Deleted;
context.SaveChanges();
}
}
return(true);
}
public bool Save(SchedulePluginsInfo entity)
{
using (var context = new ScheduleContext())
{
if (entity.Id == 0)
{
context.Plugins.Add(entity);
context.Entry <SchedulePluginsInfo>(entity).State = System.Data.Entity.EntityState.Added;
}
else
{
var info = context.Plugins.FirstOrDefault(c => c.Id == entity.Id);
if (entity != null)
{
context.Entry <SchedulePluginsInfo>(entity).State = System.Data.Entity.EntityState.Modified;
}
}
context.SaveChanges();
}
return(true);
}
public bool Save(ScheduleJobsInfo entity)
{
ScheduleJobsInfo info = FindOne(entity.Id);
if (info == null)
{
using (var context = new ScheduleContext())
{
context.ScheduleJobs.Add(entity);
context.Entry <ScheduleJobsInfo>(entity).State = EntityState.Added;
context.SaveChanges();
}
return(true);
}
using (var context = new ScheduleContext())
{
//context.ScheduleJobs.AddObject(entity);
context.Entry <ScheduleJobsInfo>(entity).State = EntityState.Modified;
int r = context.SaveChanges();
}
return(true);
}