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