public ActionResult CreateNewTag(string title)
{
Tag newTag = new Tag(title);
using (var db = new ServerDb())
{
var old = db.Tags.Where(m => m.title == newTag.title)
.FirstOrDefault();
// Save Existing
if (old != null)
{
db.Tags.Remove(old);
db.Tags.Add(newTag);
}
// Save New
else
{
db.Tags.Add(newTag);
}
db.SaveChanges();
}
return PartialView(newTag);
}
public ActionResult GetTags()
{
using (var db = new ServerDb())
{
var result = db.Tags
.ToList();
return PartialView(result);
}
}
public List<MasterEntity> Servers()
{
using (var db = new ServerDb())
{
var result = db.Servers
.Include(m => m.services)
.Include("applications.dependencies")
.ToList();
return result;
}
}
public JsonResult Entities()
{
using (var db = new ServerDb())
{
var result = db.Servers
.Include(m => m.services)
.Include("applications.dependencies")
.ToList();
return Json(result, JsonRequestBehavior.AllowGet);
}
}
public ActionResult Details(string id)
{
using (var db = new ServerDb())
{
var result = db.Servers
.Include(m => m.environment)
.Include(m => m.services)
.Include(m => m.iis)
.Include("iis.websites.applicationPools")
.Where(m => m.Id == id)
.FirstOrDefault();
return View(result);
}
}
public ActionResult Index()
{
using (var db = new ServerDb())
{
var result = db.Servers
.Include(m => m.services)
.Include(m => m.environment)
.Include(m => m.owner)
.Include("services.dependencies")
.OrderByDescending(m => m.Id)
.Skip(0)
.Take(50)
.ToList();
return PartialView(result);
}
}
public object Post([FromBody] MasterEntity content)
{
var json = this.Request.Content.ReadAsStringAsync().Result;
Console.WriteLine(json);
using (var db = new ServerDb())
{
// Check if the server already exists in the DB
var old = db.Servers.Where(m => m.Id == content.Id)
.Include(m => m.environment)
.Include(m => m.iis)
.FirstOrDefault();
// Save Existing Server
if (old != null)
{
db.Servers.Remove(old);
db.Servers.Add(content);
db.SaveChanges();
}
// Save New Server
else {
db.Servers.Add(content);
try
{
db.SaveChanges();
}
catch (System.Data.Entity.Validation.DbEntityValidationException e)
{
throw;
}
}
}
return Request.CreateResponse(HttpStatusCode.OK, "OK");
}