public ResultResponse<CustomerSummary> Get(CustomerSummarySearchRequest request) { var response = new ResultResponse<CustomerSummary>(); try { using (var rwplDb = new RWPLLinqDataContext()) { var queryable = rwplDb.GetTable<CustomerSummary>() .Where(x => x.CompanyName.Contains(request.CustomerName)) .OrderBy(x => x.CompanyName); var skipRecord = ((request.PageNo > 0) ? (request.PageNo - 1) * request.PageSize : 0); response.PageData = queryable.Skip(skipRecord).Take(request.PageSize).ToList(); response.TotalItem = queryable.Count(); if (response.TotalItem > 0) { var totalCustomer = queryable.Count(); response.ReportSummary = string.Format("Total Customer : {0}", totalCustomer); } response.IsSuccess = true; } } catch (Exception ex) { response.IsSuccess = false; response.Exception = ex; } return response; }
public ResultResponse<ApplicationDataRequest> Get() { var response = new ResultResponse<ApplicationDataRequest>(); try { using (var rwplDb = new RWPLLinqDataContext()) { var queryableItems = rwplDb.GetTable<ItemMaster>() .Where(x => !x.IsDeleted) .OrderBy(x => x.ItemName); var queryableCustomers = rwplDb.GetTable<CustomerMaster>() .Where(x => !x.IsDeleted) .OrderBy(x => x.CustomerName); var queryableReelNo = rwplDb.GetTable<InwardMaster>() .Where(x => !x.IsDeleted) .OrderBy(x => x.ReelNo); response.Object = new ApplicationDataRequest() { Items = queryableItems.ToList(), Customers = queryableCustomers.ToList(), Stocks = queryableReelNo.ToList() }; response.IsSuccess = true; } } catch (Exception ex) { response.IsSuccess = false; response.Exception = ex; } return response; }
public ResultResponse<DispatchAnalysi> Get(DispatchAnalysiSearchRequest request) { var response = new ResultResponse<DispatchAnalysi>(); try { using (var rwplDb = new RWPLLinqDataContext()) { var skipRecord = ((request.PageNo > 0) ? (request.PageNo - 1) * request.PageSize : 0); var queryable = rwplDb.GetTable<DispatchAnalysi>() .Where(x => x.Client.Contains(request.Client) && x.ItemCode.Contains(request.ItemCode) && x.ItemName.Contains(request.ItemName) //&& (!request.IsSearchByDate || // (dispatch.Date >= request.FromDate.Date && dispatch.Date <= request.ToDate.Date)) ) .OrderBy(x => (x.Year*100) + x.Month); response.PageData = queryable.Skip(skipRecord) .Take(request.PageSize) .ToList(); response.TotalItem = queryable.Count(); if (response.TotalItem > 0) { var totalClient = queryable.Select(x => x.Client).Distinct().Count(); var totalQtyDispatch = queryable.Select(x => x.TotalDispatchQty).Sum(); response.ReportSummary = string.Format("Total Client : {0}, Total dispatch Qty : {1}", totalClient, totalQtyDispatch); } response.IsSuccess = true; } } catch (Exception ex) { response.IsSuccess = false; response.Exception = ex; } return response; }