public bool PutWorkRequest(WorkRequest workRequest)
{
var maxWOCode = dbPrisma.WOrequest.Max(x => x.worequest_code);
//TODO: Entitytranslator
var woRequest = new WOrequest
{
worequest_code = maxWOCode + 1,
blbuilding_code = workRequest.BuildingCode,
blfloor_code = workRequest.FloorCode,
blroom_code = workRequest.RoomCode,
createdby = workRequest.CreatedBy,
createddate = DateTime.Now,
descr = workRequest.Description,
partwo_code = 1,
status = "1",
woaction_code = workRequest.WOActionCode,
reqphone = workRequest.Telephone
};
dbPrisma.WOrequest.Add(woRequest);
dbPrisma.SaveChanges();
return true;
}
public ResponseMessageGetWorkRequest GetWorkRequest(RequestMessageGetWorkRequest request)
{
List<WorkRequest> workRequestList = new List<WorkRequest>();
IEnumerable<WOrequest> woRequestList = dbPrisma.WOrequest.Where(x => x.createdby.Equals(request.Username));
//TODO: Entitytranslator
foreach (var req in woRequestList)
{
WorkRequest workRequest = new WorkRequest();
workRequest.BuildingCode = req.blbuilding_code;
workRequest.CreatedBy = req.createdby;
workRequest.CreatedDate = req.createddate;
workRequest.Description = req.descr;
workRequest.FloorCode = req.blfloor_code;
workRequest.RoomCode = req.blroom_code;
workRequest.WOActionCode = req.woaction_code;
workRequest.WORequestCode = req.worequest_code;
workRequest.WorkorderCode = req.wo_code;
workRequest.WorkorderPartCode = req.partwo_code;
workRequestList.Add(workRequest);
}
ResponseMessageGetWorkRequest response = new ResponseMessageGetWorkRequest();
response.WorkRequestList = workRequestList;
return response;
}
