public ActionResult <IEnumerable <Naboo.DataAccess.Model.Host> > Get()
{
var dbContext = new Naboo.DataAccess.Model.OSAgnosticContext("server=186.177.106.36;database=osagnostic;user=root;pwd=Jcv1821@t5");
var hosts = dbContext.Host.ToList();
return(hosts);
}
public static object StateChangeServer()
{
bool result = false;
var dbContext = new Naboo.DataAccess.Model.OSAgnosticContext(ConnectionHandler.ConnectionString());
try
{
var hostsDb = (from itemDb in dbContext.Host select itemDb).ToList();
if (hostsDb != null)
{
foreach (var item in hostsDb)
{
if (item.UpdateDate < DateTime.Now.AddSeconds(-30) && item.State == true)
{
item.State = false;
}
}
dbContext.SaveChanges();
result = true;
}
}
catch (Exception ex)
{
}
return(result);
}
public static List <Naboo.Entities.Job> JobByHostId(int HostId)
{
var dbContext = new Naboo.DataAccess.Model.OSAgnosticContext(ConnectionHandler.ConnectionString());
var jobs = dbContext.Job.Where(c => c.HostId == HostId).OrderBy(f => f.Id).ToList().Convert();
return(jobs);
}
public static int JobInaActive(int HostId)
{
var dbContext = new Naboo.DataAccess.Model.OSAgnosticContext(ConnectionHandler.ConnectionString());
var count = dbContext.Job.Count(c => c.HostId == HostId && c.State == false);
return(count);
}
public static Host Add(Host item)
{
Host result = new Host();
var dbContext = new Naboo.DataAccess.Model.OSAgnosticContext(ConnectionHandler.ConnectionString());
Naboo.DataAccess.Model.Host hostDb = item.Convert();
dbContext.Host.Add(hostDb);
dbContext.SaveChanges();
result = hostDb.Convert();
return(result);
}
public static Entities.Job Add(Entities.Job item)
{
Entities.Job result = new Entities.Job();
var dbContext = new Naboo.DataAccess.Model.OSAgnosticContext(ConnectionHandler.ConnectionString());
Naboo.DataAccess.Model.Job jobDb = item.Convert();
dbContext.Job.Add(jobDb);
dbContext.SaveChanges();
result = jobDb.Convert();
return(result);
}
public static List <Naboo.Entities.Host> All()
{
List <Naboo.Entities.Host> result = new List <Entities.Host>();
var dbContext = new Naboo.DataAccess.Model.OSAgnosticContext(ConnectionHandler.ConnectionString());
var hostDb = dbContext.Host.OrderByDescending(c => c.State).ToList();
result = hostDb.Convert();
foreach (var item in result)
{
item.JobActive = Handler.JobHandler.JobActive(item.Id);
item.JobInaActive = Handler.JobHandler.JobInaActive(item.Id);
}
return(result);
}
public static dynamic Exist(string Name)
{
bool result = false;
int Id = 0;
var dbContext = new Naboo.DataAccess.Model.OSAgnosticContext(ConnectionHandler.ConnectionString());
var hostDb = dbContext.Host.Where(c => c.Name.ToLower().Equals(Name.ToLower())).FirstOrDefault();
if (hostDb != null)
{
result = true;
Id = hostDb.Id;
}
return(new { Exist = result, Id = Id });
}
public static dynamic Exist(string Code, int HostId)
{
bool result = false;
int Id = 0;
var dbContext = new Naboo.DataAccess.Model.OSAgnosticContext(ConnectionHandler.ConnectionString());
var jobDb = dbContext.Job.Where(c => c.Code.ToLower().Equals(Code.ToLower()) && c.HostId == HostId).FirstOrDefault();
if (jobDb != null)
{
result = true;
Id = jobDb.Id;
}
return(new { Exist = result, Id = Id });
}
public static object StateChange(int id, bool state)
{
bool result = false;
var dbContext = new Naboo.DataAccess.Model.OSAgnosticContext(ConnectionHandler.ConnectionString());
try
{
var hostDb = dbContext.Host.Where(c => c.Id == id).FirstOrDefault();
if (hostDb != null)
{
hostDb.State = state;
dbContext.SaveChanges();
result = true;
}
}
catch (Exception ex)
{
}
return(result);
}
