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