public List <LogTypeDTO> convertToObject(DataTable input)
{
//hàm convert từ DataTable sang list<object>
List <LogTypeDTO> output = new List <LogTypeDTO>();
foreach (DataRow dr in input.Rows)
{
LogTypeDTO obj = new LogTypeDTO();
obj.LogTypeID = Convert.ToInt32(dr["LogTypeID"]);
obj.Description = Convert.ToString(dr["Description"]);
output.Add(obj);
}
return(output);
}
public List <LogTypeDTO> getLogType()
{
try
{
List <LogTypeDTO> dsLogType = new List <LogTypeDTO>();
string queryString = "SELECT * FROM LogType";
SqlCommand cmd = new SqlCommand(queryString, DataConnection.connect);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
LogTypeDTO type = new LogTypeDTO(int.Parse(dr["LogTypeID"].ToString()),
Convert.ToString(dr["Description"]));
dsLogType.Add(type);
}
dr.Close();
DataConnection.closeConnection();
return(dsLogType);
}
catch (Exception)
{
DataConnection.closeConnection();
return(null);
}
}
