/// <summary>
/// List employees
/// </summary>
/// <param name="clientID"></param>
public static List <ClientWorkHoursAllocation> List(int clientID)
{
var workAllocationList = new List <ClientWorkHoursAllocation>();
using (var connection = new SqlConnection(ConnString.ConnectionString))
{
var commandString = string.Format(
" SELECT " +
ListOfFields(",", "") +
" FROM " + tableName +
" WHERE FKCompanyUID = {0}",
clientID);
using (var command = new SqlCommand(
commandString, connection))
{
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
ClientWorkHoursAllocation clientWork = new ClientWorkHoursAllocation();
LoadObject(reader, clientWork);
workAllocationList.Add(clientWork);
}
}
}
}
return(workAllocationList);
}
/// <summary>
/// This method loads the information from the sqlreader into the Employee object
/// </summary>
/// <param name="reader"></param>
/// <param name="employee"></param>
private static void LoadObject(SqlDataReader reader, ClientWorkHoursAllocation clientWorkAllocation)
{
clientWorkAllocation.UID = Convert.ToInt32(reader[FieldName.UID.ToString()]);
clientWorkAllocation.Date = Convert.ToDateTime(reader[FieldName.Date.ToString()]);
clientWorkAllocation.FKClientWorkIsFor = Convert.ToInt32(reader[FieldName.FKClientWorkIsFor.ToString()]);
clientWorkAllocation.FKCompanyUID = Convert.ToInt32(reader[FieldName.FKCompanyUID.ToString()]);
clientWorkAllocation.FKEmployeeUID = Convert.ToInt32(reader[FieldName.FKEmployeeUID.ToString()]);
clientWorkAllocation.FKInvoiceItemID = Convert.ToInt32(reader[FieldName.FKInvoiceItemID.ToString()]);
clientWorkAllocation.FKInvoiceUID = Convert.ToInt32(reader[FieldName.FKInvoiceUID.ToString()]);
clientWorkAllocation.FKTaskUID = Convert.ToInt32(reader[FieldName.FKTaskUID.ToString()]);
clientWorkAllocation.Hours = Convert.ToInt32(reader[FieldName.Hours.ToString()]);
}