void ConfigureDlg()
{
enumcomboOperation.ItemsEnum = typeof(ExpenseType);
enumcomboOperation.Binding.AddBinding(Entity, s => s.TypeOperation, w => w.SelectedItem).InitializeFromSource();
var filterCasher = new EmployeeFilter(UoW);
filterCasher.ShowFired = false;
yentryCasher.RepresentationModel = new ViewModel.EmployeesVM(filterCasher);
yentryCasher.Binding.AddBinding(Entity, s => s.Casher, w => w.Subject).InitializeFromSource();
var filterEmployee = new EmployeeFilter(UoW);
filterEmployee.ShowFired = false;
yentryEmployee.RepresentationModel = new ViewModel.EmployeesVM(filterEmployee);
yentryEmployee.Binding.AddBinding(Entity, s => s.Employee, w => w.Subject).InitializeFromSource();
yentryEmployee.ChangedByUser += (sender, e) => UpdateEmployeeBalaceInfo();
ydateDocument.Binding.AddBinding(Entity, s => s.Date, w => w.Date).InitializeFromSource();
OrmMain.GetObjectDescription <ExpenseCategory> ().ObjectUpdated += OnExpenseCategoryUpdated;
OnExpenseCategoryUpdated(null, null);
comboExpense.Binding.AddBinding(Entity, s => s.ExpenseCategory, w => w.SelectedItem).InitializeFromSource();
yspinMoney.Binding.AddBinding(Entity, s => s.Money, w => w.ValueAsDecimal).InitializeFromSource();
ytextviewDescription.Binding.AddBinding(Entity, s => s.Description, w => w.Buffer.Text).InitializeFromSource();
ExpenseType type = (ExpenseType)enumcomboOperation.SelectedItem;
ylabelEmployeeWageBalance.Visible = type == ExpenseType.EmployeeAdvance ||
type == ExpenseType.Salary;
UpdateEmployeeBalaceInfo();
}
private string ReturnFilterString(EmployeeFilter filter, string filterText)
{
string compiledText = "&";
switch (filter)
{
case EmployeeFilter.Gender:
compiledText += "gender=" + filterText;
break;
case EmployeeFilter.Race:
compiledText += "race=" + filterText;
break;
case EmployeeFilter.MonthlyBirthDays:
compiledText += "birth_date_range=" + filterText;
break;
case EmployeeFilter.Email:
compiledText += "email__contains=" + filterText;
break;
}
return(compiledText);
}
/// <summary>
/// Lấy danh sách nhân viên có lọc
/// </summary>
/// <param name="employeeFilter">Bộ lọc nhân viên</param>
/// <returns>Danh sách nhân viên</returns>
/// CreatedBy: dbhuan (09/05/2021)
public Paging <Employee> GetEmployees(EmployeeFilter employeeFilter)
{
var res = new Paging <Employee>()
{
Page = employeeFilter.Page,
PageSize = employeeFilter.PageSize
};
// Thiết lập kết nối DB.
using var connection = new MySqlConnection(_connectionString);
// Tính tổng nhân viên.
int?totalRecord = connection.QueryFirstOrDefault <int>("Proc_GetTotalEmployees", employeeFilter, commandType: CommandType.StoredProcedure);
if (totalRecord == null)
{
return(res);
}
res.TotalRecord = totalRecord;
// Lấy danh sách nhân viên.
var employees = connection.Query <Employee>("Proc_GetEmployees", employeeFilter, commandType: CommandType.StoredProcedure);
res.Data = employees;
return(res);
}
/// <summary>
/// Lấy nhanh sách nhân viên theo điều kiện
/// </summary>
/// <param name="employeeFilter">
/// Page
/// PageSize
/// Search
/// </param>
/// <returns>Danh sách nv</returns>
/// CreatedBy KDLong 07/05/2021
public Pagging <Employee> GetEmployees(EmployeeFilter employeeFilter)
{
using (dbConnection = new MySqlConnection(connectionString))
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@Search", employeeFilter.Search);
var totalRecords = dbConnection.QueryFirstOrDefault <int>("Proc_GetTotalEmployees", param: parameters, commandType: CommandType.StoredProcedure);
var totalPages = Math.Ceiling((decimal)totalRecords / employeeFilter.PageSize);
var employees = dbConnection.Query <Employee>("Proc_GetEmployeesFilter", param: employeeFilter, commandType: CommandType.StoredProcedure);
// Dữ liệu pagging
var paging = new Pagging <Employee>()
{
TotalRecords = totalRecords,
TotalPages = (int)totalPages,
Data = employees,
PageIndex = employeeFilter.Page,
PageSize = employeeFilter.PageSize
};
return(paging);
}
}
private IEnumerable <Employee> FilterAndSortEmployees(EmployeeFilter filter, Func <Employee, bool> predicate)
{
IEnumerable <Employee> filteredSortedCollection;
// Параметры сортировки
string sortField = filter.SortField ?? "Default";
string order = filter.SortOrder ?? "Asc";
// Компараторы сортировки по возрастанию или по убыванию
IComparer <string> stringComparer = Comparer <string> .Create((x, y) => order.Equals("Asc")?(x ?? "").CompareTo(y ?? "") : (y ?? "").CompareTo(x ?? ""));
IComparer <double?> doubleNullableComparer = Comparer <double?> .Create((x, y) => order.Equals("Asc")?(x ?? 0).CompareTo(y ?? 0) : (y ?? 0).CompareTo(x ?? 0));
IComparer <DateTime> dateTimeComparer = Comparer <DateTime> .Create((x, y) => order.Equals("Asc")?x.CompareTo(y) : y.CompareTo(x));
switch (sortField)
{
case "LastName": filteredSortedCollection = Database.Employees.Get(predicate).OrderBy(e => e.LastName, stringComparer); break;
case "Email": filteredSortedCollection = Database.Employees.Get(predicate).OrderBy(e => e.Contacts.Email, stringComparer); break;
case "HireDate": filteredSortedCollection = Database.Employees.Get(predicate).OrderBy(e => e.HireDate, dateTimeComparer); break;
case "Salary": filteredSortedCollection = Database.Employees.Get(predicate).OrderBy(e => e.Post.Salary, doubleNullableComparer); break;
case "Bonus": filteredSortedCollection = Database.Employees.Get(predicate).OrderBy(e => e.Post.Premium, doubleNullableComparer); break;
case "PostTitle": filteredSortedCollection = Database.Employees.Get(predicate).OrderBy(e => e.Post.Title, stringComparer); break;
case "DepartmentName": filteredSortedCollection = Database.Employees.Get(predicate).OrderBy(e => e.Post.Department.DepartmentName, stringComparer); break;
default: filteredSortedCollection = Database.Employees.Get(predicate).OrderBy(e => e.LastName); break;
}
return(filteredSortedCollection);
}
void ConfigureDlg()
{
var filterEmployee = new EmployeeFilter(UoW);
filterEmployee.ShowFired = false;
yentryEmployee.RepresentationModel = new ViewModel.EmployeesVM(filterEmployee);
yentryEmployee.Binding.AddBinding(Entity, e => e.Accountable, w => w.Subject).InitializeFromSource();
var filterCasher = new EmployeeFilter(UoW);
filterCasher.ShowFired = false;
yentryCasher.RepresentationModel = new ViewModel.EmployeesVM(filterCasher);
yentryCasher.Binding.AddBinding(Entity, e => e.Casher, w => w.Subject).InitializeFromSource();
ydateDocument.Binding.AddBinding(Entity, s => s.Date, w => w.Date).InitializeFromSource();
OrmMain.GetObjectDescription <ExpenseCategory>().ObjectUpdated += OnExpenseCategoryUpdated;
OnExpenseCategoryUpdated(null, null);
comboExpense.Binding.AddBinding(Entity, s => s.ExpenseCategory, w => w.SelectedItem).InitializeFromSource();
yspinMoney.Binding.AddBinding(Entity, s => s.Money, w => w.ValueAsDecimal).InitializeFromSource();
ytextviewDescription.Binding.AddBinding(Entity, s => s.Description, w => w.Buffer.Text).InitializeFromSource();
ytreeviewDebts.ColumnsConfig = ColumnsConfigFactory.Create <RecivedAdvance>()
.AddColumn("Закрыть").AddToggleRenderer(a => a.Selected).Editing()
.AddColumn("Дата").AddTextRenderer(a => a.Advance.Date.ToString())
.AddColumn("Получено").AddTextRenderer(a => a.Advance.Money.ToString("C"))
.AddColumn("Непогашено").AddTextRenderer(a => a.Advance.UnclosedMoney.ToString("C"))
.AddColumn("Статья").AddTextRenderer(a => a.Advance.ExpenseCategory.Name)
.AddColumn("Основание").AddTextRenderer(a => a.Advance.Description)
.Finish();
}
void ConfigureDlg()
{
ylabelDate.Binding.AddFuncBinding(Entity, e => e.Date.ToString("D"), w => w.LabelProp).InitializeFromSource();
yspinMoney.Binding.AddBinding(Entity, e => e.TotalMoney, w => w.ValueAsDecimal).InitializeFromSource();
yentryPremiumReasonString.Binding.AddBinding(Entity, e => e.PremiumReasonString, w => w.Text).InitializeFromSource();
var filterRouteList = new RouteListsFilter(UoW);
filterRouteList.SetFilterDates(DateTime.Today.AddDays(-7), DateTime.Today.AddDays(1));
Entity.ObservableItems.ListContentChanged += ObservableItems_ListContentChanged;
var filterAuthor = new EmployeeFilter(UoW);
yentryAuthor.RepresentationModel = new EmployeesVM(filterAuthor);
yentryAuthor.Binding.AddBinding(Entity, e => e.Author, w => w.Subject).InitializeFromSource();
ytreeviewItems.ColumnsConfig = ColumnsConfigFactory.Create <PremiumItem>()
.AddColumn("Сотрудник").AddTextRenderer(x => x.Employee.FullName)
.AddColumn("Премия").AddNumericRenderer(x => x.Money).Editing().Digits(2)
.Adjustment(new Gtk.Adjustment(0, 0, 10000000, 1, 10, 10))
.AddColumn("Причина штрафа").AddTextRenderer(x => x.Premium.PremiumReasonString)
.Finish();
ytreeviewItems.ItemsDataSource = Entity.ObservableItems;
}
public void GetEmployeesTest()
{
var item1 = new EmployeeInfo()
{
Surname = "Poberezets",
Name = "Vladislav",
Patronymic = "Olegovich",
Birthday = new DateTime(1990, 12, 2)
};
var item2 = new EmployeeInfo()
{
Surname = "Antonov",
Name = "Dmitriy",
Patronymic = "Valentinovich",
Birthday = new DateTime(1984, 7, 21)
};
_repository.AddEmployee(item1);
_repository.AddEmployee(item2);
long totalItems;
var filter = new EmployeeFilter()
{
CurrenPage = 1,
PageSize = 10
};
var employees = _repository.GetEmployees(filter, out totalItems);
Assert.IsTrue(employees.Count > 1);
}
public List <Employee> Filter([FromBody] EmployeeFilter filter)
{
var employeeA = new Employee();
employeeA.Name = filter.Name_Contains;
employeeA.Salary = filter.Salary_From ?? 0;
employeeA.IsActive = filter.IsActive ?? false;
employeeA.DateOfBirth = filter.DateOfBirth_From ?? DateTime.Now;
employeeA.InternetPoints = filter.InternetPoints_From ?? 0;
employeeA.KarmaPoints = filter.KarmaPoints_From ?? 0;
employeeA.NetWorth = filter.NetWorth_From ?? 0;
var employeeB = new Employee();
employeeB.Name = filter.Name_Contains;
employeeB.Salary = filter.Salary_To ?? 0;
employeeB.IsActive = filter.IsActive ?? false;
employeeB.DateOfBirth = filter.DateOfBirth_To ?? DateTime.Now;
employeeB.InternetPoints = filter.InternetPoints_To ?? 0;
employeeB.KarmaPoints = filter.KarmaPoints_To ?? 0;
employeeB.NetWorth = filter.NetWorth_To ?? 0;
return(new List <Employee>()
{
employeeA, employeeB
});
}
//public async Task<IEnumerable<Employee>> Search(string name, Gender? gender)
public async Task <IEnumerable <Employee> > Search(EmployeeFilter filter)
{
//int gnd = (int)filter.Gender;
IQueryable <Employee> query = appDbContext.Employees;
//var x = string.IsNullOrEmpty(filter.Name) ? DBNull.Value : filter.Name;
SqlParameter name = new SqlParameter("@Name", string.IsNullOrEmpty(filter.Name) ? (object)DBNull.Value : filter.Name);
SqlParameter Email = new SqlParameter("@Email", string.IsNullOrEmpty(filter.Email) ? (object)DBNull.Value : filter.Email);
SqlParameter Gender = new SqlParameter("@Gender", filter.Gender == null || (int)filter.Gender == -1 ? (object)DBNull.Value : (int)filter.Gender);
SqlParameter DepartmentId = new SqlParameter("@DepartmentId", filter.DepartmentId == null || (int)filter.DepartmentId == -1 ? (object)DBNull.Value : filter.DepartmentId);
var result = appDbContext.Employees.
FromSqlRaw <Employee>("spSearchEmployees @Name, @Email, @Gender ,@DepartmentId"
, name, Email, Gender, DepartmentId).ToListAsync();
return(await result);
//if (!string.IsNullOrEmpty(name))
//{
// query = query.Where(e => e.FirstName.Contains(name)
// || e.LastName.Contains(name));
//}
//if (gender != null)
//{
// query = query.Where(e => e.Gender == gender);
//}
//return await query.ToListAsync();
}
void ConfigureDlg()
{
ylabelNumber.Binding.AddBinding(Entity, x => x.Title, x => x.LabelProp).InitializeFromSource();
yentryOrganization.SubjectType = typeof(Organization);
yentryOrganization.Binding.AddBinding(Entity, x => x.Organization, x => x.Subject).InitializeFromSource();
yentryOrganization.Changed += (sender, e) => {
UpdateStates();
};
var filterDefaultForwarder = new EmployeeFilter(UoW);
filterDefaultForwarder.SetAndRefilterAtOnce(x => x.RestrictCategory = EmployeeCategory.driver);
yentryDriver.RepresentationModel = new EmployeesVM(filterDefaultForwarder);
yentryDriver.Binding.AddBinding(Entity, x => x.Driver, x => x.Subject).InitializeFromSource();
yentryCar.SubjectType = typeof(Car);
yentryCar.Binding.AddBinding(Entity, x => x.Car, x => x.Subject).InitializeFromSource();
RefreshParserRootObject();
templatewidget.CanRevertCommon = QSMain.User.Permissions["can_set_common_additionalagreement"];
templatewidget.Binding.AddBinding(Entity, e => e.DocumentTemplate, w => w.Template).InitializeFromSource();
templatewidget.Binding.AddBinding(Entity, e => e.ChangedTemplateFile, w => w.ChangedDoc).InitializeFromSource();
templatewidget.BeforeOpen += Templatewidget_BeforeOpen;
UpdateStates();
}
public IActionResult Employees([FromQuery] EmployeeFilter filter)
{
return(Ok(dbContext.Employees
.Include(i => i.EmployeeTerritories)
.ThenInclude(ti => ti.Territory)
.ApplyFilter(filter)));
}
public IEnumerable <Employee> Search(EmployeeFilter filter)
{
var queryable = this.Predicate();
if (!string.IsNullOrEmpty(filter.Name))
{
queryable = queryable.Where(x => x.Name.ToLower().Contains(filter.Name.ToLower()));
}
if (!string.IsNullOrEmpty(filter.DocumentNumber))
{
queryable = queryable.Where(x => x.DocumentNumber.ToLower().Contains(filter.DocumentNumber.ToLower()));
}
if (filter.Gender.HasValue)
{
queryable = queryable.Where(x => x.Gender == filter.Gender.Value);
}
if (filter.BeginBirthDate.HasValue)
{
queryable = queryable.Where(x => filter.BeginBirthDate.Value >= x.BirthDate);
}
if (filter.EndBirthDate.HasValue)
{
queryable = queryable.Where(x => x.BirthDate <= filter.EndBirthDate.Value);
}
return(queryable.ToList());
}
private void ConfigureDlg()
{
notebook1.Page = 0;
notebook1.ShowTabs = false;
dataentryModel.Binding.AddBinding(Entity, e => e.Model, w => w.Text).InitializeFromSource();
dataentryRegNumber.Binding.AddBinding(Entity, e => e.RegistrationNumber, w => w.Text).InitializeFromSource();
yentryVIN.Binding.AddBinding(Entity, e => e.VIN, w => w.Text).InitializeFromSource();
yentryManufactureYear.Binding.AddBinding(Entity, e => e.ManufactureYear, w => w.Text).InitializeFromSource();
yentryMotorNumber.Binding.AddBinding(Entity, e => e.MotorNumber, w => w.Text).InitializeFromSource();
yentryChassisNumber.Binding.AddBinding(Entity, e => e.ChassisNumber, w => w.Text).InitializeFromSource();
yentryCarcaseNumber.Binding.AddBinding(Entity, e => e.Carcase, w => w.Text).InitializeFromSource();
yentryColor.Binding.AddBinding(Entity, e => e.Color, w => w.Text).InitializeFromSource();
yentryDocSeries.Binding.AddBinding(Entity, e => e.DocSeries, w => w.Text).InitializeFromSource();
yentryDocNumber.Binding.AddBinding(Entity, e => e.DocNumber, w => w.Text).InitializeFromSource();
yentryDocIssuedOrg.Binding.AddBinding(Entity, e => e.DocIssuedOrg, w => w.Text).InitializeFromSource();
ydatepickerDocIssuedDate.Binding.AddBinding(Entity, e => e.DocIssuedDate, w => w.DateOrNull).InitializeFromSource();
var filter = new EmployeeFilter(UoW);
filter.SetAndRefilterAtOnce(x => x.RestrictCategory = EmployeeCategory.driver);
dataentryreferenceDriver.RepresentationModel = new EmployeesVM(filter);
dataentryreferenceDriver.Binding.AddBinding(Entity, e => e.Driver, w => w.Subject).InitializeFromSource();
dataentryFuelType.SubjectType = typeof(FuelType);
dataentryFuelType.Binding.AddBinding(Entity, e => e.FuelType, w => w.Subject).InitializeFromSource();
radiobuttonMain.Active = true;
dataspinbutton1.Binding.AddBinding(Entity, e => e.FuelConsumption, w => w.Value).InitializeFromSource();
maxWeightSpin.Binding.AddBinding(Entity, e => e.MaxWeight, w => w.ValueAsInt).InitializeFromSource();
maxVolumeSpin.Binding.AddBinding(Entity, e => e.MaxVolume, w => w.Value).InitializeFromSource();
minBottlesSpin.Binding.AddBinding(Entity, e => e.MinBottles, w => w.ValueAsInt).InitializeFromSource();
maxBottlesSpin.Binding.AddBinding(Entity, e => e.MaxBottles, w => w.ValueAsInt).InitializeFromSource();
minAddressesSpin.Binding.AddBinding(Entity, e => e.MinRouteAddresses, w => w.ValueAsInt).InitializeFromSource();
maxAddressesSpin.Binding.AddBinding(Entity, e => e.MaxRouteAddresses, w => w.ValueAsInt).InitializeFromSource();
photoviewCar.Binding.AddBinding(Entity, e => e.Photo, w => w.ImageFile).InitializeFromSource();
photoviewCar.GetSaveFileName = () => String.Format("{0}({1})", Entity.Model, Entity.RegistrationNumber);
checkIsCompanyHavings.Binding.AddBinding(Entity, e => e.IsCompanyHavings, w => w.Active).InitializeFromSource();
checkIsRaskat.Binding.AddBinding(Entity, e => e.IsRaskat, w => w.Active).InitializeFromSource();
checkIsArchive.Binding.AddBinding(Entity, e => e.IsArchive, w => w.Active).InitializeFromSource();
comboTypeOfUse.ItemsEnum = typeof(CarTypeOfUse);
comboTypeOfUse.Binding.AddBinding(Entity, e => e.TypeOfUse, w => w.SelectedItemOrNull).InitializeFromSource();
attachmentFiles.AttachToTable = OrmConfig.GetDBTableName(typeof(Car));
if (!UoWGeneric.IsNew)
{
attachmentFiles.ItemId = UoWGeneric.Root.Id;
attachmentFiles.UpdateFileList();
}
OnDataentryreferenceDriverChanged(null, null);
textDriverInfo.Selectable = true;
checkIsCompanyHavings.Sensitive = CarTypeIsEditable();
checkIsRaskat.Sensitive = CarTypeIsEditable();
comboTypeOfUse.Sensitive = CarTypeIsEditable();
}
public Employee Find(EmployeeFilter filter)
{
var query = Set.AsQueryable();
if (filter.Id > 0)
{
query = query.Where(d => d.Id == filter.Id);
}
else if (!string.IsNullOrWhiteSpace(filter.Name))
{
query = query.Where(d => d.Name.Contains(filter.Name));
}
else if (!string.IsNullOrWhiteSpace(filter.CPF))
{
query = query.Where(d => d.CPF == filter.CPF);
}
else if (filter.Occupation > 0)
{
query = query.Where(d => d.Occupation == filter.Occupation);
}
else if (filter.Guid != Guid.Empty)
{
query = query.Where(d => d.Guid == filter.Guid);
}
return(query.FirstOrDefault());
}
private void ConfigureDlg()
{
TabName = "Выдача топлива";
ydatepicker.Binding.AddBinding(FuelDocument, e => e.Date, w => w.Date).InitializeFromSource();
var filterDriver = new EmployeeFilter(UoW);
filterDriver.SetAndRefilterAtOnce(x => x.RestrictCategory = EmployeeCategory.driver);
yentrydriver.RepresentationModel = new EmployeesVM(filterDriver);
yentrydriver.Binding.AddBinding(FuelDocument, e => e.Driver, w => w.Subject).InitializeFromSource();
yentryCar.SubjectType = typeof(Car);
yentryCar.Binding.AddBinding(FuelDocument, e => e.Car, w => w.Subject).InitializeFromSource();
yentryfuel.SubjectType = typeof(FuelType);
yentryfuel.Binding.AddBinding(FuelDocument, e => e.Fuel, w => w.Subject).InitializeFromSource();
yspinFuelTicketLiters.Binding.AddBinding(FuelDocument, e => e.FuelCoupons, w => w.ValueAsInt).InitializeFromSource();
disablespinMoney.Binding.AddBinding(FuelDocument, e => e.PayedForFuel, w => w.ValueAsDecimal).InitializeFromSource();
spinFuelPrice.Binding.AddBinding(FuelDocument, e => e.LiterCost, w => w.ValueAsDecimal).InitializeFromSource();
UpdateFuelInfo();
UpdateResutlInfo();
FuelDocument.PropertyChanged += FuelDocument_PropertyChanged;
}
void ConfigureDlg()
{
enumFineType.ItemsEnum = typeof(FineTypes);
enumFineType.Binding.AddBinding(Entity, s => s.FineType, w => w.SelectedItem).InitializeFromSource();
yspinLiters.Binding.AddBinding(Entity, s => s.LitersOverspending, w => w.ValueAsDecimal);
ylabelDate.Binding.AddFuncBinding(Entity, e => e.Date.ToString("D"), w => w.LabelProp).InitializeFromSource();
yspinMoney.Binding.AddBinding(Entity, e => e.TotalMoney, w => w.ValueAsDecimal).InitializeFromSource();
yentryFineReasonString.Binding.AddBinding(Entity, e => e.FineReasonString, w => w.Text).InitializeFromSource();
fineitemsview1.FineUoW = UoWGeneric;
var filterRouteList = new RouteListsFilter(UoW);
filterRouteList.SetFilterDates(DateTime.Today.AddDays(-7), DateTime.Today.AddDays(1));
yentryreferenceRouteList.RepresentationModel = new ViewModel.RouteListsVM(filterRouteList);
yentryreferenceRouteList.Binding.AddBinding(Entity, e => e.RouteList, w => w.Subject).InitializeFromSource();
yentryreferenceRouteList.CanEditReference = QSMain.User.Permissions["can_delete"];
Entity.ObservableItems.ListChanged += ObservableItems_ListChanged;
var filterAuthor = new EmployeeFilter(UoW);
yentryAuthor.RepresentationModel = new EmployeesVM(filterAuthor);
yentryAuthor.Binding.AddBinding(Entity, e => e.Author, w => w.Subject).InitializeFromSource();
UpdateControlsState();
ShowLiters();
}
void ConfigureDlg()
{
if (StoreDocumentHelper.CheckAllPermissions(UoW.IsNew, WarehousePermissions.MovementEdit, Entity.FromWarehouse, Entity.ToWarehouse))
{
FailInitialize = true;
return;
}
var editing = StoreDocumentHelper.CanEditDocument(WarehousePermissions.MovementEdit, Entity.FromWarehouse, Entity.ToWarehouse);
enumMovementType.Sensitive = referenceEmployee.IsEditable = referenceWarehouseTo.Sensitive
= yentryrefWagon.IsEditable = textComment.Sensitive = editing;
movementdocumentitemsview1.Sensitive = editing;
textComment.Binding.AddBinding(Entity, e => e.Comment, w => w.Buffer.Text).InitializeFromSource();
labelTimeStamp.Binding.AddBinding(Entity, e => e.DateString, w => w.LabelProp).InitializeFromSource();
referenceCounterpartyFrom.RepresentationModel = new ViewModel.CounterpartyVM(new CounterpartyFilter(UoW));
referenceCounterpartyFrom.Binding.AddBinding(Entity, e => e.FromClient, w => w.Subject).InitializeFromSource();
referenceCounterpartyTo.RepresentationModel = new ViewModel.CounterpartyVM(new CounterpartyFilter(UoW));
referenceCounterpartyTo.Binding.AddBinding(Entity, e => e.ToClient, w => w.Subject).InitializeFromSource();
referenceWarehouseTo.ItemsQuery = StoreDocumentHelper.GetWarehouseQuery();
referenceWarehouseTo.Binding.AddBinding(Entity, e => e.ToWarehouse, w => w.Subject).InitializeFromSource();
referenceWarehouseFrom.ItemsQuery = StoreDocumentHelper.GetRestrictedWarehouseQuery(WarehousePermissions.MovementEdit);
referenceWarehouseFrom.Binding.AddBinding(Entity, e => e.FromWarehouse, w => w.Subject).InitializeFromSource();
referenceWarehouseFrom.IsEditable = StoreDocumentHelper.CanEditDocument(WarehousePermissions.MovementEdit, Entity.FromWarehouse);
referenceDeliveryPointTo.CanEditReference = false;
referenceDeliveryPointTo.SubjectType = typeof(DeliveryPoint);
referenceDeliveryPointTo.Binding.AddBinding(Entity, e => e.ToDeliveryPoint, w => w.Subject).InitializeFromSource();
referenceDeliveryPointFrom.CanEditReference = false;
referenceDeliveryPointFrom.SubjectType = typeof(DeliveryPoint);
referenceDeliveryPointFrom.Binding.AddBinding(Entity, e => e.FromDeliveryPoint, w => w.Subject).InitializeFromSource();
var filterEmployee = new EmployeeFilter(UoW);
referenceEmployee.RepresentationModel = new EmployeesVM(filterEmployee);
referenceEmployee.Binding.AddBinding(Entity, e => e.ResponsiblePerson, w => w.Subject).InitializeFromSource();
yentryrefWagon.SubjectType = typeof(MovementWagon);
yentryrefWagon.Binding.AddBinding(Entity, e => e.MovementWagon, w => w.Subject).InitializeFromSource();
ylabelTransportationStatus.Binding.AddBinding(Entity, e => e.TransportationDescription, w => w.LabelProp).InitializeFromSource();
MovementDocumentCategory[] filteredDoctypeList = { MovementDocumentCategory.counterparty };
object[] MovementDocumentList = Array.ConvertAll(filteredDoctypeList, x => (object)x);
enumMovementType.ItemsEnum = typeof(MovementDocumentCategory);
enumMovementType.AddEnumToHideList(MovementDocumentList);
enumMovementType.Binding.AddBinding(Entity, e => e.Category, w => w.SelectedItem).InitializeFromSource();
if (Entity.Id == 0)
{
Entity.Category = MovementDocumentCategory.Transportation;
}
buttonDelivered.Sensitive = Entity.TransportationStatus == TransportationStatus.Submerged &&
CurrentPermissions.Warehouse[WarehousePermissions.MovementEdit, Entity.ToWarehouse];
movementdocumentitemsview1.DocumentUoW = UoWGeneric;
}
public List <Employee> GetEmployee(EmployeeFilter filter, int pageIndex, int pageSize, out int totalCount)
{
string querySql = "select \"row_number\"() OVER(ORDER BY e.\"EntryDate\" DESC) \"rownum\",e.\"Id\",e.\"Name\",e.\"Gender\",e.\"IdNum\",e.\"EntryDate\",e.\"Salary\",e.\"SerialNum\",d.\"Name\" as \"DutyName\",e.\"Status\",e.\"Salary\",e.\"CreateTime\", p.\"Name\" as \"PrincipalName\",u.\"UserName\" as \"OperatorName\",e.\"Remark\" from \"T_Employee\" e left join \"T_Duty\" d on d.\"Id\"=e.\"DutyId\" left JOIN \"T_Employee\" p on p.\"Id\"=e.\"PrincipalId\" join \"T_User\" u on u.\"Id\"=e.\"OperatorId\"";
string countSql = "select count(e.\"Id\") from \"T_Employee\" e left join \"T_Duty\" d on d.\"Id\"=e.\"DutyId\" left JOIN \"T_Employee\" p on p.\"Id\"=e.\"PrincipalId\" join \"T_User\" u on u.\"Id\"=e.\"OperatorId\"";
return(GetPagedData <Employee, EmployeeFilter>(pageIndex, pageSize, out totalCount, countSql, querySql, filter));
}
public IActionResult Export([FromQuery] EmployeeFilter employeeFilter)
{
var stream = _employeeService.ExportExcel(employeeFilter);
string excelName = $"Danh-sach-nhan-vien-{DateTime.Now.ToString("yyyyMMddHHmmssfff")}.xlsx";
//return File(stream, "application/octet-stream", excelName);
return(File(stream, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", excelName));
}
public IActionResult Index(EmployeeFilter employeeFilter)
{
ViewBag.Name = employeeFilter.Name;
ViewBag.CPF = employeeFilter.CPF;
var employees = _employeeRest.FindPaginated(employeeFilter);
return(View(employees));
}
/// <summary>
/// Lấy danh sách nhân viên có lọc
/// </summary>
/// <param name="employeeFilter">Bộ lọc nhân viên</param>
/// <returns>Danh sách nhân viên</returns>
/// CreatedBy: dbhuan (09/05/2021)
public Paging <Employee> GetEmployees(EmployeeFilter employeeFilter)
{
if (employeeFilter.Page <= 0 || employeeFilter.PageSize <= 0)
{
throw new ClientException("Tham số truyền vào không hợp lệ", null);
}
return(_employeeRepository.GetEmployees(employeeFilter));
}
public SearchEmployeesQuery(EmployeeFilter filter)
{
FirstName = filter.FirstName;
LastName = filter.LastName;
Email = filter.Email;
PhoneNumber = filter.PhoneNumber;
StoreId = filter.StoreId;
}
public List <EmployeeModel> GetEmpList(EmployeeFilter filter, out int total)
{
using (DataProvider dp = new DataProvider())
{
var list = data.GetEmpList(dp, filter, out total);
return(Mapper.Map <List <EmployeeModel> >(list));
}
}
public IEnumerable <Employee> Find(EmployeeFilter filter)
{
IQueryable <Employee> query = _employeeContext.User;
if (filter.Ids.Any())
{
query = query.Where(o => filter.Ids.Contains(o.userId));
}
if (!string.IsNullOrEmpty(filter.Name))
{
query = query.Where(o => o.Name.Contains(filter.Name));
}
if (!string.IsNullOrEmpty(filter.Username))
{
query = query.Where(o => o.Username.Contains(filter.Username));
}
if (!string.IsNullOrEmpty(filter.Password))
{
query = query.Where(o => o.Password.Contains(filter.Password));
}
/*if (!string.IsNullOrEmpty(filter.State))
* query = query.Where(o => o.State.Contains(filter.State));
*
* if (!string.IsNullOrEmpty(filter.CheckIn))
* query = query.Where(o => o.CheckIn.ToString().Contains(filter.CheckIn));
*
* if (!string.IsNullOrEmpty(filter.Approval))
* query = query.Where(o => o.Approval.Contains(filter.Approval));
*
* if (!string.IsNullOrEmpty(filter.HeadDivision))
* query = query.Where(o => o.HeadDivision.Contains(filter.HeadDivision));
*
* if (!string.IsNullOrEmpty(filter.ApprovalByAdmin))
* query = query.Where(o => o.ApprovalByAdmin.Contains(filter.ApprovalByAdmin));*/
if (filter.SortByUsername.HasValue && filter.SortByUsername.Value == SortByAtOffice.ASC)
{
query = query.OrderBy(o => o.Username);
}
if (filter.SortByUsername.HasValue && filter.SortByUsername.Value == SortByAtOffice.DESC)
{
query = query.OrderByDescending(o => o.Username);
}
/* if (filter.SortByDate.HasValue && filter.SortByDate.Value == SortByAtOffice.ASC)
* query = query.OrderBy(o => o.CheckIn);
*
* if (filter.SortByDate.HasValue && filter.SortByDate.Value == SortByAtOffice.DESC)
* query = query.OrderByDescending(o => o.CheckIn);*/
return(query.ToList());
}
public void Query_string_should_just_contain_page_number()
{
var pageFilter = new EmployeeFilter {
PageNumber = 1
};
var queryString = pageFilter.GetQueryStringFilter();
Assert.AreEqual("?page=1", queryString);
}
public void Query_string_should_contain_page_number_and_name()
{
var pageFilter = new EmployeeFilter {
PageNumber = 1, name = "Deep"
};
var queryString = pageFilter.GetQueryStringFilter();
Assert.AreEqual("?page=1&name=Deep", queryString);
}
public void Query_string_should_contain_page_number_and_name_and_gender_and_status()
{
var pageFilter = new EmployeeFilter {
PageNumber = 1, name = "Deep", gender = "Female", status = "Inactive"
};
var queryString = pageFilter.GetQueryStringFilter();
Assert.AreEqual("?page=1&name=Deep&gender=Female&status=Inactive", queryString);
}
private void ConfigureFilters()
{
_filters = EmployeeFilter.CreateFilter();
var configurator = ComboboxConfigurator.Configure(FilterComboBox);
configurator.AddStringList(_filters.GetFilters);
FilterTextBox.Text = string.Empty;
_actualCriteria = _filters.GetCriteriaByIndex(0);
}
void ConfigureDlg()
{
enumcomboOperation.ItemsEnum = typeof(IncomeType);
enumcomboOperation.Binding.AddBinding(Entity, s => s.TypeOperation, w => w.SelectedItem).InitializeFromSource();
var filterCasher = new EmployeeFilter(UoW);
filterCasher.ShowFired = false;
yentryCasher.RepresentationModel = new ViewModel.EmployeesVM(filterCasher);
yentryCasher.Binding.AddBinding(Entity, s => s.Casher, w => w.Subject).InitializeFromSource();
var filter = new EmployeeFilter(UoW);
filter.ShowFired = false;
yentryEmployee.RepresentationModel = new ViewModel.EmployeesVM(filter);
yentryEmployee.Binding.AddBinding(Entity, s => s.Employee, w => w.Subject).InitializeFromSource();
var filterRL = new RouteListsFilter(UoW);
filterRL.OnlyStatuses = new RouteListStatus[] { RouteListStatus.EnRoute, RouteListStatus.OnClosing };
yEntryRouteList.RepresentationModel = new ViewModel.RouteListsVM(filterRL);
yEntryRouteList.Binding.AddBinding(Entity, s => s.RouteListClosing, w => w.Subject).InitializeFromSource();
yEntryRouteList.CanEditReference = QSMain.User.Permissions["can_delete"];
yEntryRouteList.Hidden += YEntryRouteList_ValueOrVisibilityChanged;
yEntryRouteList.Shown += YEntryRouteList_ValueOrVisibilityChanged;
yEntryRouteList.ChangedByUser += YEntryRouteList_ValueOrVisibilityChanged;
yentryClient.ItemsQuery = Repository.CounterpartyRepository.ActiveClientsQuery();
yentryClient.Binding.AddBinding(Entity, s => s.Customer, w => w.Subject).InitializeFromSource();
ydateDocument.Binding.AddBinding(Entity, s => s.Date, w => w.Date).InitializeFromSource();
OrmMain.GetObjectDescription <ExpenseCategory> ().ObjectUpdated += OnExpenseCategoryUpdated;
OnExpenseCategoryUpdated(null, null);
comboExpense.Binding.AddBinding(Entity, s => s.ExpenseCategory, w => w.SelectedItem).InitializeFromSource();
OrmMain.GetObjectDescription <IncomeCategory> ().ObjectUpdated += OnIncomeCategoryUpdated;
OnIncomeCategoryUpdated(null, null);
comboCategory.Binding.AddBinding(Entity, s => s.IncomeCategory, w => w.SelectedItem).InitializeFromSource();
checkNoClose.Binding.AddBinding(Entity, e => e.NoFullCloseMode, w => w.Active);
yspinMoney.Binding.AddBinding(Entity, s => s.Money, w => w.ValueAsDecimal).InitializeFromSource();
ytextviewDescription.Binding.AddBinding(Entity, s => s.Description, w => w.Buffer.Text).InitializeFromSource();
ytreeviewDebts.ColumnsConfig = ColumnsConfigFactory.Create <Selectable <Expense> > ()
.AddColumn("Закрыть").AddToggleRenderer(a => a.Selected).Editing()
.AddColumn("Дата").AddTextRenderer(a => a.Value.Date.ToString())
.AddColumn("Получено").AddTextRenderer(a => a.Value.Money.ToString("C"))
.AddColumn("Непогашено").AddTextRenderer(a => a.Value.UnclosedMoney.ToString("C"))
.AddColumn("Статья").AddTextRenderer(a => a.Value.ExpenseCategory.Name)
.AddColumn("Основание").AddTextRenderer(a => a.Value.Description)
.Finish();
}
