public List <Machine> GetAllMachinesByEnvironmentId(int machineid)
{
using (var context = new ConStrContext())
{
return(context.Machines.Include("ConnectionStrings").Where(_ => _.MachineId == machineid).ToList());
}
}
public List <ConnectionString> GetAllConnectionStringsForMachineId(int machineId)
{
using (var context = new ConStrContext())
{
return(context.ConnectionStrings.Where(_ => _.MachineId == machineId).ToList());
}
}
public List <Machine> GetAll()
{
using (var context = new ConStrContext())
{
return(context.Machines.Include("ConnectionStrings").ToList());
}
}
public List <int> GetAllEnvIds(int projectId)
{
using (var context = new ConStrContext())
{
return(context.Environments.Where(_ => _.ProjectId == projectId).Select(_ => _.EnvironmentId)
.ToList());
}
}
public Machine GetByMachineId(int MachineId)
{
using (var context = new ConStrContext())
{
return(context.Machines
.Include("ConnectionStrings")
.FirstOrDefault(_ => _.MachineId == MachineId));
}
}
public ConnectionString Edit(ConnectionString connectionString)
{
using (var context = new ConStrContext())
{
context.Entry(connectionString).State = EntityState.Modified;
context.SaveChanges();
return(connectionString);
}
}
public ConnectionString GetByConnectionStringId(int connectionStringId)
{
using (var context = new ConStrContext())
{
return(context.ConnectionStrings
.FirstOrDefault(_ => _.ConnectionStringId == connectionStringId));
}
}
public Machine Create(Machine Machine)
{
using (var context = new ConStrContext())
{
context.Entry(Machine).State = EntityState.Added;
context.SaveChanges();
return(Machine);
}
}
public EnvironmentInfo Edit(EnvironmentInfo environmentInfo)
{
using (var context = new ConStrContext())
{
context.Entry(environmentInfo).State = EntityState.Modified;
context.SaveChanges();
return(environmentInfo);
}
}
public List <Project> GetAll()
{
using (var context = new ConStrContext())
{
return(context.Projects.Include("Environments")
.Include("Environments.Machines")
.Include("Environments.Machines.ConnectionStrings").ToList());
}
}
public Project Edit(Project project)
{
using (var context = new ConStrContext())
{
context.Entry(project).State = EntityState.Modified;
context.SaveChanges();
return(project);
}
}
public Project Create(Project project)
{
using (var context = new ConStrContext())
{
context.Entry(project).State = EntityState.Added;
context.SaveChanges();
return(project);
}
}
public Machine Edit(Machine Machine)
{
using (var context = new ConStrContext())
{
context.Entry(Machine).State = EntityState.Modified;
context.SaveChanges();
return(Machine);
}
}
public List <ConnectionString> GetAll()
{
using (var context = new ConStrContext())
{
return(context.ConnectionStrings
.ToList());
}
}
public Project Delete(int projectId)
{
using (var context = new ConStrContext())
{
var project = context.Projects.Find(projectId);
context.Entry(project).State = EntityState.Deleted;
context.SaveChanges();
return(project);
}
}
public Machine Delete(int machineId)
{
using (var context = new ConStrContext())
{
var machine = context.Machines.Find(machineId);
context.Entry(machine).State = EntityState.Deleted;
context.SaveChanges();
return(machine);
}
}
public EnvironmentInfo Delete(int environmentInfoId)
{
using (var context = new ConStrContext())
{
var environmentInfo = context.Environments.Find(environmentInfoId);
context.Entry(environmentInfo).State = EntityState.Deleted;
context.SaveChanges();
return(environmentInfo);
}
}
public ConnectionString Delete(int connectionStringId)
{
using (var context = new ConStrContext())
{
var connectionString = context.ConnectionStrings.Find(connectionStringId);
context.Entry(connectionString).State = EntityState.Deleted;
context.SaveChanges();
return(connectionString);
}
}
public Project GetByProjectId(int projectId)
{
using (var context = new ConStrContext())
{
return(context.Projects
.Include("Environments")
.Include("Environments.Machines")
.Include("Environments.Machines.ConnectionStrings")
.FirstOrDefault(_ => _.ProjectId == projectId));
}
}
public Project GetProjectByName(MainRequestObject mainRequestObject)
{
using (var context = new ConStrContext())
{
return(context.Projects
.Include("Environments")
.Include("Environments.Machines")
.Include("Environments.Machines.ConnectionStrings")
.FirstOrDefault(_ => _.ProjectName == mainRequestObject.ProjectName));
}
}
public EnvironmentInfo GetByEnvironmentInfoId(int EnvironmentInfoId)
{
using (var context = new ConStrContext())
{
return(context.Environments
.Include("Machines")
.Include("Machines.Projects")
.Include("Machines.Projects.ConnectionStrings")
.FirstOrDefault(_ => _.EnvironmentId == EnvironmentInfoId));
}
}
public AuthRepository()
{
_conStrContext = new ConStrContext();
_userManager = new UserManager <IdentityUser>(new UserStore <IdentityUser>(_conStrContext));
}
