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>
/// 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 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 InventoryService()
{
_context = new StockDataEntities();
}
/// <summary>
/// Trả về danh sách đơn vị
/// </summary>
/// <returns></returns>
public List <Data.Stock> GetStocks()
{
var context = new StockDataEntities();
return(context.Stocks.ToList());
}
public ItemService()
{
_context = new StockDataEntities();
}
public IssueDetailService()
{
_context = new StockDataEntities();
}
/// <summary>
/// Trả về danh sách
/// </summary>
/// <returns></returns>
public List <IssueDetail> GetIssueDetails()
{
var context = new StockDataEntities();
return(context.IssueDetails.ToList());
}
public UserService()
{
_context = new StockDataEntities();
}
public WeekReportService()
{
_context = new StockDataEntities();
}
public PageService()
{
_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 ReceiptDetailService()
{
_context = new StockDataEntities();
}
public ProductService()
{
_context = new StockDataEntities();
}
public PermissionService()
{
_context = new StockDataEntities();
}
/// <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 <Department> GetDepartments()
{
var context = new StockDataEntities();
return(context.Departments.ToList());
}
public DepartmentService()
{
_context = new StockDataEntities();
}
/// <summary>
/// Danh sách Log
/// </summary>
/// <returns></returns>
public List <Log> GetLogs()
{
var context = new StockDataEntities();
return(context.Logs.OrderByDescending(log => log.LogDate).ToList());
}
/// <summary>
/// Trả về danh sách
/// </summary>
/// <returns></returns>
public List <ReceiptDetail> GetReceiptDetails()
{
var context = new StockDataEntities();
return(context.ReceiptDetails.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 <Product> GetProducts()
{
var context = new StockDataEntities();
return(context.Products.ToList());
}
/// <summary>
/// Trả về danh sách đơn vị
/// </summary>
/// <returns></returns>
public List <Unit> GetUnits()
{
var context = new StockDataEntities();
return(context.Units.ToList());
}