public static IList<Task> GetNewestTaskForEmployee(Employee emp, int howMany) { Repository<Task, Guid> rep = new Repository<Task, Guid>(); var result = from t in rep.GetQueryable() where t.AssignedTo == emp && t.TaskStatus.DictionaryNumber != (byte)TaskStatusEnum.Zakonczone orderby t.DateCreated ascending select t; return result.Take(howMany).ToList(); }
public static void SaveEmployee(Employee emp) { employeeRepository.SaveOrUpdate(emp); }
public static IList<Task> GetTaskToApprove(Employee emp, int howMany) { Repository<Task, Guid> rep = new Repository<Task, Guid>(); var result = from t in rep.GetQueryable() where t.GivenBy == emp && t.DateExecuted != null orderby t.DateExecuted ascending select t; return result.Take(howMany).ToList(); }
public static IList<Task> GetTasks(Employee assignedTo, Employee givenBy, Employee createdBy, Dictionary taskStatus, bool showOnlyApproved, DateTime? dateCreatedFrom, DateTime? dateCreatedTo) { Repository<Task, Guid> rep = new Repository<Task, Guid>(); var result = from t in rep.GetQueryable() select t; if (assignedTo != null) result = result.Where(t => t.AssignedTo == assignedTo); if (givenBy != null) result = result.Where(t => t.GivenBy == givenBy); if (createdBy != null) result = result.Where(t => t.CreatedBy == createdBy); if (taskStatus != null) result = result.Where(t => t.TaskStatus == taskStatus); if (dateCreatedFrom.HasValue) result = result.Where(t => t.DateCreated > dateCreatedFrom.Value); if (dateCreatedTo.HasValue) result = result.Where(t => t.DateCreated < dateCreatedTo.Value); if (showOnlyApproved) result = result.Where(t => t.IsApproved == true); return result.ToList(); }
public override MembershipUser CreateUser(string username, string password, string email, string passwordQuestion, string passwordAnswer, bool isApproved, object providerUserKey, out MembershipCreateStatus status) { MembershipUser user = null; Employee employee = new Employee(); employee.Login = username; employee.PasswordSalt = CreateSalt(5); employee.PasswordHash = CreatePasswordHash(password, employee.PasswordSalt); employee.Active = true; employee.CreationDate = DateTime.Now; employee.LastActivityDate = DateTime.Now; EmployeeService.SaveEmployee(employee); status = MembershipCreateStatus.Success; user = new MembershipUser(this.Name, employee.Login, null, string.Empty, string.Empty, string.Empty, true, false, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now); return user; }
public static IList<Order> GetOrders(Customer customer, Employee emp, Territory terr, DateTime? startDate, DateTime? endDate, Dictionary orderStatus) { Repository<Order, Guid> rep = new Repository<Order, Guid>(); var result = from o in rep.GetQueryable() select o; if (customer != null) result = result.Where(o => o.CustomerFacility.Customer == customer); if (emp != null) result = result.Where(o => o.Employee == emp); if (terr != null) result = result.Where(o => o.Territory == terr); if (orderStatus != null) result = result.Where(o => o.OrderStatus == orderStatus); if (startDate.HasValue) result = result.Where(o => o.OrderDate > startDate.Value); if (endDate.HasValue) result = result.Where(o => o.OrderDate < endDate.Value); return result.ToList(); }