/// <summary> /// hàm phân công công việc ngẫu nhiên /// </summary> /// <param name="EmployeeID"></param> public void RandomWork(int EmployeeID) { listWorks = GetListWorks(); numberRandom = GetNumberRandom(); List <int> listRandomListWork = ListRandomListWork(listWorks.Count, numberRandom); foreach (int number in listRandomListWork) { Works works = listWorks[number]; InsertWorkEmployee(works.WorkID, EmployeeID); UpdateWork(works.WorkID, true); } }
public List <Works> GetListWorks() { listWorks = new List <Works>(); string query = "SELECT fldWorkID, fldWorkName,fldWorkStatus FROM Employee.dbo.tblWork WHERE fldWorkStatus=@fldWorkStatus"; connect(); using (SqlCommand command = new SqlCommand(query, con)) { //@fldWorkStatus=0 lấy ra các công việc chưa có ai làm. command.Parameters.AddWithValue("@fldWorkStatus", 0); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { Works work = new Works(); work.WorkID = reader.GetInt32(0); work.WorkName = reader.GetString(1); work.WorkStatus = reader.GetBoolean(2); listWorks.Add(work); } } } return(listWorks); }