public Interface.IworkerStatus Find(int stautsNumber)
{
var workerStatus = new InterfaceAdaptor.WorkerStatus();
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
var workerStatusFound = dbContext.tblWorkerStatus.SingleOrDefault(
x => x.statusNo == stautsNumber);
workerStatus.Staus = workerStatusFound.status;
workerStatus.StautsNo = workerStatusFound.statusNo;
}
return(workerStatus);
}
public List <Interface.IworkerStatus> Get()
{
var list = new List <Interface.IworkerStatus>();
using (LMCdatabaseDataContext dbContext = new LMCdatabaseDataContext(this.connectionString))
{
var tblWorkerStatus = dbContext.tblWorkerStatus;
foreach (var item in tblWorkerStatus)
{
var workerStatus = new InterfaceAdaptor.WorkerStatus()
{
StautsNo = item.statusNo,
Staus = item.status
};
list.Add(workerStatus);
}
}
return(list);
}
