public List <DepartmentDto> GetAllDepartment()
{
try
{//TODO: Departman Çağırma Performans Çalışması
List <DepartmentDto> deplist = new List <DepartmentDto>();
using (var context = new locationappEntities())
{
var departmentList = from d in context.departments
join s in context.subunits on d.SubUnitID equals s.SubUnitID
join m in context.mainunits on s.MainUnitID equals m.MainUnitID
select new
{
DID = d.DepartmentID,
DName = d.Name,
DDesc = d.Description,
DOther = d.Other,
SID = s.SubUnitID,
SName = s.Name,
SMID = s.MainUnitID,
MID = m.MainUnitID,
MName = m.Name
};
foreach (var item in departmentList)
{
DepartmentDto depDto = new DepartmentDto();
depDto.DepartmentID = item.DID;
depDto.Name = item.DName;
depDto.Other = item.DOther;
depDto.SubUnitID = item.SID;
depDto.Description = item.DDesc;
depDto.SubUnitDto = new SubUnitDto();
depDto.SubUnitDto.SubUnitID = item.SID;
depDto.SubUnitDto.Name = item.SName;
depDto.SubUnitDto.MainUnitDto = new MainUnitDto();
depDto.SubUnitDto.MainUnitID = item.SMID.Value;
depDto.SubUnitDto.MainUnitDto.Name = item.MName;
depDto.SubUnitDto.MainUnitDto.MainUnitID = item.MID;
deplist.Add(depDto);
}
return(deplist);
}
}
catch (Exception ex)
{
return(new List <DepartmentDto>());
}
}
public List <DeviceDto> GetAllDeviceWithRoomAndUser()
{
try
{
List <DeviceDto> deviceList = new List <DeviceDto>();
using (var context = new locationappEntities())
{
var query = from d in context.devices
join dt in context.devicetypes on d.DeviceTypeID equals dt.DeviceTypeID
join dr in context.devicerooms on d.DeviceID equals dr.DeviceID into deviceroom
from dr in deviceroom.DefaultIfEmpty()
join r in context.rooms on dr.RoomID equals r.RoomID into room
from r in room.DefaultIfEmpty()
join du in context.deviceusers on d.DeviceID equals du.DeviceID into deviceuser
from du in deviceuser.DefaultIfEmpty()
join u in context.users on du.UserID equals u.UserID into user
from u in user.DefaultIfEmpty()
select new
{
DeviceID = d.DeviceID,
DeviceName = d.Name,
TypeName = dt.Name,
TypeID = dt.DeviceTypeID,
Properties = d.Properties,
Technology = d.Technology,
DeviceRoomID = dr == null ? 0 : dr.DeviceRoomID,
RoomID = r == null ? 0 : r.RoomID,
RName = r == null ? "(-)" : r.Name,
DFLocationx = dr == null ? "(-)" : dr.LocationX,
DFLocationy = dr == null ? "(-)" : dr.LocationX,
DFCreationDate = dr == null ? null : dr.CreationDate,
UserID = u == null ? 0 : u.UserID,
UserFullName = u == null ? "(-)" : u.Name + " " + u.SurName,
DevUserID = du == null ? 0 : du.DeviceUserID
};
foreach (var item in query)
{
DeviceDto deviceDto = new DeviceDto();
deviceDto.DeviceID = item.DeviceID;
deviceDto.Name = item.DeviceName;
deviceDto.Properties = item.Properties;
deviceDto.Technology = item.Technology;
deviceDto.DeviceTypeDto = new DeviceTypeDto();
deviceDto.DeviceTypeDto.DeviceTypeID = item.TypeID;
deviceDto.DeviceTypeDto.Name = item.TypeName;
deviceDto.RoomDto = new RoomDto();
deviceDto.RoomDto.RoomID = item.RoomID;
deviceDto.RoomDto.Name = item.RName;
deviceDto.DeviceRoomDto = new DeviceRoomDto();
deviceDto.DeviceRoomDto.DeviceRoomID = item.DeviceRoomID;
deviceDto.DeviceRoomDto.DeviceID = item.DeviceID;
deviceDto.DeviceRoomDto.Location_X = item.DFLocationx;
deviceDto.DeviceRoomDto.Location_Y = item.DFLocationy;
deviceDto.DeviceRoomDto.CreationDate = item.DFCreationDate.Value;
deviceList.Add(deviceDto);
}
return(deviceList);
}
}
catch (Exception ex)
{
return(new List <DeviceDto>());
}
}
public UnitOfWork()
{
dbC = new locationappEntities();
}
