public static int GetApprovedRequestCount(string empCode) { using (var context = new SalesReturndbEntities()) { int Count = context.SP_GetApprovedRequest(empCode).Count(); return(Count); } }
public static List <PendingRequestModel> getApprovedRequest(string EmployeeCode) { using (var context = new SalesReturndbEntities()) { List <PendingRequestModel> dataList = null; var ApprovedRequestList = context.SP_GetApprovedRequest(EmployeeCode).ToList(); if (ApprovedRequestList != null) { dataList = ApprovedRequestList.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, // CreatedBy = x.EmpName, CreatedDate = x.CreatedDate, //TotalSRV = context.tblRequestDtls.Where(o=>o.RequestHeaderId == x.RequestHeaderId && o.IsActive == true).Sum(p=>p.SRVValue).Value, TotalSRV = x.SRVValue, RequestTypeOption = x.SKUCode,// for access data behalf on skucode }).ToList(); return(dataList); } return(dataList); } }