//Get all resources (Employees) from DB.
public JsonResult GetResources()
{
ResourceEventContext db = new ResourceEventContext();
db.Configuration.ProxyCreationEnabled = false;
var resources = db.Employees.ToList();
//Tempory holder for resrouces
List <resourceModel> resList = new List <resourceModel>();
foreach (var emp in resources)
{
resourceModel res = new resourceModel();
res.title = emp.FirstName + " " + emp.LastName;
res.id = emp.EmployeeID;
res.groupId = emp.Occupation;
resList.Add(res);
}
return(new JsonResult {
Data = resList, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult SaveEmployee(Employee emp)
{
ResourceEventContext db = new ResourceEventContext();
db.Configuration.ProxyCreationEnabled = false;
var status = false;
//If the event ID is bigger than zero its a existing event.
if (emp.EmployeeID > 0)
{
//Grabs event with given ID from the database
var oldEvent = db.Employees.Where(a => a.EmployeeID == emp.EmployeeID).FirstOrDefault();
if (oldEvent != null)
{
//Replaces fields that has been updated
oldEvent.FirstName = emp.FirstName;
oldEvent.LastName = emp.LastName;
oldEvent.Occupation = emp.Occupation;
oldEvent.EmployeeID = emp.EmployeeID;
}
}
//If a new event is added, it just adds the new event to DB
else
{
db.Employees.Add(emp);
}
db.SaveChanges();
status = true;
return(new JsonResult {
Data = new { status = status }
});
}
public JsonResult DeleteEmployee(int employeeID)
{
ResourceEventContext db = new ResourceEventContext();
db.Configuration.ProxyCreationEnabled = false;
var status = false;
List <Event> empEvent = new List <Event>();
//Finds event by ID which should be deleted
var emp = db.Employees.Where(a => a.EmployeeID == employeeID).FirstOrDefault();
if (emp != null)
{
//Removes events connected to Employee from DB
if (db.Events.Where(x => x.EmployeeID == employeeID).Any())
{
empEvent = db.Events.Where(x => x.EmployeeID == employeeID).ToList();
foreach (Event tempev in empEvent)
{
db.Events.Remove(tempev);
}
empEvent.Clear();
}
db.Employees.Remove(emp);
db.SaveChanges();
status = true;
}
return(new JsonResult {
Data = new { status = status }
});
}
//Methods for grabbing data to render Schedule
//Get all Events from DB
public JsonResult GetEvents()
{
ResourceEventContext db = new ResourceEventContext();
db.Configuration.ProxyCreationEnabled = false;
var events = db.Events.ToList();
//Tempory holder for resrouces
List <resourceModel> resList = new List <resourceModel>();
foreach (var evnt in events)
{
//Finds Employee Linked to Event
Employee tempEmp = new Employee();
tempEmp = db.Employees.Where(c => c.EmployeeID == evnt.EmployeeID).FirstOrDefault();
//Saves All information about event to temporary result model
resourceModel res = new resourceModel();
res.EventID = evnt.EventID;
res.EmployeeID = tempEmp.EmployeeID;
res.EventTitle = evnt.Title;
res.Start = evnt.Start;
res.IsFullDay = evnt.IsFullDay;
res.ThemeColor = evnt.ThemeColor;
//Adding text to event description depending on how long employee works that day
if (res.IsFullDay)
{
res.Description = tempEmp.FirstName + " " + tempEmp.LastName + " works full time today";
}
else
{
res.End = evnt.End;
TimeSpan?timeDif = res.End - res.Start;
res.Description = tempEmp.FirstName + " " + tempEmp.LastName + ", works " + timeDif.Value.TotalHours + " hours today.";
}
resList.Add(res);
}
return(new JsonResult {
Data = resList, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult Save1WEvent(DateTime startDate, DateTime endDate)
{
var status = false;
int nrOfDuplicate = 0;
ResourceEventContext db = new ResourceEventContext();
db.Configuration.ProxyCreationEnabled = false;
var eventCopyList = db.Events.Where(e => e.Start >= startDate && e.End <= endDate).ToList();
if (eventCopyList != null)
{
status = true;
foreach (var evnt in eventCopyList)
{
// Check if a event at specified time already is saved
bool duplicateEvent = db.Events.Any(e => e.EmployeeID == evnt.EmployeeID &&
e.Start.Year == evnt.Start.Year &&
e.Start.Month == evnt.Start.Month &&
e.Start.Day == evnt.Start.Day + 7);
if (!duplicateEvent)
{
evnt.EventID = 0;
evnt.Start = evnt.Start.AddDays(7);
if (evnt.End.HasValue)
{
evnt.End = evnt.End.Value.AddDays(7);
}
SaveEvent(evnt);
}
else
{
nrOfDuplicate++;
}
}
}
return(new JsonResult {
Data = new { status = status, nrOfDuplicate = nrOfDuplicate }
});
}
public JsonResult DeleteViewEvents(DateTime startDate, DateTime endDate)
{
var status = false;
ResourceEventContext db = new ResourceEventContext();
db.Configuration.ProxyCreationEnabled = false;
var eventDelList = db.Events.Where(e => e.Start >= startDate && e.End <= endDate).ToList();
if (eventDelList != null)
{
foreach (var evnt in eventDelList)
{
DeleteEvent(evnt.EventID);
}
status = true;
}
return(new JsonResult {
Data = new { status = status }
});
}
public JsonResult DeleteEvent(int eventID)
{
ResourceEventContext db = new ResourceEventContext();
db.Configuration.ProxyCreationEnabled = false;
var status = false;
//Finds event by ID which should be deleted
var evnt = db.Events.Where(a => a.EventID == eventID).FirstOrDefault();
if (evnt != null)
{
//Removes event from DB
db.Events.Remove(evnt);
db.SaveChanges();
status = true;
}
return(new JsonResult {
Data = new { status = status }
});
}
public JsonResult SaveEvent(Event evnt)
{
ResourceEventContext db = new ResourceEventContext();
db.Configuration.ProxyCreationEnabled = false;
var status = false;
//If the event ID is bigger than zero its a existing event.
if (evnt.EventID > 0)
{
//Grabs event with given ID from the database
var oldEvent = db.Events.Where(a => a.EventID == evnt.EventID).FirstOrDefault();
if (oldEvent != null)
{
//Replaces fields that has been updated
oldEvent.EventID = evnt.EventID;
oldEvent.EmployeeID = evnt.EmployeeID;
oldEvent.Title = evnt.Title;
oldEvent.Start = evnt.Start;
oldEvent.End = evnt.End;
oldEvent.IsFullDay = evnt.IsFullDay;
oldEvent.Description = evnt.Description;
oldEvent.ThemeColor = evnt.ThemeColor;
}
}
//If a new event is added, it just adds the new event to DB
else
{
db.Events.Add(evnt);
}
db.SaveChanges();
status = true;
return(new JsonResult {
Data = new { status = status }
});
}
