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);
}