public List <MovementRequestViewModel> GetMovementRequestCompleted()
{
List <MovementRequestViewModel> result = new List <MovementRequestViewModel>();
var movement = _movementrequest.GetMovementRequestToMove();
List <MovementRequestSearchResult> movementrequestlist = new List <MovementRequestSearchResult>();
foreach (var item in movement)
{
MovementRequestViewModel model = new MovementRequestViewModel();
model.MovementRequest = new MovementRequestSearchResult();
var approvalname = _pref.GetLookupByApprovalStatusCode(item.ApprovalStatus);
model.MovementRequest.ID = item.ID;
model.MovementRequest.MovementDate = item.MovementDate;
model.MovementRequest.Description = item.Description;
model.MovementRequest.ApprovedDate = item.ApprovedDate;
model.MovementRequest.LocationID = item.LocationID;
model.MovementRequest.LocationName = item.Location != null ? item.Location.Name : null;
model.MovementRequest.ApprovedBy = item.ApprovedBy;
model.MovementRequest.Notes = item.Notes;
model.MovementRequest.ApprovalStatus = item.ApprovalStatus;
model.MovementRequest.ApprovalStatusName = approvalname != null ? approvalname.Value : null;
model.MovementRequestDetail = new List <MovementRequestDetailViewModel>();
movementrequestlist.Add(model.MovementRequest);
foreach (var detail in item.MovementRequestDetail)
{
if (detail.DeletedDate == null)
{
MovementRequestDetailViewModel mvdetail = new MovementRequestDetailViewModel();
var moveasset = _assetlocation.GetAssetLocationByMovementDetailID(detail.ID);
mvdetail.Quantity = detail.Quantity;
mvdetail.Transfered = moveasset != null ? moveasset.Count : 0;
if (mvdetail.Quantity == mvdetail.Transfered)
{
var categoryname = _pref.GetLookupByCategoryCode(detail.AssetCategoryCD);
var department = _department.GetDepartmentByID(detail.RequestedTo);
mvdetail.ID = detail.ID;
mvdetail.MovementRequestID = detail.MovementRequestID;
mvdetail.Description = detail.Description;
mvdetail.AssetCategoryCD = detail.AssetCategoryCD;
mvdetail.CategoryCDName = categoryname != null ? categoryname.Value : null;
mvdetail.RequestTo = detail.RequestedTo;
mvdetail.RequestToName = department != null ? department.Name : null;
model.MovementRequestDetail.Add(mvdetail);
}
}
}
if (model.MovementRequestDetail.Count != 0)
{
result.Add(model);
}
}
return(result);
}
public List <MovementRequestViewModel> GetMovementRequestNeedApproval()
{
List <MovementRequestViewModel> result = new List <MovementRequestViewModel>();
var movement = _movementrequest.GetMovementRequestNeedApproval();
foreach (var item in movement)
{
MovementRequestViewModel model = new MovementRequestViewModel();
var approvalname = _pref.GetLookupByApprovalStatusCode(item.ApprovalStatus);
model.ID = item.ID;
model.MovementDate = item.MovementDate;
model.Description = item.Description;
model.ApprovedDate = item.ApprovedDate;
model.LocationID = item.LocationID;
model.LocationName = item.Location != null ? item.Location.Name : null;
model.ApprovedBy = item.ApprovedBy;
model.Notes = item.Notes;
model.ApprovalStatus = item.ApprovalStatus;
model.ApprovalStatusName = approvalname != null ? approvalname.Value : null;
model.MovementRequestDetail = new List <MovementRequestDetailViewModel>();
foreach (var item2 in item.MovementRequestDetail)
{
if (item2.DeletedBy == null && item2.DeletedDate == null)
{
MovementRequestDetailViewModel detail = new MovementRequestDetailViewModel();
var categoryname = _pref.GetLookupByCategoryCode(item2.AssetCategoryCD);
var deparment = _department.GetDepartmentByID(item2.RequestedTo);
var moveasset = _assetlocation.GetAssetLocationByMovementDetailID(item2.ID);
detail.ID = item2.ID;
detail.MovementRequestID = item2.MovementRequestID;
detail.Description = item2.Description;
detail.AssetCategoryCD = item2.AssetCategoryCD;
detail.CategoryCDName = categoryname != null ? categoryname.Value : null;
detail.RequestTo = item2.RequestedTo;
detail.RequestToName = deparment != null ? deparment.Name : null;
detail.Quantity = item2.Quantity;
detail.Transfered = moveasset != null ? moveasset.Count : 0;
model.MovementRequestDetail.Add(detail);
}
}
result.Add(model);
}
return(result);
}
public MovementRequestViewModel GetMovementRequestToMoveByID(int id)
{
var movement = _movementrequest.GetMovementRequestByID(id);
MovementRequestViewModel result = new MovementRequestViewModel();
result.MovementRequest = new MovementRequestSearchResult();
var approvalname = _pref.GetLookupByApprovalStatusCode(movement.ApprovalStatus);
result.MovementRequest.ID = movement.ID;
result.MovementRequest.MovementDate = movement.MovementDate;
result.MovementRequest.LocationID = movement.LocationID;
result.MovementRequest.LocationName = movement.Location != null ? movement.Location.Name : null;
result.MovementRequest.Description = movement.Description;
result.MovementRequest.ApprovedDate = movement.ApprovedDate;
result.MovementRequest.ApprovedBy = movement.ApprovedBy;
result.MovementRequest.Notes = movement.Notes;
result.MovementRequest.ApprovalStatus = movement.ApprovalStatus;
result.MovementRequest.ApprovalStatusName = approvalname != null ? approvalname.Value : null;
result.MovementRequestDetail = new List <MovementRequestDetailViewModel>();
foreach (var item in movement.MovementRequestDetail)
{
if (item.DeletedDate == null && item.DeletedBy == null)
{
MovementRequestDetailViewModel detail = new MovementRequestDetailViewModel();
var categoryname = _pref.GetLookupByCategoryCode(item.AssetCategoryCD);
var deparment = _department.GetDepartmentByID(item.RequestedTo);
var moveasset = _assetlocation.GetAssetLocationByMovementDetailID(item.ID);
detail.Quantity = item.Quantity;
detail.Transfered = moveasset != null ? moveasset.Count : 0;
if (detail.Quantity != detail.Transfered)
{
detail.ID = item.ID;
detail.MovementRequestID = item.MovementRequestID;
detail.Description = item.Description;
detail.AssetCategoryCD = item.AssetCategoryCD;
detail.CategoryCDName = categoryname != null ? categoryname.Value : null;
detail.RequestTo = item.RequestedTo;
detail.RequestToName = deparment != null ? deparment.Name : null;
result.MovementRequestDetail.Add(detail);
}
}
}
return(result);
}
