public IQueryable <SalesOrderDto> GetAllSalesOrder() { var list = from s in _salesOrder.GetAll() select new SalesOrderDto() { SalesOrderID = s.SalesOrderID, SalesOrderNum = s.SalesOrderNum, Messenger = s.Messenger, PaymentTerms = s.PaymentTerms, BranchID = s.BranchID, BranchName = s.Branch == null ? string.Empty : s.Branch.BranchName, BranchAddress = s.Branch == null ? string.Empty : s.Branch.BranchAddress, BranchDetails = s.Branch == null ? string.Empty : s.Branch.BranchDetails, CustomerID = s.CustomerID, CustomerCode = s.Customer == null ? string.Empty : s.Customer.CustomerCode, CustomerFirstName = s.Customer == null ? string.Empty : s.Customer.FirstName, CustomerMiddleName = s.Customer == null ? string.Empty : s.Customer.MiddleName, CustomerLastName = s.Customer == null ? string.Empty : s.Customer.LastName, CustomerAddress = s.Customer == null ? string.Empty : s.Customer.Address, CreatedBy = s.CreatedBy, DateCreated = s.DateCreated, DiscountPercentage = s.DiscountPercentage, SalesOrderDetails = s.SalesOrderDetails.Where(sd => sd.SalesOrderID == s.SalesOrderID).Select(sod => new SalesOrderDetailDto() { SalesOrderID = sod.SalesOrderID, SalesOrderDetailID = sod.SalesOrderDetailID, ProductID = sod.ProductID, Quantity = sod.Quantity, UnitID = sod.UnitID, UnitPrice = sod.UnitPrice }).ToList() }; return(list); }
public IQueryable <ReportCombinationDto> GetAll() { var list = from report in _reportCombination.GetAll() select new ReportCombinationDto() { TrackingID = report.TrackingID, ProductID = report.ProductID, ProductCode = report.Product == null ? string.Empty : report.Product.ProductCode, ProductName = report.Product == null ? string.Empty : report.Product.ProductName, ProductDesc = report.Product == null ? string.Empty : report.Product.ProductDesc, ProductExtension = report.Product == null ? string.Empty : report.Product.ProductExtension, ProductSize = report.Product == null ? string.Empty : report.Product.Size, Remarks = report.Remarks, PurchaseOrderQty = report.PurchaseOrderQty, SalesOrderQty = report.SalesOrderQty, ProductQty = report.ProductQty, Qty = report.Qty, RequestType = report.RequestType, RequestNum = report.RequestNum, BranchDetails = report.Product == null ? string.Empty : report.Product.Branch == null ? string.Empty : report.Product.Branch.BranchDetails, BranchAddress = report.Product == null ? string.Empty : report.Product.Branch == null ? string.Empty : report.Product.Branch.BranchAddress, BranchName = report.Product == null ? string.Empty : report.Product.Branch == null ? string.Empty : report.Product.Branch.BranchName, BranchId = report.Product == null ? null : report.Product.Branch == null ? null : (int?)report.Product.Branch.BranchID, DateCreated = report.DateCreated //Branch }; return(list); }
public IQueryable <ProductDto> GetAll() { var list = from p in _product.GetAll() select new ProductDto() { ProductID = p.ProductID, ProductCode = p.ProductCode, ProductName = p.ProductName, ProductDesc = p.ProductDesc, ProductExtension = p.ProductExtension, Quantity = p.Quantity, OriginalPrice = p.OriginalPrice, Price = p.Price, CategoryID = p.CategoryID, CategoryName = p.Category == null ? null : p.Category.CategoryName, CategoryCode = p.Category == null ? null : p.Category.CategoryCode, ModelID = p.ModelID, Model = p.Model == null ? null : p.Model.ModelName, IsActive = p.IsActive, Remarks = p.Remarks, CreatedBy = p.CreatedBy, DateCreated = p.DateCreated, UpdatedBy = p.UpdatedBy, DateUpdated = p.DateUpdated, ProductImage = p.ProductImage, Size = p.Size, BranchID = p.BranchID, BarCode = p.BarCode, BranchName = p.Branch == null ? string.Empty : p.Branch.BranchName }; return(list); }
public IQueryable <CustomerPriceDto> GetAll() { var list = from cp in _customerprice.GetAll() select new CustomerPriceDto() { CustomerPriceId = cp.CustomerPriceID, CustomerId = cp.Customer == null ? null : (int?)cp.Customer.CustomerID, FirstName = cp.Customer == null ? null : cp.Customer.FirstName, LastName = cp.Customer == null ? null : cp.Customer.LastName, MiddleName = cp.Customer == null ? null : cp.Customer.MiddleName, Extension = cp.Customer == null ? null : cp.Customer.Extension, Address = cp.Customer == null ? null : cp.Customer.Address, City = cp.Customer == null ? null : cp.Customer.City, CustomerCode = cp.Customer == null ? null : cp.Customer.CustomerCode, Region = cp.Customer == null ? null : cp.Customer.Region, ZipCode = cp.Customer == null ? null : cp.Customer.ZipCode, ProductId = cp.Product == null ? null : (int?)cp.Product.ProductID, ProductCode = cp.Product == null ? null : cp.Product.ProductCode, ProductName = cp.Product == null ? null : cp.Product.ProductName, ProductDesc = cp.Product == null ? null : cp.Product.ProductDesc, Quantity = cp.Product == null ? null : (decimal?)cp.Product.Quantity, ProductPrice = cp.Product == null ? null : (decimal?)cp.Product.Price, CategoryName = cp.Product == null ? null : cp.Product.Category == null ? null : cp.Product.Category.CategoryName, Price = cp.Price, CreatedBy = cp.CreatedBy, DateCreated = cp.DateCreated, DateUpdated = cp.DateUpdated, UpdatedBy = cp.UpdatedBy }; return(list); }
public IQueryable <DiscountDto> GetAll() { var list = from d in _discount.GetAll() select new DiscountDto() { BranchID = d.BranchID, DiscountPercentage = d.DiscountPercentage, DiscountID = d.DiscountID, CreatedBy = d.CreatedBy, DateCreated = d.DateCreated, DateUpdated = d.DateUpdated, UpdatedBy = d.UpdatedBy, BranchName = d.Branch == null ? string.Empty : d.Branch.BranchName, BranchAddress = d.Branch == null ? string.Empty : d.Branch.BranchAddress, BranchDetails = d.Branch == null ? string.Empty : d.Branch.BranchDetails, IsActive = d.IsActive, CreatedByUserName = d.CreatedBy == null ? string.Empty : d.User_CreatedBy.UserName, UpdatedByUserName = d.UpdatedBy == null ? string.Empty : d.User_UpdatedBy.UserName //CreatedByUserName = d.CreatedBy == null ? string.Empty : (from u in _userService.GetAll().ToList() where u.UserID == u.CreatedBy && u.IsActive select u).FirstOrDefault().UserName, //UpdatedByUserName = d.UpdatedBy == null ? string.Empty : (from u in _userService.GetAll().ToList() where u.UserID == u.UpdatedBy && u.IsActive select u).FirstOrDefault().UserName //CreatedByUserName = d.CreatedBy == null ? string.Empty : _userService.GetAll().ToList().Where(u => u.UserID == d.CreatedBy).FirstOrDefault().UserName, //UpdatedByUserName = d.UpdatedBy == null ? string.Empty : _userService.GetAll().ToList().Where(u => u.UserID == d.UpdatedBy).FirstOrDefault().UserName }; return(list); }
public int GeneratePONumber() { DateTime today = System.DateTime.Now; DateTime endOfMonth = new DateTime(today.Year, today.Month, DateTime.DaysInMonth(today.Year, today.Month)); var list = _purchaseOrder.GetAll().Where(s => DbFunctions.TruncateTime(s.DateCreated) >= DbFunctions.TruncateTime(today) && DbFunctions.TruncateTime(s.DateCreated) <= DbFunctions.TruncateTime(endOfMonth)).ToList(); return(list.Count); }
public IQueryable <UserTypeDto> GetAllUserType() { var list = from ut in _userType.GetAll() select new UserTypeDto() { UserTypeID = ut.UserTypeID, UserTypeName = ut.UserTypeName }; return(list); }
public IQueryable <ModelDto> GetAll() { var list = from m in _model.GetAll() select new ModelDto() { ModelID = m.ModelID, ModelName = m.ModelName }; return(list); }
public IQueryable <SupplierDetailsDto> GetAll() { var result = from det in _supplier.GetAll() select new SupplierDetailsDto() { SupplierId = det.SupplierID, SupplierCode = det.SupplierCode, SupplierName = det.SupplierName, DateCreated = det.DateCreated, CreatedBy = det.CreatedBy }; return(result); }
public IQueryable <CategoryDto> GetAll() { var list = from c in _category.GetAll() select new CategoryDto() { CategoryCode = c.CategoryCode.Trim(), CategoryID = c.CategoryID, CategoryName = c.CategoryName.Trim(), CategoryDisplay = c.CategoryCode.Trim() + " - " + c.CategoryName.Trim(), IsActive = c.IsActive, SortOrder = c.SortOrder }; return(list); }
public IQueryable <BranchDto> GetAll() { var list = from b in _branch.GetAll() select new BranchDto() { BranchId = b.BranchID, BranchName = b.BranchName, BranchDetails = b.BranchDetails, BranchAddress = b.BranchAddress, CreatedBy = b.CreatedBy, CreatedDate = b.CreatedDate, DateUpdated = b.DateUpdated, UpdatedBy = b.UpdatedBy }; return(list); }
public IQueryable <CustomerDetailsDto> GetAll() { var result = from det in _customer.GetAll() select new CustomerDetailsDto() { CustomerId = det.CustomerID, CustomerCode = det.CustomerCode, CustomerName = det.CustomerName, CustomerAddress = det.CustomerAddress, DateCreated = det.DateCreated, CreatedBy = det.CreatedBy, DateUpdated = det.DateUpdated, UpdatedBy = det.UpdatedBy }; return(result); }
public IQueryable <SalesOrderDetailDto> GetAllSalesOrderDetail() { var list = from s in _salesOrderDetail.GetAll() select new SalesOrderDetailDto() { SalesOrderID = s.SalesOrderID, SalesOrderNum = s.SalesOrder == null ? string.Empty : s.SalesOrder.SalesOrderNum, ProductID = s.ProductID, ProductCode = s.Product == null ? string.Empty : s.Product.ProductCode, ProductName = s.Product == null ? string.Empty : s.Product.ProductName, ProductDesc = s.Product == null ? string.Empty : s.Product.ProductDesc, ProductExt = s.Product == null ? string.Empty : s.Product.ProductExtension, UnitID = s.UnitID, UnitDesc = s.Unit == null ? string.Empty : s.Unit.UnitDesc, Quantity = s.Quantity, UnitPrice = s.UnitPrice, SalesOrderDetailID = s.SalesOrderDetailID }; return(list); }
public IQueryable <AuthenticationDto> GetAll() { var list = from u in _user.GetAll() select new AuthenticationDto() { UserID = u.UserID, Password = u.Password, HashPassword = u.HashPassword, IsActive = u.IsActive, UserName = u.UserName, UserTypeID = u.UserTypeID, UserTypeName = u.UserType == null ? string.Empty : u.UserType.UserTypeName, CreatedBy = u.CreatedBy, DateCreated = u.DateCreated, DateUpdated = u.DateUpdated, UpdatedBy = u.UpdatedBy, BranchId = u.BranchID, BranchName = u.Branch == null ? string.Empty : u.Branch.BranchName }; return(list); }
public IQueryable <BatchSummariesDto> GetAllBatchSummaries() { var list = from batch in _batchSummary.GetAll() select new BatchSummariesDto() { BatchNo = batch.BatchNo, FileName = batch.FileName, FilePath = batch.FilePath, TotalRecords = batch.TotalRecords, Successful = batch.Successful, Failed = batch.Failed, UploadStatus = batch.UploadStatus, IsDownload = batch.IsDownload, ResultFileName = batch.ResultFileName, ResultFilePath = batch.ResultFilePath, UploadedBy = batch.UploadedBy, StartUpload = batch.StartUpload, EndUpload = batch.EndUpload }; return(list); }