public static int GetPendingBillingClosureRequestCount(string empCode) { using (var context = new SalesReturndbEntities()) { int Count = context.SP_GetPendingSRVClosureRequest(empCode).Count(); return(Count); } }
public static List <PendingRequestModel> getRequestforBillingClosure(string employeeCode) { using (var context = new SalesReturndbEntities()) { List <PendingRequestModel> dataList = null; var PendingRequestList = context.SP_GetPendingSRVClosureRequest(employeeCode).ToList(); if (PendingRequestList != null) { dataList = PendingRequestList.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, FutureStatus = x.FutureStatus, RequestHeaderId = x.RequestHeaderId, FutureStatus_Id = x.FutureStatus_Id, 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); }; }