public static List <PendingRequestModel> getRejectedRequest(string EmployeeCode)
{
using (var context = new SalesReturndbEntities())
{
List <PendingRequestModel> dataList = null;
var RejectedRequestList = context.SP_GetRejectedRequest(EmployeeCode).ToList();
if (RejectedRequestList != null)
{
dataList = RejectedRequestList.Select(x => new PendingRequestModel()
{
BatchNo = x.BatchNo,
DealerAddress = x.DealerAddress,
DealerCode = x.DealerCode,
DealerName = x.DealerName,
DepotName = x.DepotName,
DepotAddress = x.DepotAddress,
DepotCode = x.DepotCode,
RequestHeaderId = x.RequestHeaderId,
CurrentStatus = x.CurrentStatus,
CurrentStatus_Id = x.CurrentStatus_Id,
SKUCode = x.SKUCode,
SKUName = x.SKUName,
CreatedBy_EMP_CODE = x.CreatedBy,
CreatedBy = context.SP_LFGDetails(x.CreatedBy).FirstOrDefault().Emp_First_name,
CreatedDate = x.CreatedDate,
TotalSRV = context.tblRequestDtls.Where(o => o.RequestHeaderId == x.RequestHeaderId && o.IsActive == true).Sum(p => p.SRVValue).Value,
RequestTypeOption = x.SKUCode,// for access data behalf on skucode
}).ToList();
return(dataList);
}
return(dataList);
}
}
public static int GetRejectRequestCount(string empCode)
{
using (var context = new SalesReturndbEntities())
{
int Count = context.SP_GetRejectedRequest(empCode).Count();
return(Count);
}
}