/// <summary>
/// Trả về danh sách
/// </summary>
/// <returns></returns>
public List<Receipt> GetReceipts()
{
var context = new StockDataEntities();
return context.Receipts.ToList();
}
/// <summary>
/// Trả về danh sách đơn vị
/// </summary>
/// <returns></returns>
public List<Unit> GetUnits()
{
var context = new StockDataEntities();
return context.Units.ToList();
}
/// <summary>
/// Trả về danh sách
/// </summary>
/// <returns></returns>
public List<Department> GetDepartments()
{
var context = new StockDataEntities();
return context.Departments.ToList();
}
/// <summary>
/// Danh sách Log
/// </summary>
/// <returns></returns>
public List<Log> GetLogs()
{
var context = new StockDataEntities();
return context.Logs.OrderByDescending(log => log.LogDate).ToList();
}
public List<InventoryView> GetAllInventories()
{
var context = new StockDataEntities();
List<InventoryView> inventories = (from inventory in context.Inventories
join product in context.Products on inventory.ProductID equals product.ProductID
join productGroup in context.ProductGroups on product.ProductGroupID equals productGroup.ProductGroupID
//join stock in context.Stocks on product.StockID equals stock.StockID
join unit in context.Units on product.UnitID equals unit.UnitID
where inventory.TotalOut > 0
select new InventoryView()
{
ProductGroupID = product.ProductGroupID,
ProductGroupName = productGroup.ProductGroupName,
ProductID = product.ProductID,
ProductName = product.ProductName,
Price = (long) product.Price,
QuantityFirst = (int) inventory.InventoryFirt,
QuantityImport = (int) inventory.TotalIn,
QuantityExport = (int) inventory.TotalOut,
QuantityInventory = (int) inventory.InventoryLast,
InventoryDate = inventory.InventoryDate,
UnitID = product.UnitID,
UnitName = unit.UnitName,
StockID = product.StockID,
}).ToList();
return inventories;
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public List<ReportTotalView> GetReportTotals()
{
var context = new StockDataEntities();
var reportTotals = (from inventory in context.Inventories
join product in context.Products on inventory.ProductID equals product.ProductID
//join stock in context.Stocks on product.StockID equals stock.StockName
join unit in context.Units on product.UnitID equals unit.UnitID
//join productGroup in context.ProductGroups on product.ProductGroupID equals productGroup.ProductGroupID
select new ReportTotalView()
{
ProductID = product.ProductID,
ProductName = product.ProductName,
Description = product.Description,
SPQ = unit.UnitName,
Price = (float) product.Price,
Inventory = (int) inventory.InventoryFirt,
Plan = (int) (inventory.Plan==null ? inventory.Plan : 0),
TotalIn = (int) inventory.TotalIn,
TotalOut = (int) inventory.TotalOut,
InventoryLast = (int) inventory.InventoryLast,
InventoryPrice = (float) product.Price,
InventoryDate = inventory.InventoryDate,
SearchByDate = inventory.Date,
}).ToList();
return reportTotals;
}
/// <summary>
/// Danh sách user
/// </summary>
/// <returns></returns>
public List<User> GetUsers()
{
var context = new StockDataEntities();
return context.Users.ToList();
}
/// <summary>
/// Trả về danh sách
/// </summary>
/// <returns></returns>
public List<Issue> GetIssues()
{
var context = new StockDataEntities();
return context.Issues.ToList();
}
/// <summary>
/// Trả về danh sách
/// </summary>
/// <returns></returns>
public List<Product> GetProducts()
{
var context = new StockDataEntities();
return context.Products.ToList();
}
/// <summary>
/// Trả về danh sách đơn vị
/// </summary>
/// <returns></returns>
public List<Data.Stock> GetStocks()
{
var context = new StockDataEntities();
return context.Stocks.ToList();
}
/// <summary>
/// Trả về danh sách đơn vị
/// </summary>
/// <returns></returns>
public List<Inventory> GetInventories()
{
var context = new StockDataEntities();
return context.Inventories.ToList();
}
/// <summary>
/// Trả về danh sách
/// </summary>
/// <returns></returns>
public List<WeekReport> GetWeekReports(string reportDate)
{
var context = new StockDataEntities();
if (string.IsNullOrEmpty(reportDate))
{
return context.WeekReports.ToList();
}
return context.WeekReports.Where(w => w.ReportDate == reportDate).ToList();
}
/// <summary>
/// Danh sách item theo user
/// </summary>
/// <param name="userName"></param>
/// <returns></returns>
public List<Item> GetItemsByUserName(string userName)
{
var context = new StockDataEntities();
var items = from item in context.Items
where item.Users.Any(u => u.Username == userName)
select item;
return items.ToList();
}
public List<UserPermission> GetPermissionsByUserName(string userName)
{
var context = new StockDataEntities();
var permissionsByUsername = (from perUser in context.UserPermissions
join permission in context.Permissions on perUser.ObjectID equals permission.ObjectID
where perUser.Username == userName
select perUser
).ToList();
return permissionsByUsername;
}
public DepartmentService()
{
_context = new StockDataEntities();
}
public StockService()
{
_context = new StockDataEntities();
}
public PermissionService()
{
_context = new StockDataEntities();
}
public List<Inventory> GetQuantityInventories()
{
var context = new StockDataEntities();
return context.Inventories.Where(inven => inven.InventoryLast <= 5 && !string.IsNullOrEmpty(inven.InventoryLast.ToString())).ToList();
}
public InventoryService()
{
_context = new StockDataEntities();
}
//public Inventory GetInventoryById(Guid inventoryId)
//{
// return _context.Inventories.FirstOrDefault(inven => inven.ID == inventoryId);
//}
public List<ReportByDepartment> GetReportsByDepartments()
{
var context = new StockDataEntities();
var reportsByDepartments = (from issueDetails in context.IssueDetails
join product in context.Products on issueDetails.ProductID equals product.ProductID
join unit in context.Units on product.UnitID equals unit.UnitID
join department in context.Departments on issueDetails.DepartmentID equals department.DepartmentID
select new ReportByDepartment()
{
ProductID = product.ProductID,
ProductName = product.ProductName,
Description = product.Description,
SPQ = unit.UnitName,
Price = (float) product.Price,
DepartmentID = department.DepartmentName,
}).ToList();
return reportsByDepartments;
}
public ReceiptService()
{
_context = new StockDataEntities();
}
public WeekReportService()
{
_context = new StockDataEntities();
}
public ProductService()
{
_context = new StockDataEntities();
}
public IssueDetailService()
{
_context = new StockDataEntities();
}