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