public void add(string name, int buildingID)
{
ecomanagementContext = new EcoManagementEntities();
var c = CreateClassroom(0, name, buildingID, true);
ecomanagementContext.Classrooms.AddObject(c);
ecomanagementContext.SaveChanges();
}
public void add(string reason, DateTime powerOn, DateTime powerDown, string dayOfTheWeek, int classroomID)
{
ecomanagementContext = new EcoManagementEntities();
var schedule = CreateSchedule(0, powerOn, powerDown, dayOfTheWeek, reason, classroomID, true);
ecomanagementContext.Schedules.AddObject(schedule);
ecomanagementContext.SaveChanges();
}
public void add(string name, string MACAddress, int classroomID, int admin, int OSID)
{
ecomanagementContext = new EcoManagementEntities();
var workstation = CreateWorkstation(0, name, MACAddress, classroomID, admin, true, OSID);
ecomanagementContext.Workstations.AddObject(workstation);
ecomanagementContext.SaveChanges();
}
public void add(string name)
{
ecomanagementContext = new EcoManagementEntities();
var b = CreateBuilding(0, name, true);
ecomanagementContext.Buildings.AddObject(b);
ecomanagementContext.SaveChanges();
}
public ObjectResult <GetWorkstationsToBePoweredON_Result> getWorkStationsToPowerON()
{
EcoManagementEntities eco = new EcoManagementEntities();
ObjectResult <GetWorkstationsToBePoweredON_Result> workstationList;
workstationList = eco.GetWorkstationsToBePoweredON();
return(workstationList);
}
protected void Page_Load(object sender, EventArgs e)
{
ecomanagementContext = new EcoManagementEntities();
if (gvClassrooms.Rows.Count == 0)
{
btnInsert.Visible = false;
}
}
public void delete(int id)
{
ecomanagementContext = new EcoManagementEntities();
Whitelist whitelist = (from w in ecomanagementContext.Whitelists
where w.ID == id
select w).First();
whitelist.IsActive = false;
ecomanagementContext.SaveChanges();
}
public void delete(int id)
{
ecomanagementContext = new EcoManagementEntities();
Schedule schedule = (from s in ecomanagementContext.Schedules
where s.ID == id
select s).First();
schedule.IsActive = false;
ecomanagementContext.SaveChanges();
}
public void addWhitelist(int whitelistID, int workstationID)
{
ecomanagementContext = new EcoManagementEntities();
Workstation workstation = (from w in ecomanagementContext.Workstations
where w.ID == workstationID
select w).First();
workstation.WhitelistID = whitelistID;
ecomanagementContext.SaveChanges();
}
public void delete(int id)
{
ecomanagementContext = new EcoManagementEntities();
Workstation workstation = (from w in ecomanagementContext.Workstations
where w.ID == id
select w).First();
workstation.IsActive = false;
ecomanagementContext.SaveChanges();
}
protected void Page_Load(object sender, EventArgs e)
{
ecomanagementContext = new EcoManagementEntities();
BLL.Classroom classroom = new BLL.Classroom();
foreach (BLL.Classroom c in ecomanagementContext.Classrooms)
{
cl.Add(c);
}
}
public void add(string reason, DateTime start, DateTime end, int createdBy, int workstationID)
{
ecomanagementContext = new EcoManagementEntities();
var whitelist = CreateWhitelist(0, start, end, reason, createdBy, true);
ecomanagementContext.Whitelists.AddObject(whitelist);
ecomanagementContext.SaveChanges();
Workstation workstation = new Workstation();
workstation.addWhitelist(whitelist.ID, workstationID);
}
public void edit(int id, string name, int buildingID)
{
ecomanagementContext = new EcoManagementEntities();
Classroom classroom = new Classroom();
classroom.Name = name;
classroom.BuildingID = buildingID;
classroom.ID = id;
classroom.IsActive = true;
ecomanagementContext.Classrooms.AddObject(classroom);
ecomanagementContext.ObjectStateManager.ChangeObjectState(classroom, System.Data.EntityState.Modified);
ecomanagementContext.SaveChanges();
}
protected void Page_Load(object sender, EventArgs e)
{
BLL.OperatingSystem os = new BLL.OperatingSystem();
foreach (BLL.OperatingSystem o in os.load())
{
osl.Add(o);
}
ecomanagementContext = new EcoManagementEntities();
if (gvWorkstations.Rows.Count == 0)
{
btnInsert.Visible = false;
}
}
public ObjectSet <OperatingSystem> load()
{
ecomanagementContext = new EcoManagementEntities();
var operatingSystems = ecomanagementContext.OperatingSystems;
/* var operatingSystems = (OperatingSystem) from os in ecomanagementContext.OperatingSystems
* select new
* {
* ID = os.ID,
* OSName = os.OSName,
* IsActive = os.IsActive
* };*/
return(operatingSystems);
}
public ObjectQuery load(int buildingID)
{
ecomanagementContext = new EcoManagementEntities();
//Classroom classroom = new Classroom();
var classrooms = (ObjectQuery)from c in ecomanagementContext.Classrooms
where c.Building.ID == buildingID
select new
{
ID = c.ID,
Name = c.Name,
BuildingID = c.BuildingID,
IsActive = c.IsActive
};
return(classrooms);
}
public void edit(int id, string reason, DateTime powerOn, DateTime powerDown, string dayOfTheWeek, int classroomID)
{
ecomanagementContext = new EcoManagementEntities();
Schedule schedule = new Schedule();
schedule.ID = id;
schedule.Reason = reason;
schedule.PowerOn = powerOn;
schedule.PowerDown = powerDown;
schedule.DayOfTheWeek = dayOfTheWeek;
schedule.IsActive = true;
schedule.ClassroomID = classroomID;
ecomanagementContext.Schedules.AddObject(schedule);
ecomanagementContext.ObjectStateManager.ChangeObjectState(schedule, System.Data.EntityState.Modified);
ecomanagementContext.SaveChanges();
}
public ObjectQuery load()
{
ecomanagementContext = new EcoManagementEntities();
var whitelists = (ObjectQuery)from w in ecomanagementContext.Whitelists
where w.IsActive == true
select new
{
ID = w.ID,
Start = w.Start,
End = w.End,
Reason = w.Reason,
CreatedBy = w.CreatedBy,
IsActive = w.IsActive
};
return(whitelists);
}
public void edit(int id, string name, string MACAddress, int classroomID, int admin, int OSID)
{
ecomanagementContext = new EcoManagementEntities();
Workstation workstation = new Workstation();
workstation.ID = id;
workstation.Name = name;
workstation.MAC_Address = MACAddress;
workstation.ClassroomID = classroomID;
workstation.Admin = 0;
workstation.IsActive = true;
workstation.WhitelistID = null;
workstation.OSID = OSID;
ecomanagementContext.Workstations.AddObject(workstation);
ecomanagementContext.ObjectStateManager.ChangeObjectState(workstation, System.Data.EntityState.Modified);
ecomanagementContext.SaveChanges();
}
public ObjectQuery load(int classroomID)
{
ecomanagementContext = new EcoManagementEntities();
var schedules = (ObjectQuery)from s in ecomanagementContext.Schedules
where s.Classroom.ID == classroomID && s.IsActive == true
select new
{
ID = s.ID,
Reason = s.Reason,
PowerOn = s.PowerOn,
ClassroomID = s.ClassroomID,
PowerDown = s.PowerDown,
IsActive = s.IsActive,
DayOFTheWeek = s.DayOfTheWeek
};
return(schedules);
}
public ObjectQuery load(int classroomID)
{
ecomanagementContext = new EcoManagementEntities();
var workstations = (ObjectQuery)from w in ecomanagementContext.Workstations
where w.Classroom.ID == classroomID
where w.IsActive == true
select new
{
ID = w.ID,
Name = w.Name,
MAC_Address = w.MAC_Address,
ClassroomID = w.ClassroomID,
Admin = w.Admin,
IsActive = w.IsActive,
OSID = w.OSID
};
return(workstations);
}
public void edit(int id, string reason, DateTime start, DateTime end, int createdBy, int workstationID)
{
ecomanagementContext = new EcoManagementEntities();
Whitelist whitelist = new Whitelist();
whitelist.ID = id;
whitelist.Reason = reason;
whitelist.Start = start;
whitelist.End = end;
whitelist.CreatedBy = createdBy;
whitelist.IsActive = true;
ecomanagementContext.Whitelists.AddObject(whitelist);
ecomanagementContext.ObjectStateManager.ChangeObjectState(whitelist, System.Data.EntityState.Modified);
ecomanagementContext.SaveChanges();
Workstation workstation = new Workstation();
workstation.editWhitelist(whitelist.ID, workstationID);
}
public void cleanWhiteList()
{
EcoManagementEntities eco = new EcoManagementEntities();
eco.CleanWhitelist();
}
