/// <summary>
/// Trả về danh sách
/// </summary>
/// <returns></returns>
public List <OrderExport> GetOrderExports()
{
using (var context = new StockACEntities())
{
return(context.OrderExports.ToList());
}
}
/// <summary>
/// Trả về danh sách
/// </summary>
/// <returns></returns>
public List <OrderImportDetail> GetOrderImportDetails()
{
using (var context = new StockACEntities())
{
return(context.OrderImportDetails.ToList());
}
}
public List <InventoryView> GetAllInventories()
{
var context = new StockACEntities();
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.QuantityExport > 0
select new InventoryView()
{
ProductGroupID = product.ProductGroupID,
ProductGroupName = productGroup.ProductGroupName,
ProductID = product.ProductID,
ProductName = product.ProductName,
Price = (long)product.Price,
QuantityFirst = (int)inventory.QuantityFirst,
QuantityImport = (int)inventory.QuantityImport,
QuantityExport = (int)inventory.QuantityExport,
QuantityInventory = (int)inventory.QuantityInventory,
InventoryDate = inventory.InventoryDate,
UnitID = product.UnitID,
UnitName = unit.UnitName,
StockID = product.StockID,
}).ToList();
return(inventories);
}
/// <summary>
/// Danh sách Log
/// </summary>
/// <returns></returns>
public List <Log> GetLogs()
{
using (var context = new StockACEntities())
{
return(context.Logs.OrderByDescending(log => log.LogDate).ToList());
}
}
public List <Inventory> GetQuantityInventories()
{
using (var context = new StockACEntities())
{
return(context.Inventories.Where(
inven => inven.QuantityInventory <= 5 && !string.IsNullOrEmpty(inven.QuantityInventory.ToString())).ToList());
}
}
/// <summary>
/// Trả về danh sách
/// </summary>
/// <returns></returns>
public List <Employee> GetEmployees()
{
var context = new StockACEntities();
return(context.Employees.Include("Department")
.Where(em => em.IsManagerStock == false || em.IsManagerStock == null)
.ToList());
}
/// <summary>
/// Trả về danh sách đơn vị
/// </summary>
/// <returns></returns>
public List <Unit> GetUnits()
{
//using (var context=new StockACEntities())
//{
var context = new StockACEntities();
return(context.Units.ToList());
//}
}
/// <summary>
/// Danh sách user
/// </summary>
/// <returns></returns>
public List <User> GetUsers()
{
using (var context = new StockACEntities())
{
//List<User> users = context.Users.Include("Employee")
// .Select(u => new {
// u.Employee.EmployeeName,
// u.LastLogin
// }).ToList();
return(context.Users.ToList());
}
}
/// <summary>
/// Load danh sách nhóm hàng
/// </summary>
private void LoadGirdLookUpProductGroup()
{
using (var context = new StockACEntities())
{
var stocks = context.ProductGroups.ToList();
gridLookUpEditProductGroups.Properties.View.OptionsBehavior.AutoPopulateColumns = false;
gridLookUpEditProductGroups.Properties.DisplayMember = "ProductGroupName";
gridLookUpEditProductGroups.Properties.ValueMember = "ProductGroupID";
gridLookUpEditProductGroups.Properties.View.BestFitColumns();
gridLookUpEditProductGroups.Properties.PopupFormWidth = 406;
gridLookUpEditProductGroups.Properties.DataSource = stocks;
}
}
/// <summary>
/// Trả về thông tin user theo ID
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public User GetUserById(int userId)
{
using (var context = new StockACEntities())
{
//List<User> users = context.Users.Include("Employee")
// .Select(u => new {
// u.Employee.EmployeeName,
// u.LastLogin
// }).ToList();
return(context.Users.FirstOrDefault(u => u.UserID == userId));
}
//return _context.Users.FirstOrDefault(u => u.UserID == userId);
}
public void LoadStockForGirdLookup()
{
gridLookUpEditStock.Properties.View.OptionsBehavior.AutoPopulateColumns = false;
gridLookUpEditStock.Properties.DisplayMember = "StockName";
gridLookUpEditStock.Properties.ValueMember = "StockID";
gridLookUpEditStock.Properties.View.BestFitColumns();
gridLookUpEditStock.Properties.PopupFormWidth = 300;
using (var context = new StockACEntities())
{
gridLookUpEditStock.Properties.DataSource = context.Stocks.ToList();
}
// glKhoHang.Text = "";
}
private void GetCurrentEmployeeName()
{
if (Program.CurrentUser != null)
{
string employeeId = Program.CurrentUser.EmployeeID;
using (var context = new StockACEntities())
{
var employee = context.Employees.FirstOrDefault(e => e.EmployeeID == employeeId);
if (employee != null)
{
barItemUserName.Caption = employee.EmployeeName;
}
}
}
}
/// <summary>
/// Load danh sách Kho Hàng
/// </summary>
private void LoadDataForGridViewReportByStock(DateTime?startDate, DateTime?endDate)
{
_waitDialog.CreateWaitDialog();
_waitDialog.SetWaitDialogCaption("Chương trình đang tải dữ liệu.\n Vui lòng chờ trong giây lát!");
dockPanelReports.Text = Resources.TitleDockPanelReportByStock;
using (var context = new StockACEntities())
{
var reportByStock = (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 unit in context.Units on product.UnitID equals unit.UnitID
join stock in context.Stocks on product.StockID equals stock.StockID
select new ReportByStockView()
{
ProductGroupName = productGroup.ProductGroupName,
ProductID = product.ProductID,
ProductName = product.ProductName,
Price = (int)product.Price,
InventoryDate = inventory.InventoryDate,
UnitName = unit.UnitName,
StockName = stock.StockName,
Quantity = (int)inventory.QuantityExport,
}).ToList();
gridControl1.MainView = gridViewStocks;
if (startDate != null && endDate != null)
{
gridControl1.DataSource =
reportByStock.Where(inventory => inventory.InventoryDate >= startDate && inventory.InventoryDate <= endDate);
}
else
{
gridControl1.DataSource = reportByStock;
}
if (gridControl1.DataSource != null)
{
EnableButtonExportExelAndPrinter(true);
}
_reportViews = reportByStock;
_waitDialog.CloseWait();
}
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public List <ManagersView> GetManagers()
{
// SELECT
//Users.UserName AS Expr1,
//Users.EmployeeID AS Expr2,
//Departments.DepartmentName, Departments.DepartmentID
//AS Expr3, Employees.*
//FROM Departments
//INNER JOIN Employees ON Departments.DepartmentID = Employees.DepartmentID
//INNER JOIN Users ON Employees.EmployeeID = Users.EmployeeID
//WHERE Employees.IsManagerStock=1
//var 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 product.StockID == stockId
using (var context = new StockACEntities())
{
var managers = (from department in context.Departments
join employee in context.Employees on department.DepartmentID equals employee.DepartmentID
join user in context.Users on employee.EmployeeID equals user.EmployeeID
where employee.IsManagerStock == true
select new ManagersView()
{
DepartmentName = department.DepartmentName,
UserName = user.UserName,
EmployeeCode = employee.EmployeeCode,
EmployeeID = employee.EmployeeID,
EmployeeName = employee.EmployeeName,
Alias = employee.Alias,
Sex = employee.Sex,
Address = employee.Address,
HomeTell = employee.HomeTell,
Mobile = employee.Mobile,
Fax = employee.Fax,
Email = employee.Email,
Birthday = employee.Birthday
}).ToList();
return(managers);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtColorName.Text))
{
XtraMessageBox.Show("Vui lòng nhập vào Tên màu", "THÔNG BÁO", MessageBoxButtons.OK,
MessageBoxIcon.Warning);
txtColorName.Focus();
}
else
{
var color = new Color()
{
ColorName = txtColorName.Text,
Description = txtDescription.Text,
ColorCode = colorEditColorCode.Color.Name,
IsActive = checkEditIsActive.Checked,
};
using (var context = new StockACEntities())
{
try
{
context.Colors.Add(color);
context.SaveChanges();
if (XtraMessageBox.Show("Thêm thành công.\n Bạn có muốn thêm mới Màu Sắc nữa không?", "THÔNG BÁO", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
ResetControls();
}
else
{
DialogResult = DialogResult.No;
}
}
catch (Exception ex)
{
XtraMessageBox.Show(string.Format("Lỗi {0}", ex.Message), "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
public List <ManagersView> GetEmployeeManagers()
{
// SELECT
//Users.UserName AS Expr1,
//Users.EmployeeID AS Expr2,
//Departments.DepartmentName, Departments.DepartmentID
//AS Expr3, Employees.*
//FROM Departments
//INNER JOIN Employees ON Departments.DepartmentID = Employees.DepartmentID
//INNER JOIN Users ON Employees.EmployeeID = Users.EmployeeID
//WHERE Employees.IsManagerStock=1
//var 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 product.StockID == stockId
using (var context = new StockACEntities())
{
var managers = (from department in context.Departments
join employee in context.Employees on department.DepartmentID equals employee.DepartmentID
where employee.IsManagerStock == true
select new ManagersView()
{
EmployeeCode = employee.EmployeeCode,
EmployeeID = employee.EmployeeID,
EmployeeName = employee.EmployeeName,
Email = employee.Email,
}).ToList();
return(managers);
}
}
/// <summary>
/// Trả về danh sách đơn vị
/// </summary>
/// <returns></returns>
public List <Inventory> GetInventories()
{
var context = new StockACEntities();
return(context.Inventories.ToList());
}
public UnitService()
{
_context = new StockACEntities();
}
public OrderImportDetailService()
{
_context = new StockACEntities();
}
public ProductGroupService()
{
_context = new StockACEntities();
}
/// <summary>
/// Trả về danh sách
/// </summary>
/// <returns></returns>
public List <ProductGroup> GetProductGroups()
{
var context = new StockACEntities();
return(context.ProductGroups.ToList());
}
public SuppliersService()
{
_context = new StockACEntities();
}
/// <summary>
/// Trả về danh sách
/// </summary>
/// <returns></returns>
public List <Supplier> GetSuppliers()
{
var context = new StockACEntities();
return(context.Suppliers.Include("Area").ToList());
}
public List <Employee> GetAllEmployees()
{
var context = new StockACEntities();
return(context.Employees.Include("Department").ToList());
}
public EmployeeService()
{
_context = new StockACEntities();
}
public DepartmentService()
{
_context = new StockACEntities();
}
/// <summary>
/// Trả về danh sách đơn vị
/// </summary>
/// <returns></returns>
public List <Data.Stock> GetStocks()
{
var context = new StockACEntities();
return(context.Stocks.ToList());
}
/// <summary>
/// Trả về danh sách
/// </summary>
/// <returns></returns>
public List <Department> GetDepartments()
{
var context = new StockACEntities();
return(context.Departments.ToList());
}
public OrderExportService()
{
_context = new StockACEntities();
}
public InventoryService()
{
_context = new StockACEntities();
}
