public Outage GetOutage(int?id)
{
ApplicationOutageEntities entities = new ApplicationOutageEntities();
Outage outage = entities.Outages.Find(id);
return(outage);
}
public Outage DeleteOutage(int id)
{
ApplicationOutageEntities entities = new ApplicationOutageEntities();
Outage outage = entities.Outages.Find(id);
entities.Outages.Remove(outage);
entities.SaveChanges();
return(outage);
}
public ActionResult Add()
{
ApplicationOutageEntities entities = new ApplicationOutageEntities();
ViewBag.Applications = entities.Applications.Select(x => new SelectListItem {
Text = x.ApplicationName, Value = x.ID.ToString()
});
ViewBag.Components = Components.GetComponents();
return(View());
}
// GET: Outage
public ActionResult Index()
{
List <Outage> outage;
ApplicationManager applicationManager = new ApplicationManager();
applicationManager.GetApplicationList();
ViewBag.Applications = applicationManager.GetApplicationList();
ViewBag.Components = Components.GetComponents();
using (ApplicationOutageEntities entities = new ApplicationOutageEntities())
{
outage = entities.Outages.Include("Application").ToList();
}
return(View(outage));
}
public bool EditOutage(Outage outage)
{
using (ApplicationOutageEntities entities = new ApplicationOutageEntities())
{
entities.Entry(outage).State = EntityState.Modified;
entities.SaveChanges();
if (outage.StartDate.Month != outage.EndDate.Month)
{
Outage outageDelete = entities.Outages.Find(outage.ID);
entities.Outages.Remove(outage);
entities.SaveChanges();
DateTime newEndDate = new DateTime(outage.StartDate.Year, outage.StartDate.Month, (DateTime.DaysInMonth(outage.StartDate.Year, outage.StartDate.Month)), 23, 59, 00);
entities.Outages.Add(new Outage()
{
ApplicationID = outage.ApplicationID,
StartDate = outage.StartDate,
EndDate = newEndDate,
Component = outage.Component,
IncidentNumber = outage.IncidentNumber,
Impact = outage.Impact,
Description = outage.Description
});
DateTime newStartDate = new DateTime(outage.EndDate.Year, outage.EndDate.Month, 1, 00, 00, 00);
entities.Outages.Add(new Outage()
{
ApplicationID = outage.ApplicationID,
StartDate = newStartDate,
EndDate = outage.EndDate,
Component = outage.Component,
IncidentNumber = outage.IncidentNumber,
Impact = outage.Impact,
Description = outage.Description
});
}
else
{
entities.Outages.Add(outage);
}
entities.SaveChanges();
return(true);
}
}
public JsonResult TotalAvailability(int Year, int Month)
{
double TotalOutage = 0;
DateTime startDate = new DateTime(Year, Month, 1, 00, 00, 00);
DateTime endDate = new DateTime(Year, Month, DateTime.DaysInMonth(Year, Month), 23, 59, 00);
using (ApplicationOutageEntities entities = new ApplicationOutageEntities())
{
var outageList = entities.Outages.Where(x => x.StartDate >= startDate && x.EndDate <= endDate).ToList();
if (outageList != null && outageList.Any())
{
foreach (var outage in outageList)
{
TotalOutage += (outage.EndDate - outage.StartDate).TotalMinutes;
}
}
}
return(Json(new { outage = TotalOutage }));
}
public List <Application> GetApplicationList()
{
ApplicationOutageEntities entities = new ApplicationOutageEntities();
return(entities.Applications.ToList());
}