public DatabaseOption GetById(int Id)
{
using (InsightEntities db = new InsightEntities())
{
return(db.DatabaseOptions.Find(Id));
}
}
public List <Drive> GetAll()
{
using (InsightEntities db = new InsightEntities())
{
return(db.Drives.ToList());
}
}
public Instance GetById(int Id)
{
using (InsightEntities db = new InsightEntities())
{
return(db.Instances.Find(Id));
}
}
public List <Job> GetAllActive()
{
using (InsightEntities db = new InsightEntities())
{
return(db.Jobs.Where(x => x.Enabled == true).ToList());
}
}
public Drive GetById(int Id)
{
using (InsightEntities db = new InsightEntities())
{
return(db.Drives.Find(Id));
}
}
public List <DatabaseOption> GetAll()
{
using (InsightEntities db = new InsightEntities())
{
return(db.DatabaseOptions.ToList());
}
}
public JobLog GetById(int Id)
{
using (InsightEntities db = new InsightEntities())
{
return(db.JobLogs.Find(Id));
}
}
public List <Instance> GetAll()
{
using (InsightEntities db = new InsightEntities())
{
return(db.Instances.ToList());
}
}
public List <Instance> GetAllActive()
{
using (InsightEntities db = new InsightEntities())
{
return(db.Instances.Where(x => x.Active == true).ToList());
}
}
public Backup GetById(int Id)
{
using (InsightEntities db = new InsightEntities())
{
return(db.Backups.Find(Id));
}
}
public List <Backup> GetAll()
{
using (InsightEntities db = new InsightEntities())
{
return(db.Backups.ToList());
}
}
public List <JobLog> GetAll()
{
using (InsightEntities db = new InsightEntities())
{
return(db.JobLogs.ToList());
}
}
public Drive Insert(Drive obj)
{
using (InsightEntities db = new InsightEntities())
{
db.Drives.Add(obj);
db.SaveChanges();
return(obj);
}
}
public void Delete(Backup obj)
{
using (InsightEntities db = new InsightEntities())
{
db.Backups.Attach(obj);
db.Backups.Remove(obj);
db.SaveChanges();
}
}
public LoginMembership Insert(LoginMembership obj)
{
using (InsightEntities db = new InsightEntities())
{
db.LoginMembership.Add(obj);
db.SaveChanges();
return(obj);
}
}
public Backup Insert(Backup obj)
{
using (InsightEntities db = new InsightEntities())
{
db.Backups.Add(obj);
db.SaveChanges();
return(obj);
}
}
public void Delete(JobLog obj)
{
using (InsightEntities db = new InsightEntities())
{
db.JobLogs.Attach(obj);
db.JobLogs.Remove(obj);
db.SaveChanges();
}
}
public Instance Insert(Instance obj)
{
using (InsightEntities db = new InsightEntities())
{
db.Instances.Add(obj);
db.SaveChanges();
return(obj);
}
}
public LogSize Insert(LogSize obj)
{
using (InsightEntities db = new InsightEntities())
{
db.LogSize.Add(obj);
db.SaveChanges();
return(obj);
}
}
public JobLog Insert(JobLog obj)
{
using (InsightEntities db = new InsightEntities())
{
db.JobLogs.Add(obj);
db.SaveChanges();
return(obj);
}
}
public DatabaseOption Insert(DatabaseOption obj)
{
using (InsightEntities db = new InsightEntities())
{
db.DatabaseOptions.Add(obj);
db.SaveChanges();
return(obj);
}
}
public void Delete(DatabaseOption obj)
{
using (InsightEntities db = new InsightEntities())
{
db.DatabaseOptions.Attach(obj);
db.DatabaseOptions.Remove(obj);
db.SaveChanges();
}
}
public void Delete(InstanceDetail obj)
{
using (InsightEntities db = new InsightEntities())
{
db.InstanceDetails.Attach(obj);
db.InstanceDetails.Remove(obj);
db.SaveChanges();
}
}
public void Delete(Drive obj)
{
using (InsightEntities db = new InsightEntities())
{
db.Drives.Attach(obj);
db.Drives.Remove(obj);
db.SaveChanges();
}
}
public void Update(InstanceDetail obj)
{
using (InsightEntities db = new InsightEntities())
{
db.InstanceDetails.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public void Update(DatabaseOption obj)
{
using (InsightEntities db = new InsightEntities())
{
db.DatabaseOptions.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public DatabaseSize Insert(DatabaseSize obj)
{
using (InsightEntities db = new InsightEntities())
{
db.DatabaseSize.Add(obj);
db.SaveChanges();
return(obj);
}
}
