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