private static void DIPExample()
{
List <Employee> employees = new List <Employee>
{
new Employee {
Name = "Rodrigo", Gender = Gender.Male, Role = Role.Developer
},
new Employee {
Name = "Robert", Gender = Gender.Male, Role = Role.Executive
},
new Employee {
Name = "Martin", Gender = Gender.Male, Role = Role.Executive
},
new Employee {
Name = "Vanessa", Gender = Gender.Female, Role = Role.Executive
}
};
var employeManager = new EmployeeManager();
foreach (var employee in employees)
{
employeManager.Save(employee);
}
var search = new EmployeeSearch(employeManager);
Console.WriteLine($" Cantidad de Empleados Ejecutivos y de genero Masculino: {search.GetMaleExecutives()}");
Console.ReadLine();
}
public void Test_Employee_Find()
{
var timestamp = DateTime.Now;
var marks = TestUtils.RandomString();
IEmployeeConnector connector = new EmployeeConnector();
for (var i = 0; i < 5; i++)
{
connector.Create(new Employee()
{
EmployeeId = TestUtils.RandomString(), City = marks
});
}
var searchSettings = new EmployeeSearch();
//searchSettings.LastModified = timestamp; //parameter is not accepted by server
searchSettings.Limit = APIConstants.Unlimited;
var employees = connector.Find(searchSettings);
var newEmployees = employees.Entities.Where(e => e.City == marks).ToList();
Assert.AreEqual(5, newEmployees.Count);
}
/// <summary>
/// 查询员工列表
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public IPagedList <EmployeeDetailModel> Query(EmployeeSearch search)
{
var query = storeDB.EmployeeInfo.Where(x => !x.Deleted);
if (search.EmployeeNo != 0)
{
query = query.Where(x => x.EmployeeNo == search.EmployeeNo);
}
if (!string.IsNullOrEmpty(search.EmployeeName))
{
query = query.Where(x => x.Name.Contains(search.EmployeeName));
}
if (!string.IsNullOrEmpty(search.EmployeeMobile))
{
query = query.Where(x => x.Mobile == search.EmployeeMobile);
}
if (search.Gender.HasValue)
{
query = query.Where(x => x.Gender == search.Gender.Value);
}
if (search.EmployeeId.HasValue && search.EmployeeId != Guid.Empty)
{
query = query.Where(x => x.Id == search.EmployeeId);
}
if (search.Quit.HasValue)
{
query = query.Where(x => x.Quit == search.Quit);
}
query = query.OrderByDescending(x => x.LastUpdatedOn);
var pageResult = new PagedList <EmployeeInfo>(query, search.PageIndex, search.PageSize);
var pageList = pageResult.Data.Select(x => x.InfoToModel());
return(new PagedList <EmployeeDetailModel>(pageList, pageResult.PageIndex, pageResult.PageSize, pageResult.TotalCount));
}
/// <summary>
/// 查询员工列表
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public IPageList <UserViewModel> SearchEmployeeList(EmployeeSearch search)
{
IPageList <UserViewModel> userViews = new PageList <UserViewModel>();
userViews.Data = new List <UserViewModel>();
try
{
if (UserStorage.Instance.Authority <= 1)
{
var employees = _employeeInfoRepository.SearchEmployeeList(search);
if (employees?.Data != null)
{
userViews.Data = employees.Data.Select(x => x.ToUserViewModel()).ToList();
userViews.PageIndex = employees.PageIndex;
userViews.PageSize = employees.PageSize;
userViews.TotalCount = employees.TotalCount;
userViews.TotalPage = employees.TotalPage;
if (employees.TotalPage == 0)
{
userViews.TotalPage = 1;
}
return(userViews);
}
}
return(userViews);
}
catch (Exception ex)
{
return(userViews);
}
}
public ActionResult Details(int id)
{
Step2017Entities1 ent = new Step2017Entities1();
EmployeeSearch empSearch = ent.EmployeeSearches.Where(c => c.Id == id).FirstOrDefault();
return(View(empSearch));
}
private void EmployeeToolStripMenuItem_Click(object sender, EventArgs e)
{
this.Hide();
EmployeeSearch Stud = new EmployeeSearch();
Stud.ShowDialog();
}
public void GetsValidSubordinate()
{
List <Employee> employees = new List <Employee>
{
new Employee
{
Id = 2,
SuperiorId = 1,
Name = "Jackie",
Surname = "Smith",
Company = "IBM",
City = "Johannesburg",
Position = "Junior Analyst"
},
new Employee
{
Id = 1,
SuperiorId = 0,
Name = "Jackie",
Surname = "Smith",
Company = "IBM",
City = "Johannesburg",
Position = "Assistant Director"
}
};
var expected_subordinate = JsonConvert.SerializeObject(employees[0]);
var actual_subordinate = JsonConvert.SerializeObject(EmployeeSearch.GetSubordinates(employees, 1).First());
Assert.AreEqual(expected_subordinate, actual_subordinate);
}
public ActionResult Create(EmployeeSearch empSearch)
{
Step2017Entities1 ent = new Step2017Entities1();
ent.EmployeeSearches.Add(empSearch);
ent.SaveChanges();
return(RedirectToAction("List"));
}
public List <slideshowNew> ShowDataForEmployeeAdvanceSearch([FromBody] JObject CgetDetails)
{
TAdvanceSearch advancesearch = CgetDetails["GetDetails"].ToObject <TAdvanceSearch>();
EmployeeSearch employeesearch = CgetDetails["customerpersonaldetails"].ToObject <EmployeeSearch>();
List <TAdvanceSearch> lstAdvance = new List <TAdvanceSearch>();
lstAdvance.Add(advancesearch);
employeesearch.dtTableValues = Commonclass.returnListDatatable(PersonaldetailsUDTables.dtcreateDatatableShowDataForEmployeeAdvanceSearch(), lstAdvance);
return(this.ICustomerSearch.ShowDataForEmployeeAdvanceSearch(employeesearch));
}
public List <slideshowNew> ShowDataForEmployeeGeneral([FromBody] JObject CgetDetails)
{
TGeneralSearch generalsearch = CgetDetails["GetDetails"].ToObject <TGeneralSearch>();
EmployeeSearch employeesearch = CgetDetails["customerpersonaldetails"].ToObject <EmployeeSearch>();
List <TGeneralSearch> lstGeneral = new List <TGeneralSearch>();
lstGeneral.Add(generalsearch);
employeesearch.dtTableValues = Commonclass.returnListDatatable(PersonaldetailsUDTables.dtcreateDatatableShowDataForEmployeeGeneral(), lstGeneral);
return(this.ICustomerSearch.ShowDataForEmployeeGeneral(employeesearch));
}
/// <summary>
/// 查询员工列表
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public IPagedList <EmployeeDetailModel> Query(EmployeeSearch search)
{
var _session = HttpContext.Current.Session;
if (int.Parse(_session["Authority"].ToString()) > 0)
{
throw new Exception("无人事管理权限！");
}
return(_employeeInfoRepository.Query(search));;
}
public ActionResult Edit(EmployeeSearch empSearch)
{
Step2017Entities1 ent = new Step2017Entities1();
EmployeeSearch es = ent.EmployeeSearches.Where(c => c.Id == empSearch.Id).FirstOrDefault();
es.Name = empSearch.Name;
es.Address = empSearch.Address;
es.Salary = empSearch.Salary;
ent.SaveChanges();
return(RedirectToAction("List"));
}
public ActionResult Query(EmployeeSearch search)
{
//System.Threading.Thread.Sleep(3000);
try
{
var result = _employeeService.Query(search);
return(PartialView("_SingersSearch", result));
}
catch (Exception ex)
{
return(Json(new { Success = false, Messages = ex.Message }));
}
}
/// <summary>
/// 查询员工列表
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public IPageList <EmployeeInfo> SearchEmployeeList(EmployeeSearch search)
{
IPageList <EmployeeInfo> pageList = new PageList <EmployeeInfo>();
var infos = storeDB.EmployeeInfo.Where(x => x.Deleted == false);
if (search.Id.HasValue)
{
infos = infos.Where(x => x.Id == search.Id.Value);
}
if (search.EmployeeNo.HasValue)
{
infos = infos.Where(x => x.EmployeeNo.ToString().Contains(search.EmployeeNo.Value.ToString()));
}
if (!string.IsNullOrWhiteSpace(search.Name))
{
infos = infos.Where(x => x.Name.Contains(search.Name));
}
if (!string.IsNullOrWhiteSpace(search.Mobile))
{
infos = infos.Where(x => x.Mobile.Contains(search.Mobile));
}
if (search.Gender.HasValue)
{
infos = infos.Where(x => x.Gender == search.Gender.Value);
}
if (search.Birthday.HasValue)
{
infos = infos.Where(x => x.Birthday.HasValue && x.Birthday.Value.Month == search.Birthday.Value.Month && x.Birthday.Value.Day == search.Birthday.Value.Day);
}
if (search.MinSpend.HasValue)
{
infos = infos.Where(x => x.Spend >= search.MinSpend.Value);
}
if (search.MaxSpend.HasValue)
{
infos = infos.Where(x => x.Spend <= search.MaxSpend.Value);
}
if (search.Quit.HasValue)
{
infos = infos.Where(x => x.Quit == search.Quit.Value);
}
infos = infos.OrderBy(x => x.JoinDate);
pageList.TotalCount = infos.Count();
infos = infos.Skip(search.Index * search.PageSize).Take(search.PageSize);
pageList.Data = infos.AsNoTracking().ToList();
pageList.PageIndex = search.Index;
pageList.PageSize = search.PageSize;
pageList.TotalPage = (int)Math.Ceiling((double)pageList.TotalCount / (double)pageList.PageSize);
return(pageList);
}
public ActionResult GetEmployees(EmployeeSearch employeeSearch)
{
try
{
List <DtoEmployee> employeeList = employeeBll.GetPagingEmployee(employeeSearch.Pagination, employeeSearch.AccountOrNameOrPhone, employeeSearch.Role, employeeSearch.Status);
var table = AbhsTableFactory.Create(employeeList, employeeSearch.Pagination.TotalCount);
return(Json(table, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new JsonSimpleResponse()
{
State = false, ErrorMsg = ex.Message
}));
}
}
public JsonResult List(EmployeeSearch search, FormCollection form)
{
if (search == null)
{
search = new EmployeeSearch();
}
search.ORG_ID = base.CurrentUserOrgId;
search.CuEmpId = base.CurrentUserEmployeeId;
search.UserType = form["USER_TYPE"] == null ? "" : form["USER_TYPE"].ToString();
PageView view = new PageView(form);
string colkey = form["colkey"];
string colsinfo = form["colsinfo"];
//员工列表
PagedList <ORG_EMPLOYEE_EX> pList = _eservice.QueryEmployeeList(search, view);
JsonQTable fdata = JsonQTable.ConvertFromPagedList <ORG_EMPLOYEE_EX>(pList, colkey, colsinfo.Split(','));
return(Json(fdata));
}
public PaginatedResults <EmployeeGridDto> Search(EmployeeSearch search)
{
var query = _employeeRepository.Query.ProjectTo <EmployeeGridDto>(_mapper.ConfigurationProvider);
if (!search.Filter.IsNotNullOrEmpy() || !search.Filter.HasValue())
{
return(_employeeRepository.PaginatedSearch(query, search));
}
var filter = search.Filter.ToUpper();
var cb = new CriteriaBuilder <EmployeeGridDto>();
cb.Or(c => c.FirstName != null && c.FirstName.ToUpper().Contains(filter));
cb.Or(c => c.LastName != null && c.LastName.ToUpper().Contains(filter));
cb.Or(c => c.Email != null && c.Email.ToUpper().Contains(filter));
cb.Or(c => c.PhoneNumber != null && c.PhoneNumber.ToUpper().Contains(filter));
query = query.AsExpandable().Where(cb.GetCondition());
return(_employeeRepository.PaginatedSearch(query, search));
}
private void FillDatabaseObjects()
{
WebsiteContext C = GetInMemoryDBWithSeeder();
SearchController SC = new SearchController(C);
DatabaseObject Employee = new EmployeeSearch(C);
DatabaseObject Product = new ProductSearch(C);
DatabaseObject Recipe = new RecipeSearch(C);
DatabaseObject News = new NewsSearch(C);
Employee.SetObject(C.Employee_Profiles.ToList().ElementAt(0));
Product.SetObject(C.Products.ToList().ElementAt(0));
Recipe.SetObject(C.Recipes.ToList().ElementAt(0));
News.SetObject(C.News_Items.ToList().ElementAt(0));
EmployeeTest = Employee;
ProductTest = Product;
RecipeTest = Recipe;
NewsTest = News;
}
public EmployeeSearchResponse Map(EmployeeSearch employee)
{
if (employee == null)
{
return(null);
}
var response = new EmployeeSearchResponse()
{
EmployeeId = employee.EmployeeId,
FirstName = employee.FirstName,
LastName = employee.LastName,
Bio = employee.Bio,
SubDepartmentName = employee.SubDepartmentName,
DepartmentName = employee.DepartmentName,
ProfileImage = employee.ProfileImage,
FbprofileLink = employee.FbprofileLink,
TwitterProfileLink = employee.TwitterProfileLink
};
return(response);
}
//查询按钮
private void QueryButton_Click(object sender, RoutedEventArgs e)
{
search = new EmployeeSearch();
if (!string.IsNullOrWhiteSpace(NameValue.Text))
{
search.Name = NameValue.Text;
}
if (!string.IsNullOrWhiteSpace(MobileValue.Text))
{
search.Mobile = MobileValue.Text;
}
if (GenderStringValue.Text == "男")
{
search.Gender = 1;
}
if (GenderStringValue.Text == "女")
{
search.Gender = 0;
}
ListUpdate();
}
public static void Main()
{
var employees = new List <Employee>();
employees.AddRange(new Employee[] { new Employee {
Name = "Frank", Id = 2
},
new Employee {
Name = "Jill", Id = 3
},
new Employee {
Name = "Dave", Id = 5
},
new Employee {
Name = "Jack", Id = 8
},
new Employee {
Name = "Judith", Id = 12
},
new Employee {
Name = "Robert", Id = 14
},
new Employee {
Name = "Adam", Id = 1
} });
employees.Sort();
var es = new EmployeeSearch("J");
int index = employees.FindIndex(4, es.StartsWith);
Console.WriteLine("Starting index of'J': {0}",
index >= 0 ? index.ToString() : "Not found");
es = new EmployeeSearch("Ju");
index = employees.FindIndex(4, es.StartsWith);
Console.WriteLine("Starting index of 'Ju': {0}",
index >= 0 ? index.ToString() : "Not found");
}
public static void Main()
{
var employees = new List <Employee>();
employees.AddRange(new Employee[] { new Employee {
Name = "Frank", Id = 2
},
new Employee {
Name = "Jill", Id = 3
},
new Employee {
Name = "Dave", Id = 5
},
new Employee {
Name = "Jack", Id = 8
},
new Employee {
Name = "Judith", Id = 12
},
new Employee {
Name = "Robert", Id = 14
},
new Employee {
Name = "Adam", Id = 1
} });
employees.Sort();
var es = new EmployeeSearch("J");
Console.WriteLine("'J' starts at index {0}",
employees.FindIndex(es.StartsWith));
es = new EmployeeSearch("Ju");
Console.WriteLine("'Ju' starts at index {0}",
employees.FindIndex(es.StartsWith));
}
/// <summary>
///
/// </summary>
public void enterEmployeeID()
{
//TODO
//string username = ObjectRepository.User;
//if (username == null)
//{
//EmployeeSearch.SendKeys("13775301");
DirectoryInfo currentDir = new DirectoryInfo(Directory.GetCurrentDirectory());
XmlDocument xmldoc = new XmlDocument();
xmldoc.Load(currentDir + @"\XML Test Data\CreatePackage.xml");
XmlNode hierarchyNode = xmldoc["Request"]["CometCreatePackage"];
empNumber = hierarchyNode.ChildNodes[1].ChildNodes[2].ChildNodes[0].InnerText;
EmployeeSearch.SendKeys(hierarchyNode.ChildNodes[1].ChildNodes[2].ChildNodes[0].InnerText);
driver.Manage().Timeouts().ImplicitWait = TimeSpan.FromSeconds(50);
//}
//else
//{
// EmployeeSearch.SendKeys(username);
// driver.Manage().Timeouts().ImplicitWait = TimeSpan.FromSeconds(5);
//}
}
public async Task Test_Employee_Find()
{
var marks = TestUtils.RandomString();
var connector = FortnoxClient.EmployeeConnector;
for (var i = 0; i < 5; i++)
{
await connector.CreateAsync(new Employee()
{
EmployeeId = TestUtils.RandomString(), City = marks
});
}
var searchSettings = new EmployeeSearch();
//searchSettings.LastModified = TestUtils.Recently; //parameter is not accepted by server
searchSettings.Limit = ApiConstants.Unlimited;
var employees = await connector.FindAsync(searchSettings);
var newEmployees = employees.Entities.Where(e => e.City == marks).ToList();
Assert.AreEqual(5, newEmployees.Count);
}
public static ArrayList GetUsers(string strRole)
{
ArrayList arrList = new ArrayList();
try
{
EmployeeSearch objEmployeeSearch = new EmployeeSearch();
objEmployeeSearch.basic = new EmployeeSearchBasic();
objEmployeeSearch.basic.role = new SearchMultiSelectField();
objEmployeeSearch.basic.role.@operator = SearchMultiSelectFieldOperator.anyOf;
objEmployeeSearch.basic.role.operatorSpecified = true;
objEmployeeSearch.basic.role.searchValue = new RecordRef[1];
objEmployeeSearch.basic.role.searchValue[0] = new RecordRef();
objEmployeeSearch.basic.role.searchValue[0].internalId = strRole;
objEmployeeSearch.basic.role.searchValue[0].type = RecordType.salesRole;
objEmployeeSearch.basic.role.searchValue[0].typeSpecified = true;
SearchResult objSearchResult = _service.search(objEmployeeSearch);
if (objSearchResult.status.isSuccess && objSearchResult.recordList != null)
{
foreach (Employee objEmployee in objSearchResult.recordList)
{
arrList.Add(objEmployee);
}
}
}
catch (Exception objExc)
{
}
return arrList;
}
public IList <Employee> OnEmployeeSearch(ISession session, EmployeeSearch e)
{
return(new Expression().List <Models.Employees, Employee>());
}
public override async Task <Tuple <List <Model.Response.Employee>, int> > GetByParametersAsync(EmployeeSearch search, string order, string nameOfColumnOrder, int start, int length)
{
var query = ctx.Employees.Include(x => x.Copier).ThenInclude(x => x.Company).Include(x => x.Person.City).ThenInclude(x => x.Country).AsQueryable();
if (search.CopierId != null)
{
query = query.Where(x => x.Person.CityId == search.CopierId);
}
if (search.CompanyId != null)
{
query = query.Where(x => x.Copier.CompanyId == search.CompanyId);
}
if (search.Gender != null)
{
query = query.Where(x => x.Person.Gender == search.Gender);
}
if (!string.IsNullOrWhiteSpace(search.FirstName))
{
query = query.Where(x => x.Person.FirstName.Contains(search.FirstName));
}
if (!string.IsNullOrWhiteSpace(search.LastName))
{
query = query.Where(x => x.Person.LastName.Contains(search.LastName));
}
if (search.Active != null)
{
query = query.Where(x => x.Active == search.Active);
}
if (nameOfColumnOrder == nameof(Database.Employee.ID))
{
query = query.OrderByAscDesc(x => x.ID, order);
}
else if (nameOfColumnOrder == nameof(Database.Employee.Person.FirstName))
{
query = query.OrderByAscDesc(x => x.Person.FirstName, order);
}
else if (nameOfColumnOrder == nameof(Database.Employee.Person.LastName))
{
query = query.OrderByAscDesc(x => x.Person.LastName, order);
}
var data = mapper.Map <List <Model.Response.Employee> >(await query.Skip(start).Take(length).ToListAsync());
return(new Tuple <List <Model.Response.Employee>, int>(data, await query.CountAsync()));
}
public List <slideshowNew> ShowDataForEmployeeAdvanceSearch_Nocastebar(EmployeeSearch employeesearch)
{
return(new CustomerSearch().GetShowDataForAdvanced(employeesearch, "[dbo].[usp_get_AdvancedSearchResultSet1_CasteNoBar_NewDesign]"));
}
public List <slideshowNew> ShowDataForEmployeeGeneral(EmployeeSearch employeesearch)
{
return(new CustomerSearch().GetShowDataForGeneral(employeesearch, "[dbo].[usp_get_SearchResultSet1_Test_Profor_NewDesign]"));
}
public IList<Employee> OnEmployeeSearch(ISession session, EmployeeSearch e)
{
return new Expression().List<Models.Employees, Employee>();
}
