public Interface.Idepartment Find(int deparmentNo)
{
var department = new InterfaceAdaptor.Department();
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
var item = dbContext.tblDepartments.SingleOrDefault(x => x.department == deparmentNo);
department.Active = (bool)item.active;
department.Address = item._address;
department.AltPhoneNo = item.altPhoneNo;
department.CompanyName = item.companyName;
department.CvrNo = item.cvrNo;
department.Deparment = item.department;
department.Email = item.email;
department.PhoneNo = item.phoneNo;
#region department => DeparmentHead : Worker
department.DeparmentHead = new InterfaceAdaptor.Worker()
{
Active = (bool)item.tblWorker.active,
Address = item.tblWorker.homeAddress,
AltPhoneNo = item.tblWorker.altPhoneNo,
Email = item.tblWorker.email,
Name = item.tblWorker.name,
PhoneNo = item.tblWorker.phoneNo,
Surname = item.tblWorker.surname,
WorkNo = item.tblWorker.workNo,
#region DeparmentHead => Post number
PostNo = new InterfaceAdaptor.PostNo()
{
City = item.tblWorker.tblPostNo.city,
Id = item.tblWorker.tblPostNo.ID,
PostNumber = item.tblWorker.tblPostNo.postNo
},
#endregion
#region DeparmentHead => Worker Status
WorkerStatus = new InterfaceAdaptor.WorkerStatus()
{
Staus = item.tblWorker.tblWorkerStatus.status,
StautsNo = item.tblWorker.tblWorkerStatus.statusNo
}
#endregion
};
#endregion
//88
department.PostNo = new InterfaceAdaptor.PostNo()
{
City = item.tblPostNo.city,
Id = item.tblPostNo.ID,
PostNumber = item.tblPostNo.postNo
};
}
return(department);
}
public List <Interface.Idepartment> Get(bool?active)
{
var list = new List <Interface.Idepartment>();
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
IQueryable <tblDepartment> dbContentDepartments;
if (active == null)
{
dbContentDepartments = from tblDepartment in dbContext.tblDepartments
select tblDepartment;
}
else
{
dbContentDepartments = from tblDepartment in dbContext.tblDepartments
where tblDepartment.active == active
select tblDepartment;
}
foreach (var item in dbContentDepartments)
{
var department = new InterfaceAdaptor.Department();
department.Active = (bool)item.active;
department.Address = item._address;
department.AltPhoneNo = item.altPhoneNo;
department.CompanyName = item.companyName;
department.CvrNo = item.cvrNo;
department.Deparment = item.department;
department.Email = item.email;
department.PhoneNo = item.phoneNo;
department.DeparmentHead = new InterfaceAdaptor.Worker()
{
Active = (bool)item.tblWorker.active,
Address = item.tblWorker.homeAddress,
AltPhoneNo = item.tblWorker.altPhoneNo,
Email = item.tblWorker.email,
Name = item.tblWorker.name,
PhoneNo = item.tblWorker.phoneNo,
PostNo = new InterfaceAdaptor.PostNo()
{
City = item.tblWorker.tblPostNo.city,
Id = item.tblWorker.tblPostNo.ID,
PostNumber = item.tblWorker.tblPostNo.postNo
},
Surname = item.tblWorker.surname,
WorkerStatus = new InterfaceAdaptor.WorkerStatus()
{
Staus = item.tblWorker.tblWorkerStatus.status,
StautsNo = item.tblWorker.tblWorkerStatus.statusNo
},
WorkNo = item.tblWorker.workNo
};
department.PostNo = new InterfaceAdaptor.PostNo()
{
City = item.tblPostNo.city,
Id = item.tblPostNo.ID,
PostNumber = item.tblPostNo.postNo
};
list.Add(department);
}
}
return(list);
}
