/// <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);
}
